Search results

  1. C

    DLookup Syntax error

    I am receiving this error in regards to DLookup: Syntax error (missing operator) in query expression 'Course Number = 'FMF 1002" This is line of code where error is happening: CompetencyType = Nz(DLookup("Competency", TableContainUpdates, "[Course Number] = '" & rs.Fields(FieldtoPair) &...
  2. C

    Query to find all field header names contain string

    I need a query to find all the field header names that contain string "PL-" and along with records contain a value with the field name containing "PL-" within a Access DB table. thank you.
  3. C

    VBA Excel 2010 Hide Non Adjacent Columns not working

    I am formatting access data to excel worksheet and the portion of my code runs, but it is not hiding excel columns that I specify. I am including the function below and highlighted code hiding the excel columns portion that does not hide the columns. I took the code generated by Excel when...
  4. C

    Update Access table from Excel Workbook cells

    Access database table was created from importing 6 Excel Workbooks with multiple tabs via a Visual Basic Script. All 6 Excel workbooks all had identical field structure. I wrote a VBA script to create the Access table. The initial ACCESS table contained 502 records and 38 columns (fields). The...
  5. C

    Run-time error 1004 - Save method of workbook failed

    I modified a Function SendTQ2XLWbSheet (access query results to existing excel workbook) in attempting to save Excel workbook and exiting out of Excel after the "CopyFromRecordset" was done. I made these changes when observing each time I called the function I saw it was not saving the file with...
  6. C

    Question run time error 3011 when exporting access report to excel

    Hello, I using excel 2010 and access 2010. I have VBA script runtime error 3011 when running script. It has problem finding access report. First I was passing in as variable with the name. Then I used a script to pull in the report name from access and it is still failing with same error...
  7. C

    Import Excel workbook into Access table using Excel's format (formulas, values, etc)

    All, Is there a way to import an Excel workbook into Access keeping the various worksheets formatting such as Excel sheet's formulas, value, formats, comments, etc.? From google search so far, I can not find such a capability. I am able to import only the data from Excel workbooks into Access...
  8. C

    Question Export access table to multiple excel workbooks with multiple tabs

    I am using Access 2010 and Excel 2010. I need to have VB script to export the access table 502 records by 38 fields into Multiple Excel workbooks each having multiple tabs. In the Access table each record has two fields: Div and Tab that will be used to name each workbook and each tab...
  9. C

    VB Script to import Excel workbooks with multiple tabs in MS Access 2010

    I am using Excel and Access 2010. I have 7 Excel workbooks with multiple tabs with the same type of data need to be imported into a single Access 2010 database. Each tab has identical field names with different number of records. I would like to import automatically by some type of VBscript or...
Top Bottom