Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MS Access Printing Report from Button
The listbox get's it values from another query. I got the parentheses... ='" & BatchFiles.value & "'" Yep it does make sense, but somehow I can't get it to work. But I've made a workaround, deleted the report and made with the excel object my own report. Screen.MousePointer = 11 Dim...- Sscumbag
- Post #8
- Forum: Microsoft: Access Reports
-
MS Access Printing Report from Button
1The data I use in the onclick event is from the listbox named "Batchfiles" 2 Private Sub Print_Click() 'On Error Resume Next If MsgBox("Wilt u de selectie printen?", vbYesNo, "JCF - Print selectie") = vbYes Then DoCmd.OpenReport "rptIncasso", acViewPreview, ...- Sscumbag
- Post #6
- Forum: Microsoft: Access Reports
-
MS Access Printing Report from Button
Thanks so far, but I'm not there yet.. I changed the reportsource, it's not pointing to the query anymore. I pasted the query right behind it. Then I set Filter On = Yes Now when I press the button, a popup shows: Enter Parameter Value When I leave the parameter blank, it will show all...- Sscumbag
- Post #4
- Forum: Microsoft: Access Reports
-
MS Access Printing Report from Button
Hi all, I'm new at this, never did a thing with MS Access... This is my problem.. I have a form with 2 listboxes, the left listbox (Batchfiles) gets its data from a select statement. The onclick event "sends" data to the right listbox (lstDetails) with another query. Private Sub...- Sscumbag
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
