Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old December 4th, 2005, 01:27 AM
Registered User
 
Join Date: Dec 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Append table question - newbie at work

I have a table that data will be entered into through a form. On clicking the control I need to generate a unique (non repeating) five digit whole number for the new entry. This number is converted to a string as it will be concatenated with two other strings later.

I am setting up the action to generate the random number, convert to string, then it will compare with existing records in the field and if matches it will run again. If it does not match any records it is to append the new record.

I'm totally stumped on how to get the formula result into the table.



Reply With Quote
  #2 (permalink)  
Old December 4th, 2005, 10:07 AM
Registered User
 
Join Date: Dec 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Disregard. I had a mental block from thinking too much, needed more sleep and less caffeine.

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie question: check if table exists in DB savoym Java Databases 4 March 9th, 2012 05:57 AM
create table/append data. bpdineen Access VBA 1 January 4th, 2007 10:47 AM
Append Query to Table ! penta Access 3 February 24th, 2005 03:24 PM
copy and append records from table-A to table B bhunter Access 6 March 9th, 2004 01:02 PM
Append Records From One Table to Another Table twsinc Access VBA 4 February 29th, 2004 02:04 PM



All times are GMT -4. The time now is 10:05 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.