Search results

Hi, I need to add a new field to display a reference which is automatically generated when a new record is added, except the numbering format will need to be: 10001/0 ... 10001/1 ... 10001/2 ... etc ... 10001/9 ... 10002/0 ... and so on. I will use code to check the last one used and add +1...

Hi all - Need some help! I am creating a database to keep a record of incoming orders. My main table has the following fields, which is linked to a form for easy input: Ref - (Autonumber) for a unique reference Date - (Date) Order Date Customer - (Text) Customers Name Details - (Text) -...

Hi. I am trying to import a FILTERED Excel spreasheet into an access table. One of the columns has numerous blank cells, so I am using a 'non-blanks' filter to reduce it down to just the rows that contain info. These are the rows I want to import. By using the DoCmd.TransferSpreadsheet ...