T
Tom C
My functions worked in Access 2000 and 2003, but dont work in Access 2007.
Any tricks to this?
Any tricks to this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
Tom
Did you?:
* successfully compile the Access 2000 (and 2003) applications before
trying them in Access 2007?
* confirm that all references are set in Access 2007 (and not showing as
MISSING)?
You don't mention whether the functions that aren't working are actually
Access' (like "Date()" or "Sum()"), or are truly "your" functions? If they
are yours (i.e., home-grown), what are they (?all of them?!) trying to do?
More info, please!
Regards
Jeff Boyce
Microsoft Office/Access MVP
Did you?:
* successfully compile the Access 2000 (and 2003) applications before
trying them in Access 2007?
* confirm that all references are set in Access 2007 (and not showing as
MISSING)?
You don't mention whether the functions that aren't working are actually
Access' (like "Date()" or "Sum()"), or are truly "your" functions? If they
are yours (i.e., home-grown), what are they (?all of them?!) trying to do?
More info, please!
Regards
Jeff Boyce
Microsoft Office/Access MVP
T
Tom C
The functions are "homgrown". They do such things as analze text and convert
it into all capitals to match other portions of reports using multiple
databases. One uses a month number and assigns an abreviated month name, and
one cleans up data by removing commas, etc so that the data can be imported
into other databases.
I think I found the answer to my problem. I did need to recompile my
functions and had to change the security level to "enable all macros". Is
there a way to enable my macros without openning "Pandora's Box" like this?
it into all capitals to match other portions of reports using multiple
databases. One uses a month number and assigns an abreviated month name, and
one cleans up data by removing commas, etc so that the data can be imported
into other databases.
I think I found the answer to my problem. I did need to recompile my
functions and had to change the security level to "enable all macros". Is
there a way to enable my macros without openning "Pandora's Box" like this?
J
Jeff Boyce
If you are working in Access 2007, the new security (thanks, Microsoft...)
can use either trusted locations or "signed" code.
What I've done for my day-job customers is set a folder up on their hard
drives that only I put things in, then trusted that location (and
sub-folders) from my Access 2007 applications.
Regards
Jeff Boyce
Microsoft Office/Access MVP
can use either trusted locations or "signed" code.
What I've done for my day-job customers is set a folder up on their hard
drives that only I put things in, then trusted that location (and
sub-folders) from my Access 2007 applications.
Regards
Jeff Boyce
Microsoft Office/Access MVP
T
Tom C
Thanks Jeff,
You've been most helpful.
Tom
You've been most helpful.
Tom
Jeff Boyce said:If you are working in Access 2007, the new security (thanks, Microsoft...)
can use either trusted locations or "signed" code.
What I've done for my day-job customers is set a folder up on their hard
drives that only I put things in, then trusted that location (and
sub-folders) from my Access 2007 applications.
Regards
Jeff Boyce
Microsoft Office/Access MVP