Search results

  1. A

    Query criteria can either have a value or not problem

    I need help. I have a query that can either have criteria specified in a field or not depending on the form that is open. I have a function in the criteria field that is supposed to determine this. I'm having problems working out how to assign a value to the criteria field that means "no...
  2. A

    Export Report to Excel. Columns move position

    Hi I have a report with various calculated text boxes. I have had to add another one to the report and now when the user exports to Excel one of the original text boxes outputs to Excel in a different position. e.g Used to do this txtProblemPercent Text61 Now does this Text61 txtSale...
  3. A

    3 possible criteria in a query parameter

    I have a parameter query that is passed three possible options from a combo box. I have an iif statement to evaluate the criteria. It goes a little something like this..... iif([Forms]![frmWhatever]![combo]= "Choose sales","Sale", iif([Forms]![frmWhatever]![combo]= "Choose...
  4. A

    Dde

    I have managed to run an Excel macro from within Access using the following code XCL = DDEInitiate("Excel", "System") DDEExecute XCL, "[Run(""pmac220502.xls!Auto"")]" DDETerminateAll However when I get to the DDEExecute line, my macro in Excel runs fine but an error message appears in Access...
  5. A

    Running code in Excel via Access using GetObject

    Have managed to open an Excel file via Access by using GetObject. Code as follows..... Set ExcelWorksheet1 = Nothing Set ExcelWorksheet1 = GetObject("c:\bpm-teamlead\performance\Performancemacdata\pmac220502.xls") ExcelWorksheet1.Activate...
Top Bottom