User Profile

Collapse

Profile Sidebar

Collapse
Invicta
Invicta
Last Activity: Oct 10 '07, 09:28 AM
Joined: Sep 12 '07
Location: Tewkesbury, UK
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Invicta
    started a topic Copy Record using selected fields on Form
    in Access

    Copy Record using selected fields on Form

    There are two fields I need to copy preferably using a command button. If possible I would also like to stipulate how many new records I want.

    I've made a start using the in built Duplicate Record function but can't work out what needs to be ammended.

    Any help would be appreciated.
    Bernard

    [CODE=vb]
    Private Sub CmdDuplicateRec ord_Click()

    On Error GoTo Err_CmdDuplicat eRecord_Click...
    See more | Go to post
    Last edited by MMcCarthy; Sep 12 '07, 04:55 PM. Reason: added code tags for readability
    • Invicta
      replied to MS Access - Startup menu
      in Access
      I've used the following in the past:
      Open Database and Hold down the Shift key
      Or
      Open database
      When the “Run Macros” dialog box opens select “Cancel”
      Then use the View, Toolbars, Customize.
      Select the Commands Tab, scroll down to the Tools option and drag this to the top toolbar.
      This should then allow you to select the Startup option from the Tools, click full menu.
      Bernard...
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...