Search results

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

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

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() " _...

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