Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Version Of SQL NewID

Status
Not open for further replies.
OrWolf

OrWolf

MIS
Mar 19, 2001
291
I have a 32 character text field for a primary key. When inserting into the table using SQL I can use NewID with CAST/REPLACE. I'd like to handle it the same way in Access but I've been unable to find a similar function in Access. Can anyone give me any tips?

Thanks
 
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
3K
SoftwareRT
SoftwareRT
DarkOne72
  • Locked
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
2K
lameid
lameid
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
554
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
2K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top