Sorry about taking so long to respond.
Thank you for your assistance, and the scripting!
malteselemon
Last Activity: Nov 2 '07, 02:53 PM
Joined: Aug 24 '07
Location:
-
Roger, I will fix the error when I get backto the office on Monday. Thank you.Leave a comment:
-
My apologies for not getting back to you in a timely manner, things have been hectic. I made the corrections that you pointed out. Now the database is giving me an error on the
strCurrentDay = DateDiff("d", CDate("1/1/" & Year(Now())), , Now()) + 1
line. When opening the serial number table, I receive "Compile error: Arguement not optional: warning, and it highlights the above mentioned...Leave a comment:
-
To see if I could get this to work, I created a new table. I named the
table "tblTest. I entered 3 fields. Field 1 - ID (autonumber), Field 2
-
SerialNo (no format), Field 3 - data (no format).
I then went to the VB (Tools/Macro/Visual Basic Editor). I entered the
code as typed. When I opened the VB, it had autopopulated "option
compare database" on the top line, so I left that information...Leave a comment:
-
Roger, I will have access to the database tomorrow morning, I will try at that time, thank you. I'll reply back whether I manage or not.Leave a comment:
-
This is kind of what I was afraid of. I have no idea where I would put the VB in the database.Leave a comment:
-
Create Specific Unique Serial Number
Using Access 2003, I need to create an automatic Serial Number.
Example "7235-E001"
"7" is current year
"235" is day
"-E" is static
"001" is sequencial, restarting at "001" each day
I set a table field with "=right(Format( Now(),"yy") & Format(Format(N ow(),"y"),"000" ),4)" to create the year/day...
No activity results to display
Leave a comment: