New to Access, i need to make a browse button

[panos80s]

Hi there,

I am very new to access.
I am designing a form and i would like to create a button, and when i click it a new dialog box will appear and give me the option to browse for an image file on my hard disk. The image i select will automatically placed into an image field. I seach arround he web and i didn't find nothing. Please tell me what can i do step by step because i am very new to this and i dont now nothing on vba.

 

[lcook1974]

See if this will help...

http://www.access-programmers.co.uk/forums/showthread.php?t=190908&highlight=Add+image+form

 

[Obeng]

lcook i tried that code but i get error, anymore suggestions?

 

[phatus]

go to table>designview>Datatype Select Attachement....

 

[vbaInet]

go to table>designview>Datatype Select Attachement....

I really wouldn't advise using the Attachment datatype. Your database would grow rapidly.

Only opt for this option if your database is relatively small and if you're daunted by the code.

 

[lcook1974]

Did you check out the microsoft link at the bottom?

 

[vbaInet]

lcook i tried that code but i get error, anymore suggestions?

lcook1974, I believe the obeng did.

 

[MSAccessRookie]

lcook i tried that code but i get error, anymore suggestions?

You have not specified any details regarding the error. What type of error are you getting? Perhaps the code might be able to work for you once the error is addressed and eliminated.

 

[phatus]

@vbaInetok

i have database with 900+ list of names...

in their form they must have pic on it with their name.... what i did is i put attachment so that when i go to next form the picture of the next name must be his/her picture....

any alternatives? so that i can minimize the size of my database if you are not suggesting the attachment thing sir

 

[vbaInet]

@vbaInetok

i have database with 900+ list of names...

in their form they must have pic on it with their name.... what i did is i put attachment so that when i go to next form the picture of the next name must be his/her picture....

any alternatives? so that i can minimize the size of my database if you are not suggesting the attachment thing sir

An alternative was in the link lcook1974 provided. Have a look at the second post in that thread and follow the link.

The images will be on your hard disk and you supply the full path to the image to your image control for it to be displayed. It's all in the link.

 

[Obeng]

Can anyone help me with option groups, I inserted a first option group for sex; male or Female with radio buttons and it works fine, I inserted a new one for marital status; Single, Married, Divorce and it is not working, Please help me else I'm screwed>

 

[lcook1974]

What is it doing? Did you assign a code to the option group THEN rename the option group? That would cause the code behind it not to work.

 

[Obeng]

Thank Lcook but I just figured it out, in the table under the field type I chose Yes/No and that is why it wasn't working, it however started working when I changed it to text, Once again thanks for the help

 

[lcook1974]

Great! Glad I could help.

This forum is AWESOME...lots and lots of good stuff here! (better than books!)

Larry