p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Auto Serial# on Subform


Message #1 by "George Oro" <george@c...> on Sun, 9 Jun 2002 15:48:14 +0400
Hi Guys,

I have a subform (Orders Details) in a Datasheet view with the following below fields:
How can I put an Auto Serial# on my fldSlNo (Number format) every time I will add a new record line.

fldSlNo	fldCategory		fldDescription	fldCost
---------------------------------------------------------
1		Category 1		Description 1	144.00
2		Category 2		Description 2	564.00
3		===			===			==
4
5
6

Any idea and tips are highly appreciated.


Cheers,
George



Message #2 by "Leo Scott" <leoscott@c...> on Sun, 9 Jun 2002 15:10:54 -0700
Make the field in the table the subform is based on an Autonumber field.

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Sunday, June 09, 2002 4:48 AM
|To: Access
|Subject: [access] Auto Serial# on Subform
|
|
|Hi Guys,
|
|I have a subform (Orders Details) in a Datasheet view with the 
|following below fields:
|How can I put an Auto Serial# on my fldSlNo (Number format) every 
|time I will add a new record line.
|
|fldSlNo	fldCategory		fldDescription	fldCost
|---------------------------------------------------------
|1		Category 1		Description 1	144.00
|2		Category 2		Description 2	564.00
|3		===			===			==
|4
|5
|6
|
|Any idea and tips are highly appreciated.
|
|
|Cheers,
|George
|
|
|
|
|
Message #3 by "George Oro" <george@c...> on Mon, 10 Jun 2002 09:08:42 +0400
Leo,

I know what you mean, but it wont do. The below example is one order, and the details Sl# start with 1. Next time I will create a
new order, the details Sl# should start also with 1.


Thanks for the tips...
Cheers,
George

-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Monday, June 10, 2002 2:11 AM
To: Access
Subject: [access] RE: Auto Serial# on Subform


Make the field in the table the subform is based on an Autonumber field.

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Sunday, June 09, 2002 4:48 AM
|To: Access
|Subject: [access] Auto Serial# on Subform
|
|
|Hi Guys,
|
|I have a subform (Orders Details) in a Datasheet view with the
|following below fields:
|How can I put an Auto Serial# on my fldSlNo (Number format) every
|time I will add a new record line.
|
|fldSlNo	fldCategory		fldDescription	fldCost
|---------------------------------------------------------
|1		Category 1		Description 1	144.00
|2		Category 2		Description 2	564.00
|3		===			===			==
|4
|5
|6
|
|Any idea and tips are highly appreciated.
|
|
|Cheers,
|George
|
|
|
|
|


Message #4 by "Leo Scott" <leoscott@c...> on Mon, 10 Jun 2002 00:33:54 -0700
I have looked at a problem similar to this before and the simplist way would
be to create a temporary table for the data with an autonumber field.

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Sunday, June 09, 2002 10:09 PM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Leo,
|
|I know what you mean, but it wont do. The below example is one
|order, and the details Sl# start with 1. Next time I will create a
|new order, the details Sl# should start also with 1.
|
|
|Thanks for the tips...
|Cheers,
|George
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Monday, June 10, 2002 2:11 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Make the field in the table the subform is based on an Autonumber field.
|
||-----Original Message-----
||From: George Oro [mailto:george@c...]
||Sent: Sunday, June 09, 2002 4:48 AM
||To: Access
||Subject: [access] Auto Serial# on Subform
||
||
||Hi Guys,
||
||I have a subform (Orders Details) in a Datasheet view with the
||following below fields:
||How can I put an Auto Serial# on my fldSlNo (Number format) every
||time I will add a new record line.
||
||fldSlNo	fldCategory		fldDescription	fldCost
||---------------------------------------------------------
||1		Category 1		Description 1	144.00
||2		Category 2		Description 2	564.00
||3		===			===			==
||4
||5
||6
||
||Any idea and tips are highly appreciated.
||
||
||Cheers,
||George
||
||
||
||
||
|
|
|

Message #5 by "George Oro" <george@c...> on Mon, 10 Jun 2002 11:58:04 +0400
Do you have any sample code to do that?


Cheers,
George


-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Monday, June 10, 2002 11:34 AM
To: Access
Subject: [access] RE: Auto Serial# on Subform


I have looked at a problem similar to this before and the simplist way would
be to create a temporary table for the data with an autonumber field.

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Sunday, June 09, 2002 10:09 PM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Leo,
|
|I know what you mean, but it wont do. The below example is one
|order, and the details Sl# start with 1. Next time I will create a
|new order, the details Sl# should start also with 1.
|
|
|Thanks for the tips...
|Cheers,
|George
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Monday, June 10, 2002 2:11 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Make the field in the table the subform is based on an Autonumber field.
|
||-----Original Message-----
||From: George Oro [mailto:george@c...]
||Sent: Sunday, June 09, 2002 4:48 AM
||To: Access
||Subject: [access] Auto Serial# on Subform
||
||
||Hi Guys,
||
||I have a subform (Orders Details) in a Datasheet view with the
||following below fields:
||How can I put an Auto Serial# on my fldSlNo (Number format) every
||time I will add a new record line.
||
||fldSlNo	fldCategory		fldDescription	fldCost
||---------------------------------------------------------
||1		Category 1		Description 1	144.00
||2		Category 2		Description 2	564.00
||3		===			===			==
||4
||5
||6
||
||Any idea and tips are highly appreciated.
||
||
||Cheers,
||George
||
||
||
||
||
|
|
|



Message #6 by "David Chapman" <luckychap@b...> on Mon, 10 Jun 2002 19:51:12 +0930
George,

A lot depends on what you are required to produce.

I used form.tag to store a line number once. I set it to zero on open,
incremented it and applied the value before insert. It worked well because
the forms were never re-opned and updated.

On another occasion I used a function before insert, which used SQL to find
the max line number when the invoice number was =   to the current invoice.
There were only two machines using the data base and about 30 invoices a
day.

If I had to rewrite either project I would seriously question the need to
display a line number. When you normalize your data you find that each line
of data contains the smallest practical data items. You could use the
complex index of InvoiceNo. +  LineNo to identify each line, but it is just
as easy to use an auto number. You still have to link the subform to the
mainform using InvoiceNo, but the space used is the same. On the other hand
a unique identifyer is very helpful when you design queries.

I hope I have made you think a bit.

David


-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 10, 2002 5:28 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


Do you have any sample code to do that?


Cheers,
George


-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Monday, June 10, 2002 11:34 AM
To: Access
Subject: [access] RE: Auto Serial# on Subform


I have looked at a problem similar to this before and the simplist way would
be to create a temporary table for the data with an autonumber field.

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Sunday, June 09, 2002 10:09 PM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Leo,
|
|I know what you mean, but it wont do. The below example is one
|order, and the details Sl# start with 1. Next time I will create a
|new order, the details Sl# should start also with 1.
|
|
|Thanks for the tips...
|Cheers,
|George
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Monday, June 10, 2002 2:11 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Make the field in the table the subform is based on an Autonumber field.
|
||-----Original Message-----
||From: George Oro [mailto:george@c...]
||Sent: Sunday, June 09, 2002 4:48 AM
||To: Access
||Subject: [access] Auto Serial# on Subform
||
||
||Hi Guys,
||
||I have a subform (Orders Details) in a Datasheet view with the
||following below fields:
||How can I put an Auto Serial# on my fldSlNo (Number format) every
||time I will add a new record line.
||
||fldSlNo	fldCategory		fldDescription	fldCost
||---------------------------------------------------------
||1		Category 1		Description 1	144.00
||2		Category 2		Description 2	564.00
||3		===			===			==
||4
||5
||6
||
||Any idea and tips are highly appreciated.
||
||
||Cheers,
||George
||
||
||
||
||
|
|
|





Message #7 by "George Oro" <george@c...> on Mon, 10 Jun 2002 14:49:14 +0400
David,

This is what I'm looking for (Automate the Order Details Line# & the Next Invoice#).

One question, let say initially I have already an Order or a Line# 1,2,3 on my order details, then after sometimes I might Add or
Delete Line so what will happen now to my Line# now?

I'm not really good in VBA, CAN YOU SHARE TO ME YOUR CODE? PLEASE...

Thank you in advance...

Cheers
George ^_^


-----Original Message-----
From: David Chapman [mailto:luckychap@b...]
Sent: Monday, June 10, 2002 2:21 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


George,

A lot depends on what you are required to produce.

I used form.tag to store a line number once. I set it to zero on open,
incremented it and applied the value before insert. It worked well because
the forms were never re-opned and updated.

On another occasion I used a function before insert, which used SQL to find
the max line number when the invoice number was =   to the current invoice.
There were only two machines using the data base and about 30 invoices a
day.

If I had to rewrite either project I would seriously question the need to
display a line number. When you normalize your data you find that each line
of data contains the smallest practical data items. You could use the
complex index of InvoiceNo. +  LineNo to identify each line, but it is just
as easy to use an auto number. You still have to link the subform to the
mainform using InvoiceNo, but the space used is the same. On the other hand
a unique identifyer is very helpful when you design queries.

I hope I have made you think a bit.

David


-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 10, 2002 5:28 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


Do you have any sample code to do that?


Cheers,
George


-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Monday, June 10, 2002 11:34 AM
To: Access
Subject: [access] RE: Auto Serial# on Subform


I have looked at a problem similar to this before and the simplist way would
be to create a temporary table for the data with an autonumber field.

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Sunday, June 09, 2002 10:09 PM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Leo,
|
|I know what you mean, but it wont do. The below example is one
|order, and the details Sl# start with 1. Next time I will create a
|new order, the details Sl# should start also with 1.
|
|
|Thanks for the tips...
|Cheers,
|George
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Monday, June 10, 2002 2:11 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Make the field in the table the subform is based on an Autonumber field.
|
||-----Original Message-----
||From: George Oro [mailto:george@c...]
||Sent: Sunday, June 09, 2002 4:48 AM
||To: Access
||Subject: [access] Auto Serial# on Subform
||
||
||Hi Guys,
||
||I have a subform (Orders Details) in a Datasheet view with the
||following below fields:
||How can I put an Auto Serial# on my fldSlNo (Number format) every
||time I will add a new record line.
||
||fldSlNo	fldCategory		fldDescription	fldCost
||---------------------------------------------------------
||1		Category 1		Description 1	144.00
||2		Category 2		Description 2	564.00
||3		===			===			==
||4
||5
||6
||
||Any idea and tips are highly appreciated.
||
||
||Cheers,
||George
||
||
||
||
||
|
|
|







