How can I get the Primary Key to show up in an e-mail?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FargoBison - 11 Jul 2007 22:40 GMT

I created a Help Desk database that once I have the form completed I click on
a macro that takes the information I have selected and places it into an e-
mail using outlook and will be e-mailed to the tech to take care of the pc
issue. I have the tables stored on the server and they are linked to Access
2003.

All the information transfers over except for the Ticket ID (which is the
primary key) field. It doesn't enter that into the e-mail since it really has
not been created because the table has not been updated. I had the table set
to Auto-Number and on the server I had it to increment by one and the seed
was set to start at 100.

Could anyone please give me any ideas how I can get that to update before I
create teh e-mail ticket?

Thanks

Reply to this Message

John W. Vinson - 12 Jul 2007 01:09 GMT

>Could anyone please give me any ideas how I can get that to update before I
>create teh e-mail ticket?

Put a line in the code

If Me.Dirty = False Then Me.Dirty = True

This will force a write of the record to disk, and increment the autonumber.

John W. Vinson [MVP]

Reply to this Message

FargoBison - 12 Jul 2007 16:19 GMT

>>Could anyone please give me any ideas how I can get that to update before I
>>create teh e-mail ticket?
[quoted text clipped - 6 lines]
>
> John W. Vinson [MVP]

Thanks for the help! I was trying to make it harder than it actually was

Reply to this Message