Way to dynamically refer to field names?

M

markmarko

I need to export data from many tables into a flat file as an interim
procedure as we switch from tracking work in Excel to Access.

I have created a temp table to collect the data, which can then be exported.

Basic structure is:
tblSalesOrder
tblSalesDetails (Product, Quantity)
tblSalesCodes (a list of codes which are used in lookup on SalesDetails)

Then field names in the temp exporting table are the same as on tblSalesCodes.

I plan to use recordsets to look at each SalesDetail for each SalesOrder,
and place the corresponding Quantity into the proper field on the temp table.

So for instance, temp table fields might be "Candy", "Beer", "Donuts"

When the code looks at the first SalesOrder, it would see "Beer" (2), "Candy
(3).

I would want be able to find the field to send the quantity based on the
product. Ie, a way to refer to the field rsSalesOrders!Beer dynamically.

Any thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Excel check field names Please Help 2
VBA - exporting serial letters to single documents 0
Is there a way to concatenate Sales Details? 2
Loop through form's field names 4
Refer to Field Name dynamically 6
Suggest technique for a totals control based on subform 1
Appending records to new table using field names as values 2
How to set a field in a table as a Primary Key in VBA code? 1

Top