Attachments in a database

Resolved · Medium Priority · Version 2007

Mon 20 Dec 2010, 12:34 Delegate Jamie said...

Jamie has attended:
Access Introduction course
Access Intermediate course

Attachments in a database

Hi,
I have a field on a database where an attachment needs to be added.
Is it possible to drag and drop an attachment from Outlook into the space for attachments on the database/ form, or would I have to download the attachment from the email, then save it manually into the database?
Is there a quicker way then doing it manually?
Cheers,
Jamie

Tue 4 Jan 2011, 11:44 Trainer Anthony said...

RE: Attachments in a database

Hi Jamie, thanks for your query. It is possible to drag and drop attachments into this field, as long as the field type is set to OLE Object. Note, this doesn't save the file into the database, just creates a link to it so you will need to save the file somewhere.

Hope this helps,

Anthony

Mon 10 Jan 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips