Search results

I put it on lost focus but I think it might be on focus otherwaise the command button exit takes over

thanks for the help. however when I click the close button I still get the message box and when that is closed the form closes and the record has a start time with no workers name.

I enetered this code so that if you go to close the form and "proofreaders name" is null I want it to not close and set the focus back on the "proofreaders name" however all I get is an error message on the set focus line.. any suggestions? Private Sub Close_form_LostFocus() If...

WayneRyan thanks for the info. If and when I complete this I can send you a copy if you would like.

I have never tried this. They want me to develope a database to track and schedule copy jobs. The pc will be linked to a flat screen on the wall that will show all the jobs when they are do who they are assigned to etc. Is it possible to have that report or form include a clock and continually...

Thanks for all the help.

Thanks. But where would I put it? In the global code as a private sub?

Thanks but I am not talking about a form. I am talking about the actuall background in access.

Within a database is there a way to add a picture or change the dull grey background of access?

sub compactDB() dim je as new jro.jetengine if len(dir("c:\folder name\whatever.mdb")) then kill "C:\folder name\whatever.mdb end if je.compactdatabase sourceconnection:="data source=c:\folder name\whatever.mdb,_ dest connection:="data source=c:\folder name\whatever.mdb; "&_ "jet...

Go to Tools Options Click on the General tab Click "compact on close"

I have a combo box that pulls down customer name and auto fills a text box with the customer #. The bound column is 3 which is the customer # however I want to save coloumn 1 which is the ID to the table. Can I do this? any suggestions? thanks in advance

thanks

Yes the Query looks for the "Date Returned" to be null. After fighting over this for a few hours I finally decided to change the macro so that after the control button is clicked I have it go to the next record and then go to the previouse record so that the date shows on the form. The user...

I tried both of your examples however when it requeies it only pulls records where the date returned is null so once the button is clicked the record disapears

I have a database for records management and I set up a form to check the boxes back in. I am using a control button to run a macro that when clicked it will enter the date into the date returned check box. This works in other databases that I have however, in this one when clicked it will put...

or buy this http://www.lostpassword.com/access.htm

Try this

I tried this but I get an error that the macro ifme does not exsist? Any suggestions

I have a form with a check box that is checked when a file is returned. How can I make it so once the check box is checked it will auto fill the date in a text box called "date Returned"? thanks in advance