Access Form Load

In created a Form in Access. Once I open the form, It is retriving the data from the table.

I need the Form only to be for additions of new Record. So when I open the form, it should be blank.

I have also to add an attachment to one of the form fields. The Table column properties is Attachment but how Can I add the attachement??

Thanks
LVL 1
ramziabkAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
peter57rConnect With a Mentor Commented:
If the form is only used for new records then set the form's Data Entry property to Yes.


For the attachments, right-click the textbox and choose Manage Attachments.
0
 
ramziabkAuthor Commented:
For the textbox, I cant find manage attachement!!!
0
 
peter57rCommented:
I don't know why that is.

If the textbox has the attachment field as its controlsource then you should get 'Manage Attachments '  on the right-clcik menu.

I assume you haven't disabled shortcut menus?
0
 
Kelvin SparksCommented:
Is the database using Access tables or linked to SQL Server. These special datatypes only work with Access tables.


Kelvin
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
There's also an Attachment control (looks like a paper clip in the toolbox). Add that to your form, set the ControlSource to your Attachment field, and you can manage attachments with that. If you use the control, then when you set the focus on that control (i.e. click or tab into it) you'll see a small toolbar appear above it. Click the paperclip in that toolbar and you can then Add Attachments. You can also right-click on that control (as peter suggested above) and select Manage Attachments.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.