Recent content by jaegca

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