i am retrieving 10 records out of 50 records from the access database using dataenvironment based on some condition. Now i want to place the serial number in the data report. Please give ur suggestions.
Thanks in advance
indra.G
9  8147 
i am retrieving 10 records out of 50 records from the access database using dataenvironment based on some condition. Now i want to place the serial number in the data report. Please give ur suggestions.
I think we need more information about the situation. For example, what are you referring to as "serial number" here? Is this a field in your database?
And what environment are you working in? VB6? VB.Net? VBA in Access?
I think we need more information about the situation. For example, what are you referring to as "serial number" here? Is this a field in your database?
And what environment are you working in? VB6? VB.Net? VBA in Access?
Sir,
I have created a database in access and iam using vb as front end. For the data report the data source is dataenvironment.For e.g I have nearly 100 records and i am selecting few records based on a condition in the dataenvironment sql command(select * from contract where vtcno>?) and placing the dataenvironment as the data source to the data reort. The selected records should be numbered(1,2,3...) in the data report by adding an additional field in the data report.
thnaks
indra
Sir,
I have created a database in access and iam using vb as front end. For the data report the data source is dataenvironment.For e.g I have nearly 100 records and i am selecting few records based on a condition in the dataenvironment sql command(select * from contract where vtcno>?) and placing the dataenvironment as the data source to the data reort. The selected records should be numbered(1,2,3...) in the data report by adding an additional field in the data report.
thnaks
indra
Ah! So you want a simple sequential "record number" on the report.
I'll have to check with some experts who know more SQL than I do, to see whether there's a way to generate it in the query. Will get back to you on that.
If this is going through VB one record at a time, then you could just increment a counter variable and include that.
NeoPa 32,556
Recognized Expert Moderator MVP
Create an unbound TextBox in the report with - Control Source = "=1" (Lose quotes)
-
Running Sum = Over All
Create an unbound TextBox in the report with
- Control Source = "=1" (Lose quotes)
-
Running Sum = Over All
sir,
ican't understand.please tell me where to place. iam getting an error end of statement.
thanks
indra
MMcCarthy 14,534
Recognized Expert Moderator MVP
Create an unbound TextBox in the report with
- Control Source = "=1" (Lose quotes)
-
Running Sum = Over All
Adrian
Indra is using a VB front end.
Mary
NeoPa 32,556
Recognized Expert Moderator MVP
Adrian
Indra is using a VB front end.
Mary
But they refer to a report.
I don't use VB as a front end myself so am unaware of which features are unavailable.
I know I could use an Access report if I were controlling this remotely from an Excel front end (using the Access library).
If that's not appropriate then please ignore my post Indra.
AricC 1,892
Recognized Expert Top Contributor
In your for/while loop add something like intIndex += 1 that will increment the value each time you move through a record. By data report are you using Crystal Reports? Also, didn't see what version of VB you are using. Post what code you have if this doesn't help.
In your for/while loop add something like intIndex += 1 that will increment the value each time you move through a record. By data report are you using Crystal Reports? Also, didn't see what version of VB you are using. Post what code you have if this doesn't help.
iam using vb6. data report connected using data environment.(not crystal report).
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Gavin |
last post by:
Hi, I'm a newbie to programming of any kind. I have posted this to other
groups in a hope to get a response from anyone.
Can any one tell me how to make my VB program read the Bios serial number...
|
by: tom |
last post by:
Hi,
How do I get the serial number of the harddisk in .NET?
I want this to be the same number even if the user has
reformatted, so I do not want the volume serial number.
Thanx,
t
|
by: Peter |
last post by:
Dear all,
Would you tell me how to solve the following two problems in an access file
upon preparing report form:
a) I have written an IIf function for a string field at the beginning of...
|
by: Mark Harris |
last post by:
I have an installer which uses a Customer Information page in it, is there
an easy way to pass the
serial number entered to a custom action?
If not, where would i find the serial number in the...
|
by: Bayazee |
last post by:
Hi,
How can I get CPU Serial number , or motherboard serial number with
python . I need an idetification of a computer ....
ThanX
---------------------------------------------------
iranian...
|
by: swamimeenu |
last post by:
Hi,
I need to add a automatic serial number in datareport in vb without having tht field in database..
but the remaining fields are connected from db...
how to generate automatic serial number...
|
by: Mai Le |
last post by:
Hello,
I have a table in Microsoft Access with serial numbers field for production, this field contains 10 digits. I would like to show just 6 digits in report, example in table 0000123456 but in...
|
by: surkonsam |
last post by:
Sir,
In the report design , I cannot make a report that shows serial Number.
Front end : visual basic 6.0 and back end : Ms access 2003.
I don't know what to do.
With regards
sur
|
by: Airslash |
last post by:
Hello,
I've written a class that resembles a hard drive. I'm already able using the Windows API to get information such as the remaining free bytes, the sectors and clusters,a nd it all works...
|
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,...
|
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...
|
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,...
|
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...
|
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...
|
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,...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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 ...
| |
