ansaurus

Question

Where can I find MSAccess Control in Database

Answer 1

+1 A:

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?

David M 2010-01-13 15:27:00

When I view the code it just has a few simple functions. I guess there must be a "global" code module somewhere where can I find this?

zzapper 2010-01-13 15:29:12

You can choose Alt+F11 to open the code window and then choose Edit->Find or ctrl+F to find code. Make sure you select Current Project.

Remou 2010-01-13 15:29:46

It is also possible that a library has been added to References, check the references (Tools->References) for anything called *.mde or *.mdb or just anything unusual :)

Remou 2010-01-13 15:31:44

I have been given notes from last year which state."Change This Year and Next Year in program to 2008/2009"This Year and Next Year are obviously global for the Database Application so where would they likely be declared?

zzapper 2010-01-13 15:48:59

If it says This Year with a space between This and Year, I think it is likely to be a table. You can use ADO to find the table that contains these columns http://stackoverflow.com/questions/1851883/how-to-find-list-of-all-tables-in-access-database-matching-certaing-format-in-del

Remou 2010-01-13 18:06:41

Answer 2

+1 A:

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

There is your code

Andreas Hoffmann 2010-01-13 15:28:31

Useful! char char

Remou 2010-01-13 15:33:12

Or, once you've typed the function name, hit SHIFT-F2.

David-W-Fenton 2010-01-14 02:57:00

Or, hit F2 in the VBE and type the function name in the search box and hit the binoculars.

David-W-Fenton 2010-01-14 02:57:46

BTW, those who don't know these keyboard shortcuts might spend some time browsing the menus in the VBE, which give all these shortcuts right there on the menus beside the commands themselves.

David-W-Fenton 2010-01-14 02:59:07

Answer 3

A:

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

zzapper 2010-01-13 16:06:22

"it may help somebody else" ... mhhhh ... not sure!

Philippe Grondier 2010-01-14 19:52:07

ansaurus

tags:

views:

answers:

Where can I find MSAccess Control in Database

related questions