Solved

button add new

Posted on 2011-03-14
3
291 Views
Last Modified: 2012-05-11
In acces 2007 I want to create a form where i scroll through records but the only way to edit or add a new record is to click on a button and go to another form.

How can i link to another form via a button and how can i disable the add new default feature when scrolling through forms?
0
Comment
Question by:jagguy
  • 2
3 Comments
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 35126096
<How can i link to another form via a button>

Private Sub btnOpenForm_Click()
DoCmd.OpenForm "frmName", acNormal, , , acFormAdd
End Sub


< how can i disable the add new default feature when scrolling through forms? >

Go to Form property -> Data Tab -> Set Allow Additions to "No"

Sincerely,
Ed
0
 

Author Comment

by:jagguy
ID: 35126703
can i do this with property click or something without vba code?

Private Sub btnOpenForm_Click()
DoCmd.OpenForm "frmName", acNormal, , , acFormAdd
End Sub
0
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 500 total points
ID: 35126963
Yeap, you can. Use the hyperlink property.

Go to the Button property ->Format Tab -> Hyperlink Sub Address
then click for ... and locate the form you want to opern.

Sincerely,
Ed
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question