accessdummy
Registered User.
- Local time
- Today, 09:46
- Joined
- Sep 7, 2003
- Messages
- 44
Subject: [Access 97] Creating form interface to select fields from a table and Exporting (filtered) data into Excel spreadsheet.
Greetings,
I will like to consult the experts here on
A) how to create a form interface (as shown in the image) for people to select the +fields they want from the table.
+fields refers to the necessary fields. In my table, I have boolean fields which people do not need to know. for example,the fields in my table are ID, Name, Email, Address, telephone, boolresign (for employees who have resigned). I do not want to reflect the boolresign field in the form created.
B) have an inbuilt filter command to filter out records. e.g: I want to filter out records which boolresign = "No"
C) export data into excel.
I don't have knowledge on the technicalities behind this. However, the logic is quite the same as building a query and then export the data into excel spreadsheet.
I will want to k.i.s.s by creating a form interface which can resolve the technical issue of having the end users to build a query and export to spreadsheet. Tough on me but easy for the end users.
Pls help. Thanks.
Greetings,
I will like to consult the experts here on
A) how to create a form interface (as shown in the image) for people to select the +fields they want from the table.
+fields refers to the necessary fields. In my table, I have boolean fields which people do not need to know. for example,the fields in my table are ID, Name, Email, Address, telephone, boolresign (for employees who have resigned). I do not want to reflect the boolresign field in the form created.
B) have an inbuilt filter command to filter out records. e.g: I want to filter out records which boolresign = "No"
C) export data into excel.
I don't have knowledge on the technicalities behind this. However, the logic is quite the same as building a query and then export the data into excel spreadsheet.
I will want to k.i.s.s by creating a form interface which can resolve the technical issue of having the end users to build a query and export to spreadsheet. Tough on me but easy for the end users.
Pls help. Thanks.
