microsoft training access course - Adding Pictures to access table

Resolved · Low Priority · Version Standard

Adding Pictures to access table

Tony has attended:
Access Consulting course

by - delegate Tony [1 post] (2007 Oct 5 Fri, 15:45) Reply

Please advise how to add photos to records in a table and does the photo file have to be a specific type ( E.G product photos)???

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Adding Pictures to access table

by - trainer Carlos gold contributer [479 posts] (2007 Oct 8 Mon, 11:12) Edited on 2007 Oct 8 Mon, 11:13 Reply

Hi Tony

I repeated what we did in the training on my PC and it gave me no problems. Use JPG pictures for this. I used photos I had taken with my digital camera. Try to keep the picture size down. (GIF and BMP don't work too well)

So to add a picture to a database use the following steps:

1. In the design view add a field named Picture with an OLE Object type.

2. In the Datasheet view Select the Picture cell and insert Object

3. I the Object dialog box, Select Create from file, Browse for the required picture and click OK.

To View the picture in the Form:

1. Create the form as normal

2. In design view right click the picture box and select Properties

3. In the Size Mode line Select Zoom (This ensures the picture resizes to the frame you created for it)

Hope this helps

Carlos

· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· MS Access and Database Normalisation
· The Benefits of Certified Microsoft Training in Access
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· Microsoft Access Mistakes to Avoid

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips

Rate this page: