Dani
03-17-2008, 06:22 AM
I have a database that holds about 3500 records. On the main form, I have several queries for people to run reports and download spreadsheets. My problem is that for every query (we are now up to about 10), I have separate buttons-- one to view the data in access, one to save the data in excel. Obviously, this is really crowding up the form.
I would really, really like to have all the queries there, but to have only one button to view the information in access. I would like the user to be able to select whatever field(s) they are running in the report (these fields are either typed into or chosen by a drop-down box). Ideally, I would like to have only one button to save whichever query they chose to pull up in excel, also, but considering I had to do a macro for each different query to save in excel, I'm not sure if that's possible.
My problem is that I don't know VBA at all. Barely know sql, but otherwise, my access knowledge is pretty complete.
I would really, really like to have all the queries there, but to have only one button to view the information in access. I would like the user to be able to select whatever field(s) they are running in the report (these fields are either typed into or chosen by a drop-down box). Ideally, I would like to have only one button to save whichever query they chose to pull up in excel, also, but considering I had to do a macro for each different query to save in excel, I'm not sure if that's possible.
My problem is that I don't know VBA at all. Barely know sql, but otherwise, my access knowledge is pretty complete.