I have created a db in access and an access report which I need to open from a form in visual basic.
My vb form contains:
2 calendar controls: I would like the user to be able to select a date range to query for the report.
2 list boxes: The first list box i have (successfully) populated with data from the database. The second list box is empty and is filled with the user's selections (through the use of arrow command buttons).
Here is where I need help:
I then want to use the second list box to query the database and return only the records the user has selected and show these on my access report. I can get my access report to show up, but I am unsure how to query with the list box. I am pretty sure it involves a loop and indexes and SQL. I also need help with the date range query and calendar controls.
This is the code I use to display my access report
'Displays Report
Dim appAccess As Access.Application
Set appAccess = New Access.Application
appAccess.Visible = True
appAccess.OpenCurrentDatabase App.Path & "\Database1.mdb"
appAccess.DoCmd.OpenReport "Usage1", acViewPreview
appAccess.DoCmd.Maximize
but i need to query it before i display it.