Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: NavAmmo
  • Content: Threads
  • Order by date
  1. NavAmmo

    Week Of Year

    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?
  2. NavAmmo

    Multiple criteria in Dmax/Dlookup

    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...
  3. NavAmmo

    Dumb Question

    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?
  4. NavAmmo

    Rolling serial number

    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...

Part and Inventory Search

Back
Top