Hi,
I have a form which I would like to keep in 'FormView', but which displays
rows each containing records. Generally the data will be added/updated by
moving between fields, but I would also like the down arrow to move down a
record and the up arrow move up a record etc. Darned if I can see how,
despite searching through the help - both Access and Visual basic.
Thanks in advance 2 8210
Hi John
It's obvious that your form is a continuous form which the default behaviour
for the down arrow with this type of form is to move to the next field.
Solution:
In the Form's properties, select the Event tab and change the "Key Preview"
to "Yes". In the Form's "On Key Down" event type the following code
If KeyCode = vbKeyDown Then
DoCmd.GoToRecor d , , acNext
End If
You might want to do a similar one for the up arrow too.
Jeff
"John M" <jo**@jmawer.de mon.co.uk> wrote in message
news:ci******** ***********@new s.demon.co.uk.. . Hi,
I have a form which I would like to keep in 'FormView', but which
displays rows each containing records. Generally the data will be added/updated by moving between fields, but I would also like the down arrow to move down a record and the up arrow move up a record etc. Darned if I can see how, despite searching through the help - both Access and Visual basic.
Thanks in advance
When you say FormView but with rows containing records, I assume you mean
Continuous Forms.
In that view, Up/Down works ok - until you input or change a data field.
When that happens you have to use enter or tab to move to the next field.
You could write some code in the KeyUp/KeyDown event to force a move, but
try using a DataSheet view instead.
On Sun, 12 Sep 2004 10:52:25 +0100, John M <jo**@jmawer.de mon.co.uk> wrote: Hi,
I have a form which I would like to keep in 'FormView', but which displays rows each containing records. Generally the data will be added/updated by moving between fields, but I would also like the down arrow to move down a record and the up arrow move up a record etc. Darned if I can see how, despite searching through the help - both Access and Visual basic.
Thanks in advance
--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: * |
last post by:
I am looking for a way of moving records around in a CMS
like if you click an up arrow it moves the record above the record above and
changes the sort order. Does anyone know the best way to do this,
|
by: Vincent |
last post by:
Hi,
I have a user control that needs to trap the arrow keys to move items
around internally. However, using the arrow keys will move the focus to
another control on the form hosting the user control.
How do I stop this?
Vincent.
|
by: Andrus |
last post by:
I have combobox column in DataGridView.
Up and down error keys should be used to navigate previous and next row in
grid.
For this I override them in ProcessCmdKey() event.
When combobox dropdown menu is open arrow arrow keys should move to previous
and next item in
dropdown menu instead of moving betveen rows.
How to check that combobox dropdown menu is open in ProcessCmdKey() ?
|
by: sathyan8294 |
last post by:
i am using dotnet 2003.i want to move records using firstbutton,previous button,next button,last button in vb.net windows application(not web application).
|
by: Starke |
last post by:
I have a table that contains an SCC # and then locations, Qty, SKU.
As below
SCC Lcoation qty Sku
123 adffa 3 321a1 m
123 adfa 3 32111 l
123 adfa 3 32111 xl
123 adfffa 3 32111 s
321 adfffa 3 32111 m
321 addfa 3 32111 d
| |
by: cmrhema |
last post by:
Hello
I am using ASP.net 2.0 with VC# 2005.
I have populated a listbox as below and when I click on the value on the list box I display out the related values. All works fine. But I have one problem. Now i "CLICK" on a particular value on a listbox and display the results. What i need
is to scroll down using up and down arrow(because there are many items in the list box). But my up and down arrow does not move in the list box.I am using...
|
by: trixb |
last post by:
Hello all,
Here is what I need to do and need help with:
I have a table that is feeding a chart in a report in Access. If this table has more than 50 records, the graph gets messy, and this is where I need help with my solution to this. If the table has more than 50 records, I want to take the next 50 records after the 50th and move these to another table (which I need to create), and this will continue until there are no more records.
I...
|
by: beary |
last post by:
Hi
Being tested using FF 3 on WAMP server. I have spent a number of hours trying to figure this out myself.
I have a html form using table cells and had a request to enable the arrow keys on a keyboard to move through the cells. I found some code and adapted it, and it works well now. Arrow keys move the cursor exactly to the correct cell. There are two things I can't do which I was hoping you guys would give me some help on. I am a...
|
by: Perissos |
last post by:
ooooooooh ok.
I have a form with three combo boxes on it. The first one is based on a query which selects the distinct name from the table, the other two I have as a list.
I originally tried to make this unbound because I thought that would be the best way, but in trying tons of stuff, I decided to change that. So I have a query which pulls distinct records and then use the information gathered from the combobox to gather the data for the...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |