Search results for query: *

I am working in Access 97 - created a form from a query using the Wizard and selected "datasheet" from the view options - put a command button on another form to open the datasheet form. The form opened in single form view so I set the properties of the form to Default View "datasheet" and...

I have a main form with a subform - the subform has a field (Primary Key) that I used a combo box to display a text field so data entry is by a drop down text selection. My problem is that I want the field to display a different Forecolor depending on what is entered (Red - Green - Yellow). I...

I have an end-user who would like to know EXACTLY what the error message "MSAccess.exe has generated an error. Check the error log..." means. I have searched Microsoft, here, and 3 other sites looking for a definition. My understanding was that this was a "generic" error...

We have an Access 2002 db that seems to be corrupted. The end-user has it stored on his C:\ instead of a network drive. We believe the source of corruption may be repeated end-user error (ok he admitted it) by ctrl+alt+del when it moved "too slow" - ldb files were created which could...

My boss insists there is a way to remove the Application XClose (so no one can even see it) for Access. I have found a lot of info on disabling the close, but nothing to REMOVE IT - any input most gratefully appreciated.

I need to write a query to capture only the most recently imported data into a table (put a "Date()" default field in table) which populates when I import the data - search MS ACCESS help and Microsoft's site, even keyword search here and must not be using the correct terminology - any...

We are importing employee data into Access - the imported SSN does not display the &quot;zeros&quot; that some SSN start with - any way to set the properties of the field to automatically populate SSN that import with <9 numbers to put zeros at the beginning. Thanks so much!

I work at a hospital and I realize this is a very generic question. Many end-users are creating their own Dbs and saving them on shared Novell drives for their departments. These end-users/developers seem to be having some fairly consistent &quot;odd&quot; problems. Most often reported are...

Let me prefice this with I'm not VBA savy AT ALL... I have a yes/no data type field I want to display in a report and count. Each record has 3 fields with yes/no data types displayed horizontally across the report. I used an unbound text box to create a calculated control using an IIf...

I seem to have multiple new occurrences of Access Db errors and am hoping someone has some input. Does anyone know of any unique problems with: 1. Access 97 and Windows 2000/NT 2. Access 97, Windows 2000/NT, and imports of large comma delimited .txt files Reoccurring are database errors as...

Primary Key field - autonumber properties set to RANDOM and formatted to 3 digits(000)suddenly (after upgrade to Windows 2000 from 95) generates >8 numbers when new record added-- some of them negative!

In Access table design view / properties, the validation rules for any text data type(ie. ??)is kicking all end-users out of Access with non-specific error message- &quot;Access has generated errors....&quot; - wanted to know if anyone else is having this problem or if it could have something to...