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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Sscumbag

  1. Sscumbag

    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...
  2. Sscumbag

    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, ...
  3. Sscumbag

    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...
  4. Sscumbag

    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...

Part and Inventory Search

Back
Top