Search results

  1. W

    SHELL command

    Hi I'm trying to use this command: Shell "C:\WINDOWS\explorer.exe """ & Me.txtSource & """, VbMaximizedFocus" to open a folder from within Access 2007 & Windows7. It works, but it always opens the folder minimised, whether I use VbMaximizedFocus or VbNormalFocus. It used to work properly in...
  2. W

    Sub or Function not defined

    Hi All I've got a weird problem. When I try to compile the code below I get the error message 'Sub or Function not defined'. I'm using Access 2007. For x = 0 To 20 If Nz(rec1(x), "") <> Nz(rec2(x), "") Then DoCmd.SetWarnings False strSQL =...
  3. W

    Works then doesn't then does - repeat!

    Hi I'm trying to run a bit of code in Access 2007 on Excel 2007. Its supposed to open 2 workbooks, change the names of the sheets, copy one sheet to the other workbook, save it with a new name then close. My problem is it works... once. Run it again and I get errors (Run time error 462 at the...
  4. W

    DoCmd.TransferSpreadsheet acExport - loses part of dataset

    Hello :banghead: I am exporting a query from access to excel (both 2003), then creating a pivot table in excel from access. This all works fine. I use the same query with different criteria to produce different reports, then output them to excel, create the pivot table, close excel, rinse...
  5. W

    Access VBA query error 3122

    Hello First post here! I am using MS Access 2003 VBA. I have a query that worked and did what I wanted... strSQL = "SELECT tblCombiSS.CustomerID, tblCombiSS.CustomerName, tblCombiSS.UAID, tblMaterials.MaterialIDDW, tblMaterials.Material, tblMaterials.P24BUABR...
Back
Top Bottom