Recent content by Ikon

  1. I

    Suspend Screen Painting During Form Updates

    Apologies, I'd just been working with an Excel query and this method is from Excel not Access.
  2. I

    Suspend Screen Painting During Form Updates

    You can probably achieve this with: Application.Screenupdating = False before your update code. And then use: Application.Screenupdating = True after the code has finished. Hope this helps. - Mike
  3. I

    Exporting Access Query to Excel (into a temp file)

    The way to make a new workbook is this: Sub newBook() Dim myExcel As Excel.Application Dim myBook As Excel.Workbook Dim mySheet As Excel.Worksheet Set myExcel = CreateObject("Excel.Application") myExcel.Visible = True Set myBook = myExcel.Workbooks.Add(1) Set mySheet =...
  4. I

    Generate Temp Table in Access from ADO SQL query in VBA

    Ok great :) We have to use ADO as our IT department is not too keen on us linking table with the main database. Thanks a lot for your help :) - Mike
  5. I

    Generate Temp Table in Access from ADO SQL query in VBA

    Thanks for the reply. So would I then need to run through each record 1 by 1 using an INSERT query to add each record? From what I've read this could end up being quite slow but given that I probably won't be copying thousands of records at a time this may not be the case. Is this the only...
  6. I

    Generate Temp Table in Access from ADO SQL query in VBA

    I am writing an application in MS Access. I need to extract data from an Oracle database and load the results into a temporary table in MS Access so that it can be processed in VBA code. The data being extracted takes the form of: Code Job Type User_ID Dstamp Job Start PICK STWMITCHELLB...
See more
Top Bottom