Search results for query: *

Worked like a charm - thank you so much!!!!!

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...

Loktar, I am using Access 97 - when I went to the control's properties, there is no option available for conditional formatting - am I looking in the wrong place or is it a version issue? Thanks much, cindy

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.

The data source is a hospital database (McKesson Star) - the import will be accomplished by running a Star SQL that downloads to the end-users C:\ drive - then a macro button will import to a table that stores all the employee historical data - I wanted to use the date field to capture the most...

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...

Nope - that didn't work - but I did change the data type from text to number and formatted Nine "0"s and that worked - put a zero in if no digit there.

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 am told by our Novell Admin that they should have full rights if they can open the Db... so I don't think that's it. Keep in mind, no one is splitting their Dbs - it's all out there. Most don't even have passwords on the front end much less user level security. Could that be a contibuting...

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...

To JPeters: It does seem to have occurred since the Hospital Db upgrade. But the end-user isn't 100% sure. My knowledge base about the upgrade changes as they would affect file downloads is limited but I am researching it. PS - Thanks to all! I'm still learning Access and I can't tell you...

To jpetersMIS - Yes it has worked in the past. This is a simple flat file import into an Access table of a download file from our Hospital Db. The end-user imports, runs queries and then deletes the data each month. To CosmoKramer - We only have 1 version of Access on our Network and the...

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...

'm still kinda new to Access and actually I didn't create the Db - I'm just supposed to fix it. I do know better than to use the autonumber field for anything meaningful. The Db was created in Access 97 and even though we upgraded to Windows 2000 OS we are still using Access 97. When you say...

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...