Question Problems after upgrading from 2003 to 2007

[Darrenc]

Hi,

Our company is currently moving to some new servers and unfortunately I’m being forced to move to access 2007

So, i have a problem trying to run the database i had created in 2000/2003. I have a button the i use to open a form, when i click this button i get the following message.

"The expression you entered has a function name that Microsoft access can't find."

I have read up a little on this and some people suggest the problem lies in the trust centre settings.

I have tried every combination in there, and i have created trusted locations for where my access database resides but nothing so far has worked.

Can anyone else help? I’m under a bit of pressure because this is the only thing that’s holding the upgrade back?


Thanks
Darren.

 

[KenHigg]

Can you post your code?

 

[Darrenc]

Thanks for the reply Ken!

As always the answer isn't straight forward , so i'll try and keep this short.

There are five buttons that update depending on what is pressed. 2 of the buttons just link straight to opening up a form (making it visible) the other buttons refresh the button label(s) depending on what was pressed.

(Sorry i left something out, they aren't actually buttons, they are just a combination of labels and images.)

The 2 buttons that link straight to opening the form work ok, its the other buttons that update that crash.

The strange thing is i have put a break in every piece of the code that is on this form, and the error comes before it gets to any of the code?

But like a say the other 2 buttons work fine?

I can't find the problem let alone finding a solution for it.

Any suggestions welcomed

Darren.

 

[Darrenc]

One other thing, my button labels 'On click' event does call a procedure called =MMouseClick(4). Could it be this? Has there been changes to the way procedures are called from 'on click' events in 2007?

I do have a procedure

Private Function MMouseClick(index As Integer)

and i have put a break in the code in there but it doesn't get to the code before it errors.