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 TouchToneTommy 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: mjones219
  • Content: Threads
  • Order by date
  1. mjones219

    Incremental/Auto-Number w/Combo Box selection???

    I have an Assignments Table (tblAssignment) that I need to have incremental numbering on a field so that each record has a unique number. However the numbering is alpha-numeric: YYYY-xxx-0000 where YYYY = the current year (4-digits); and xxx is 3-alpha-characters limited to a...
  2. mjones219

    Telephone Field for Toll-Free numbers only

    I need to restrict input in to a telephone field. I want to allow only the entry of an "8" as the first number in the input mask "(000) 000-0000". How do I make the first number only allow an "8"?
  3. mjones219

    Show Leading Zeroes in Numbers and Dates

    How do I make number fields (autonumber and/or number) display the leading zeroes, such as 0007? Also, How to default date fields to show leading zeroes, such as 06/02/02?

Part and Inventory Search

Back
Top