Search results

  1. H

    Access into Excel VBA problem

    Hi, I've read and created a macro that imports a simple CrossTab Query into Excel. I just recorded it and played it back. Works perfectly. But when I tried it again with more columns headers (50 column headers that are time broken down into 15 minute intervals) and run the code. Nothing...
  2. H

    Table data as criteria in Query?

    Is it possible to use data in a table as the criteria in a query.
  3. H

    Multiple Parameter Query from Excel

    Hi, I have an Excel sheet that has data pulling from Access via ‘Import External Data’. I use 6 cells for Parameters Years, Months, Part Numbers etc. This works perfectly if each Parameter has only one criteria. What I can’t figure out is how to allow more than one Part Number to be...
  4. H

    Update Query Help

    I’m new to Access and new to the forum, Hi. I'm in the process of creating a database that uses an Update Query to populate one table to another. I've created a simple 3 field database to practice on. The fields are ID, Colour, Amount. My problem is updating only one figure without wiping the...
Back
Top Bottom