By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 3,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

Send queries, reports, forms via email

P: 1
How can I send queries, reports, and perhaps forms for one database via email to a colleague who also has Access 2003 and the same database as the one I'm using to create these queries and reports? I'm using Access 2002, 2003, Windows XP and Yahoo email.

How can I send these queries and reports without sending the entire database each time?

Thank you for your assistance!

Mark / SF Bay Area
Jan 16 '07 #1
Share this Question
Share on Google+
3 Replies


nico5038
Expert 2.5K+
P: 3,072
Did you try the SendObject command ?
You'll need to write one line of code for this e.g. behind a button, but that shouldn't be too hard.

Idea ?

Nic;o)
Jan 17 '07 #2

ADezii
Expert 5K+
P: 8,638
Did you try the SendObject command ?
You'll need to write one line of code for this e.g. behind a button, but that shouldn't be too hard.

Idea ?

Nic;o)
If I'm not mistaken, wouldn't the visual representation of these Objects be sent and not the Objects themselves. I don't think that they would be able to be used in the Recipient's Database. Please correct me if I am wrong.
Jan 17 '07 #3

nico5038
Expert 2.5K+
P: 3,072
Hm,normally data is exchanged, but when you want to exchange the definitions, then the best way would be to define a new empty .mdb and import the new objects using the File/Get external data/Import. Then the .mdb can be mailed witout the data it should be small.
This process can be automated by using VBA.

Nic;o)
Jan 17 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.