o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

How to generate serial numbers automatically in the datareports. -

How to Generate serial numbers automatically in the datareports based on the number of records in the table. Iam using access and I dont think internally Access uses rowid option to keep track of rows. I dont know what function do I have to use to generate serial numbers. Rememeber I am not asking the count option it will give the total number of rows. I want to generate serial numbers dynamically from the front-end (VB) dont say to use the counter datatype in the backend (access). I want to generate serial numbers purely based on that row number in my report(datareport). It wont have any connection with the backend(access database). I want each row to be incremented automatically based on the row number. Is some one there to answer my question. I dont think there are too many to answers to the ?s on Datareports.


[Edited by n_indureddy@yahoo.com on 01-04-2001 at 11:46 PM]

 

How to generate serial numbers automatically in the datareports. -
How to Generate serial numbers automatically in the datareports based on the number of records in the table. Iam using access and I dont think internally Access uses rowid option to keep track of rows. I dont know what function do I have to use to generate serial numbers. Rememeber I a


Is it possible to auto generate serial numbers in VB6 reports -
I use VB6 reports. Is it possible to generate serial numbers of the records in the VB reports? For eg. I am grouping some records. Each group's items should be serially numbered. In the next group, the items should start from serial number 1.


generate 6 random numbers -
hey..how do i generate 6 random numbers? these numbers have to be in a serial form like those used on receipts..for example 000001, 000002 and so on..plz help!


serial no in datareport -
Hi friends, How to generate automatically serial nos. in datareport. Suppose if it displays 100 employee's payment report,serial no.should be generated from 1-100.Please help me?


Serial Number Generation -
Hi Friends, I am preparing a report. Using VB native report(Datareports). I have a query which retrieves records from the database based on a condition. Upto now OK. Problem is i want to display serial number(1,2,...) for the records to be displayed. If i pass from the form, o


Serial No. In datareports -
I am making a data report where I have to list all the employees of my firm. I want to give each and every employee a serial no. I am not getting the process to do. plz. help me out. thnx in adv.


Generate Serial Number -
Hi, i am very new in VB. I am looking forward for someone to help me up. I would like to generate a serial number. This is how it goes. Well, Each time Form1 load the a number will be increase By One and display the result in Form2.Text1.text. The serial number is true only when the


I dont Program...Plz H3lp -
I am trying to Create a VB Program to where i can put all my Serial Numbers in to a program so its faster and easyer to get to them. And getting the help i could learn to. how could you generate more the one serial number. Like press a buttion and you get more then one S.N.. Thank you


Serial in my app -
How can i create or generate serials to install my app? Like i want to generate a serail based on the users pc like there username and the date then the serial number of the harddrive. How do i do this ?


Generating Random Numbers -
In the Program I am Writing I need to have the ability to generate random numbers... Mainly 1-100 right now I used this per1.Text = Int(Rnd * 100) But it does not generate a very random number beig each time i run the program it runs the same numbers... ButI also need to know


[2008] Something like Serial Number Generating -
Hello! I'm building a small commercial application. I need to make something like "Enter a Serial Key". I imagine it would work like this: For example, I download the application (for free) The application then would give me a String of numbers (unique) or somethin


Retrieving Serial Numbers -
Hi! I am assigned by my boss to retrieve the serial numbers of the following: Hard Disk, CPU, Video Card, Memory(RAM), Motherboard and monitor. Is it possible to do it in vb? please help...


Help with serial number validation -
I have made a program. But how do I go about making it piracy-proof? It should be just like the virus scan softwares nowadays. What I have in mind is to have a list of valid serial numbers on the server before distributing the program. Whenever one user tries to access the program,


How to know the Algorithm of this!!!!! -
Hi! My question is about Algorithms.. I have two numbers.. for example :- First Number: 87519756113659 Second Number:87719753497097 There is an Algorithm used here to generate these numbers.. I can get more numbers generated from the same algorithm.. but how to know


[2005] Question About Serial Numbers -
i'm thinking about putting a serial number in one of my projects... that way, users have to have the serial number in order to use it... i'm also have an idea for another program that will extract a working serial number from any software... is that even possible to do?


Very Important Please Read! -
Does anybody know a function or code that will automatically generate random numbers based on the following criteria? A set of eight numeric and alpha-numeric numbers?


Working with very large numbers. -
Hi, I am working on some code that is using some very large numbers. What is the absolute largest numeric data type that I can use before I have to use something fancy? What I am doing is making what is called a Rabbiski sequence, which is where the user types in 2 numbers, and I


Generate random numbers without repeating -
I need to generate random numbers, from 1 to 15. The program runs a timer, and every second, a new number is generated, but it cannot be one that was already generated. This means that by time the 15th number is reached, it will be automatically chosen. I have created a way of doing


