Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Macro skipped update query?

Macro skipped update query?

Macro skipped update query?

I have a Database we have used for 12 years. Access 2003 (Access 2000 file format).
The user opens a form it show open invoices we owe to a customer. It is a continuous form. Only one control is available to the user in the Detail. CheckNum, it corresponds to TxtChkNumber in the table.
In the Form Footer, I have an unbound text box, labeled "Pay on Check Number". The user enters the check number for the invoices they want to pay in the CheckNum box and then in the Unbound text box in the footer.
The user clicks the "PAY" button. The button initiates a macro.
The macro first prints the check and then runs an update query. The query updates a yes/no to yes, updates paiddate to today's date for every record with the check number matching the one entered into the unbound text box.

Today for some reason (only one time out of several done today) it looks like the check printed but the query did not run. The User claims nothing out of the ordinary happened when she performed the operation. Is this something that happens? As I have mentioned this has been in operation for over 12 years and we haven't had any problems. My gut instinct tells me the user managed to create this anomaly but she is adamant nothing out of the ordinary happened. You can see how this is a huge problem if paid invoices are not updating to paid.

Follow up Question: Does anyone have an idea for a better way to institute this operation?

RE: Macro skipped update query?

Almost anything is possible. My experience is that the more a user says nothing happened, the more likely it is that something happened! That said, as long as the update query ran for rest of the checks issued today, I wouldn't worry about it. If another user has this happen, then I would worry!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close