• 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:

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.

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