By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,318 Members | 2,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,318 IT Pros & Developers. It's quick & easy.

Transfer field valve to text file and increment

P: n/a
HI,

I have two tables which currently have Autonumber fields which are
used to create a unique number to identify an invoice for each table.

Instead of having two unique numbers I'm after only one.

My thinking behind this is to

Create a text file with a number in it.
Import the text file into a field and then increment the number and
write it back to the txt file, so it can be called again for the next
invoice, whether it is in the first table or second table.
Incrementing by one everytime it is used.

Is the Transfertext code the write code to consider.

Any advise greatly appreciated
Jun 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On May 20, 11:20*am, Studiotyphoon <a...@pidesign.co.ukwrote:
HI,

I have two tables which currently have Autonumber fields which are
used to create a unique number to identify an invoice for each table.

Instead of having two unique numbers I'm after only one.

My thinking behind this is to

Create a text file with a number in it.
Import the text file into a field and then increment the number and
write it back to the txt file, so it can be called again for the next
invoice, whether it is in the first table or second table.
Incrementing by one everytime it is used.

Is the Transfertext code the write code to consider.

Any advise greatly appreciated
I don't understand why you're doing what you're doing, but why don't
you just write whatever value you're trying to increment to a field in
a table?
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.