Reference problem

[CALV]

Hi all,

Created a very simple dbase at home (access 2002) and all works fine, brought it to work, got 2 mising references:windows common controls 2-6-0 (MSCOMCT2.OCX) and Microsoft common dialog control 6 (COMDLG32.OCX) So I removed the ticks from the references, and tried to add them again, but they wernt listed, I tried browsing and adding them that way but got "can't add a reference to the specified file". Does anyone have any suggestions?

TIA

CALV

 

[Mile-O]

Are you using Access 2002 at work also? Could be that, if you are using an earlier version at work then the references in that version hadn't been "invented" yet - in the sense that their may be a previous version.

 

[Edski]

I noticed this problem once before too, and I'd be interested in the solution ! I discovered that some References are only added when you 'add' a control that 'uses' it. Eg. adding a Microsoft Forms 2.0 control to a form will automatically add the reference to the DLL - without telling you! No big deal but this doesn't really solve your problem then does it?

 

[CALV]

Thanks for the replies, I am using 2002 at work also, I've just applied SP2 but still doesnt work I'd be happy to re do it in 2000 but everyone here uses xp so I'm stuck with it.

 

[CALV]

well, I gave up! rewrote the front end in VB, took less than an hour, stupid that you need to do so though, and of course not everyone has vb.

CALV

 

[WayneRyan]

CALV,

You should have been able to add them programmatically:

http://www.access-programmers.co.uk...threadid=41181&highlight=references+and+wayne

Wayne

 

[CALV]

Hi,

I looked at your suggestion Wayne, you may recall you helped me out with that before, the problem was, I didnt have the OCX's handy. Pat, I used that method in a previous dbase (cant remember why), the problem was, I ended up with a whole lot of code that I didnt understand.

 

[WayneRyan]

CALV,

You are trying to make a file browser for the user?

Wayne

 

[CALV]

Yes,

It is (was!) a dead simple thing, part of it involved reading info in from a text file, now the location of this file varies from system to system, thats why I needed the open file dialog. Also It had on it a timedate picker control - this also had references problems.

 

[WayneRyan]

CALV,

About the 9th post in this thread is a sample db with a browser.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=54716

Wayne