Exporting Reports with subreports to excel

ok the 2 boxes still came up hit ok on both the sheet opened but its missing the 2nd part code. the 1st and 3rd are good.
 
Okay, I must be tired... it's a little after 10:00 pm. How about I have it fixed by tomorrow AM?
 
yes absolutely no problem. i hear ya me tired too.

ty
 
Okay, just ran a test and it came up perfect. Are you sure you copied the amended code I sent.

Guess I wasn't that tired...
 
YEEEEESSSSSS.....i think we got it.....thank you. ok so i can use all this for the other products i have right its all in the same format as this form.

This has been a great experience with you. Great to work with you.
 
Well, that's done....

As long as they are all laid out the same way, yes, for all the reports.

No problem that's why we're here!
 
Yes they are... thank u...I will let u know how it all turns out.
 
Just want to say thanks again for all your help. I made several database using this code and I also added some fields and I didnt blow it up. LOL.

thanks again.
 
Since you were so great on helping me on this project, I have another project. But I am not sure this is even possible. I will try to explain. As you know I have a database with linked tables. We have different servers that we map to. We have a server in mexico that is separate from ours here. Because you can't cross servers with these links unless you are mapped to it (unless you know a way that the link tables can be accessed). What is done now, the files (pdf's and cut files) are updated through a program that takes the files on our server and updates their server when there is a change or update. We tried that with these database files but it was just copying the database including the linked tables but that wont work because they can't open it. So I made copy of the database but just imported the table instead of linked it. But this will not update when I make any changes to the data as you know since the tables are no longer linked. I would have to import the tables every time I change any of the data to copy over the old data. And there are several databases that I use. Do you know a way to automatically update or anything like that. I am not sure if I explained this right. Let me know what you think. thank you so much.
 
Nope, don't get it... at least I don't think I get it because it sounds like you want to share files without using Remote Desktop or a VPN... is that what you are saying?
 
They were using a VPN but it was so slow they couldn't open anything especially access databases. So they got them their own server but because all my databases are on my server here and he cannot map to mine(still over the VPN and slow) the links on my database dont work because it cant find the path. In order for him to receive any updates on my databases it needs to be link to my main one but since he cant map to it that doesnt work. So i thought maybe give him copies of the database with out the link tables just the imported tables. but i need a way to give him the updated boms when things change pricing, new boms etc. he wont get that because the tables wouldnt be linked.

This is and example of my path to the link tables S:\Allfiles\snappy\2016\2016 Westland. So because he is not mapped to this drive the boms wont get the linked data it needs and says it cant find this path.

We tried to copy over the databases as data changed (My IT guy has this program that will update that server when someone changes a file PDF or Cut file automatically) but it copies all the link tables instead of just the data that is in the tables.

Having to import the tables everytime there is an update can take alot of work. I was hoping there could be something that can automatically do this without having to do it one by one.

I hope this makes sense :)
 
Yep, makes better sense...

Hmm, no way to do what you want without *fixing* the VPN. Any thing I could think of still involve the VPN and that's not working properly. Try posting a new question maybe someone else has an idea!
 
Hey there again. Got a questions for you. I have a form set up that I created a button to send an email blast. It sends the information in the body of an email and puts in a supbject. Do you know a way to send a email with a report attached instead of the info in the body of the email.

Thanks for your help.:)
 
Thanks for that. But I have a stupid questions. I created a module but how do I get the command button to use it. I thought I know LOL. It gives me an error on the Public. It says Invalid Attribute in Sub or Function.

thanks,
 
You missed this part...

Now, on your Form in the Event Procedure of your Command Button place…

Code: 
Call eMailOverdue
 
You must log in or register to reply here.

Similar threads

F
Help request for creating Reports with pictures
Replies
3
Views
223
Mark_
M
S
Is there a way to have print/save options for filtered form without utilizing right click?
Replies
10
Views
518
Gasman
Gasman
Safaa
How to display a specific number of records in a subreport linked to the original report with the patient code
2
Replies
20
Views
796
Pat Hartman
P
F
Solved Mask with sub-mask filtered by 2 combined drop-down boxes and a checkbox, opening two different reports depending on the checkbox
Replies
6
Views
352
Faoineag
F
P
Solved current record PDF issues
2
Replies
23
Views
502
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom