A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Command button for file open



 
 
Thread Tools Display Modes
  #1  
Old August 6th, 2004, 05:29 AM
accessbabe
external usenet poster
 
Posts: n/a
Default Command button for file open

Basic but common question.

I have a single form. I can create a command button (cmd001). I want to be
able to click on this button and have a windows "file open" dialog appear, so
that I can search my harddrive for a picture (jpg). THEN, I want the picture
to be attached to the particular record in this form. (Meaning that if I add
another record (ex. record #2), the picture from record #1 is not displayed.)

First, what code do I need. Where exactly do I put it in the VB console.

Second, what other control do I need to add to the form as the image place
holder. Essentially, once I select a picture using the command button
(cmd001), how does the picture that I've selected know where to get placed on
the form.

Thank you so much to anyone who can answer this persistent question!

AB
--
accessbabe
  #2  
Old August 6th, 2004, 06:06 AM
Albert D. Kallal
external usenet poster
 
Posts: n/a
Default Command button for file open

I have working sample that pops open the dialog box in my shift key code
example:

You can grab the shift key code on my web page he
http://www.attcanada.net/~kallal.msn...s/DownLoad.htm

It uses the file dialog open box code from access web found he

http://www.mvps.org/access/api/api0001.htm
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.attcanada.net/~kallal.msn


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Document won't open Bob Stubbs General Discussion 4 August 3rd, 2004 05:45 AM
datasheet forms open in form mode from the Switchboard Paul James Using Forms 5 July 13th, 2004 06:51 AM
Re-Upgraded to OE6. Now Inbox msgs don't open Bernard R Buchta Outlook Express 1 July 3rd, 2004 06:52 AM
Excel Workbooks do not open from windows explorer lstumme Setting up and Configuration 2 October 30th, 2003 01:44 AM
excel; File Open or click on open folder [email protected] Setting up and Configuration 0 October 29th, 2003 05:15 PM


All times are GMT +1. The time now is 07:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.