Solved

cmd button to field

Posted on 2009-07-05
4
229 Views
Last Modified: 2013-11-24
I have a database  called TOEWYS with table  TOEWYS with field HKNR and Form called INVOER.
How do I make cmd button on form INVOER
 to go to new record  
to the field HKNR
on the form INVOER ?
0
Comment
Question by:WIETIE
  • 3
4 Comments
 
LVL 41

Expert Comment

by:pcelba
Comment Utility
You just have to add Button to your form (in Design mode) and in the button's On Click event you have to call macro GoToRecord with record parameter = New and then you have to call macro GoToControl with parameter containing the name of your field (HKNR).

Hope you have Access 2007 but it should be very similar in older versions.
0
 
LVL 41

Accepted Solution

by:
pcelba earned 125 total points
Comment Utility
Access 2007 has this button predefined in Command Button Wizard (Category "Record operations", Action "Add new record") you just have to add GoToControl macro into On Click event.
0
 

Author Comment

by:WIETIE
Comment Utility
I have Access 2003, Can you please explain in more detail the parameter bit for field

WIETIE
0
 
LVL 41

Expert Comment

by:pcelba
Comment Utility
The answer is in the question having higher point value :-) :
http://www.experts-exchange.com/Microsoft/Applications/dBase/Q_24545567.html  

The process of button adding and its click event definition is slightly different in Access 2003 but very similar to Access 2007.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

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

10 Experts available now in Live!

Get 1:1 Help Now