Search results

  1. R

    Pulling the record souce object out of Report from a FORM

    I have an option group that has many reports being picked using a CASE statement and being fed into a DoCmd.OpenReport command. I am wanting to not actually run the report, but the query (Record Source) and then export the results into a csv file. the issue is I want the query to be run to be as...
  2. R

    Function Madness syntax error on call

    I've got a problem with a function I wrote. Actually it's with the call. everytime I call the function i get a compile error. I don' t know why thou. The error reads as Compile error: Syntax error The code it highlights is: Private Sub barcodemaster_Click() 'barcodemaster(Numoflabel As...
  3. R

    Shell command passing variable into

    Sorry for posting something you all have thoroughly spoken about before but I am trying to pass RetVal = Shell("C:\Program Files\Seagull\BarTender 6.20\Professional\bartend.exe /F=C:\barcode\IncomingBarcodedbsample.btw /P /C=Numoflabel", 1) I want it to take the Numoflabel and put the number...
  4. R

    Declare variable as Printer Does not work

    I'm trying to run some vb code that declares a printer and then prints on a specific printer that is found. When I try to run the code an error comes up as: "Compile error: User defined type not defined". I saw an earlier posts that said something about the Printers not being accessible, but I...
Top Bottom