Search results for query: *

Hi - This is probably Programming 101 but I am a business systems analyst and not a programmer so am missing the background to get started on the following ... I do not want access to save the data on a form automatically. The users should be able to open a blank form, enter all of the data on...

I am looking for a non-programming solution to a common problem. When importing data files into access, I sometimes receive data where certain values have been suppressed if they are identical to the record above. Example: SSN and Name fields are suppressed. SSN NAME AMOUNT...

Thank you Remou for your response. It is greatly appreciated. I did review the filters that are applied per the properties on the form's data tab and these were as I wanted them to be. I still believe that Access was somehow retaining the conditions of an earlier filter by form action and...

Hi: Is it possible that Access saves a default filter with a form? I have somehow introduced a problem into my database that I can't figure out how to resolve. I have a main form which contains two subforms. I have created three command buttons on the main form which, when clicked, launch...

PHV - Thank you for your response. I did try it but my #Error changed to a #Name error. In the end, I deleted and started over and took some other precautions: 1. I renamed each control that I added to the form from the Access Default name to a new name with each dlookup control I was...

[Find Billing Issues to Research]![Plan-Code]" is the reference to the Query Name and field from the query on which this form is based. When the Plan Code on the Query matches the Plan Code from the XREF table, I display the corresponding description from the XREF table.

This happens from time to time during form design. My DLookup fields, which were previously working, suddenly display "#Error" and the message "Calculating ..." appears in the lower left of the screen. I try several things to fix it: closing the form/database sometimes works; sometimes I...