Updating access form book club shoreditch dating

Rated 4.60/5 based on 648 customer reviews

I have a form that displays each of these jobs one-by-one, and has two buttons (Job has been completed, and Job not completed). I cannot find a way to get access to the current record to update it's contents if the "Has been Completed" button is pressed, the closest I can get is the long number which represents the records position in the form. This is called on button-press I am posting an image which shows the form (non-continuous).

The VBA to get the index of the record in the form is as follows. Execute str SQL1, db Fail On Error str SQL2 = "UPDATE job SET JOB_NEXT_OCCURANCE = JOB_NEXT_OCCURANCE JOB_RECURRANCE_RATE WHERE job. @Hans Up, I get what you are saying, but I dont quite think it's applicable (I did not provide enough information first time around for you to understand I think) @sarh I believe this Recordset that you are talking about is what I need, however I cannot figure out how to use it, any hints?

If you append an at sign to the beginning of a person's name, that person will be notified, however, you can only notify one additional person per comment.To run the After Update macro or event procedure without running the Exit and Lost Focus macros or event procedures, save the record by using the Save Record command on the Records menu.After Update macros and event procedures run only if you change the data in a control.If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. I have a job-tracking system, and there is a query that returns results of all jobs that are overdue. Execute str SQL2, db Fail On Error End Sub is completely incorrect, I believe this is what I need to figure out?

Leave a Reply