G Guest Oct 23, 2007 #1 Hi, is it possible to start a query every day at a specific time, automaticly?
G Guest Oct 23, 2007 #2 You don't say if you DB will be open - so I assume it will not (ie. a backup at night, send reports overnight, etc) You can use xmacro - something like this. msaccess.exe PathToDatabase /x NameOfMacro If I have not understand your question please answer with more details.
You don't say if you DB will be open - so I assume it will not (ie. a backup at night, send reports overnight, etc) You can use xmacro - something like this. msaccess.exe PathToDatabase /x NameOfMacro If I have not understand your question please answer with more details.
G Guest Oct 23, 2007 #3 You understand my question right (sorry for my English) 10x for the reply, but can you help me more about this macro. I dont understand VBA at all
You understand my question right (sorry for my English) 10x for the reply, but can you help me more about this macro. I dont understand VBA at all
G Guest Oct 23, 2007 #4 Hi I you have a form that is open all the time you can use the form's timer to run the macro Something like this Private Sub Form_Timer() If Time() = #12:01:00 AM# Then 'place code here' End If End Sub If the databsae is not open all the time you can use windows scedualer to run it for you. See this link for help (sorry no time at the moment) http://support.microsoft.com/default.aspx?scid=kb;EN-US;230575 good luck
Hi I you have a form that is open all the time you can use the form's timer to run the macro Something like this Private Sub Form_Timer() If Time() = #12:01:00 AM# Then 'place code here' End If End Sub If the databsae is not open all the time you can use windows scedualer to run it for you. See this link for help (sorry no time at the moment) http://support.microsoft.com/default.aspx?scid=kb;EN-US;230575 good luck
