Computing.Net > Forums > Programming > DoCmd.SendObject acQuery,

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

DoCmd.SendObject acQuery,

Reply to Message Icon

Name: mark
Date: October 23, 2002 at 07:45:22 Pacific
OS: w2k
CPU/Ram: 128mb 500mhz
Comment:

i have this statement

DoCmd.SendObject acQuery, "etc etc etc

then i have another one

DoCmd.SendObject acQuery, "etc etc etc

but only one will work, at any one time

the code sends an query ex access as an excel document via email

basically it will only execute the DoCmd.SendObject acQuery,
once and not again

the values in the statements are only different by the file name

i have tryied seperating them into different modules and it will only execute once.

if i close the application and reopen it, again i can only use the statement once.

full code is below

DoCmd.SendObject acQuery, "actpe", "MicrosoftExcel(*.xls)", emailaddress, "", "", "Automated Call Centre Stats " + subjectdate, "Average Call Time per Extension and Total Calls Made, There is a copy already saved in j:\this other file", False, ""

DoCmd.SendObject acQuery, "tctpe", "MicrosoftExcel(*.xls)", emailaddress, "", "", "Automated Call Centre Stats " + subjectdate, "Total Call Time per Extension and Total Calls Made , There is a copy already saved in j:\this file", False, ""

why can i only run this once

rgds,

Mark



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: DoCmd.SendObject acQuery,

Top N Access Query www.computing.net/answers/programming/top-n-access-query/4404.html

Mailto in VB !! www.computing.net/answers/programming/mailto-in-vb-/3706.html

Displaying Checkbox in email msg? www.computing.net/answers/programming/displaying-checkbox-in-email-msg/15548.html