Need VBA for file requester please

[Bugs]

Hi Everyone.

What I wish to do in VBA is call up a file request dialog box so the user
can select any file on the PC, and have the selected file's path put into
the current record's applicable field in the table.

I have googled and cannot find a solution.

This would really help greatly and any help much appreciated.

Thank you.

[Allen Browne]

See:
Call Windows File Open/Save Dialog box
at:
http://www.mvps.org/access/api/api0001.htm

--
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.

"Bugs" <bu*****@optusnet.com.au> wrote in message
news:42***********************@news.optusnet.com.a u...

Hi Everyone.

What I wish to do in VBA is call up a file request dialog box so the user
can select any file on the PC, and have the selected file's path put into
the current record's applicable field in the table.

[pietlinden]

You couldn't have looked very hard. there's one right here.

http://www.mvps.org/access/api/api0001.htm

[Bugs]

Thanks very much for your assistance,

I shall study the code and try adapt it to my use as my VBA is somewhat
limited.

Also would anyone know why having a tab contol on a form with images stuffs
up the print and print previews in Access 2003 ? Driving me nuts.

Thanks again.

Cheers.



"Bugs" <bu*****@optusnet.com.au> wrote in message
news:42***********************@news.optusnet.com.a u...

Hi Everyone.

What I wish to do in VBA is call up a file request dialog box so the user
can select any file on the PC, and have the selected file's path put into
the current record's applicable field in the table.

I have googled and cannot find a solution.

This would really help greatly and any help much appreciated.

Thank you.

[Allen Browne]

Bugs, you generally need to create a report laid out how you want it to
print.

Printing a form doesn't work very well, especially so where you have
multiple tabs.

--
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.

"Bugs" <bu*****@optusnet.com.au> wrote in message
news:42***********************@news.optusnet.com.a u...

Also would anyone know why having a tab contol on a form with images
stuffs
up the print and print previews in Access 2003 ? Driving me nuts.

[Bugs]

Thank you for everything Allen and Piet.

Ive worked out how to use the code suggested and all is now working very
well.

I am replacing the OLE images with an image path in the table and removing
the tab control as it will be no longer necessary.

And thanks for the tip re the report.

Cheers.

Joe.


"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au...

Bugs, you generally need to create a report laid out how you want it to
print.

Printing a form doesn't work very well, especially so where you have
multiple tabs.

--
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.

"Bugs" <bu*****@optusnet.com.au> wrote in message
news:42***********************@news.optusnet.com.a u...

Also would anyone know why having a tab contol on a form with images
stuffs
up the print and print previews in Access 2003 ? Driving me nuts.