Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Adding and Deleting records simultaneously in multiple tab..

 
   Database Help (Home) -> MS Access -> Tables DB Design RSS
Next:  Decimal displays 1, 2, or None  
Author Message
Bobk

External


Since: Oct 07, 2007
Posts: 8



(Msg. 1) Posted: Sun Oct 05, 2008 7:57 am
Post subject: Adding and Deleting records simultaneously in multiple tables
Archived from groups: microsoft>public>access>tablesdbdesign (more info?)

I have inherited a table called "Bookings". This table cotains summary sales
order data. It was loaded via a Form. I have been asked to build a detailed
order entry system with an order entry form that will record all detailed
information associated with an order. This is ok. The problem I'm haveing is:
I want to be able to automatically update the existing Bookings table. When
new orders are entered through the order entry form, I want them to appear in
the bookings table. All new order data entered through the order entry form
is held in a table called "oeheader". Orders entered into the bookings table
prior to using the new order entry form do not appear in oeheader. The order
entry form is driven from a query and contains the bookings table. I have the
bookings table related to the oeheader table via the keys in both tables.
When I try to add or delete a record from oeheader I am only able to modify
the oeheader table. Can anyone point me in the right direction?

 >> Stay informed about: Adding and Deleting records simultaneously in multiple tab.. 
Back to top
Login to vote
Klatuu

External


Since: Sep 30, 2008
Posts: 163



(Msg. 2) Posted: Mon Oct 06, 2008 8:58 am
Post subject: Re: Adding and Deleting records simultaneously in multiple tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Before you implement the new design, you need to convert the data in your
existing Bookings table to the new format.

Your new design should have two tables. One for the header info and a
related detail table that contains line item detail for the order.

"Bobk" <Bobk RemoveThis @discussions.microsoft.com> wrote in message
news:9F6D109C-78A1-450D-B054-6EA5856CD8B2@microsoft.com...
>I have inherited a table called "Bookings". This table cotains summary
>sales
> order data. It was loaded via a Form. I have been asked to build a
> detailed
> order entry system with an order entry form that will record all detailed
> information associated with an order. This is ok. The problem I'm haveing
> is:
> I want to be able to automatically update the existing Bookings table.
> When
> new orders are entered through the order entry form, I want them to appear
> in
> the bookings table. All new order data entered through the order entry
> form
> is held in a table called "oeheader". Orders entered into the bookings
> table
> prior to using the new order entry form do not appear in oeheader. The
> order
> entry form is driven from a query and contains the bookings table. I have
> the
> bookings table related to the oeheader table via the keys in both tables.
> When I try to add or delete a record from oeheader I am only able to
> modify
> the oeheader table. Can anyone point me in the right direction?

 >> Stay informed about: Adding and Deleting records simultaneously in multiple tab.. 
Back to top
Login to vote
Bobk

External


Since: Oct 07, 2007
Posts: 8



(Msg. 3) Posted: Mon Oct 06, 2008 8:58 am
Post subject: Re: Adding and Deleting records simultaneously in multiple tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I have set up a table called oeheader and oeline to handle the new order
entry. The only thing I am having trouble with is adding new data to the old
Bookings table. When I enter data into oeheader I want to be able to add data
to the Bookings file at the same time.

"Klatuu" wrote:

> Before you implement the new design, you need to convert the data in your
> existing Bookings table to the new format.
>
> Your new design should have two tables. One for the header info and a
> related detail table that contains line item detail for the order.
>
> "Bobk" <Bobk.RemoveThis@discussions.microsoft.com> wrote in message
> news:9F6D109C-78A1-450D-B054-6EA5856CD8B2@microsoft.com...
> >I have inherited a table called "Bookings". This table cotains summary
> >sales
> > order data. It was loaded via a Form. I have been asked to build a
> > detailed
> > order entry system with an order entry form that will record all detailed
> > information associated with an order. This is ok. The problem I'm haveing
> > is:
> > I want to be able to automatically update the existing Bookings table.
> > When
> > new orders are entered through the order entry form, I want them to appear
> > in
> > the bookings table. All new order data entered through the order entry
> > form
> > is held in a table called "oeheader". Orders entered into the bookings
> > table
> > prior to using the new order entry form do not appear in oeheader. The
> > order
> > entry form is driven from a query and contains the bookings table. I have
> > the
> > bookings table related to the oeheader table via the keys in both tables.
> > When I try to add or delete a record from oeheader I am only able to
> > modify
> > the oeheader table. Can anyone point me in the right direction?
>
>
>
 >> Stay informed about: Adding and Deleting records simultaneously in multiple tab.. 
Back to top
Login to vote
Bobk

External


Since: Oct 07, 2007
Posts: 8



(Msg. 4) Posted: Mon Oct 06, 2008 8:58 am
Post subject: Re: Adding and Deleting records simultaneously in multiple tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"Klatuu" wrote:

> Before you implement the new design, you need to convert the data in your
> existing Bookings table to the new format.
>
> Your new design should have two tables. One for the header info and a
> related detail table that contains line item detail for the order.
>
> "Bobk" <Bobk.DeleteThis@discussions.microsoft.com> wrote in message
> news:9F6D109C-78A1-450D-B054-6EA5856CD8B2@microsoft.com...
> >I have inherited a table called "Bookings". This table cotains summary
> >sales
> > order data. It was loaded via a Form. I have been asked to build a
> > detailed
> > order entry system with an order entry form that will record all detailed
> > information associated with an order. This is ok. The problem I'm haveing
> > is:
> > I want to be able to automatically update the existing Bookings table.
> > When
> > new orders are entered through the order entry form, I want them to appear
> > in
> > the bookings table. All new order data entered through the order entry
> > form
> > is held in a table called "oeheader". Orders entered into the bookings
> > table
> > prior to using the new order entry form do not appear in oeheader. The
> > order
> > entry form is driven from a query and contains the bookings table. I have
> > the
> > bookings table related to the oeheader table via the keys in both tables.
> > When I try to add or delete a record from oeheader I am only able to
> > modify
> > the oeheader table. Can anyone point me in the right direction?
>
>
>
 >> Stay informed about: Adding and Deleting records simultaneously in multiple tab.. 
Back to top
Login to vote
Bobk

External


Since: Oct 07, 2007
Posts: 8



(Msg. 5) Posted: Mon Oct 06, 2008 9:00 am
Post subject: Re: Adding and Deleting records simultaneously in multiple tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I don't think I have explained my problem very well. What I have is an
existing Bookings table with several hundred records. The records contain
data that you would typically find in an Order Header table like customer
name, PO number and amount and due date. I have created a real order entry
system which will contain all the same data fields that are now existing in
the Bookings table. All I want to do is add more records to the old Bookings
table when I enter a new order from the new order entry system. The new order
entry system will have data entered in a table called oeheader. The oeheader
table will only contain newly entered data. What I want to do is be able to
add, delete, update and edit the new entries in the Bookings table through
the new order entry system and have this happen automatically when new orders
are entered or changed.


"Bobk" wrote:

>
>
> "Klatuu" wrote:
>
> > Before you implement the new design, you need to convert the data in your
> > existing Bookings table to the new format.
> >
> > Your new design should have two tables. One for the header info and a
> > related detail table that contains line item detail for the order.
> >
> > "Bobk" <Bobk.DeleteThis@discussions.microsoft.com> wrote in message
> > news:9F6D109C-78A1-450D-B054-6EA5856CD8B2@microsoft.com...
> > >I have inherited a table called "Bookings". This table cotains summary
> > >sales
> > > order data. It was loaded via a Form. I have been asked to build a
> > > detailed
> > > order entry system with an order entry form that will record all detailed
> > > information associated with an order. This is ok. The problem I'm haveing
> > > is:
> > > I want to be able to automatically update the existing Bookings table.
> > > When
> > > new orders are entered through the order entry form, I want them to appear
> > > in
> > > the bookings table. All new order data entered through the order entry
> > > form
> > > is held in a table called "oeheader". Orders entered into the bookings
> > > table
> > > prior to using the new order entry form do not appear in oeheader. The
> > > order
> > > entry form is driven from a query and contains the bookings table. I have
> > > the
> > > bookings table related to the oeheader table via the keys in both tables.
> > > When I try to add or delete a record from oeheader I am only able to
> > > modify
> > > the oeheader table. Can anyone point me in the right direction?
> >
> >
> >
 >> Stay informed about: Adding and Deleting records simultaneously in multiple tab.. 
