Hi. I am putting the finishing touches on a maintenance and equipment database.
Maint. staff schedules a maintenance job. Once that job completes and is an on-going job (based on frequency), my append query runs and auto-schedules the next instance of this job. The append query pulls most...
HI. I'm trying to create my 1st append query and am having some trouble. I have an append query set to duplicate some record data to a new record in the same table through an on-click event on my form. When I click the button, the query runs but rather than appending the single record, it...
Hi. I have created a button that sends an outlook task but I can't get the reminder or the reminder sound to work. The task is received with no reminder or sound yet the assigned due date is populated ok. I'm lost - does anyone have any ideas? Here's the code I'm using:
Private Sub...
Hi. Does anyone know of a way to make an entry field non-editable after the initial entry into that field?
I have a standard date entry field on an access form that, through some code, measures on-time status of a project and reports the status accordingly. A few of my users are changing the...
Hi. Does anyone know of a way to call a subroutine within access from outside of access? I currently have an on-click event that sends out a series of net sends to my network users based on timeliness of an entry into the table. I would like to automate the event so that it runs weekly (or...
I have a few different on-click events that send a task to a specific address, based on MSDN help:
_______________________________________
Private Sub Ass2_Click()
On Error GoTo Err_Ass2_Click
Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olTaskItem)...
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.