Re: Appending values from a form into a new record in an existing
- From: "Jeff Boyce" <nonsense@xxxxxxxxxxxx>
- Date: Fri, 13 Jun 2008 09:59:41 -0700
If your form allows a way to enter a misspelled name, you may want to
revisit your basic database design. Having to put the correct name in
repeatedly means you are probably using a spreadsheet, not a relational
database!
Please post a description of the table structure (table names, field names,
type of data in fields) you are using.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"jerryb123" <jerryb123@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D12880F6-B4A6-4E9E-8C34-3F1F088ACE07@xxxxxxxxxxxxxxxx
The form is not bound to the underlying table because I don't want the
users
putting junk into the underlying table. For the Sales Rep, Agent and
Subagent, there are existing relationships, and I don't want them to be
able
to put in the wrong Agent for a particular Subagent, or the wrong Sales
Rep
for a particular Agent. And I don't want them misspelling the names.
Having said that, I'm just getting back into this whole database thing
after
a lengthy hiatus, so I don't always know the best way to do things!
"Jeff Boyce" wrote:
Are you saying that the form is NOT bound to the underlying table? If
so,
why not?
Regards
Jeff Boyce
Microsoft Office/Access MVP
"jerryb123" <jerryb123@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:52E8E16D-00F0-4CAD-8CED-EC84976A071F@xxxxxxxxxxxxxxxx
How do I append data from a form into a new record in an existing
table?
I have a form that I want to use to generate the following fields:
Sales
Rep, Agent, Subagent, Revenue, Commission and Transaction Number. I
have
combo boxes so that the user can select the Sales Rep, Agent and
Subagent
based on values in a reference table, and I have text boxes for the
user
to
manually input dollar amounts for Revenue, Commission and Transaction
Number.
Once the user has made selections from the combo boxes and entered
values
in
the text boxes, I want them to be able to press a button so that these
values
are appended into an existing table.
Any help is greatly appreciated!
.
- Follow-Ups:
- References:
- Re: Appending values from a form into a new record in an existing tabl
- From: Jeff Boyce
- Re: Appending values from a form into a new record in an existing
- From: jerryb123
- Re: Appending values from a form into a new record in an existing tabl
- Prev by Date: Re: Appending values from a form into a new record in an existing
- Next by Date: Re: rs.FindFirst to find last and first name
- Previous by thread: Re: Appending values from a form into a new record in an existing
- Next by thread: Re: Appending values from a form into a new record in an existing
- Index(es):
Relevant Pages
|
