Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: valmatic
  • Content: Threads
  • Order by date
  1. valmatic

    Append query append date to separate field?same table

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

    Append a single record to a table

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

    Outlook task via Access_reminders

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

    switch field to non-edit after initial entry in that field

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

    Set a task to start an access subroutine

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

    Send a task request to a variable recipient

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

Part and Inventory Search

Back
Top