Message #8 by "Leo Scott" <leoscott@c...> on Mon, 10 Jun 2002 01:15:58 -0700
Are you using Access 2000 or higher?

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Monday, June 10, 2002 12:58 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Do you have any sample code to do that?
|
|
|Cheers,
|George
|
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Monday, June 10, 2002 11:34 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|I have looked at a problem similar to this before and the simplist 
|way would
|be to create a temporary table for the data with an autonumber field.
|
||-----Original Message-----
||From: George Oro [mailto:george@c...]
||Sent: Sunday, June 09, 2002 10:09 PM
||To: Access
||Subject: [access] RE: Auto Serial# on Subform
||
||
||Leo,
||
||I know what you mean, but it wont do. The below example is one
||order, and the details Sl# start with 1. Next time I will create a
||new order, the details Sl# should start also with 1.
||
||
||Thanks for the tips...
||Cheers,
||George
||
||-----Original Message-----
||From: Leo Scott [mailto:leoscott@c...]
||Sent: Monday, June 10, 2002 2:11 AM
||To: Access
||Subject: [access] RE: Auto Serial# on Subform
||
||
||Make the field in the table the subform is based on an Autonumber field.
||
|||-----Original Message-----
|||From: George Oro [mailto:george@c...]
|||Sent: Sunday, June 09, 2002 4:48 AM
|||To: Access
|||Subject: [access] Auto Serial# on Subform
|||
|||
|||Hi Guys,
|||
|||I have a subform (Orders Details) in a Datasheet view with the
|||following below fields:
|||How can I put an Auto Serial# on my fldSlNo (Number format) every
|||time I will add a new record line.
|||
|||fldSlNo	fldCategory		fldDescription	fldCost
|||---------------------------------------------------------
|||1		Category 1		Description 1	144.00
|||2		Category 2		Description 2	564.00
|||3		===			===			==
|||4
|||5
|||6
|||
|||Any idea and tips are highly appreciated.
|||
|||
|||Cheers,
|||George
|||
|||
|||
|||
|||
||
||
||
|
|
|
|
|
Message #9 by "Derrick Flores" <Derrick_Flores@s...> on Mon, 10 Jun 2002 11:48:30 -0500
Hello to all,
   Sorry to but in on your email conversation, but I thought about this 
and came up with a code that you can insert in the BeforeUpdate Event of 
your text box in your subform that will create a recordset clone of the 
recordset and asign an integer the recordsetcount of the recordset clone 
then add it to the record serial number when a record is updated or 
created.  Here's my example below.

Private Sub TEXT1_BeforeUpdate(Cancel As Integer)

Dim i As Integer
Dim recCLONE As Recordset

Set recCLONE =3D Me.RecordsetClone()
i =3D recCLONE.RecordCount

Me.SUBSN.Value =3D i + 1

End Sub

Good luck,
Derrick Flores
Sony Semiconductor
San Antonio, TX 78245-2100

>>> "Leo Scott" <leoscott@c...> 06/10 3:15 AM >>>
Are you using Access 2000 or higher?

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Monday, June 10, 2002 12:58 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Do you have any sample code to do that?
|
|
|Cheers,
|George
|
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Monday, June 10, 2002 11:34 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|I have looked at a problem similar to this before and the simplist
|way would
|be to create a temporary table for the data with an autonumber field.
|
||-----Original Message-----
||From: George Oro [mailto:george@c...]
||Sent: Sunday, June 09, 2002 10:09 PM
||To: Access
||Subject: [access] RE: Auto Serial# on Subform
||
||
||Leo,
||
||I know what you mean, but it wont do. The below example is one
||order, and the details Sl# start with 1. Next time I will create a
||new order, the details Sl# should start also with 1.
||
||
||Thanks for the tips...
||Cheers,
||George
||
||-----Original Message-----
||From: Leo Scott [mailto:leoscott@c...]
||Sent: Monday, June 10, 2002 2:11 AM
||To: Access
||Subject: [access] RE: Auto Serial# on Subform
||
||
||Make the field in the table the subform is based on an Autonumber field.
||
|||-----Original Message-----
|||From: George Oro [mailto:george@c...]
|||Sent: Sunday, June 09, 2002 4:48 AM
|||To: Access
|||Subject: [access] Auto Serial# on Subform
|||
|||
|||Hi Guys,
|||
|||I have a subform (Orders Details) in a Datasheet view with the
|||following below fields:
|||How can I put an Auto Serial# on my fldSlNo (Number format) every
|||time I will add a new record line.
|||
|||fldSlNo	fldCategory		fldDescription	fldCost
|||---------------------------------------------------------
|||1		Category 1		Description 1	144.00
|||2		Category 2		Description 2	564.00
|||3		=3D=3D=3D			=3D=3D=3D			
=3D=3D
|||4
|||5
|||6
|||
|||Any idea and tips are highly appreciated.
|||
|||
|||Cheers,
|||George
|||
|||
|||
|||
|||
||
||
||
|
|
|
|
|


Message #10 by "George Oro" <george@c...> on Tue, 11 Jun 2002 09:55:42 +0400
Leo,

I'm using Access 2000.


Cheers,
George


-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Monday, June 10, 2002 12:16 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


