Display count of table entries - Microsoft Access / VBA

102 New Member

Background: Front end is MS Access/VBA and Back end is MS SQL Server 2008.

I have a form (Supplier) that shows all the details of the supplier. This form has a button on it and when pushed all of the notes are shown on this supplier. A one to many relationship is established (Supplier --> Notes). This button works fine. Is there a way I can put the count of Notes table entries beside the button on the Supplier form?

Apr 27 '15 #1

Subscribe Reply

1439

Seth Schrock

2,965

Recognized Expert Specialist

You could use the DCount() function to count the number of records.

Apr 28 '15 #2

jforbes

1,107

Recognized Expert Top Contributor

I do something very similar to this for the caption of Tab on a Tab Control and it is going about it in the manner Seth mentions. I've placed this in the OnCurrent Event of the Form

Expand|Select|Wrap|Line Numbers

 Me.pgNotes.Caption = "Notes(" & DCount("JobNoteID", "JobNotes", "JobNumber='" & Nz(Me!JobNumber, "") & "'") & ")"
 
 

Apr 28 '15 #3

Similar topics

9095

Access 2000: Need a count of entries by state.

by: C. Homey | last post by:

I have an Access 2000 database (42,000+ records) for which I need a count of records by state (AL=320, AK=92, NY=1,932, etc). Obviously, I don't want to (and probably can't...) do the count...

Microsoft Access / VBA

2982

HOW-TO display a table in front of Image?

by: Raed Sawalha | last post by:

Dear : I have an image in a aspx page I need when user mouseover it to display HTML Table with links. Regards

ASP.NET

9269

how to create dynamically edit table entries

by: Sheau Wei | last post by:

i wish to know how to create a dinamically edit table entries .can u help me ?thanks.

PHP

1954

how to display the table names in the combobox

by: Soumya v s | last post by:

i wants to display all table names in the combo box with php and mysql

PHP

1469

Run External Script Based on Table Entries

by: dreaken667 | last post by:

I currently have a PHP script that pulls records from a table and runs PHP scripts based on the table entries, but it requires that I actually load the page in a browser and wait for it to complete....

MySQL Database

2592

Query, need to count unique entries?

by: muld | last post by:

I've inherited a database system designed to calculate sickness absence statistics. There is a main table with an employee ID which also holds the number of days worked by that person in a year ....

Microsoft Access / VBA

1972

In view source,html code to display a table is present but its not getting rendered

by: khadar siddi | last post by:

I have tested this in the following two browsers. 1.Internet Exolorer 2.Mozilla FireFox In Internet Explorer: ------------------------ When I right click and see the view source...the html...

ASP / Active Server Pages

1761

Count table in DB2

by: zulkifb | last post by:

How to count table inside DB2. I have almost 400 table in DB2v9. How can I make calculating for 1. table have no relationship 2. table have relationship

DB2 Database

7336

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

7405

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

7066

The easy way to turn off automatic updates for Windows 10/11

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

Windows Server

5059

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

4724

Couldn’t get equations in html when convert word .docx file to html file in C#.

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

C# / C Sharp

3214

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

3198

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1568

transfer the data from one system to another through ip address

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

C# / C Sharp

773

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP