Search results

I get the following error when I try it: 3044 'C:\Documents and Settings\user\Desktop\DeepDiveReports\Grp 11 DeepDive Reports.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. below is the code I am...

I would like to take the USERNAME of the person logged in and pass it to the address of the transferspreadsheet function, below is an example: Private Sub Command3_Click() Dim User As String User = Environ$("USERNAME") On Error GoTo SendError 'Tricare Reports DoCmd.TransferSpreadsheet...

I have a macro the sends an email out and everytime it runs a message box pops up asking something to the effect of "Another application is trying to send an email, do you want to allow this?" Yes or No. How do I prevent this box from popping up and just send the email?

Thank you so much that worked.......

I have a query named "*90JJ AR by Rej" when I run the DoCmd.TransferSpreadsheet function it will transfer the query to Excel however when I open the Excel workbook it opens with an Error saying something like some information is unreadable, so it opens as a recovered workbook. Well it turns out...

I have a couple queries that for some reason someone started the names out with an *, well the TransferSpreadsheet function doesn't like the * in the Query name. How do I Declare a variable as a Query? Thanks

I tried it and it worked like a Charm... Thank you all for helping me with this I really do appreciate you and this forum very much.... Below is what I tested Function test() DoCmd.TransferSpreadsheet acExport, , "90JJ AR by Rej", "C:\Documents and Settings\bconner\Desktop\Access to...

Thank you for your help I will try...

Is it possible to send the query results to a specific worksheet within a workbook? When I use the docmd.OutputTo it won't let me export multiple queries to the same workbook it overrides each the last tab in the workbook with the new query. I want to be able to send multiple access...

I have an Access Database with 3 reports that I would like to export to excel each month. I would like for all three reports to export to the same workbook just to different tabs. I used the select into below but it doesn't work after the first export... into [excel 8.0;database=C:\Documents...

below is the code I am using. When I execute the below code it runs and looks like it is printing then it errors out and the database automatically creates a backup and runs a compact repair. Any ideas why it might be bombing out????? I even tried another PDF writer other than CutePDF Writer...

I was going to use PrimoPDF as the default printer it's program that will convert the Access Report to a PDF File. Problem is I don't know the VBA Syntax for sending the report to a specific printer. I have looked under DoCmd property but I can't find anything.

I have a Report in Access and I would like to Print it to a certain Printer how would I do this using VBA Code?

I have a couple Access Reports that I would like to Export as Excel but I am getting an error saying that Access can't complete the Output Operation. Below is the code for one of the Reports: If Option_Ref_Loc_Bad_Debt_By_Paycode = True Then DoCmd.OutputTo acOutputReport...

I have an Access database with around 8 reports right now and I would like to send all 8 reports out as one single package (within 1 SnapShot File). Is this possible?

Thank you all for your responses they are all very useful and I learned a lot..... I appreciate your help...

I am trying to Output an Access Report as a SnapShot using VBA code, below is the code I am using but I can't find SnapShot under the Output Format... DoCmd.OutputTo acOutputReport, "Rpt_Ref_Loc_Bad_Debt_By_Paycode",

Thank you very much!!! That worked perfectly....

Hi MStef, I tried it but it didn't work. It pulled so long as I selected a location but if I left it blank it pull blank instead of all entries.

I have a query whose Criteria is linked to a Form. Specifically when someone selects a Location and pushes a Button the Query will run and only pull thru the Location that was selected. So far so good, now I would like to add one additional piece of criteria to the same field that if No Location...