microsoft access 2002 training - inserting picture
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access 2002 training - Inserting picture

microsoft access 2002 training - Inserting picture

resolvedResolved · Low Priority · Version Standard

replyReply Mon 24 Sep 2007, 17:01Delegate Sebastien said...

Sebastien has attended:
Access Introduction course

Inserting picture

How to insert a picture into an employee form, where the picture update for each record?

For upcoming training course dates see: Pricing & availability

replyReply Mon 8 Oct 2007, 12:05Trainer Carlos said...

RE: Inserting picture

Dear Sebastian

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. (Use JPG's only and try to keep them small <500 Mgb)

To View the picture in the Form:

1. Create the form as normal (Using Wizard)

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

 

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard