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...
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
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...
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??
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.