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 Westi 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: *

  1. soulfunkuk

    Input Masks

    Anyone got any ideas I still cant get it to work? Cheers Keith
  2. soulfunkuk

    Input Masks

    I found some info on the following thread, but my problem is that the sku field can be of any length from 8 characters to 20 characters. thread702-1044888 TheAceMan1 (Programmer) 17 Apr 05 22:44 How are ya olypost . . . . . Hard to tell with info supplied, but you can remove the dash with...
  3. 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...
  4. soulfunkuk

    Resetting Autonumber

    Could you delete all the links, reset or compact repair, and then put the links back in?? Would this be safe? Cheers for the help
  5. soulfunkuk

    Resetting Autonumber

    So is this some visual basic code or in properties?
  6. 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
  7. 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...
  8. soulfunkuk

    Laser Scanners and Access

    Cheers MichaelRed that makes perfect sense!
  9. soulfunkuk

    Query as part of a sub form

    cheers
  10. soulfunkuk

    Laser Scanners and Access

    Sorry I meant datamatic scanner. Basically the warehouse dont want to manualy enter the barcodes onto the database they want to be able to scan them on to the database.
  11. 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??
  12. soulfunkuk

    Laser Scanners and Access

    Hi evalesthy, My real question I suppose is how would I setup the MS Access form. Apparently the scanner is datmatic scanner. Thanks Soul
  13. soulfunkuk

    Laser Scanners and Access

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

Part and Inventory Search

Back
Top