The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access database training - Photos privacy

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

access database training - Photos privacy

Resolved · Low Priority · Version Standard

ReplyMon 22 Jan 2007, 09:57Delegate Jessica said...

Photos privacy

How can we enter photos on our database, preferably behind a button for privacy?

For upcoming training course dates see: Pricing & availability

ReplyMon 22 Jan 2007, 11:09Trainer Richard said...

RE: photos privacy

To store pictures in a database, you would need to use an OLE Object field

(OLE Object data type: A field data type you use for objects created in other applications that can be linked or embedded (inserted) in an Access database.).

You can then embed images into the database and display them where required (forms / reports).

Take a look at the help section of access under "Add a picture or object". That will give you a good background understanding of what is required to add pictures to a database.

If you have any further questions, please post a reply.

Access articles

· Different Ways To Use Forms In Access 2007
· It Is Important To Take Care Over Primary Key Assignment
· So You Still Haven't Learned How To Use Access Yet?
· Microsoft Access, an Efficient Database Tool
· How To Successfully Design An Access Database For A Paying Client

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips

How To Show JPG Or GIF Images In Access 2003 Forms

Want to show jpg or gif images corresponding to each record in an Access 2003 form? Access 2003 only allows bmp images to do this, but read this article to discover how you can overcome this limitation.

» Article: Ms access course

I dont use Access as yet but what I would like to know is if someone could show me something with the end product using Access? I need to see an end result so I can see what somebody would be working to.
I am finding it hard to grasp the full concept if..

» Forum post: Full working data base

May have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in...