Search results

  1. L

    Solved Using a parameter in a query that will have a changing number of search values

    Hey guys, I currently have a simple query with a parameter to allow the user to type in an item code and pull all of the information required, I then have a macro to export this data to Excel. What I would like to do is be able to enter multiple item codes at once so that I can export the...
  2. L

    Solved Difficulty calling a macro from a different database to export a query as a text file

    Ah okay, I've just tested quickly with the Excel file and that had 0 problems exporting to txt. It's not a problem, I've decided to link the Excel export created from the external database to my current one and I have an append query to update the tables within my database. This seems to do the...
  3. L

    Solved Difficulty calling a macro from a different database to export a query as a text file

    I don't think it has to be text, that's just what I tried first and was curious as to why that didn't work at all but Excel was perfectly fine. Just in case I encounter the problem again but do need it to be text. Access is all very new to me so still getting to grips with it all.
  4. L

    Solved Difficulty calling a macro from a different database to export a query as a text file

    Hey, Thanks for answering. I haven't tried this since there are actually 8 external databases (currently separated for use by different parts of the business, this was setup before I joined the company). All of the databases give a similar output so I was going to mimic my query/macro once...
  5. L

    Solved Difficulty calling a macro from a different database to export a query as a text file

    Hey, Thanks for answering, the size of the Excel file is 9kb so I believe it's something to do with Access.
  6. L

    Solved Difficulty calling a macro from a different database to export a query as a text file

    Hi Everyone, So my issue currently is: I would like to run a macro to call a query from a database that contains a lot of information I need for what I am doing (this separate database is owned by someone else and multiple people input data into it). I have setup a query in this separate...
Top Bottom