Search results

If you shift open the Database then open VBE and go to Tools>References and uncheck any that say MISSING that should sort out the 1st error. The version of Access you are using appears to be preventing the AutoExec macro from running - is there a way of turning off this disable macro security?

I can't d/l the zip file you've posted from work - crappy restrictions. Any chance you can post the error messages and say when they occur???

In my example the duration of each session is added as a new record into a local table (but this should be changed to a linked table when the Database is split and the Back End password protected so the user cannot access it). The total duration is calculated in a query by summing the individual...

Are the paths still valid? i.e. can you navigate to the specified files using Windows Explorer?

Last revision - this version now shows the user the time they have remaining. Feel free to ask any questions. EDIT - also in this version you can change the time allowed by simply overtyping the value held in Table2

Have a look at the version I've attached to this post. The previous version only checked the time open when the Database was opened, which meant that the user could use the system for as long as they wanted if they didn't close it down. The new version checks the time open every second and as...

Have a look at the attached sample Database I've knocked up. The controls and code on the opening form would have to be incorporated into your main switchboard. The Database is opened to the form. The 'Time Opened' control is set to Time() when the form is opened. The 'Timer' control...

As DCrake says it would be more helpful if you provided an actual example. Please correct me if I am wrong, but here is my understanding of your request:- You have 2 controls, Field1 and Field2 If the value entered into Field1 is equal to the value of the label of Field2 then you wish to...

Something along the lines of:- If Field1 = Field2 Then MsgBox "Please provide answer in Field3" Me.Field3.SetFocus Else MsgBox "Please provide answer in Field4" Me.Field4.SetFocus End If And you want to place this in the after update event of the control EDIT - Then if you only require...

This is an Access forum but I'll provide you with this link which should be what you're after - http://www.excelforum.com/excel-programming/647935-macro-to-create-new-sheet-based-on-value-in-cells.html

You need to remove the links to the tables, then password protect the back end, then link the tables again entering the password for the back end when prompted

Place the code in the On Open event of the form

Thanks for the interest wiklendt - I agree it is a strange setup but I couldn't find any other way around it. I have finally managed to get it working and it was actually a lot simpler than I was making it - only needed to use a SELECT statement for the rowsource of the combo box and change...

I placed this code in the On Change event:- Dim Msg As String Dim Style As vbMsgBoxStyle Dim Title As String Dim Response As vbMsgBoxResult Msg = "Your Question Here" Style = vbYesNo Title = "Your Title Here" Response = MsgBox(Msg, Style,Title) If Response = vbYes Then...

I am having trouble working out how to change the row source of a combo box based on the value of a text box. I have 2 controls - txtCurrentStatus is a text box and cboNewStatus is a combo box. I would like to change the row source of cboNewStatus based on the value of txtCurrentStatus, for...

Ok, here you go. Start by creating a new table with one field and make it a date datatype (formatted short date). In this example I have named my table 'LastAutoImport' and I have named the date field 'LastAutoUpdate' - obviously you can change these names. Now open up VBA and create a new...

I was going to create a function and then run that function from an autoexec macro as deleting/importing are not the only actions to perform. He wants it to run automatically once a day the first time the Database is opened so more work to do. bschultz - I have some code that can do all of...

and that was me being thick - tfi almost Friday!!!

Create new Databases. Just import the objects into new blank Databases with 2003 selected in this option. Then replace the new Back End on the server and distribute the new front end. Obviously some down time but shouldn't take you long. Is having the Database in A2000 format causing you any...

Ok, thats good as there appears to be no need to create a new table and query every day. All you need to do is get the data from your Spreadsheet into your table. As I see it you have 2 options:- 1) You delete the records in the table then import the Spreadsheet data 2) You import the...