If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
opening Access '03 file in Access 2007
Hello to all
I have a 2003 database that I am opening in Access 2007. I am noticing that I have lost some functionality. More specifically the macro that looks for changes to project information on a form and then sends a snapshot to the boss. It works fine if opened in Access 2003; but when opened in 2007 it doesn't email the information. Thank you This thing is driving me out of my mind |
#2
|
|||
|
|||
opening Access '03 file in Access 2007
HP,
You need to put your database in a Trusted Location... http://www.regina-whipp.com/index_fi...edLocation.htm -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "hp" wrote in message ... Hello to all I have a 2003 database that I am opening in Access 2007. I am noticing that I have lost some functionality. More specifically the macro that looks for changes to project information on a form and then sends a snapshot to the boss. It works fine if opened in Access 2003; but when opened in 2007 it doesn't email the information. Thank you This thing is driving me out of my mind |
#3
|
|||
|
|||
opening Access '03 file in Access 2007
Thanks for the advice but the database is in a trusted location.
"Gina Whipp" wrote: HP, You need to put your database in a Trusted Location... http://www.regina-whipp.com/index_fi...edLocation.htm -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "hp" wrote in message ... Hello to all I have a 2003 database that I am opening in Access 2007. I am noticing that I have lost some functionality. More specifically the macro that looks for changes to project information on a form and then sends a snapshot to the boss. It works fine if opened in Access 2003; but when opened in 2007 it doesn't email the information. Thank you This thing is driving me out of my mind |
#4
|
|||
|
|||
opening Access '03 file in Access 2007
Thanks for the tip, the database is already in a trusted location and the
function still won't email. What's crazy is that if the user adds a project it will email; if they edit a project it won't email. "Gina Whipp" wrote: HP, You need to put your database in a Trusted Location... http://www.regina-whipp.com/index_fi...edLocation.htm -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "hp" wrote in message ... Hello to all I have a 2003 database that I am opening in Access 2007. I am noticing that I have lost some functionality. More specifically the macro that looks for changes to project information on a form and then sends a snapshot to the boss. It works fine if opened in Access 2003; but when opened in 2007 it doesn't email the information. Thank you This thing is driving me out of my mind |
#5
|
|||
|
|||
opening Access '03 file in Access 2007
HP,
Next thought... I have not tried this but I image it could be a problem. Trying to eMail thru Access 2007 via an Access 2003 database that is probably confused about which Outlook version to use. Are you using late binding? If you are unsure, post the code you use to send the eMail. Another thought... are the .snp files in a Trusted Location? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "hp" wrote in message ... Thanks for the advice but the database is in a trusted location. "Gina Whipp" wrote: HP, You need to put your database in a Trusted Location... http://www.regina-whipp.com/index_fi...edLocation.htm -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "hp" wrote in message ... Hello to all I have a 2003 database that I am opening in Access 2007. I am noticing that I have lost some functionality. More specifically the macro that looks for changes to project information on a form and then sends a snapshot to the boss. It works fine if opened in Access 2003; but when opened in 2007 it doesn't email the information. Thank you This thing is driving me out of my mind |
#6
|
|||
|
|||
opening Access '03 file in Access 2007
HP,
Scratch my last thoughts... Try putting the macro in the On_Dirty of the form where the Project is edited. Of course, this will mean everytime a Project is edited it will send the eMail, if that is what you want... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "hp" wrote in message ... Thanks for the tip, the database is already in a trusted location and the function still won't email. What's crazy is that if the user adds a project it will email; if they edit a project it won't email. "Gina Whipp" wrote: HP, You need to put your database in a Trusted Location... http://www.regina-whipp.com/index_fi...edLocation.htm -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "hp" wrote in message ... Hello to all I have a 2003 database that I am opening in Access 2007. I am noticing that I have lost some functionality. More specifically the macro that looks for changes to project information on a form and then sends a snapshot to the boss. It works fine if opened in Access 2003; but when opened in 2007 it doesn't email the information. Thank you This thing is driving me out of my mind |
#7
|
|||
|
|||
opening Access '03 file in Access 2007
Hello Ms. Gina,
I'm sorry, I am having trouble with this forum I didn't get your last reply about late binding. I don't know what that is but I will look it up in case it helps. I think i can isolate the part of the code that sends the email and post it. I was thinking about what you wrote concerning the outlook versions and I thought that you were on to something; but I don't think that would be the case because it works when adding a project just not when editing a project. Also, how would i check if the .snp is in a trusted location; i thought it would be stored temporarily. Not to mention that the ..snp for adding a project works fine. Thanks soooooo much for the help will try to post code pronto "Gina Whipp" wrote: HP, Next thought... I have not tried this but I image it could be a problem. Trying to eMail thru Access 2007 via an Access 2003 database that is probably confused about which Outlook version to use. Are you using late binding? If you are unsure, post the code you use to send the eMail. Another thought... are the .snp files in a Trusted Location? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "hp" wrote in message ... Thanks for the advice but the database is in a trusted location. "Gina Whipp" wrote: HP, You need to put your database in a Trusted Location... http://www.regina-whipp.com/index_fi...edLocation.htm -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "hp" wrote in message ... Hello to all I have a 2003 database that I am opening in Access 2007. I am noticing that I have lost some functionality. More specifically the macro that looks for changes to project information on a form and then sends a snapshot to the boss. It works fine if opened in Access 2003; but when opened in 2007 it doesn't email the information. Thank you This thing is driving me out of my mind |
#8
|
|||
|
|||
opening Access '03 file in Access 2007
HP,
Please see my other reply... I reread your question and had another thought! -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "hp" wrote in message ... Hello Ms. Gina, I'm sorry, I am having trouble with this forum I didn't get your last reply about late binding. I don't know what that is but I will look it up in case it helps. I think i can isolate the part of the code that sends the email and post it. I was thinking about what you wrote concerning the outlook versions and I thought that you were on to something; but I don't think that would be the case because it works when adding a project just not when editing a project. Also, how would i check if the .snp is in a trusted location; i thought it would be stored temporarily. Not to mention that the .snp for adding a project works fine. Thanks soooooo much for the help will try to post code pronto "Gina Whipp" wrote: HP, Next thought... I have not tried this but I image it could be a problem. Trying to eMail thru Access 2007 via an Access 2003 database that is probably confused about which Outlook version to use. Are you using late binding? If you are unsure, post the code you use to send the eMail. Another thought... are the .snp files in a Trusted Location? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "hp" wrote in message ... Thanks for the advice but the database is in a trusted location. "Gina Whipp" wrote: HP, You need to put your database in a Trusted Location... http://www.regina-whipp.com/index_fi...edLocation.htm -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "hp" wrote in message ... Hello to all I have a 2003 database that I am opening in Access 2007. I am noticing that I have lost some functionality. More specifically the macro that looks for changes to project information on a form and then sends a snapshot to the boss. It works fine if opened in Access 2003; but when opened in 2007 it doesn't email the information. Thank you This thing is driving me out of my mind |
Thread Tools | |
Display Modes | |
|
|