Article View: comp.databases.ms-access
Article #467Re: help with form/table automatic entry
From: JLindsay
Date: Thu, 10 Jul 1997 00:00
Date: Thu, 10 Jul 1997 00:00
43 lines
2208 bytes
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
Technical Details
Message-ID:
<33C4D865.401A@notme.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<01bc8bc9$b2c566e0$1575aace@adp547> <33C2C958.3DF9@ix.netcom.com> <33C41B2A.F3344650@earthlink.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 101bdd,636d2ef524c2aa6f X-Google-Attributes: gid101bdd,public X-Google-Thread: 111a5a,636d2ef524c2aa6f X-Google-Attributes: gid111a5a,public X-Google-Thread: 1041a7,636d2ef524c2aa6f X-Google-Attributes: gid1041a7,public X-Google-Thread: ff0ac,636d2ef524c2aa6f X-Google-Attributes: gidff0ac,public X-Google-Thread: ffa7b,636d2ef524c2aa6f X-Google-Attributes: gidffa7b,public From: JLindsay <Jim@notme.net> Subject: Re: help with form/table automatic entry Date: 1997/07/10 Message-ID: <33C4D865.401A@notme.net> X-Deja-AN: 255948110 References: <01bc8bc9$b2c566e0$1575aace@adp547> <33C2C958.3DF9@ix.netcom.com> <33C41B2A.F3344650@earthlink.net> Organization: ADG Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access,microsoft.public.access.forms,microsoft.public.access.tablesdbdesign,microsoft.public.msaccess.chat