Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

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
0
ramziabk
Asked:
ramziabk
2 Solutions
 
peter57rCommented:
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 )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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now