Search results

I am trying to use the dmin function in access 95, but I seem to get the error messages that says compile error due to the macro or expression. I made a command button that has the expression below for event. I want to go to a record that has the INSURED field blank, with no entries. The...

I have a form that takes data from a table which has preassigned policy numbers that I entered. For each policy number there is data that goes with it (ie Name, address, etc). The user fills out this data and closes the database. Is there any way to go to the next policy number that has no...

I have a form that allows users to input data in records. One of the fields uses the autonumber option. When more than one person works on the form, the autonumbers will not be in order(say 100,102,101). Even when I close everything and filter the column on the table, the numbers on the form...

I am trying to make a text box that acts similar to the find function in Access. I have made a macro that uses the find record feature. I want the user to enter what they want to search for (could be a name, or a number) in the text box (including searching with wildcards) and the macro should...

I am trying to conduct a search through a fields in a table using Form Filter. I made a macro that's action is "DoMenuItem" and the command is "Filter by form". Every time I try to search for an object by typing in a value in a field (regular way and with wildcard characters), I never get...

Is there any way to start the autonumber process at a different number than 1? I have about 2000 records in a log and I would like to start the access log at 2001, can this be done? Thanks in advance. Enrico

Is there any way to prevent info in a column of a table from being deleted (except by an administrator) after it is inserted from a form by a user?