Back to top
Login to vote
Klatuu

External


Since: Sep 30, 2008
Posts: 163



(Msg. 6) Posted: Mon Oct 06, 2008 2:39 pm
Post subject: Re: Adding and Deleting records simultaneously in multiple tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

What would be the purpose of keeping the data in the old table if you are
replacing it with the new system?

What you are wanting to do is not that simple. It will involve some queries
to update your old bookings table. You can execute the queries from the
form where you enter data for the new header table.


"Bobk" <Bobk RemoveThis @discussions.microsoft.com> wrote in message
news:6C7D267B-FE05-4F9A-953B-FC5735B3BAB7@microsoft.com...
>I don't think I have explained my problem very well. What I have is an
> existing Bookings table with several hundred records. The records contain
> data that you would typically find in an Order Header table like customer
> name, PO number and amount and due date. I have created a real order entry
> system which will contain all the same data fields that are now existing
> in
> the Bookings table. All I want to do is add more records to the old
> Bookings
> table when I enter a new order from the new order entry system. The new
> order
> entry system will have data entered in a table called oeheader. The
> oeheader
> table will only contain newly entered data. What I want to do is be able
> to
> add, delete, update and edit the new entries in the Bookings table through
> the new order entry system and have this happen automatically when new
> orders
> are entered or changed.
>
>
> "Bobk" wrote:
>
>>
>>
>> "Klatuu" wrote:
>>
>> > Before you implement the new design, you need to convert the data in
>> > your
>> > existing Bookings table to the new format.
>> >
>> > Your new design should have two tables. One for the header info and a
>> > related detail table that contains line item detail for the order.
>> >
>> > "Bobk" <Bobk RemoveThis @discussions.microsoft.com> wrote in message
>> > news:9F6D109C-78A1-450D-B054-6EA5856CD8B2@microsoft.com...
>> > >I have inherited a table called "Bookings". This table cotains summary
>> > >sales
>> > > order data. It was loaded via a Form. I have been asked to build a
>> > > detailed
>> > > order entry system with an order entry form that will record all
>> > > detailed
>> > > information associated with an order. This is ok. The problem I'm
>> > > haveing
>> > > is:
>> > > I want to be able to automatically update the existing Bookings
>> > > table.
>> > > When
>> > > new orders are entered through the order entry form, I want them to
>> > > appear
>> > > in
>> > > the bookings table. All new order data entered through the order
>> > > entry
>> > > form
>> > > is held in a table called "oeheader". Orders entered into the
>> > > bookings
>> > > table
>> > > prior to using the new order entry form do not appear in oeheader.
>> > > The
>> > > order
>> > > entry form is driven from a query and contains the bookings table. I
>> > > have
>> > > the
>> > > bookings table related to the oeheader table via the keys in both
>> > > tables.
>> > > When I try to add or delete a record from oeheader I am only able to
>> > > modify
>> > > the oeheader table. Can anyone point me in the right direction?
>> >
>> >
>> >
 >> Stay informed about: Adding and Deleting records simultaneously in multiple tab.. 
Back to top
Login to vote
Bobk

External


Since: Oct 07, 2007
Posts: 8



(Msg. 7) Posted: Mon Oct 06, 2008 2:39 pm
Post subject: Re: Adding and Deleting records simultaneously in multiple tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I think that is what I want to do. I am trying to avoid disturbing what is
already in place. I just don't know how to do it.


"Klatuu" wrote:

