frefreshlinks

[Guest]

Excuse me, where do i need to put the code (fRefreshLinks) to run it
I´ve inserted it in a module and appears a Compile error (i´m using acces 2000) User_defined type not defyned
I hope that you can help me because i´ve used access just a few time

 

[Allen Browne]

The user-defined type error probably indicates you don't have the DAO
reference.

From your code window, choose References from the Tools menu, and check the
box beside:
Microsoft DAO 3.6 Library

More information on references:
http://allenbrowne.com/ser-38.html


fRefreshLinks is not part of Access, so presumably you are talking about the
code in this link:
http://www.mvps.org/access/tables/tbl0009.htm
If so, you probably want to run that code when your application starts. It
needs to run before any bound form tries to load. One approach is to specify
an unbound form as your startup form under:
Tools | Startup
Use the Open event of the form to run the code, open the real form, and
cancel the Form_Open event (which unloads all your initialization code from
memory).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Excuse me, where do i need to put the code (fRefreshLinks) to run it ?
I´ve inserted it in a module and appears a Compile error (i´m using acces

2000) User_defined type not defyned.

 

[Allen Browne]

Place the code in the [Event Procedure] of the On Open event of the form.

That's what "Form_Open" was referring to.