Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pperilman

    DoCmd TransferSpreadsheet Help

    cmdReports is the name of the button on the form where the dates are entered. Here is the SQL for one of the queries. SELECT [PCard Transactions].[Full Name], [Employee Data Table].[Supervisor Name], [PCard Transactions].[Transaction Date], [PCard Transactions].Amount, [PCard...
  2. pperilman

    DoCmd TransferSpreadsheet Help

    jsteph - I have a form where I can enter the dates and the query runs based on the dates entered in the form. adalger - The query is just a select query that I need to run quarterly. There are over 30 of them and I was trying to figure out a way to export them to excel all at once rather than...
  3. pperilman

    DoCmd TransferSpreadsheet Help

    I have code written to export 30+ queries to excel using the same date parameters. It runs and creates all of the export files but each file only contains the field headers and none of the data. I have included the code below. Please let me know if there is something I am missing. Private Sub...
  4. pperilman

    Export multiple queries to Excel

    I am not sure this solves my problem. I am trying to run all of the queries using the same date parameters with one button click. I would also be easier if I could just run ti for all queries whose name started with Quarterly so that if queries are added I don't have to go through and manually...
  5. pperilman

    Export multiple queries to Excel

    Ok I finally got around to setting this up and I am having trouble with the DoCmd.TransferSpreadsheet command. I want it to grab the dates entered on the form and export all of the queries starting with the word "Quarterly". I would also like the name of the exported file to be the same as the...
  6. pperilman

    Export multiple queries to Excel

    Thank you for the quick response. i am new to VB and creating this type of thing in Access. Can you give me an example or explain further what you mean by use a form as the source of your parameters? Right now I do not use forms. Only I and others in my department use the DB and just open the...
  7. pperilman

    Export multiple queries to Excel

    I have an access DB with over 30 quarterly reports that are run and sent out to different people at the company. each query is setup eaxactly the same way with slightly different parameters. There is also a prompt for starting transaction date and ending transaction date for each query. Is...

Part and Inventory Search

Back
Top