Search results

Alright it worked well. Again, thank you for all of your help! It is greatly appreciated.

Actually, I just now thought of something. Instead of having the code close down the excel program in the end, would it be easier to have the command button open excel, export the queries, and just leave excel open so the user can "save as" and close it manually? If this can be done, then ignore...

Works perfectly! I really appreciate all the help you have given me. There is no way I would have figure any of this stuff out by myself, so thank you very much, Isskint!

I named a filepath to a specific workbook when I ran the code successfully before, so I tried using your second way and I got "Compile error: User-defined type not defined". I put brackets [] around the items that were highlighted in the code below. [Public Sub ExportQueries...As String] was...

Thank you! That looks like something I can handle. I can't do it until I'm back in the office on monday, but I'll try it then and let you know how it works out.

Thanks for the suggestions, but the layout that you helped me with before is easier to work with. One last question (I think) on those queries that you helped me export to excel earlier. Your code opens up the excel workbook, exports the queries, overwrites it, and closes it back down. Before...

I applied that criteria to [BlockDesDateStamp] and worked just like you said, thank you. Is there any way that I can get it to tally the numbers for each "BlockDesigner"? I attached another document to show you what I mean. So bangel1 would only be listed once and the "Count of tbl" would say...

Attached in the zip folder is a .docx or .pdf with the following: First, I listed the SQL. Second, picture of query in datasheet view. Third, picture of query in design view. Fourth, picture of query in design view with it asking for parameter. Note: I created this query with the 4 field...

I went into the design view of "Block Count (Filtered)" (my query) and try tossing "Month([BlockDesDateStamp]) = (Month(Date)-1)" into the "Criteria" under the field name "BlockDesDateStamp" which is the column that deals with the dates. A window pops up asking to "Enter Parameter Value" and...

Thank you very very much! This works perfectly! I really appreciate that you stuck with me and helped me out! Your code opens up the correct excel workbook, exports the queries, overwrites it, and closes it back down. Before it saves the overwrite, can I get it to ask me to "save as" so I can...

I tried everything again with the same codes as my post above. I hit my command button and all it did was open up excel. Nothing happened to the excel workbook, it stayed the same, it just opened up. I looked back at my access page and it says the error; "Subscript out of range" four times...

Thank you for replying so quickly! Okay, so I created a new module (Module1) and I put your code in. Then, I typed all the "Call ExportQueries" under my command button. I get an error that says: "Automation error. The object involved has disconnected from its clients." I tried a couple...

I took your code, put it under a command button, and tried plugging in my information. Simply put, I'm sure I didn't do something right, so try to be patient with me. I get the error "Compile Error: Invalid attribute in Sub or Function" and it highlights the word "Public" on the second line...

Can I please get some help? I am not good with VBA.

Would you mind typing that out for me? The code I mentioned in the question is copy and pasted from that exact site, because I don't really know what I am doing with VBA. So I tried using his code four separate times and that is where I am at now.

Export multiple queries to multiple excel sheets. Option Compare Database Private Sub Command11_Click() ' ______________________________________________________________________ ' EXPORTS "BLOCK COUNT (FILTERED)" QUERY TO EXCEL SHEET1 Dim rst As DAO.Recordset Dim ApXL As Object Dim...

I'll find another way to figure it out. Thank you for giving it an attempt though and I'm sorry I couldn't make it easier for you to view.

Okay, sorry. It is attached in a zip file. Thanks again for your help!

My queries all basically work the same way. They give me all the data that is in the database for every month that has ever been entered, so I filter them for the previous month. They are set up like so: this isn't code, it is the best way to display the layout) Employee Month of created...

Also since these are monthly reports, the data being exported from access will need to overwrite the old data that is already in the existing excell spreadsheet cells. How would I go about doing this? Thanks for your help.