Button to create a report with selectable filters (1 Viewer)

Jab331 · Sep 26, 2018

Hi everyone,

I need to create a button on a database switchboard to "Tool List Via Customer" so basically i would like to be able to click the button which will then bring up a list of customers with check boxes (doesn't need to be a check box, just a selectable list) so one can be selected which then created a report showing all of their tools and relevant information in the table.

I am pretty much a complete novice so all help is appreciated.

Thanks,

Jack

Ranman256 · Sep 26, 2018

you can have the customer table have a field : MARK , as y/n
show the list and the MARK field, the user checks the customers wanted.

then the report query would join to the customers table where MARK = TRUE.
then your report will show only those chosen.

an update query may be needed to set all MARK = false, to start fresh.

Jab331 · Sep 26, 2018

Thank you for your reply.

I'm really sorry but i wouldn't really know where to start with trying to implement that, prior to this project i have only ever been an end user of access databases, rather than a creator.

Thanks,

Jack

GinaWhipp · Sep 27, 2018

Hmm, well I would suggest a List Box on a Form. Create a multi-select List Box with the list of Customers making sure the first column of the List Box is the Customers Primary Key. Once you do that post the name of the List Box and the field name of the first column of the List Box which is the Primary Key and the name of the Report that you want to display.

Jab331 · Sep 27, 2018

Hi Gina,

I have created a list box and entered just a few of the customer names for now just until i have a working model, i have also create an ID field giving each customer a number.

The list box is called "Customer_List", the Report is called "Customer_Report" and the field name is called "ID".

Thanks

isladogs · Sep 27, 2018

Gina's suggestion is very similar to the listbox & form question you had yesterday. Use a similar approach in this case.

I would strongly recommend you work through some online Access tutorial videos. Those by Steve Bishop & Richard Rost are both very good covering everything from the basics through to advanced concepts.
Time spent doing this now will repay itself many times over in time saved in the future

arnelgp · Sep 27, 2018

add a button on the form to do the actual print-out.
add code to it's Click Event:

Private Sub button_Click()
Dim strFilter As Variant
Dim varItem As Variant
strFilter=Null
If Me.Customer_List.ListIndex <> -1 Then
For Each varItem In Me.Customer_List.ItemsSelected
strFillter = (strFilter + ",") & Me.Customer_List.ItemData(varItem)
Next
DoCmd.OpenReport "Customer_Report", acViewPreview,, "ID In (" & strFilter & ")"

Else
Msgbox "You need to select at least a Customer from the List"
End If
End Sub

GinaWhipp · Sep 27, 2018

I see arnelgp posted the next steps. Did that give you what you want?

Button to create a report with selectable filters (1 Viewer)

Jab331

Registered User.

Ranman256

Well-known member

Jab331

Registered User.

GinaWhipp

AWF VIP

Jab331

Registered User.

isladogs

MVP / VIP

arnelgp

..forever waiting... waiting for jellybean!

GinaWhipp

AWF VIP

Similar threads

Users who are viewing this thread