I'm looking for a way to create a form that will not go to the next record when the tab or enter key is pressed after inserting data into the last textfield of that form. It would be much more convenient to have record selection only controlled by record selectors, and not the keyboard. Is there a way to build an event, so that when data is entered into strField50 for Record1 and the tab or enter key is pressed, the record will stay the same and the cursor will simply return to strField1 in Record1?
2  2142 
It's even easier than you think. (I'm assuming this works the same in 97, although I could be totally wrong, I'm used to 2000/2003)
Go to the form's properties, and find the Cycle property (under the Other tab)
It's probably defaulted to 'All Records'.
Change this to 'Current Record' and your tab events will always cycle within the same record.
Now set the 'Tab Stop' value to 'NO' for all objects you do NOT want to tab to, and then for the rest, set the 'Tab Value' numbers incrementally for the order you want.
When you get to the highest 'Tab Value', it will automatically start back at the beginning, instead of advancing to the next record.
If you needed to switch this with code, you would add this to your Form Load event:
me.form.cycle = 1
(0 for all records, 1 for current record, 2 for current page)
That is fantastic beyond reason.
Thanks for helping the newbie.
It's even easier than you think. (I'm assuming this works the same in 97, although I could be totally wrong, I'm used to 2000/2003)
Go to the form's properties, and find the Cycle property (under the Other tab)
It's probably defaulted to 'All Records'.
Change this to 'Current Record' and your tab events will always cycle within the same record.
Now set the 'Tab Stop' value to 'NO' for all objects you do NOT want to tab to, and then for the rest, set the 'Tab Value' numbers incrementally for the order you want.
When you get to the highest 'Tab Value', it will automatically start back at the beginning, instead of advancing to the next record.
If you needed to switch this with code, you would add this to your Form Load event:
me.form.cycle = 1
(0 for all records, 1 for current record, 2 for current page)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Kevin Myers |
last post by:
Hello,
Please forgive my reposting of this note with hopefully a more relevant
subject line.
On an Access 2000 form under Windows 2000 I would like to use a Kodak Image
Edit Control to...
|
by: Peter Frost |
last post by:
Please help
I don't know if this is possible but what I would really like to do is
to use On Error Goto to capture the code that is being executed when
an error occurs.
Any help would be much...
|
by: Yannick Turgeon |
last post by:
Hello,
We are in the process of examining our current main application. We have to
do some major changes and, in the process, are questionning/validating the
use of MS Access as front-end. The...
|
by: Olav.NET |
last post by:
I am a .NET/C++ developer who is supposed to do some work with Access.
I do not know much about it except for the DB part.
Questions:
*1*
I am looking for INTENSIVE books to get quickly up to...
|
by: Sean |
last post by:
Have you ever wanted to add the great features inherent in Google Maps?
Here is how you do it.
==============
== STEP ONE ==
==============
Create a new MS Access form called frmGoogleMap....
|
by: TD |
last post by:
This is the code under a command button -
Dim ctl As Control
For Each ctl In Me.Controls
If ctl.BackColor <> RGB(255, 255, 255) Then
ctl.BackColor = RGB(255, 255, 255)
End If
Next ctl
|
by: Arend Jan Nijenhuis |
last post by:
Hi,
I'm fairly new to .Net, but an expert in Microsoft Access VBA.
For a large Access application, I want to create some sort of custom control
(COM interop?) in VB.Net, to be used in an Access...
|
by: dbuchanan |
last post by:
I have a Windows Forms application that accesses SQL Server 2k from a
small local network. The application has been used for weeks on other
systmes but a new install on a new machine retruns...
|
by: prakashwadhwani |
last post by:
Hi !! I'm about to develop a new project for a client.
Should I go about it in Access 2003 or 2007 ? Purchasing it either
for me or for my client is not a major consideration here ... what I'd...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| | |