Are you using Access 2000 or higher?

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Monday, June 10, 2002 12:58 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Do you have any sample code to do that?
|
|
|Cheers,
|George
|
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Monday, June 10, 2002 11:34 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|I have looked at a problem similar to this before and the simplist 
|way would
|be to create a temporary table for the data with an autonumber field.
|
||-----Original Message-----
||From: George Oro [mailto:george@c...]
||Sent: Sunday, June 09, 2002 10:09 PM
||To: Access
||Subject: [access] RE: Auto Serial# on Subform
||
||
||Leo,
||
||I know what you mean, but it wont do. The below example is one
||order, and the details Sl# start with 1. Next time I will create a
||new order, the details Sl# should start also with 1.
||
||
||Thanks for the tips...
||Cheers,
||George
||
||-----Original Message-----
||From: Leo Scott [mailto:leoscott@c...]
||Sent: Monday, June 10, 2002 2:11 AM
||To: Access
||Subject: [access] RE: Auto Serial# on Subform
||
||
||Make the field in the table the subform is based on an Autonumber field.
||
|||-----Original Message-----
|||From: George Oro [mailto:george@c...]
|||Sent: Sunday, June 09, 2002 4:48 AM
|||To: Access
|||Subject: [access] Auto Serial# on Subform
|||
|||
|||Hi Guys,
|||
|||I have a subform (Orders Details) in a Datasheet view with the
|||following below fields:
|||How can I put an Auto Serial# on my fldSlNo (Number format) every
|||time I will add a new record line.
|||
|||fldSlNo	fldCategory		fldDescription	fldCost
|||---------------------------------------------------------
|||1		Category 1		Description 1	144.00
|||2		Category 2		Description 2	564.00
|||3		===			===			==
|||4
|||5
|||6
|||
|||Any idea and tips are highly appreciated.
|||
|||
|||Cheers,
|||George
|||
|||
|||
|||
|||
||
||
||
|
|
|
|
|


Message #11 by "David Chapman" <luckychap@b...> on Fri, 14 Jun 2002 20:17:28 +0930
George

I could send you lots of code but it will be useless to you because it
refers to my tables and names. Your problem is that you hav not defined what
you want. You are saying "I might delete a line, what happens to my line
numbers". This is up to you. You have to define what you want to happen. If
your employer or customer used manual invoices, and a clerk rubbed out a
line - what would happen to the line numbers? You can duplicate that in a
computer system,you are the one that has to define what your system will do.
There is no standard to adhere to.  In my previous email I suggested that it
may not be necessary to show the line numbers to your users, which means it
won't matter if a line is deleted, and you could use an auto number which
would accurately identify a record in a normalized table. You will
appreciate this as you develop your database and your queries become more
complex.

However if you have to display the line numbers to the users of your data
base, I suggest it would not matter if a sequence was missing - eg in a five
line invoice where you delete line three, the line numbers will be 1, 2, 4,
5. But this is for you to decide. You could develop code to renumber the
lines in VBA, I would have to do a lot of thinking to do it in a query. And
it is dangerous because the line number is likely to be part of link between
tables.

