Hi, I want to display the number of records in a form on an access
2002 database.
I know that under properties you can select navigation button, which
allows the user to flick through the records and see which record
number it is and how many records there are.
But I want to be able to display the number of records myself on the
form, without using the access version.
Kindest regards
3  1811 
"Cillies" <le*@prologic.i e> wrote in message
news:ba******** *************** ***@posting.goo gle.com... Hi, I want to display the number of records in a form on an access
2002 database.
I know that under properties you can select navigation button, which
allows the user to flick through the records and see which record
number it is and how many records there are.
But I want to be able to display the number of records myself on the
form, without using the access version.
Kindest regards
Create the following function:
--------------------------------------------------
Public Function NumRecs() As Long
Dim RS As Recordset
Set RS = CodeContextObje ct.RecordsetClo ne
If RS.RecordCount Then
RS.MoveLast
NumRecs = RS.RecordCount
Else
NumRecs = 0
End If
End Function
-------------------------------------------------
In a Textbox on your form put =NumRecs()
on its Control Source.
Ciao
Bruno
On 26 Oct 2004 07:24:48 -0700, Cillies wrote: Hi, I want to display the number of records in a form on an access
2002 database.
I know that under properties you can select navigation button, which
allows the user to flick through the records and see which record
number it is and how many records there are.
But I want to be able to display the number of records myself on the
form, without using the access version.
Kindest regards
in an unbound control:
=[Recordset].[RecordCount]
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Thanks Guys! Much appreciated. And Fred thanks for the simple solution
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Steve Claflin |
last post by:
I have a database with a moderate number of records in several tables
(the biggest table at the moment is about 800 records). In development
it got moved between 2K and XP repeatedly. Several days ago, it
wouldn't open, and proposed creating a backup before fixing. OK, but
the "fixed version" didn't open -- same messages as the original -- but
the backup did. But, in the 800 record table only 200 records
appeared. We went back several...
|
by: RC |
last post by:
I have an Access 2002 database with many tables and forms (but just to
keep things simple, let's say the DB has one Table "Table1" and one
Form "Form1").
I have managed to cobble together so much complex code to add records
and edit records I need to step back and ask you all what is the
proper way to do this. The database is DAO. The table has Columns
SerialNumber, CPU, HardDrive and Model. I am trying to use a Form to
fill out the...
|
by: KC |
last post by:
I am using Access 2002, with a database template from MS Office. The
Orders Management Database. I have tweaked this for use with our
company. It is a small database with close to a 1000 records in our
Orders table. Within this table are 80 records that I decided to
delete to clean it up a bit. When I went into my data entry form, I
noticed the bottom portion of the form was blank, this is usually the
area that contains each customers...
|
by: M. David Johnson |
last post by:
I cannot get my OleDbDataAdapter to update my database
table from my local dataset table. The Knowledge Base
doesn't seem to help - see item 10 below.
I have a Microsoft Access 2000 database which indexes
computer magazine articles for personal reference.
I am developing a Visual Basic.NET program whose sole
purpose is to enter new records into the database. No
updates to existing entries, no deletions, and no display
|
by: Tony |
last post by:
vs 2002 - vb - access 2002 - xp - web forms
I want to display records, one at a time.
I have about 25 fields to display.
I've created SQL and retrieved records.
I placed data in 25 separate dropdown list. (made them invisible on form)
each time they pick next I add 1 and do something like this for each field
CurrentRecord += 1
(test for upper bounds and less then 0)
ddName.selectedindex = CurrentRecord
| | |
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server 2005, and, since he already has
licenses for Office Pro 2002, he wants to upgrade to that.
I've been saying that we need to upgrade to Access 2003, not 2002, even if
Office is kept at 2002. We are also looking to do a fair amount of...
|
by: Robert |
last post by:
How do you get an accurate count of the number of records returned from
a query when using linked tables.
I have an access 2003 database as a front end to another access 2003
database that contains only tables. I have linked the tables for the
front end to the back end database.
I am trying to set the recordsource of a form to a query established by
the user to narrow the scope but I don't want to display the form if
there are no...
|
by: Clint Stowers |
last post by:
Access 2003
I have a Continuous Form. On Open I force it to go to the Last
Record.
When the form opens only the last record is shown at the top. To view
any of the previous records you must scroll. This give the appearance
at first glance that no other records exist.
Is there a simple method to populate the form with records and leaving
|
by: ramprakashjava |
last post by:
hi,
i hav "java.lang.NullPointerException" error while Deleting table records using checkbox in jsp here i enclosed files help quickly plzzz..
Regards
Ramprakash
/*Adminpage.jsp*/
<%@ page language="java" import="java.sql.*"%>
<html>
<head>...
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
