Recent content by Lance R Peck

Is there a way to time an event to occur at a given number of days from the time the database is first used even though it is shut down in between uses? Or Can the timer function be made cumulative for total hours used, even though the database has been shut down between uses.

The application is a small .exe file that I use with access. I start it with a RunApp macro and it will run on top of access. When I close a form with a command button I need it to also close the other application.

The application I want to close is not Access. The Quit or DoCmd seem only to close Access. Is there a way I can close the application from within Access? Here's what I have: Macro for RunApp that has the command: C:\Programs\my application From a form I need a way to close: C:\Programs\my...

I have an application that starts with a command button on a form (macro using the RunApp command). I need to close the application with a command button. How can I do this?

I have database that I would like to distribute. How do I make the forms adjust to differnet monitor sizes?

How can I make a field of a new record on a form default to the value of the same field of the previous record (automatically)? I want the field data to repeat until it is chaned by typing in new data, then the new data becomes the default until changed.

I want to calculate the difference in time between two fields to get a duration. Start time 01:10:53 Stop time 01:20:05 Duration 00:09:12 How can I achieve this? Or can I?

Thanks, that worked to broaden the search. Both Darren and Travis's expressions worked. I have implemited them both.

Good, I've got that working now, thanks. How can I use an * for the wild card. When I enter an * the search comes up blank.

How can I create a form that will allow the text entered to be entered into the criteria row for a Select Query? Can this be done? What I want to do is type search criteria into a form field and have it be the search criteria of a query.