Combine two Form textbox fields prior to writing the record 
Author Message
 Combine two Form textbox fields prior to writing the record

That can be done, but shouldn't be. First of all using a natural key that
can be duplicated needs to be avoided. What happens when there are 2 (or
more) Bob Joneses? Second, you can create a compound index on the 2, but
will still have the first problem if you try to make it a unique index.
Third, the first rule of relational databases is not to use multiple values
in a field (1NF or First Normal Form). Relational database design is
dependent on Relational Set Theory from calculus. To work properly, it is
highly recommended that you follow the rules.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.*-*-*.com/
http://www.*-*-*.com/


Quote:
> As a user enters a persons frmCustomer.FirstName and frmCustomer.LastName
I
> want to combine them together so that when the record is written to the
> database a third field is created for the record.  The third field is
called
> tblCustomer.CusKey
> The result I want should be:

> tblCustomer.CusKey    tblCustomer.LastName   tblCustomer.FirstName
> JonesBob                   Jones                            Bob



Wed, 25 Jul 2007 21:58:42 GMT  
 Combine two Form textbox fields prior to writing the record
Arvin,

Thanks for the reply.  I agree with the approach that you suggest, I tried
to make the example simple enough to explain.  My problem is the programming,
I am simply stuck.  I don't know how to do it.  Can you help?

Thanks

Quote:

> That can be done, but shouldn't be. First of all using a natural key that
> can be duplicated needs to be avoided. What happens when there are 2 (or
> more) Bob Joneses? Second, you can create a compound index on the 2, but
> will still have the first problem if you try to make it a unique index.
> Third, the first rule of relational databases is not to use multiple values
> in a field (1NF or First Normal Form). Relational database design is
> dependent on Relational Set Theory from calculus. To work properly, it is
> highly recommended that you follow the rules.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads:
> http://www.datastrat.com
> http://www.mvps.org/access



> > As a user enters a persons frmCustomer.FirstName and frmCustomer.LastName
> I
> > want to combine them together so that when the record is written to the
> > database a third field is created for the record.  The third field is
> called
> > tblCustomer.CusKey
> > The result I want should be:

> > tblCustomer.CusKey    tblCustomer.LastName   tblCustomer.FirstName
> > JonesBob                   Jones                            Bob



Thu, 26 Jul 2007 01:31:02 GMT  
 Combine two Form textbox fields prior to writing the record
To create a compound index, open the indexes dialog (In a table's design
view, click on View ... Indexes), type in a name for the index in the first
column, then add the fields to the middle column. You can have as many as 10
fields in an index.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access


Quote:
> Arvin,

> Thanks for the reply.  I agree with the approach that you suggest, I tried
> to make the example simple enough to explain.  My problem is the
programming,
> I am simply stuck.  I don't know how to do it.  Can you help?

> Thanks


> > That can be done, but shouldn't be. First of all using a natural key
that
> > can be duplicated needs to be avoided. What happens when there are 2 (or
> > more) Bob Joneses? Second, you can create a compound index on the 2, but
> > will still have the first problem if you try to make it a unique index.
> > Third, the first rule of relational databases is not to use multiple
values
> > in a field (1NF or First Normal Form). Relational database design is
> > dependent on Relational Set Theory from calculus. To work properly, it
is
> > highly recommended that you follow the rules.
> > --
> > Arvin Meyer, MCP, MVP
> > Microsoft Access
> > Free Access downloads:
> > http://www.datastrat.com
> > http://www.mvps.org/access



> > > As a user enters a persons frmCustomer.FirstName and

frmCustomer.LastName

- Show quoted text -

Quote:
> > I
> > > want to combine them together so that when the record is written to
the
> > > database a third field is created for the record.  The third field is
> > called
> > > tblCustomer.CusKey
> > > The result I want should be:

> > > tblCustomer.CusKey    tblCustomer.LastName   tblCustomer.FirstName
> > > JonesBob                   Jones                            Bob



Fri, 27 Jul 2007 03:51:55 GMT  
 Combine two Form textbox fields prior to writing the record
Thanks Arvin,

I will give that a try.  Thnaks for the help.

Quote:

> To create a compound index, open the indexes dialog (In a table's design
> view, click on View ... Indexes), type in a name for the index in the first
> column, then add the fields to the middle column. You can have as many as 10
> fields in an index.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads:
> http://www.datastrat.com
> http://www.mvps.org/access



> > Arvin,

> > Thanks for the reply.  I agree with the approach that you suggest, I tried
> > to make the example simple enough to explain.  My problem is the
> programming,
> > I am simply stuck.  I don't know how to do it.  Can you help?

> > Thanks


> > > That can be done, but shouldn't be. First of all using a natural key
> that
> > > can be duplicated needs to be avoided. What happens when there are 2 (or
> > > more) Bob Joneses? Second, you can create a compound index on the 2, but
> > > will still have the first problem if you try to make it a unique index.
> > > Third, the first rule of relational databases is not to use multiple
> values
> > > in a field (1NF or First Normal Form). Relational database design is
> > > dependent on Relational Set Theory from calculus. To work properly, it
> is
> > > highly recommended that you follow the rules.
> > > --
> > > Arvin Meyer, MCP, MVP
> > > Microsoft Access
> > > Free Access downloads:
> > > http://www.datastrat.com
> > > http://www.mvps.org/access



> > > > As a user enters a persons frmCustomer.FirstName and
> frmCustomer.LastName
> > > I
> > > > want to combine them together so that when the record is written to
> the
> > > > database a third field is created for the record.  The third field is
> > > called
> > > > tblCustomer.CusKey
> > > > The result I want should be:

> > > > tblCustomer.CusKey    tblCustomer.LastName   tblCustomer.FirstName
> > > > JonesBob                   Jones                            Bob



Fri, 27 Jul 2007 22:25:02 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Combining Two Textbox Values into a Third Textbox

2. combining two records' output into one field

3. writing VBA textbox value into an MS Word Form Field

4. Setting field value for following record with data from prior record

5. Pluck Value from Prior Record Place in New Record in DIFFERENT Field

6. Compare field to a Field in a Prior Record using VBA

7. Write data into a table based on two fields in form

8. combining two formfield and writing it to a table

9. combining text from two textboxes

10. Combining two fields into one field


 
Powered by phpBB® Forum Software © phpBB Group