Phil Peel
11-21-2005, 03:28 AM
Hi All
I need some help on exporting data.
My database is on Access 2000 and consists of the following tables
Styles - Contains a details about each product
Components - A price list of all the components we use
Costings - Is a table that links the 2 together and contains the quantity of each component required for each style.
I have a form that will allow me to view one of the Styles from the Styles table - a subform on this contains the relavant components used from the Costings table - and then the prices of these components from the Components table.
When I try and export using file/export - all I get is the contents of the Styles table for the particular reference I have open.
How do I export all the data for this reference from the Costings and Component table.
I need to be able to export this to a text file or excel spreadsheet.
Will I need a macro to do this? I have used VB in excel - but not in access.
Any help on this would be much appreciated. :)
I need some help on exporting data.
My database is on Access 2000 and consists of the following tables
Styles - Contains a details about each product
Components - A price list of all the components we use
Costings - Is a table that links the 2 together and contains the quantity of each component required for each style.
I have a form that will allow me to view one of the Styles from the Styles table - a subform on this contains the relavant components used from the Costings table - and then the prices of these components from the Components table.
When I try and export using file/export - all I get is the contents of the Styles table for the particular reference I have open.
How do I export all the data for this reference from the Costings and Component table.
I need to be able to export this to a text file or excel spreadsheet.
Will I need a macro to do this? I have used VB in excel - but not in access.
Any help on this would be much appreciated. :)