Custom exports form - Need help please

[CrisMonty]

Hi all,

I'm working on a database at work at the moment just to make my job a little simpler.

My database only has one table of data so it's not complicated.

I would like to create a form that can create customisable Excel exports of the data based on set conditions and exporting only select fields.

http: (//i984.photobucket.com/albums/ae321/MontyMoneyBags/CustomReport.png)

I have one table of data (tblCustomers) which contains all of the fields in the box above.


I would like export the data from the table to excel showing only the fields that are ticked in the box (frmCustomReport).


The check boxes are named chk then whatever the field name is eg. chkLocation, chkStatus. The labels are the names of the fields in tblCustomers.


Is there a way to do this in SQL or VBA? I’m afraid I have little in experience in either.

Any help would be greatly appreciated. I've already learned a lot from these forums.

 

[CrisMonty]

Sorry, the link doesn't work because it was my first post. If you take the brackets out, I think it should work.

Thanks for the link, I'll have a read through that today.