Search results for query: *

Thank you dilettante!

Thanks a million PHV! So great to have people with such expertise who don't mind answering the "dumb" questions and pointing newbies like me in the right direction! I LOVE THIS FORUM!!

Is there a weekofyear type function for determining what week number (1-52) a given date occurs in? If not, does anyone know of an acceptable alternative to get the same data?

Nevermind, i got it... txtSN = DMax("Doc", "Off-Station", "[SN_Date]=#" & DMax("SN_Date", "Off-Station", "Left ([Doc], 1) = 'N'") & "#") Duh...

I'm using the following code in a database that creates a new record and assigns it a Julian Date, Serial Number, and Timestamp, when a user presses a button. The idea is that the serial must always remain the same number of digits, so it rolls over from N999 to N001 - the timestamp allows the...

That would solve my problem, except that I cannot access individual users' workstations to ensure that setting is selected. Is there any way to accomplish the same thing with code on the database itself?

Is there a way to "lock-out" users, so that only one user at a time can access the database on a file share server?

That's perfect MoLaker, I hadn't even thought of using a timestamp! I think this is going to do the trick!

I'm trying to create a system, whereby an incrementing serial number is automatically assigned to each new entry. The serial needs to increment from 001 to 999, and then "roll-over" back to 001. Duplicate entries are allowed, because the user will enter other identifying data that when combined...