> What would be the purpose of keeping the data in the old table if you are
> replacing it with the new system?
>
> What you are wanting to do is not that simple. It will involve some queries
> to update your old bookings table. You can execute the queries from the
> form where you enter data for the new header table.
>
>
> "Bobk" <Bobk RemoveThis @discussions.microsoft.com> wrote in message
> news:6C7D267B-FE05-4F9A-953B-FC5735B3BAB7@microsoft.com...
> >I don't think I have explained my problem very well. What I have is an
> > existing Bookings table with several hundred records. The records contain
> > data that you would typically find in an Order Header table like customer
> > name, PO number and amount and due date. I have created a real order entry
> > system which will contain all the same data fields that are now existing
> > in
> > the Bookings table. All I want to do is add more records to the old
> > Bookings
> > table when I enter a new order from the new order entry system. The new
> > order
> > entry system will have data entered in a table called oeheader. The
> > oeheader
> > table will only contain newly entered data. What I want to do is be able
> > to
> > add, delete, update and edit the new entries in the Bookings table through
> > the new order entry system and have this happen automatically when new
> > orders
> > are entered or changed.
> >
> >
> > "Bobk" wrote:
> >
> >>
> >>
> >> "Klatuu" wrote:
> >>
> >> > Before you implement the new design, you need to convert the data in
> >> > your
> >> > existing Bookings table to the new format.
> >> >
> >> > Your new design should have two tables. One for the header info and a
> >> > related detail table that contains line item detail for the order.
> >> >
> >> > "Bobk" <Bobk RemoveThis @discussions.microsoft.com> wrote in message
> >> > news:9F6D109C-78A1-450D-B054-6EA5856CD8B2@microsoft.com...
> >> > >I have inherited a table called "Bookings". This table cotains summary
> >> > >sales
> >> > > order data. It was loaded via a Form. I have been asked to build a
> >> > > detailed
> >> > > order entry system with an order entry form that will record all
> >> > > detailed
> >> > > information associated with an order. This is ok. The problem I'm
> >> > > haveing
> >> > > is:
> >> > > I want to be able to automatically update the existing Bookings
> >> > > table.
> >> > > When
> >> > > new orders are entered through the order entry form, I want them to
> >> > > appear
> >> > > in
> >> > > the bookings table. All new order data entered through the order
> >> > > entry
> >> > > form
> >> > > is held in a table called "oeheader". Orders entered into the
> >> > > bookings
> >> > > table
> >> > > prior to using the new order entry form do not appear in oeheader.
> >> > > The
> >> > > order
> >> > > entry form is driven from a query and contains the bookings table. I
> >> > > have
> >> > > the
> >> > > bookings table related to the oeheader table via the keys in both
> >> > > tables.
> >> > > When I try to add or delete a record from oeheader I am only able to
> >> > > modify
> >> > > the oeheader table. Can anyone point me in the right direction?
> >> >
> >> >
> >> >
>
>
>
 >> Stay informed about: Adding and Deleting records simultaneously in multiple tab.. 
Back to top
Login to vote
Klatuu

External


Since: Sep 30, 2008
Posts: 163



(Msg. 8) Posted: Wed Oct 08, 2008 8:56 am
Post subject: Re: Adding and Deleting records simultaneously in multiple tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I would suggest replacing the old way of doing it rather than complicate the
application trying to keep two versions of the same thing. That will, of
course, require some remediation to other parts of the application, but in
the long run, it would be better. If that is too daunting a task, there is
one other possibility. That would be to not update the old table as you are
entering data in the new tables, but create queries to update the old table
with the data in the new tables and only do the update when you need to use
the data in the old format.


