Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / May 2008

Tip: Looking for answers? Try searching our database.

Transfer field valve to text file and increment

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Studiotyphoon - 20 May 2008 20:20 GMT
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
JohnH - 20 May 2008 23:26 GMT
> HI,
>
[quoted text clipped - 14 lines]
>
> 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?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.