opening Access '03 file in Access 2007

[hp]

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

 

[Gina Whipp]

HP,

You need to put your database in a Trusted Location...

http://www.regina-whipp.com/index_files/TrustedLocation.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]

Thanks for the advice but the database is in a trusted location.

 

[hp]

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]

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

 

[Gina Whipp]

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]

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]

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