Search results

  1. G

    Solved VBA Code for Printer settings - need updated version

    Hi, The following code I found on https://www.tek-tips.com/viewthread.cfm?qid=599797 supplied by a programmer Nelviticus. It was back in 2003. I'm using MS Access 2021 and I can't compile this. The first stumbling block is SetPrinterProperty with ActivePrinter with the error 'Variable not...
  2. G

    Problem VBA automatic printing Reports to pdf

    Hi I'm using the following piece of code to automatically print to pdf 4 different reports in an Access DB (2021) DoCmd.OutputTo acOutputReport, "ReportName", acFormatPDF, myPathnFile This is working perfectly for 2 of the reports but not for the other 2. These reports are also manually run...
  3. G

    Option Group on Continuous Form - updating all records

    I have a simple option group set up to record responses to questions on a form (Yes, No, Pending). This works perfectly for single records. I have the list of questions on a continuous form binding to a Query for the selected questions. So in design mode there is a single record with one...
  4. G

    Solved Using either Global Variable or Form field as query criteria

    Hi all, it's a number of years since I was a member here before. Back using Access/VBA/SQL after a long absence. I'm having trouble with getting a global variable and/or a form field value to work as a criteria in a query. I think it's because the values are an array. I'm getting the multi...
Top Bottom