Search results for query: *

Can someone recommend some code that would prevent saving a record or file when the record or file already exists? Thanks in advance.

I hoping someone can suggest some VBA code to do the following calculations. I want to calculate in hour and minutes the total time of an event that may be less than one day, equal to one day, or more than one or two days long. On a subform Users enter a [StartDate] in one field and...

I have a simple search screen that opens with a subform with client records rows based on a query. Users can type in Client ID or Last Name into unbound text boxes and click a search button which run a macro to select/filter out the specific client record row. I want to click or double click on...

I have a simple access db, one main form with basic client demographic data. The main form has 4 subforms that contain multiple records of different client events. I would like to have the subforms default to the last record so as to make the information on the client selected be the most...

I have a report that is based on a select query. When I preview this report it produces multiple pages of the query results. In order to print it you have to use File|Print and select page 1 to page 1 or you get 9 pages. In all the form's text box controls where the data values come from this...

I have an Access database that tracks resident population counts on a daily basis. I have a query problem with the DateAdd function where it won't count Saturday. It counts the population every day of the week fine except Saturday. Saturday is blank. There is a Entry Date and an Exit Date and I...