Using a combobox to affect a query that launches into a report

[kchm2000]

Hi,

I have created a form called report launcher in the following database Country Form v04042017.zip. I am trying to use the form to select the particular country so that the report will generate records linked to the country. Would it be possible for the report to directly also export to excel? Could somebody help with this? thanks in advance

[andy49]

Better surely to export data to excel. It will look less pretty but you'll be able to use the data and even reformat it from inside excel


Sent from my iPhone using Tapatalk

[kchm2000]

Thanks, but do you know how to use access forms to launch an export to excel command? My question is for how to launch an export to excel command.

[andy49]

Yes

On the on update event

Add vba code which runs the query

Check out the transfer spreadsheet function.


Sent from my iPhone using Tapatalk

[kchm2000]

Would someone be able to use the database i uploaded to create an example to help me please?

[aytee111]

For the report, add a Where condition for each of the buttons - where CountryCode=Forms![Report Launcher]!Combo14



For exporting to Excel, add a new button and use the TransferSpreadsheet function

[kchm2000]

Would it be possible for you to help me with the VBA (working example) that is necessary? I am really new to ms access and programming in general. A working example would be big help. thanks

[aytee111]

You don't need VBA for this, you are already using macros and can continue with that if you aren't comfortable with VBA.

[kchm2000]

By the way whats the difference between VBA and macros. Aren't Macros some kind of coding as well? In addition how do i add in the where clause for "where CountryCode=Forms![Report Launcher]!Combo1" Could you point me to which part of the property sheet?

[aytee111]

VBA is code, macros are commands. If you go to one of those macros that you use you will see how to enter the where condition, plus other parameters you could utilize. Take a tutorial on macros before even considering using VBA.