Counting the no of records in a MS Access table using VB 2005

Question

0.00/5 (No votes)

See more:

I want to create a counter that uses the MS Access records. I am going to explain how
I want that counter works.

I need to make a counter that initialize from 0. But after that the counter should
check the last entered Student ID and start counting starting from that. This will
help me to create an automated invoice numbering field using text data type in MS
Access database!

Posted 28-Jun-11 6:16am

Chiranthaka Sampath

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dr.Walt Fair, PE · Accepted Answer · 2011-06-28T07:37:00

Solution 1

I'm not sure if I understand. Have you looked at using AUTOINCREMENT[^]? You can change the starting value if needed, but I'm not sure that's what you're looking for.

Posted 28-Jun-11 7:37am

Dr.Walt Fair, PE

Comments

Maciej Los 28-Jun-11 15:13pm

5! Very short and very good answer!

Vivek Krishnamurthy 28-Jun-11 15:48pm

5!

Chiranthaka Sampath 29-Jun-11 4:35am

Actually I want to make a automatic invoice no that depend on the last entered invoice no to the access table. Please help

Dr.Walt Fair, PE 29-Jun-11 10:45am

OK, I've done something similar. I set up the invoice number as an AUTOINCREMENT field. You can initialize it as you please, by default it starts at 1. Every time you create and save a new invoice, the number automatically gets incremented. That way there are no duplicates and you don't need to do hardly anything at all.

Chiranthaka Sampath 1-Jul-11 13:07pm

Thanx pal but if I used text data type instead of auto number how can I do my generating of invoice no! Because my invoice no format is 'INV######' that is why I do not use autonumber format!

Dr.Walt Fair, PE 1-Jul-11 23:45pm

Wow, it sounds like you need to rethink your database schema! I would suggest using a number for invoice number and concatenate the INV part when needed.

In the case that you really do save INV#### as a text string, then you'll need to manually keep track of things. You can either save the last number in a table somewhere and retrieve and update as needed or grab the last one using SQL. Retrieving the last one from the data itself won't work if you allow records to be deleted, though.

Chiranthaka Sampath 3-Jul-11 22:15pm

If I use a masked text box within my program how can I concatenate it with 'INV' part with the auto increment numbering?

Chiranthaka Sampath 25-Jul-11 2:58am

After sometime I have noticed that static variables can do this thing easily!

Chiranthaka Sampath · Accepted Answer · 2011-07-24T21:12:00

Solution 3

Using static variables this can do easily!

Dim Static intCVal as New Integer
Dim intTotVal as New Integer
Dim intVal as New Integer

intTotVal = intCVal + intVal

Posted 24-Jul-11 21:12pm

Chiranthaka Sampath

mike2315 · Accepted Answer · 2011-06-28T08:38:00

Solution 2

Very diffical to undestant what you are trying to count if number of students then you select count(*) from table