Macros quit working

[vbaInet]

I number these records with an autonumber sequence. ie. If the last changed is numbered 39 then obviously the next change comes out as 40

Not quite. If you have multiple users using your db and they make changes before you do the number would have gone up a bit. So don't rely on that number.

So like I've requested a couple of times, I need to see your macro. And I need to know how it's hooked to your form or control.

 

[eMel]

There are no other people using the database. I have a sample database that I'm trying to set this up on, therefore any number increment is a result of me. The macro is attached directly to a table, not a form or control. Boss wants to know who makes changes on the tables.

Not much in the way of an image. I deleted and started clean, this morning. It's the gist of my logic. I've started to think that maybe it's a group thing.

 

[vbaInet]

You can take a pic on your form and upload it. Or better still, convert the macro to VBA (there's a button for that) and send.

 

[eMel]

Give me a bit. I'll rewrite the macro and then attach the sample database. It's very small. You can then look at the Customer Table's macro.

Thank you for your time.

 

[vbaInet]

Alright the pic is better. You need an entirely new IF (not ElseIf) for the First Name.

What you're currently doing is IF Last Name was changed, it won't check the Else part.

 

[eMel]

Got it all working. Thanks for the help vbaInet. It was definately an Else If issue.

For 'clean-up', I'm going to turn off the navigation window and have it open to a form with controls, etc for reports.

Thanks again!!

 

[vbaInet]

We got there in the end.

For clean-up you want to split your db. This makes sure your forms, reports and code is locked and can't be modified by your users. Look into that.