Search results

  1. L

    MS Access 2010 Query Linked to a SQL 2008 database do INSERT to table in MS Access fi

    We have about a dozen inherited Access programs written 10-12 years ago. The author is not here now. We are having to add functionality to the Access code. I have never developed in Access. I am just learning as I go. The problem right now with an Access 2010 database (.accdb) on Win 7...
  2. L

    Question Query/proc/connection problem in MS Access 2010

    re-writing them in VB.Net but there have been higher priorities. We have had to make "minimal" changes to the Access code. I have never developed in Access. Access file: corr.accdb In the VBA code: Set qdf = CurrentDb.QueryDefs("create proc ##tempDimCorrSample 02_noID") qdf.Execute Query...
  3. L

    Changing the connection information on a linked QUERY in Access 2007

    This is about linked queries, not linked tables. With no linked tables, the Linked Table Manager is disabled. I know how to see the connection of a linked query, linked to SQL Server: ?CurrentDB.QueryDefs("create").Connect "ODBC;DRIVER=SQL Server...
  4. L

    Question Problem with Dates in Excel 2003 from Access 2007

    The user gets the front end of Access 2007 from an outside entity. We have no ability to put code in it to export/create a spreadsheet. She exports data to an Excel 2003 format, which includes dates. She checks "Export data with formatting and layout." and "Open the destination file after the...
Back
Top Bottom