Search results

Thanks jhb, that worked a treat.

Because the user needs.to select their name and then another macro runs, then their name is passed to the table. Make sense?

Hi All, I have a form in which the user selects a combobox and this value becomes a tempvar called "un" on clicking a command button I need the value of "un" to be passed into a table. "un" is a number. Here is what I have so far..... CurrentDb.Execute "INSERT INTO...

Thanks but the macro that it runs needs to interact with some data in the tables of the main database. So would it have to do a call or something?

Hi all, I would like to have a macro run at a set time each day. I hoped to use .ontime but apparently that doesn't exist in access. The macro must run at 10:00am each day, the db will be open from 8:30am until 16:30pm so no problem from that point of view +/- a few mins when the staff...

Hi all, I am trying to write a more complex macro that will start another macro at a preset time, however I am getting stopped at the first hurdle - getting a macro to run another macro. Here is the code i am using at the moment, all I want to do currently is click the first button, then get...

Textbook, thanks

Thanks, that's fantastic because it works! Is this written down anywhere in a concise form, you know give the man a net not a fish type thing. :)

David, you're probably totally correct but would you mind telling me where and how to change it? Your help is much appreciated. On a side note I really hate having to ask what are probably simple questions but I cant find any good sources on VBA syntax. :banghead:

Its still kicking out a syntax error, "expected end of phrase" and highlighting " BGSnum = " Still a little lost!?!?!

Hi all, I am trying to add multiple WHERE criteria into my UPDATE macro, but I cant seem to get the AND syntax to work. Private Sub update_test_Click() Dim dbs As Database Dim qdf As QueryDef CurrentDb.Execute "UPDATE timedata " _ & "SET timestampstop = now() " _...

Ok, so it worked perfectly when on my message box test but just doesnt want to work when put into VBasic. BGSnum, processdone and startstop are all numbers I feel its always a syntax problem:confused: Private Sub update_test_Click() Dim dbs As Database Dim qdf As QueryDef...

Fantastic cheers!

Great, that works a treat. So am I right in thinking that a third criteria would be? DLookUp("[timedata]![id]","timedata", "[processdone] = " & Forms![Mainform]![p11] & " AND [BGSnum] = " & Forms![Mainform]![BGS] " AND [ABCcriteria] = " & Forms![Mainform]![XYZvalue])

Hi all, I am trying to make a DLookup function to return the ID number of an entry that matches 2 or 3 criteria but I am struggling to get the syntax correct for the second and third criteria. Here is what I have so far: 1 criteria, works fine =DLookUp("[timedata]![id]","timedata"...