Search results for query: *

I figured it out. Forgot I posted another issue about this same query some time ago but I only needed to refresh the data prior to running the append. The table wasn't getting populated with the calculated date so had nothing to transfer over... I love it when a plan comes together...

Maybe a better description of issue: Hi. I have a ScheduleMaintenance Form and an EditMaintenance Form with a clicky button on both forms that runs a bunch of code, one of which runs an append query that auto-schedules the next instance of an on-going maintenance job once an instance is marked...

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

Yay, I got it. I new I was missing something simple. thanks for the tip Remou:) Thanks also for the quick response Golom:)

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

On the same note, how would I set a reminder prior to the due date. If I change the line oc code above to: myItem.DueDate = [duedate] then how would I set the reminder date 1 month prior to the due date? Sorry, I'm a noob coder learning as I go so any help would be huge to me :) thanks...

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

Worked like a charm... Thanks a bunch for the help PHV :)

Wow, that works great. Thanks so much. One last question: Any idea how to bypass Access security and just run the code? I set up the task scheduler to run the macro through my mdw file and it works fine except the user has to log in to the secured database first. Once logged in, the code...

Thanks for the tips. I'll look at HAL for sure but if I can do it through the task scheduler, even better. I can't find any help on using the /x switch though and I can't figure out how to open the subroutine through a task. Could you provide an example? Here's the path to my database...

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

omg - I can't believe it's that simple. Worked great. Thank you so much. Just so I understand though, what does the "Me." statement do exactly or a link to an explanation would be great. I did a quick google and an explanation didn't really pop up quickly.

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