"Bobk" <Bobk DeleteThis @discussions.microsoft.com> wrote in message
news:8D2EE4CC-5C2F-45F4-BD46-6FB907A4FDB4@microsoft.com...
>I think that is what I want to do. I am trying to avoid disturbing what is
> already in place. I just don't know how to do it.
>
>
> "Klatuu" wrote:
>
>> What would be the purpose of keeping the data in the old table if you are
>> replacing it with the new system?
>>
>> What you are wanting to do is not that simple. It will involve some
>> queries
>> to update your old bookings table. You can execute the queries from the
>> form where you enter data for the new header table.
>>
>>
>> "Bobk" <Bobk DeleteThis @discussions.microsoft.com> wrote in message
>> news:6C7D267B-FE05-4F9A-953B-FC5735B3BAB7@microsoft.com...
>> >I don't think I have explained my problem very well. What I have is an
>> > existing Bookings table with several hundred records. The records
>> > contain
>> > data that you would typically find in an Order Header table like
>> > customer
>> > name, PO number and amount and due date. I have created a real order
>> > entry
>> > system which will contain all the same data fields that are now
>> > existing
>> > in
>> > the Bookings table. All I want to do is add more records to the old
>> > Bookings
>> > table when I enter a new order from the new order entry system. The new
>> > order
>> > entry system will have data entered in a table called oeheader. The
>> > oeheader
>> > table will only contain newly entered data. What I want to do is be
>> > able
>> > to
>> > add, delete, update and edit the new entries in the Bookings table
>> > through
>> > the new order entry system and have this happen automatically when new
>> > orders
>> > are entered or changed.
>> >
>> >
>> > "Bobk" wrote:
>> >
>> >>
>> >>
>> >> "Klatuu" wrote:
>> >>
>> >> > Before you implement the new design, you need to convert the data
>> >> > in
>> >> > your
>> >> > existing Bookings table to the new format.
>> >> >
>> >> > Your new design should have two tables. One for the header info and
>> >> > a
>> >> > related detail table that contains line item detail for the order.
>> >> >
>> >> > "Bobk" <Bobk DeleteThis @discussions.microsoft.com> wrote in message
>> >> > news:9F6D109C-78A1-450D-B054-6EA5856CD8B2@microsoft.com...
>> >> > >I have inherited a table called "Bookings". This table cotains
>> >> > >summary
>> >> > >sales
>> >> > > order data. It was loaded via a Form. I have been asked to build a
>> >> > > detailed
>> >> > > order entry system with an order entry form that will record all
>> >> > > detailed
>> >> > > information associated with an order. This is ok. The problem I'm
>> >> > > haveing
>> >> > > is:
>> >> > > I want to be able to automatically update the existing Bookings
>> >> > > table.
>> >> > > When
>> >> > > new orders are entered through the order entry form, I want them
>> >> > > to
>> >> > > appear
>> >> > > in
>> >> > > the bookings table. All new order data entered through the order
>> >> > > entry
>> >> > > form
>> >> > > is held in a table called "oeheader". Orders entered into the
>> >> > > bookings
>> >> > > table
>> >> > > prior to using the new order entry form do not appear in oeheader.
>> >> > > The
>> >> > > order
>> >> > > entry form is driven from a query and contains the bookings table.
>> >> > > I
>> >> > > have
>> >> > > the
>> >> > > bookings table related to the oeheader table via the keys in both
>> >> > > tables.
>> >> > > When I try to add or delete a record from oeheader I am only able
>> >> > > to
>> >> > > modify
>> >> > > the oeheader table. Can anyone point me in the right direction?
>> >> >
>> >> >
>> >> >
>>
>>
>>
 >> Stay informed about: Adding and Deleting records simultaneously in multiple tab.. 
Back to top
Login to vote
Bobk

External


Since: Oct 07, 2007
Posts: 8



(Msg. 9) Posted: Thu Oct 09, 2008 6:42 am
Post subject: Re: Adding and Deleting records simultaneously in multiple tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Yes, I think an update query might be the quickest way to get this done. For
a large table it might be a little slow. At least I wouldn't have to rewrite
a lot off stuff. I just didn't want to have to get into the existing stuff
that works ok now. Thanks for the help.

"Klatuu" wrote:

