CODEWITHSUNDEEP
ms-access
zzapper
zzapper

Reputation: 5043

Where can I find MSAccess Control in Database

I am updating a MSAccess Database for 2010. When it runs a report it is displaying 2009 rather than 2010.

When in Design View I can see that a Control

=GetThisYearLong() is being called.

But where the heck is this function or whatever? is it code a query a bultin ??

where should I look? Thanks

Upvotes: 0

Views: 91

Answers (3)

zzapper
zzapper

Reputation: 5043

Hi sorry to answer my own question, but it may help somebody else:-

I went into view code on first screen (ie anywhere) and then selected "search current project" and it jumped me to a section called general this found:-

 Global Const ThisYear = 2009
 Global Const LastYear = 2008

 Public Function GetThisYearLong() ...

So the answer for me was to select the option "current project" in the "find" dialog

Anyway thanks you got me there, and thanks stack overflow

phew!! I couldn't go home till I solved this

Upvotes: 0

David M
David M

Reputation: 72850

It's not a built-in function. It must be in the code of your database somewhere, perhaps in a code module? Or in an externally referenced DLL?

Upvotes: 1

Summer-Time
Summer-Time

Reputation: 1874

Press Ctrl + G type in GetThisYearLong right click an say definition

There is your code

Upvotes: 1

Related Questions