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.

Thanks much Duane for that reference. And Skip... you are correct. I noticed right away when I was putting in different times and dates. I appreciate the help.

The previous solution works only in the subform when is opened separately. It doesn't work when the main form is open. The error message I get tells me it can't find the subform or it is not open. Does anyone have any suggestions on how to fix this macro expression.

Your suggestion helped me out. With a slight modification I was able to get exactly what I wanted. A SetValue macro: Item: [Forms]![SfrmEventData]![TotalEventTime] Expression...

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

Thank you both for your help. I will post my second problem in a new thread. I'm hoping you can help me with that one too.

Thanks... Works like a charm. I was just thinking the same thing, but I forgot to cut and past the code in the code builder window under OnCurrent Sub, Doh! Thanks GK, Ken ps. I'll have another question with a simple search and Go To Record issue a little later.

AceMan1, Your suggestion works fine on the first load for the first client. As you cycle through the clients it reverts back to the first record in each subform. Any other ideas?

AceMan1, Your suggestion worked perfectly on all subforms. Thanks Much. Ken Goonan

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

The problem, I discovered, was the DateAdd function on the end date day. Once I removed it from the expression it worked fine. The function in the first day date didn't make any difference since is 0.

I have solved the problem. Thank you all for being interested in helping me. It's nice to know you can get help online, and quickly I might add. I'll be back for sure. I will post my solution on Monday, so if anyone who has a similar problem doing what I am doing they might benefit from the...

After running a test query with the DateAdd function to see what dates return for each day of the week based on my EFF_BGN and EFF_END date expression, it's obvious there is a flaw in it. The dates of the days of the week that return are not correct using the DataAdd funtion. Here is the...

The result I am trying to get is a daily census count of persons from three categories by gender for each day of the week - Sunday through Saturday. Entry and Exit dates can be before, equal to, or after the report period start and end dates.

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