To get the next  line number I use something like -
set db = currentdb
set rs= db.openrecordset("select max(lineno) as MaxLine from InvoiceLines
where InvoiceNo='" & InvoiceNo & "'")
If rs.recount = 0 then
   LineNo = 1
else
   LineNo = MaxLine + 1
end if
rs.close

David

-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 10, 2002 8:19 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


David,

This is what I'm looking for (Automate the Order Details Line# & the Next
Invoice#).

One question, let say initially I have already an Order or a Line# 1,2,3 on
my order details, then after sometimes I might Add or
Delete Line so what will happen now to my Line# now?

I'm not really good in VBA, CAN YOU SHARE TO ME YOUR CODE? PLEASE...

Thank you in advance...

Cheers
George ^_^


-----Original Message-----
From: David Chapman [mailto:luckychap@b...]
Sent: Monday, June 10, 2002 2:21 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


George,

A lot depends on what you are required to produce.

I used form.tag to store a line number once. I set it to zero on open,
incremented it and applied the value before insert. It worked well because
the forms were never re-opned and updated.

On another occasion I used a function before insert, which used SQL to find
the max line number when the invoice number was =   to the current invoice.
There were only two machines using the data base and about 30 invoices a
day.

If I had to rewrite either project I would seriously question the need to
display a line number. When you normalize your data you find that each line
of data contains the smallest practical data items. You could use the
complex index of InvoiceNo. +  LineNo to identify each line, but it is just
as easy to use an auto number. You still have to link the subform to the
mainform using InvoiceNo, but the space used is the same. On the other hand
a unique identifyer is very helpful when you design queries.

I hope I have made you think a bit.

David


-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 10, 2002 5:28 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


Do you have any sample code to do that?


Cheers,
George


-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Monday, June 10, 2002 11:34 AM
To: Access
Subject: [access] RE: Auto Serial# on Subform


I have looked at a problem similar to this before and the simplist way would
be to create a temporary table for the data with an autonumber field.

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Sunday, June 09, 2002 10:09 PM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Leo,
|
|I know what you mean, but it wont do. The below example is one
|order, and the details Sl# start with 1. Next time I will create a
|new order, the details Sl# should start also with 1.
|
|
|Thanks for the tips...
|Cheers,
|George
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Monday, June 10, 2002 2:11 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Make the field in the table the subform is based on an Autonumber field.
|
||-----Original Message-----
||From: George Oro [mailto:george@c...]
||Sent: Sunday, June 09, 2002 4:48 AM
||To: Access
||Subject: [access] Auto Serial# on Subform
||
||
||Hi Guys,
||
||I have a subform (Orders Details) in a Datasheet view with the
||following below fields:
||How can I put an Auto Serial# on my fldSlNo (Number format) every
||time I will add a new record line.
||
||fldSlNo	fldCategory		fldDescription	fldCost
||---------------------------------------------------------
||1		Category 1		Description 1	144.00
||2		Category 2		Description 2	564.00
||3		===			===			==
||4
||5
||6
||
||Any idea and tips are highly appreciated.
||
||
||Cheers,
||George
||
||
||
||
||
|
|
|









Message #12 by "George Oro" <george@c...> on Sat, 15 Jun 2002 08:52:05 +0400
David,
I understand what you mean, thanks for the tips I will try it ...

Cheers,
George


-----Original Message-----
From: David Chapman [mailto:luckychap@b...]
Sent: Friday, June 14, 2002 2:47 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


George

I could send you lots of code but it will be useless to you because it
refers to my tables and names. Your problem is that you hav not defined what
you want. You are saying "I might delete a line, what happens to my line
numbers". This is up to you. You have to define what you want to happen. If
your employer or customer used manual invoices, and a clerk rubbed out a
line - what would happen to the line numbers? You can duplicate that in a
computer system,you are the one that has to define what your system will do.
There is no standard to adhere to.  In my previous email I suggested that it
may not be necessary to show the line numbers to your users, which means it
won't matter if a line is deleted, and you could use an auto number which
would accurately identify a record in a normalized table. You will
appreciate this as you develop your database and your queries become more
complex.

However if you have to display the line numbers to the users of your data
base, I suggest it would not matter if a sequence was missing - eg in a five
line invoice where you delete line three, the line numbers will be 1, 2, 4,
5. But this is for you to decide. You could develop code to renumber the
lines in VBA, I would have to do a lot of thinking to do it in a query. And
it is dangerous because the line number is likely to be part of link between
tables.

To get the next  line number I use something like -
set db = currentdb
set rs= db.openrecordset("select max(lineno) as MaxLine from InvoiceLines
where InvoiceNo='" & InvoiceNo & "'")
If rs.recount = 0 then
   LineNo = 1
else
   LineNo = MaxLine + 1
end if
rs.close

David

-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 10, 2002 8:19 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


David,

This is what I'm looking for (Automate the Order Details Line# & the Next
Invoice#).

One question, let say initially I have already an Order or a Line# 1,2,3 on
my order details, then after sometimes I might Add or
Delete Line so what will happen now to my Line# now?

I'm not really good in VBA, CAN YOU SHARE TO ME YOUR CODE? PLEASE...

Thank you in advance...

Cheers
George ^_^


-----Original Message-----
From: David Chapman [mailto:luckychap@b...]
Sent: Monday, June 10, 2002 2:21 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


George,

A lot depends on what you are required to produce.

I used form.tag to store a line number once. I set it to zero on open,
incremented it and applied the value before insert. It worked well because
the forms were never re-opned and updated.

On another occasion I used a function before insert, which used SQL to find
the max line number when the invoice number was =   to the current invoice.
There were only two machines using the data base and about 30 invoices a
day.

If I had to rewrite either project I would seriously question the need to
display a line number. When you normalize your data you find that each line
of data contains the smallest practical data items. You could use the
complex index of InvoiceNo. +  LineNo to identify each line, but it is just
as easy to use an auto number. You still have to link the subform to the
mainform using InvoiceNo, but the space used is the same. On the other hand
a unique identifyer is very helpful when you design queries.

I hope I have made you think a bit.

David


-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 10, 2002 5:28 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


Do you have any sample code to do that?


Cheers,
George


-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Monday, June 10, 2002 11:34 AM
To: Access
Subject: [access] RE: Auto Serial# on Subform


I have looked at a problem similar to this before and the simplist way would
be to create a temporary table for the data with an autonumber field.

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Sunday, June 09, 2002 10:09 PM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Leo,
|
|I know what you mean, but it wont do. The below example is one
|order, and the details Sl# start with 1. Next time I will create a
|new order, the details Sl# should start also with 1.
|
|
|Thanks for the tips...
|Cheers,
|George
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Monday, June 10, 2002 2:11 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Make the field in the table the subform is based on an Autonumber field.
|
||-----Original Message-----
||From: George Oro [mailto:george@c...]
||Sent: Sunday, June 09, 2002 4:48 AM
||To: Access
||Subject: [access] Auto Serial# on Subform
||
||
||Hi Guys,
||
||I have a subform (Orders Details) in a Datasheet view with the
||following below fields:
||How can I put an Auto Serial# on my fldSlNo (Number format) every
||time I will add a new record line.
||
||fldSlNo	fldCategory		fldDescription	fldCost
||---------------------------------------------------------
||1		Category 1		Description 1	144.00
||2		Category 2		Description 2	564.00
||3		===			===			==
||4
||5
||6
||
||Any idea and tips are highly appreciated.
||
||
||Cheers,
||George
||
||
||
||
||
|
|
|











Message #13 by "Derrick Flores" <Derrick_Flores@s...> on Mon, 17 Jun 2002 07:21:01 -0500
George,  Have you tried using the RecordClone method?  Here's what you can 
do to create a Auto Serial # for your subform.
Once I created the subform with the field (number) that will hold the 
autonumber included in the table, I used the beforeupdate event on the 
first textbox to be used to enter data in the subform.

Here's my fully functionable sample code:

Private Sub TEXT1_BeforeUpdate(Cancel As Integer)
Dim i As Integer
Dim recCLONE As Recordset

Set recCLONE =3D Me.RecordsetClone()
i =3D recCLONE.RecordCount

' add the autonumber to the textbox
Me.SUBSN.Value =3D i + 1

End Sub

Good luck,
Derrick Flores
Sony Semiconductor
San Antonio, TX


>>> "George Oro" <george@c...> 06/14 11:52 PM >>>
David,
I understand what you mean, thanks for the tips I will try it ...

Cheers,
George


-----Original Message-----
From: David Chapman [mailto:luckychap@b...]
Sent: Friday, June 14, 2002 2:47 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


George

I could send you lots of code but it will be useless to you because it
refers to my tables and names. Your problem is that you hav not defined 
what
you want. You are saying "I might delete a line, what happens to my line
numbers". This is up to you. You have to define what you want to happen. 
If
your employer or customer used manual invoices, and a clerk rubbed out a
line - what would happen to the line numbers? You can duplicate that in a
computer system,you are the one that has to define what your system will 
do.
There is no standard to adhere to.  In my previous email I suggested that 
it
may not be necessary to show the line numbers to your users, which means 
it
won't matter if a line is deleted, and you could use an auto number which
would accurately identify a record in a normalized table. You will
appreciate this as you develop your database and your queries become more
complex.

However if you have to display the line numbers to the users of your data
base, I suggest it would not matter if a sequence was missing - eg in a 
five
line invoice where you delete line three, the line numbers will be 1, 2, 
4,
5. But this is for you to decide. You could develop code to renumber the
lines in VBA, I would have to do a lot of thinking to do it in a query. 
And
it is dangerous because the line number is likely to be part of link 
between
tables.

To get the next  line number I use something like -
set db =3D currentdb
set rs=3D db.openrecordset("select max(lineno) as MaxLine from InvoiceLines

where InvoiceNo=3D'" & InvoiceNo & "'")
If rs.recount =3D 0 then
   LineNo =3D 1
else
   LineNo =3D MaxLine + 1
end if
rs.close

David

-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 10, 2002 8:19 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


David,

This is what I'm looking for (Automate the Order Details Line# & the Next
Invoice#).

One question, let say initially I have already an Order or a Line# 1,2,3 
on
my order details, then after sometimes I might Add or
Delete Line so what will happen now to my Line# now?

I'm not really good in VBA, CAN YOU SHARE TO ME YOUR CODE? PLEASE...

Thank you in advance...

Cheers
George ^_^


-----Original Message-----
From: David Chapman [mailto:luckychap@b...]
Sent: Monday, June 10, 2002 2:21 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


George,

A lot depends on what you are required to produce.

I used form.tag to store a line number once. I set it to zero on open,
incremented it and applied the value before insert. It worked well because
the forms were never re-opned and updated.

On another occasion I used a function before insert, which used SQL to 
find
the max line number when the invoice number was =3D   to the current 
invoice.
There were only two machines using the data base and about 30 invoices a
day.

If I had to rewrite either project I would seriously question the need to
display a line number. When you normalize your data you find that each 
line
of data contains the smallest practical data items. You could use the
complex index of InvoiceNo. +  LineNo to identify each line, but it is 
just
as easy to use an auto number. You still have to link the subform to the
mainform using InvoiceNo, but the space used is the same. On the other 
hand
a unique identifyer is very helpful when you design queries.

I hope I have made you think a bit.

David


-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 10, 2002 5:28 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


Do you have any sample code to do that?


Cheers,
George


-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Monday, June 10, 2002 11:34 AM
To: Access
Subject: [access] RE: Auto Serial# on Subform


I have looked at a problem similar to this before and the simplist way 
would
be to create a temporary table for the data with an autonumber field.

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Sunday, June 09, 2002 10:09 PM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Leo,
|
|I know what you mean, but it wont do. The below example is one
|order, and the details Sl# start with 1. Next time I will create a
|new order, the details Sl# should start also with 1.
|
|
|Thanks for the tips...
|Cheers,
|George
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Monday, June 10, 2002 2:11 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Make the field in the table the subform is based on an Autonumber field.
|
||-----Original Message-----
||From: George Oro [mailto:george@c...]
||Sent: Sunday, June 09, 2002 4:48 AM
||To: Access
||Subject: [access] Auto Serial# on Subform
||
||
||Hi Guys,
||
||I have a subform (Orders Details) in a Datasheet view with the
||following below fields:
||How can I put an Auto Serial# on my fldSlNo (Number format) every
||time I will add a new record line.
||
||fldSlNo	fldCategory		fldDescription	fldCost
||---------------------------------------------------------
||1		Category 1		Description 1	144.00
||2		Category 2		Description 2	564.00
||3		=3D=3D=3D			=3D=3D=3D			
=3D=3D
||4
||5
||6
||
||Any idea and tips are highly appreciated.
||
||
||Cheers,
||George
||
||
||
||
||
|
|
|












Message #14 by "George Oro" <george@c...> on Mon, 17 Jun 2002 17:11:39 +0400
Derrick,

Wow, its working!!! just a thought to make your code perfect as in perfect...

I created 3 entry (Sl# 1,2,3) which is fine, then I deleted Sl# 2, of course Sl# 1 & 3 will remain. Is there any way or chance
to
change Sl# 3 to Sl# 2 automatically or refresh the Sl# accordingly after deleting any row?

Many-many thanks man...



Cheers,
George






-----Original Message-----
From: Derrick Flores [mailto:Derrick_Flores@s...]
Sent: Monday, June 17, 2002 4:21 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


George,  Have you tried using the RecordClone method?  Here's what you can do to create a Auto Serial # for your subform.
Once I created the subform with the field (number) that will hold the autonumber included in the table, I used the beforeupdate
event on the first textbox to be used to enter data in the subform.

Here's my fully functionable sample code:

Private Sub TEXT1_BeforeUpdate(Cancel As Integer)
Dim i As Integer
Dim recCLONE As Recordset

Set recCLONE = Me.RecordsetClone()
i = recCLONE.RecordCount

' add the autonumber to the textbox
Me.SUBSN.Value = i + 1

End Sub

Good luck,
Derrick Flores
Sony Semiconductor
San Antonio, TX


>>> "George Oro" <george@c...> 06/14 11:52 PM >>>
David,
I understand what you mean, thanks for the tips I will try it ...

Cheers,
George


-----Original Message-----
From: David Chapman [mailto:luckychap@b...]
Sent: Friday, June 14, 2002 2:47 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


George

I could send you lots of code but it will be useless to you because it
refers to my tables and names. Your problem is that you hav not defined what
you want. You are saying "I might delete a line, what happens to my line
numbers". This is up to you. You have to define what you want to happen. If
your employer or customer used manual invoices, and a clerk rubbed out a
line - what would happen to the line numbers? You can duplicate that in a
computer system,you are the one that has to define what your system will do.
There is no standard to adhere to.  In my previous email I suggested that it
may not be necessary to show the line numbers to your users, which means it
won't matter if a line is deleted, and you could use an auto number which
would accurately identify a record in a normalized table. You will
appreciate this as you develop your database and your queries become more
complex.

However if you have to display the line numbers to the users of your data
base, I suggest it would not matter if a sequence was missing - eg in a five
line invoice where you delete line three, the line numbers will be 1, 2, 4,
5. But this is for you to decide. You could develop code to renumber the
lines in VBA, I would have to do a lot of thinking to do it in a query. And
it is dangerous because the line number is likely to be part of link between
tables.

To get the next  line number I use something like -
set db = currentdb
set rs= db.openrecordset("select max(lineno) as MaxLine from InvoiceLines
where InvoiceNo='" & InvoiceNo & "'")
If rs.recount = 0 then
   LineNo = 1
else
   LineNo = MaxLine + 1
end if
rs.close

David

-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 10, 2002 8:19 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


David,

This is what I'm looking for (Automate the Order Details Line# & the Next
Invoice#).

One question, let say initially I have already an Order or a Line# 1,2,3 on
my order details, then after sometimes I might Add or
Delete Line so what will happen now to my Line# now?

I'm not really good in VBA, CAN YOU SHARE TO ME YOUR CODE? PLEASE...

Thank you in advance...

Cheers
George ^_^


-----Original Message-----
From: David Chapman [mailto:luckychap@b...]
Sent: Monday, June 10, 2002 2:21 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


George,

A lot depends on what you are required to produce.

I used form.tag to store a line number once. I set it to zero on open,
incremented it and applied the value before insert. It worked well because
the forms were never re-opned and updated.

On another occasion I used a function before insert, which used SQL to find
the max line number when the invoice number was =   to the current invoice.
There were only two machines using the data base and about 30 invoices a
day.

If I had to rewrite either project I would seriously question the need to
display a line number. When you normalize your data you find that each line
of data contains the smallest practical data items. You could use the
complex index of InvoiceNo. +  LineNo to identify each line, but it is just
as easy to use an auto number. You still have to link the subform to the
mainform using InvoiceNo, but the space used is the same. On the other hand
a unique identifyer is very helpful when you design queries.

I hope I have made you think a bit.

David


-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 10, 2002 5:28 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


Do you have any sample code to do that?


Cheers,
George


-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Monday, June 10, 2002 11:34 AM
To: Access
Subject: [access] RE: Auto Serial# on Subform


I have looked at a problem similar to this before and the simplist way would
be to create a temporary table for the data with an autonumber field.

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Sunday, June 09, 2002 10:09 PM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Leo,
|
|I know what you mean, but it wont do. The below example is one
|order, and the details Sl# start with 1. Next time I will create a
|new order, the details Sl# should start also with 1.
|
|
|Thanks for the tips...
|Cheers,
|George
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Monday, June 10, 2002 2:11 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Make the field in the table the subform is based on an Autonumber field.
|
||-----Original Message-----
||From: George Oro [mailto:george@c...]
||Sent: Sunday, June 09, 2002 4:48 AM
||To: Access
||Subject: [access] Auto Serial# on Subform
||
||
||Hi Guys,
||
||I have a subform (Orders Details) in a Datasheet view with the
||following below fields:
||How can I put an Auto Serial# on my fldSlNo (Number format) every
||time I will add a new record line.
||
||fldSlNo	fldCategory		fldDescription	fldCost
||---------------------------------------------------------
||1		Category 1		Description 1	144.00
||2		Category 2		Description 2	564.00
||3		===			===			==
||4
||5
||6
||
||Any idea and tips are highly appreciated.
||
||
||Cheers,
||George
||
||
||
||
||
|
|
|














Message #15 by "George Oro" <george@c...> on Thu, 20 Jun 2002 09:12:42 +0400
Derrick,

Have you try my below suggestion?

Cheers,
Goerge


-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 17, 2002 5:12 PM
To: Access
Subject: RE: [access] RE: Auto Serial# on Subform


Derrick,

Wow, its working!!! just a thought to make your code perfect as in perfect...

I created 3 entry (Sl# 1,2,3) which is fine, then I deleted Sl# 2, of course Sl# 1 & 3 will remain. Is there any way or chance
to
change Sl# 3 to Sl# 2 automatically or refresh the Sl# accordingly after deleting any row?

Many-many thanks man...



Cheers,
George






-----Original Message-----
From: Derrick Flores [mailto:Derrick_Flores@s...]
Sent: Monday, June 17, 2002 4:21 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


George,  Have you tried using the RecordClone method?  Here's what you can do to create a Auto Serial # for your subform.
Once I created the subform with the field (number) that will hold the autonumber included in the table, I used the beforeupdate
event on the first textbox to be used to enter data in the subform.

Here's my fully functionable sample code:

Private Sub TEXT1_BeforeUpdate(Cancel As Integer)
Dim i As Integer
Dim recCLONE As Recordset

Set recCLONE = Me.RecordsetClone()
i = recCLONE.RecordCount

' add the autonumber to the textbox
Me.SUBSN.Value = i + 1

End Sub

Good luck,
Derrick Flores
Sony Semiconductor
San Antonio, TX


>>> "George Oro" <george@c...> 06/14 11:52 PM >>>
David,
I understand what you mean, thanks for the tips I will try it ...

Cheers,
George


-----Original Message-----
From: David Chapman [mailto:luckychap@b...]
Sent: Friday, June 14, 2002 2:47 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


George

I could send you lots of code but it will be useless to you because it
refers to my tables and names. Your problem is that you hav not defined what
you want. You are saying "I might delete a line, what happens to my line
numbers". This is up to you. You have to define what you want to happen. If
your employer or customer used manual invoices, and a clerk rubbed out a
line - what would happen to the line numbers? You can duplicate that in a
computer system,you are the one that has to define what your system will do.
There is no standard to adhere to.  In my previous email I suggested that it
may not be necessary to show the line numbers to your users, which means it
won't matter if a line is deleted, and you could use an auto number which
would accurately identify a record in a normalized table. You will
appreciate this as you develop your database and your queries become more
complex.

However if you have to display the line numbers to the users of your data
base, I suggest it would not matter if a sequence was missing - eg in a five
line invoice where you delete line three, the line numbers will be 1, 2, 4,
5. But this is for you to decide. You could develop code to renumber the
lines in VBA, I would have to do a lot of thinking to do it in a query. And
it is dangerous because the line number is likely to be part of link between
tables.

To get the next  line number I use something like -
set db = currentdb
set rs= db.openrecordset("select max(lineno) as MaxLine from InvoiceLines
where InvoiceNo='" & InvoiceNo & "'")
If rs.recount = 0 then
   LineNo = 1
else
   LineNo = MaxLine + 1
end if
rs.close

David

-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 10, 2002 8:19 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


David,

This is what I'm looking for (Automate the Order Details Line# & the Next
Invoice#).

One question, let say initially I have already an Order or a Line# 1,2,3 on
my order details, then after sometimes I might Add or
Delete Line so what will happen now to my Line# now?

I'm not really good in VBA, CAN YOU SHARE TO ME YOUR CODE? PLEASE...

Thank you in advance...

Cheers
George ^_^


-----Original Message-----
From: David Chapman [mailto:luckychap@b...]
Sent: Monday, June 10, 2002 2:21 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


George,

A lot depends on what you are required to produce.

I used form.tag to store a line number once. I set it to zero on open,
incremented it and applied the value before insert. It worked well because
the forms were never re-opned and updated.

On another occasion I used a function before insert, which used SQL to find
the max line number when the invoice number was =   to the current invoice.
There were only two machines using the data base and about 30 invoices a
day.

If I had to rewrite either project I would seriously question the need to
display a line number. When you normalize your data you find that each line
of data contains the smallest practical data items. You could use the
complex index of InvoiceNo. +  LineNo to identify each line, but it is just
as easy to use an auto number. You still have to link the subform to the
mainform using InvoiceNo, but the space used is the same. On the other hand
a unique identifyer is very helpful when you design queries.

I hope I have made you think a bit.

David


-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Monday, June 10, 2002 5:28 PM
To: Access
Subject: [access] RE: Auto Serial# on Subform


Do you have any sample code to do that?


Cheers,
George


-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Monday, June 10, 2002 11:34 AM
To: Access
Subject: [access] RE: Auto Serial# on Subform


I have looked at a problem similar to this before and the simplist way would
be to create a temporary table for the data with an autonumber field.

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Sunday, June 09, 2002 10:09 PM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Leo,
|
|I know what you mean, but it wont do. The below example is one
|order, and the details Sl# start with 1. Next time I will create a
|new order, the details Sl# should start also with 1.
|
|
|Thanks for the tips...
|Cheers,
|George
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Monday, June 10, 2002 2:11 AM
|To: Access
|Subject: [access] RE: Auto Serial# on Subform
|
|
|Make the field in the table the subform is based on an Autonumber field.
|
||-----Original Message-----
||From: George Oro [mailto:george@c...]
||Sent: Sunday, June 09, 2002 4:48 AM
||To: Access
||Subject: [access] Auto Serial# on Subform
||
||
||Hi Guys,
||
||I have a subform (Orders Details) in a Datasheet view with the
||following below fields:
||How can I put an Auto Serial# on my fldSlNo (Number format) every
||time I will add a new record line.
||
||fldSlNo	fldCategory		fldDescription	fldCost
||---------------------------------------------------------
||1		Category 1		Description 1	144.00
||2		Category 2		Description 2	564.00
||3		===			===			==
||4
||5
||6
||
||Any idea and tips are highly appreciated.
||
||
||Cheers,
||George
||
||
||
||
||
|
|
|















  Return to Index