introduction access training - enter 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 » introduction access training - Enter Picture

introduction access training - Enter Picture

resolvedResolved · Low Priority · Version Standard

replyReply Mon 24 Sep 2007, 17:00Delegate Suze said...

Suze has attended:
Access Introduction course

Enter Picture

How do i get a picture of employee to appear on employee form

For upcoming training course dates see: Pricing & availability

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

RE: Enter Picture

Dear Suze

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:

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


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