How can I make a procedure run at a certain time everyday. I was thinking about using the "
If Timevalue= 12:00:00 then
RunMacro "X"
End If
But How would I execute this procedure. Is there a better way todo what I am trying to do?
I have a combo box, in a subform whose value list is based on a query. How can I make these values reflect the true result of the query without closing and reopening the main form.
Thanks
This code is intended to send an appointment. When I double click my command button,in Access 97, nothing happens, and the appointment that I am send to myself does not appear. Any ideas, here is the code:
Private Sub Command94_Click()
Dim objOutlook As New Outlook.Application
Dim objAppoint...
I am updating a date, and userid field with "afterupdate" property set on the form property. When I do this, the entire form locks, except, the record that was updated. I can't even go into design view.
What am I doing wrong,
Thanks
How can I use the environs function, in a form to capture the NT userid of the person updating aform. There is a field called "username" on the form that should capture this.
Thanks
When I try to execute this code, I get en "Error 91, object variabe or with block not set.
The purpose of the code is to update a record in a table, based on a match of a field on a form. The code will be executed from a command button.
Option Compare Database
Dim MachineNames As Object...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.