help with form/table automatic entry

Thread View: comp.databases.ms-access

5 messages

[T] Back to Threads [V] Tree View [G] Group Articles

5 total messages Started by TIMOTHY W. NEWTON Tue, 08 Jul 1997 00:00

#457

Author: TIMOTHY W. NEWTON
Date: Tue, 08 Jul 1997 00:00

7 lines
1257 bytes

I have a table that use a long entry. The first part of the entry is alway
"R" followed by eleven numbers (changes each entry) then "UNOFSAND"
followed by seven more numbers. How can I make it so the "R" and "UNOFSAND"
are alway there and all have to do is type the other numbers in on the form
and it saves it to the table. Pls help. Pls email answers to
enforcer@pacbell.net.  Thanks.....

Re: help with form/table automatic entry

#458

Author: Ron Myer
Date: Tue, 08 Jul 1997 00:00

16 lines
1455 bytes

TIMOTHY W. NEWTON wrote:
> 
> I have a table that use a long entry. The first part of the entry is alway
> "R" followed by eleven numbers (changes each entry) then "UNOFSAND"
> followed by seven more numbers. How can I make it so the "R" and "UNOFSAND"
> are alway there and all have to do is type the other numbers in on the form
> and it saves it to the table. Pls help. Pls email answers to
> enforcer@pacbell.net.  Thanks.....

Hi,

Use an Input Mask to do this task!

hth,
Ron Myer

Re: help with form/table automatic entry

#464

Author: Robert Bote
Date: Wed, 09 Jul 1997 00:00

28 lines
1791 bytes

How about when the entry is made up of text from other controls on the
same form.  I am having trouble piecing the text together when I am at a
new record...

txtFullText = [cboPart1] & "_" & [txtPart2] & "text" & [txtPart3] &
".txt"

Ron Myer wrote:

> TIMOTHY W. NEWTON wrote:
> >
> > I have a table that use a long entry. The first part of the entry is
> alway
> > "R" followed by eleven numbers (changes each entry) then "UNOFSAND"
> > followed by seven more numbers. How can I make it so the "R" and
> "UNOFSAND"
> > are alway there and all have to do is type the other numbers in on
> the form
> > and it saves it to the table. Pls help. Pls email answers to
> > enforcer@pacbell.net.  Thanks.....
>
> Hi,
>
> Use an Input Mask to do this task!
>
> hth,
> Ron Myer

Re: help with form/table automatic entry

#467

Author: JLindsay
Date: Thu, 10 Jul 1997 00:00

43 lines
2208 bytes

Robert:
The input mask does not need to be created on the form design 
property sheet. You can do it in code as part of an event 
procedure for the control that defines it. Assume that you are 
getting some information that defines the input mask in txtONE, and 
you want to set the input mask in txtTWO.

In the LostFocus event of txtOne, set the property txtTWO.Inputmask 
to the correct construction.
 HTH
JLindsay

Robert Bote wrote:
> 

> How about when the entry is made up of text from other controls on the
> same form.  I am having trouble piecing the text together when I am at a
> new record...
> 
> txtFullText = [cboPart1] & "_" & [txtPart2] & "text" & [txtPart3] &
> ".txt"
> 
> Ron Myer wrote:
> 
> > TIMOTHY W. NEWTON wrote:
> > >
> > > I have a table that use a long entry. The first part of the entry is
> > alway
> > > "R" followed by eleven numbers (changes each entry) then "UNOFSAND"
> > > followed by seven more numbers. How can I make it so the "R" and
> > "UNOFSAND"
> > > are alway there and all have to do is type the other numbers in on
> > the form
> > > and it saves it to the table. Pls help. Pls email answers to
> > > enforcer@pacbell.net.  Thanks.....
> >
> > Hi,
> >
> > Use an Input Mask to do this task!
> >
> > hth,
> > Ron Myer

Re: help with form/table automatic entry

#468

Author: Darla Neargarth
Date: Thu, 10 Jul 1997 00:00

17 lines
1544 bytes

Hi. You want to use a mask on the control. Go to the properties sheet
and use the build button for the mask property to invoke the mask
wizard. It will walk you through it. 

hth,
Darla


TIMOTHY W. NEWTON wrote:
> 
> I have a table that use a long entry. The first part of the entry is alway
> "R" followed by eleven numbers (changes each entry) then "UNOFSAND"
> followed by seven more numbers. How can I make it so the "R" and "UNOFSAND"
> are alway there and all have to do is type the other numbers in on the form
> and it saves it to the table. Pls help. Pls email answers to
> enforcer@pacbell.net.  Thanks.....

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads