Search results

With DoCmd.TransferSpreadsheet can you only use queries and tables? I was trying to run it off my report.

The query that I use to create the report.

Using DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_SoilB", "F:\WH\Ft\Soil Report\qry_SoilB.xls", True, "Test1" I get Runtime Error '3011' " Microsoft Access database engine could not find the object qry_SoilB. Make sure the object exists and that you spell its name and...

hmmm I haven't done that before. Do you have an example?

I initially wanted reports because I was creating additional calculations(Sums, Averages and %'s) at the end but then I found out that when you export reports those additional calculations won't follow. I'm not sure what the best option would be at this point.

Is there a way to have all 5 of the reports be in one excel file but separate sheets?

After changing the code, I do not even need a time delay for this.

Wow.. I knew I was missing something that simple. For some reason, I thought I just needed the location folder and not the file name for that. I will be changing the report names once it is complete. Much appreciated.

I added TWait = Time TWait = DateAdd("s", 15, TWait) Do Until TNow >= TWait TNow = Time Loop Right after 'Set attachments but I am still getting the same error.

"Cannot find this file. Verify the path and file name are correct."

Hello, I have 5 reports that I want to send via outlook at the same time from a push of a button on an access form. I have currently have: Option Compare Database Function sndrpt() Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem Dim strAttach1 As String Dim...

I know this post is very old but I was attempting to do the same thing and came across an issue. When I try to run the mod I get a runtime errorRuntime error '-2147024894(80070002)'. The debug highlights .Attachments.Add strAttach1 It does not appear to be exporting to the file location. If I...

Sorry for responding so late. A few things came up. I was able to get it to work based on your suggestion. I appreciate your help.

Yes, a make table query. The cpearson debugging link doesn't work.

It works if I change it to a make query..... Link doesn't work

From what I can tell, it seems to be working BUT access freezes up after I run the query lol.

I do not want to manually add. It will be roughly right around 200 rows of data. What do you recommend? Yes, I have two tables. I will only be looking at the previous year and the current year. I will be changing these field names eventually.

I do not have Autonumbers in this table. I am trying to figure out a way that I can link the two tables. I have seen a few things on RowNumber but haven't been successful with it.

I may be overthinking this but I have two tables without a common link. Eventually, I am trying to create a report that compares two different years of data. The two tables were created from append queries. Is there any way I can create an additional column that shows the row number? I would...

That is a great read. Thank you.