> I would suggest replacing the old way of doing it rather than complicate the
> application trying to keep two versions of the same thing. That will, of
> course, require some remediation to other parts of the application, but in
> the long run, it would be better. If that is too daunting a task, there is
> one other possibility. That would be to not update the old table as you are
> entering data in the new tables, but create queries to update the old table
> with the data in the new tables and only do the update when you need to use
> the data in the old format.
>
>
> "Bobk" <Bobk.RemoveThis@discussions.microsoft.com> wrote in message
> news:8D2EE4CC-5C2F-45F4-BD46-6FB907A4FDB4@microsoft.com...
> >I think that is what I want to do. I am trying to avoid disturbing what is
> > already in place. I just don't know how to do it.
> >
> >
> > "Klatuu" wrote:
> >
> >> What would be the purpose of keeping the data in the old table if you are
> >> replacing it with the new system?
> >>
> >> What you are wanting to do is not that simple. It will involve some
> >> queries
> >> to update your old bookings table. You can execute the queries from the
> >> form where you enter data for the new header table.
> >>
> >>
> >> "Bobk" <Bobk.RemoveThis@discussions.microsoft.com> wrote in message
> >> news:6C7D267B-FE05-4F9A-953B-FC5735B3BAB7@microsoft.com...
> >> >I don't think I have explained my problem very well. What I have is an
> >> > existing Bookings table with several hundred records. The records
> >> > contain
> >> > data that you would typically find in an Order Header table like
> >> > customer
> >> > name, PO number and amount and due date. I have created a real order
> >> > entry
> >> > system which will contain all the same data fields that are now
> >> > existing
> >> > in
> >> > the Bookings table. All I want to do is add more records to the old
> >> > Bookings
> >> > table when I enter a new order from the new order entry system. The new
> >> > order
> >> > entry system will have data entered in a table called oeheader. The
> >> > oeheader
> >> > table will only contain newly entered data. What I want to do is be
> >> > able
> >> > to
> >> > add, delete, update and edit the new entries in the Bookings table
> >> > through
> >> > the new order entry system and have this happen automatically when new
> >> > orders
> >> > are entered or changed.
> >> >
> >> >
> >> > "Bobk" wrote:
> >> >
> >> >>
> >> >>
> >> >> "Klatuu" wrote:
> >> >>
> >> >> > Before you implement the new design, you need to convert the data
> >> >> > in
> >> >> > your
> >> >> > existing Bookings table to the new format.
> >> >> >
> >> >> > Your new design should have two tables. One for the header info and
> >> >> > a
> >> >> > related detail table that contains line item detail for the order.
> >> >> >
> >> >> > "Bobk" <Bobk.RemoveThis@discussions.microsoft.com> wrote in message
> >> >> > news:9F6D109C-78A1-450D-B054-6EA5856CD8B2@microsoft.com...
> >> >> > >I have inherited a table called "Bookings". This table cotains
> >> >> > >summary
> >> >> > >sales
> >> >> > > order data. It was loaded via a Form. I have been asked to build a
> >> >> > > detailed
> >> >> > > order entry system with an order entry form that will record all
> >> >> > > detailed
> >> >> > > information associated with an order. This is ok. The problem I'm
> >> >> > > haveing
> >> >> > > is:
> >> >> > > I want to be able to automatically update the existing Bookings
> >> >> > > table.
> >> >> > > When
> >> >> > > new orders are entered through the order entry form, I want them
> >> >> > > to
> >> >> > > appear
> >> >> > > in
> >> >> > > the bookings table. All new order data entered through the order
> >> >> > > entry
> >> >> > > form
> >> >> > > is held in a table called "oeheader". Orders entered into the
> >> >> > > bookings
> >> >> > > table
> >> >> > > prior to using the new order entry form do not appear in oeheader.
> >> >> > > The
> >> >> > > order
> >> >> > > entry form is driven from a query and contains the bookings table.
> >> >> > > I
> >> >> > > have
> >> >> > > the
> >> >> > > bookings table related to the oeheader table via the keys in both
> >> >> > > tables.
> >> >> > > When I try to add or delete a record from oeheader I am only able
> >> >> > > to
> >> >> > > modify
> >> >> > > the oeheader table. Can anyone point me in the right direction?
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
> >>
>
>
>
 >> Stay informed about: Adding and Deleting records simultaneously in multiple tab.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Adding Records to multiple tables - I am working on a database with the primary function of tracking attendance for many people to many events. The database is set up so that there is a table of personnel and a table of events where each user's name and each event appear once..

Deleting Duplicate Records in a Table - Hi, I need to be able to delete duplicate records in a table. The problem is that i would need to run this constantly. I know about the procedure of creating a new table with the duplicate records table and then using Append query. The problem wit...

Deleting duplicate parents and grouping children to single.. - So here is my question. I'm building a rather simple db consisting of a parent child and child table in a one-to-many relationship (based on the Parent's ID and the Child's "ParentID" field). For the intended workflow,data will be regularly ...

Adding Automuber Field with code - Hello there I have table. Is there a way to add auto number field to table with vb code?

Contact Management Template help - adding to existing form - Folks, I'm trying to use the Access 2003 Contact Management template downloaded from Microsoft Office's web site to create a customer management database. It has most of the items I need, but I do need to add a few small things, and I'm having..
   Database Help (Home) -> MS Access -> Tables DB Design All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]