RE: Recordset
- From: MikeJohnB <MikeJohnB@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 2 Sep 2008 12:21:01 -0700
Sorry forgot to mention, using Access 2007 but programming in Access 2k3
database. Also meant Vb not VBA
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B
"MikeJohnB" wrote:
I know I should not have done it this way BUT!.
Tables
TbL_Main_Data (Top level Table_
Tbl_Quotation (Second Level Table linked to top level as below)
These through Queries form the source for two forms, (Frm_Main_Data) and a
sub form Called (Frm_Line_Item)
the two fields that link these two forms are
Tbl_Main_Data (Quote_Ref)(Unique)
Tbl_Line_Item (Quotation_Ref)(Many)
These are linked with Enforce referentian integrity, with cascade udate and
delete all ticked. giving a one to many link.
Here is the problem
On the Tbl_Line_Item I have a field called (Line_item_No)
After deleting a line item, I want to be able to re-number the sequence of
line items sequentially as indicated below
line Items 3 and 7 deleted leaving
1, 2, 4, 5, 6. 8, 9, 10 etc if there are more line items.
to be re-numbered
1, 2, 3, 4, 5, 6, 7, 8,
I know how this should be done using the recordset in vba but I am lost on
the syntax.
Can anyone assist?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B
- Prev by Date: RE: Insert Statement Syntax
- Next by Date: Re: Custom shortcut Menu with a Popup Control showing data-driven item
- Previous by thread: RE: Insert Statement Syntax
- Next by thread: Re: Custom shortcut Menu with a Popup Control showing data-driven item
- Index(es):
Relevant Pages
|
