Access updating records Sex private cams us

25-Sep-2019 15:22

access updating records-47

Free totally live naked chat rooms

Is there a way to automatically minimize/hide query windows or disable screen update?

Hi all, I have a macro that executes ~200 queries which modify the data, create some tables etc.

There may also be a way to execute a macro from VBA using the Do Cmd method, but I'm not familiar with doing that.

Everyone I have talked to has advised me to avoid using macros when possible.

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?

When a name has been entered, select to modify design on completion.