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!

  • Congratulations derfloh 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: soulfunkuk
  • Content: Threads
  • Order by date
  1. soulfunkuk

    Input Masks

    Hi, Ive been trying to create an input mask for a reference document field of the syntax: Store-Sku-Date-Item The input mask is as follows: L000-CCCCCCCCCCCCCCCCCCCC-000000-09 or L000-####################-000000-09 a sku can be anything from 8 to 20 characters with either all digits or...
  2. soulfunkuk

    Resetting Autonumber

    Is there anyway of reseting an autonumber field to 1, without deleting and then recreating the table it is in?? For example if you wanted to enter test data and then clear all data out? Cheers Keith
  3. soulfunkuk

    Importing excel spreadsheet with 16 digit numbers.

    Whenever I try to use the import wizard to upload an excel spreadsheet into access it turns all fields to data type "text". Even if I have formatted my spreadsheet so the field is data type "number", it turns 10788574823920 to 10788574823+E11. We have used a select query to repair the number...
  4. soulfunkuk

    Query as part of a sub form

    Hi, I have two subforms as part of a main form. The first subform is a data entry form based on a table. The second subform is a query based on the table. Is it possible to see new records entered in the first subform, on the query subform without leaving the main form??
  5. soulfunkuk

    Laser Scanners and Access

    Is there anyway of scanning barcodes into an access database via a form????

Part and Inventory Search

Back
Top