Product ID (Serial Number) -
I have used GetVoulmeInformation API to get the Voulme Serial number of the drives. I used this with different type and it works well. But when i use this with CD-to-CD copied CD ROMS it gives the same volume serial numbers. why? Any solution?. I use this number to make the Product ID


HD and CPU serial numbers in VB 3.0 -
Does anybody knows how to get HD and CPU serial numbers in VB 3.0 (16 bits) GetVolumeInformation doesn't work.


Serial numbers - generating and checking them -
Im trying to understand serial numbers how they are generated and checked if they are valid. Im writing application witch if you will want to install you will have to go on home page of this app and then just request for free serial but the page is not problem, problem is i dont know


Increment Numbers -
Hi, I am trying to write a program that will increment numbers. I want to specify two sets of numbers and then generate them. So :- 01-01-01 to 03-03-03 Would generate 01-01-01 01-01-02 01-01-03 01-02-01 01-02-02 etc etc does anybody have any ideas how I could a


Random Verification Codes -
how can I automatically generate random verification codes from scratch like numbers and letters together as in "AB4G679" or just simply numbers as in "287359" and so on and so forth... i need it and have it stored in a database afterwards... i just dont the how to'


SL Nos. in DataGrid..How -
How to generate Serial Nos. automatically in a Datagrid in ASP.NET. Please help me out


Query design help -
Can anyone help with creating this join? I need to join 2 tables based on a value in table A. Table A contains products and serial numbers and table B contains shipping information. Table A and Table B are joined on a serial number, but the problem is Table A has 2 different serial


Automatic primary key generation -
Hi I'm using vb6 & sql. I was wondering if theres any way to automatically generate primary key numbers sequentially (like client id ). Suppose the database contains client id's from 1-10, on the next add operation automatically 11 should be generated.


Using Datareports Dynamically. -
Iam using the datareports dynamically to get the output by using the Dataenvironment Object in conjunction with the command Object and using the Open method of the command Object. But there is one problem, if I dont have any value in some of the fields then I dont want to show those fi


How to generate numbers -
Hello VB Experts! Do any of you know how to generate random numbers in Visual Basic 6 Professional? Thanks


Hard one CHANGING/ERASING a disk's serial number -
I've seen quite a few question about hot to RETRIVE a disk's serial number... I was wondering if there is any way to change or erase it... I'm mostly refering to serial numbers on floppy disks... Since every time you format a disk you get a new serial number, I'm guessing the "For


I want to find CPU serial numbers HElp -
I want to processor serial numbers can I find processor serial numbers Tanks


insert numbers into table -
Hi: im building a table in oracle 9. teh table is called visitor and it has one field called card_number. i want to have this card number to generate numbers automatically from 1 to 200. how do i write the script for that? Thanks, Sheikha


Access Date searching using VB6 & SQL -
I have a list of product serial numbers and the dates the numbers were issued in an access database. I am querying from a VB program which lets the users pick a start and end date to assign the relevant serial numbers within that date range to a recordset. I can a list for a specifi


SOLVED : Serial ID(auto number) -
how i can arrange the ID numbers in ascending order . when i delete a record ... the id serial number cannot be chnged in serial order ... it still as it is .. thnx


Changing data in registry -
Hi I'm doing a program, that allows a user of SolidWorks to change serial (depending on different dongles) in a userfriendly way. How do I change the serial? The path is: HKEY_LOCAL_MACHINE\SOFTWARE\Solidworks\Security the key is: Serial Number and then some xxxxxx-numb


Serial Numbers -
I need to know if it is possible to get the serial number of a removable device (e.g. a CD). If it is I need to know how to do so. Any help much appreciated, Dataphoenyx.


MainBoard serial number -
Can I find mainboars serial numbers


Checking CD Drive Serial -
Any one knows how to check all the CD Drives in the PC and retun all the CD's serial numbers??


UDF Function Trying to Add Date serials -
The problem I had with this was in excel I could get the date serials to sum together. In VB I tried to get them to sum and it concatenated them. I would much rather have them sum together, where it does the m+today. Is there a fix or is it always going to think a date is text in VB.


Access- -Copy values -
I would like to copy values I have in text boxes, generate an new record and then paste those same values into the text boxes on the new record. Is this possible? I am trying to come up with an easy way to automatically fill in the values. I have a piece of equipment scheduled for w


How do I generate random numbers -
I am making a new program and I need to know how to make it generate a random number from 1 to 100. I found one way on the web, but the numbers always seem to go in this order: 71,54,58, and so on. The order is always exactly the same. I need to find a way to make the numbers purely an