Solved

button add new

Posted on 2011-03-14
3
286 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
Comment Utility
<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
Comment Utility
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
Comment Utility
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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

728 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now