frefreshlinks

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 times

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.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Victor" wrote in message
...
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 times

Thanks !
Yes i´m talking about that code
I have no set (yet) the form at the startup.
Where do i need to put the code to run it when the application Starts ?

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

That's what "Form_Open" was referring to.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Victor" wrote in message
...
Thanks !
Yes i´m talking about that code
I have no set (yet) the form at the startup.
Where do i need to put the code to run it when the application Starts ?