Assign a number to all records in a field 1

[RobPotts]

Hi,

I'm importing a table from excel, which becomes a many part of a query. In order for this to happen however I need to assign the RecallID to each of the records in the import.

The table that get generated as part of the field is called TblRecallImport
The Feild I want to populate the RecallID field in this table for all enteries.
The recall number comes from a combo box ComboRecalID on an unbound form called FrmRecallImport

Can someone please point me in the right direction on how to do this.

Ta


Rob! [Bigcheeks]
Process and Procedure are the last hiding place of people without the wit
and wisdom to do their job properly.

 

[faeryfyrre]

Assuming you use the import wizard to get data out of the excel document, you can run an Update query that sets all records in TblRecallImport (where the RecallID is NULL) to the value in your combo box.

OR

You can learn how to use the Excel object model from within Access to import the data and using a recordset situation set the RecallID when you import the rest of the data.



Alec Doughty
Doughty Consulting P/L

"Life's a competition. Play hard, but play fair"

 

[RobPotts]

Hi,

Thanks for that, I went for the update query and it works great, I knew it would be simple.

Thanks again


Rob! [Bigcheeks]
Process and Procedure are the last hiding place of people without the wit
and wisdom to do their job properly.