Can this be done using a Form?

[ossse]

So far I have done the following using Tables and Queries, however I have run into afew problems and everybody tells me that the user should not be dealing with Tables/Queries, but only Forms. I have experience with Tables, Queries and Modules, but NONE with Forms.

Before I spend days trying to do the following, I would like to know if it is possible to do the following using a Form. Here is what I would like to do...

1- I have a Table with lots of fields. I would like to display the data (as a form) in the table format (looks the exact same as the table). BUT, the user form/table does not display all of the original fields. I would need to create the form/table using a module

2- The User filters the form/table as desired then runs a module which exports and saves the filtered form/table to a .txt format. BUT the .txt file includes the original fields that were not displayed in the form/table. AND some other fields must not be exported to the .txt file. AND some other fields that contain data must be exported as blank fields (place holders) to the .txt file.

I am just looking for a 'thumbs up/down' if this is even possible using a Form and modules. Any additional tips/pointers of how I will need to go about doing anything would be much appreciated

Thanks in advance!!!

 

[Remou]

Start with a few queries that look the way you want for each section, that is, the form(s) and the export(s). There is no difficulty in excluding fields from a table or including blank fields when you use a query. After that, take the form queries and create single or continuous forms using the wizard. Add a few buttons to export the export queries and all should be well.

 

[fneily]

This is some basic stuff. The first question is answered by the Form wizard. The second question is answered by a combobox or a parameter query. Then a little code to export to a text file.
Your second question is confusing. "BUT the .txt file includes the original fields that were not displayed in the form/table. AND some other fields must not be exported to the .txt file." Sounds contradictory.
By the way, how was it possible to learn about Access tables and not forms?
And you don't need modules to do any of what you'd like.
So the answer is yes, you can do what you want with a form. After you start developing it, then you can ask more specific questions.

 

[ossse]

Thank you for the 'Thumbs Up', and the bit of direction. I am sure that I will have more specific questions once I start developing it.

I know it is odd that I have experience with tables, queries and modules but not forms. I was taught the VERY basics of Access which included tables, relationships and queries. Everything from there was self-taught and 'tek-tips' taught. Since I never knew anything about Forms I was kinda scared to start and just stuck with what I knew and made it work.

Re-reading my post, it does sound contradictory and unclear. Some of the original fields that WERE NOT displayed in the form, I want to display when exported to .txt file. And some of the fields that WERE displayed in the form, I want to NOT display when exported to .txt file.

I do not need any further replies, I just wanted to respond to your replies.

Thanks again!!