1
  • Zero fill numbers

    I have an address field with a 6 digit zero fill street address. eg, 1032 is 001032. I need to eliminate only the leading zeros.

    timmyd5 pointsBadges:
  • Using IIF statement in query to return answer

    How do I write a IFF statement to return data? I am trying to write a IIF statement to let a student know if they are approved or not approved to play a sport. Here's the statement: Status: IIF([Waiver]="Yes"]) and IIF([Academic]="Yes"), "Approved", "Not Approved" When I do this and hit run, it...

    loggerhead79150 pointsBadges:
  • Microsoft Access change

    I'm trying to add fields to a table that says it is read-only. I don't want that,  how do I turn it off?

    PG755 pointsBadges:
  • Extend char length

    How do I extend char length in memo field?

    flattop10 pointsBadges:
  • How to refresh page when leaving the field

    In my form I have a calculated field, this field is based on two other fields in the table. The field updates only when I page up or down or manually refresh. How can I get it to refresh once the other two fields are populated?

    RKJohn95 pointsBadges:
  • Count characters for each string in a column of data

    Within MS Access 2003 I want to create a column of data containing the results of a count. The count needs to tell me the string length of each data element in an adjacent Field. So, if for example I had a Field containing people's surnames, and I want to see, for each surname, the string length...

    AADataExec5 pointsBadges:
  • Link RDP in Microsoft Access to click computer name to remote control

    I have build a Microsoft Access 2007 database for trouble tickets and inventory.  I have a table called INVENTORY.  One fo the fields is DEVICE NAME.  Right now it is simpy a text field.  In this field we enter the comptuer name (example COMPUTER1234) We have forms which contain the DEVICE...

    Maxwellafb35 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following