how to know the record position shown in a form?

zhouzhendong

I have a form that shows a table in single form format.
how can I know the position of the record the form is current showing
so that I can enable or disable some buttons according to the position
information.
For example if the form is showing the first record I need to disable
the Previous button, and for the last record I need to disable the Next
button, etc.
Thanks

Dec 14 '05 #1

Subscribe Post Reply

6432

Galka

Hello
Access navigation buttons do it for you. Haven't you noticed that when
you are at the first record, button Go To Previous is disabled? Button
Go To Next is disabled, when you are at the last record, if the form
doesn't allow to add records. If the form does, the button is not
disabled because Go To Next creates a new record in this case. Hope it
helps.
Galka

zh**********@hotmail.com wrote:

I have a form that shows a table in single form format.
how can I know the position of the record the form is current showing
so that I can enable or disable some buttons according to the position
information.
For example if the form is showing the first record I need to disable
the Previous button, and for the last record I need to disable the Next
button, etc.
Thanks

Dec 14 '05 #2

fredg

On 13 Dec 2005 20:47:14 -0800, zh**********@hotmail.com wrote:

I have a form that shows a table in single form format.
how can I know the position of the record the form is current showing
so that I can enable or disable some buttons according to the position
information.
For example if the form is showing the first record I need to disable
the Previous button, and for the last record I need to disable the Next
button, etc.
Thanks

If you are replacing the built in navigation buttons with your own
command buttons, you can use, in the Form's Current event:

cmdPreviousButton.Enabled = Not Me.CurrentRecord = 1
cmdNextButton.Enabled = Me.CurrentRecord = 1 Or Me.CurrentRecord <
Me.Recordset.RecordCount

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Dec 14 '05 #3

zhouzhendong

Thanks Fred. Yes that's what I want.
all the best

If you are replacing the built in navigation buttons with your own
command buttons, you can use, in the Form's Current event:

cmdPreviousButton.Enabled = Not Me.CurrentRecord = 1
cmdNextButton.Enabled = Me.CurrentRecord = 1 Or Me.CurrentRecord <
Me.Recordset.RecordCount

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Dec 15 '05 #4

by: Joachim Bauer | last post by:

I'm using the code below to display a menu that opens when the mouse goes over the main menu item (try it in your browser to understand the behaviour). It uses "position:absolute" and a switch...

Javascript

Find: record found, incorrect data shown

by: HJ | last post by:

Hi all, Consider an Access 2002 run-time application on Windows XP. The controls on a form are locked until the user clicks an Edit button. The form is based on a query and all controls are...

Microsoft Access / VBA

Move a Record Up/Down in a Continuous Form !

by: Prakash | last post by:

Hi !! In a Continuous Form with say 10 records, I'd like to have 1 button with an "UP" Arrow & another button with a "DOWN" arrow. By pressing either the Up or the Down Arrow, I'd like the user...

Microsoft Access / VBA

Displaying (scrolling to) a specific record in a continuous form with VBA

by: Typehigh | last post by:

I am a good programmer, but this one stumps me! I have a form with a continuous subform. The continuous subform contains records of data and may reach a depth of 1000's of entities. I have...

Microsoft Access / VBA

How to get at sub-form record number in VBA (or an expresion)?

by: usenet | last post by:

I want to be able to use the record numbers of a sub-form, are they available anyhow in VB (Access 2003)? I want to use the sub-form record number as *part* of the primary key for the table...

Microsoft Access / VBA

Repost: find record in form1 from form2

by: Kaur | last post by:

I am reposting this message. I am a beginner using MS Access. I am working in MS Access 2000 and have created two forms. Form 1 is called frmParent (which has a read only subform called SfrmChild)....

Microsoft Access / VBA

Display and Update record in php

by: Bakarre | last post by:

I have problem in retrieving record from mysql using php form, I was able to retrieve the record, if I edit, the changes is not updated in mysql. find below my code <html> <body> <?php $db =...

PHP

Find Record From sub forms

by: farhan31 | last post by:

Hello all I have Two tables.Table 1 and table 2.Table 1 has one to many relation with Table 2.I have one main form Form1 based on table 1.On form 1 i have a sub form based on table 2.I have put a...

Microsoft Access / VBA

Update list box when a new record added.

by: MerlinS | last post by:

Using Access 2003. I have a form and a subform. On the main form, one of the fields is a lost box, which lists line numbers ie 1, 2, 3 etc. Then the list box is clicked, the subform corresponding...

Microsoft Access / VBA

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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,...

General

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

how to know the record position shown in a form?

Similar topics