• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

Access Forms: Adding Paste & Delete Record Functions

Hi,

I noticed that these functions are not present via Access 2007 runtime, so I guess they need to be added manually.

I would like them via Right Mouse Click popup menu. Can someone please assist me on how to

1. Add PASTE
2. Add Delete Record
3. Add a Popup Menu.

Thank you!
0
mullykid
Asked:
mullykid
  • 7
  • 5
  • 4
2 Solutions
 
peter57rCommented:
Creating custom ribbons is not simple, compared to the pre-ribbon era.

http://office.microsoft.com/en-us/access-help/customize-the-ribbon-HA010211415.aspx
0
 
mullykidAuthor Commented:
Thank you. Will the custom ribbon appear in the runtime 2007 version?
0
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
hello_everybodyCommented:
The runtime has never supported built in menus of any kind (including right-click menus).
It will work with custom ones though.
0
 
peter57rCommented:
As long as you display it  - YOU have to display it - nothing happens automatically in a runtime.
0
 
mullykidAuthor Commented:
Guys, thanks for all ur help. Before I aware points, I created a Delete Record and Paste control on my custom Ribbon. However, they are disabled and do not get enabled on my form. Any ideas?
0
 
hello_everybodyCommented:
Can you upload a sample?
0
 
peter57rCommented:
They will only be enabled if there is something for them to do.  
0
 
mullykidAuthor Commented:
No, doesn't appear to be the case.
0
 
mullykidAuthor Commented:
For example. The delete record is disabled until I right mouse click (on the row) to bring up popup menu, where Delete Record option also exists and is enabled. When I close out of the popup menu the Delete Record option disables again. It is like they are linked.
0
 
mullykidAuthor Commented:
Also, the delete (shortkey) works while the button is disabled.
0
 
mullykidAuthor Commented:
I have found out why. My form is a popup window. If I switch if off (which I don't) the buttons become enabled. Any work - around for this?

I have the window as a popup so that it does not resize.
0
 
hello_everybodyCommented:
You can set the size of the form in code. Post back if you need help.
0
 
mullykidAuthor Commented:
Oh cool. Yea, please let me know. Thks.
0
 
hello_everybodyCommented:
on the form's resize event add the following:
 
Me.InsideHeight = 4000
Me.InsideWidth = 5000

Open in new window

change the numbers to fit your form.

To determaine the InsideHeight and InsideWidth of your form create a cmdButton with the following code on the OnClick event:
 
MsgBox "InsideHeight = " & InsideHeight & vbCrLf & "InsideWidth = " & InsideWidth

Open in new window

0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 7
  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now