Prev: Multiple selection filter - any help appreciated
Next: Link Dbase Tables as read only in Access Database
From: Leza S. on 27 May 2010 20:05
I am a new at this....

I have 10 names and addresses in a table with other "stuff". Each name has
a User ID #. I want to enter the User ID# in one form and have another form
come up that displays all the other fields in that record. I don't want to
add or edit; I just want the new form to come up with that record's
information.

I am not a programmer, don't understand Dlookup, but have figured out how to
add the "button" macros. Help!!
--
Leza
New and Confused User
From: Tom van Stiphout on 27 May 2010 23:24
On Thu, 27 May 2010 17:05:03 -0700, Leza S.
<LezaS(a)discussions.microsoft.com> wrote:

The Button Wizard can do this.

-Tom.
Microsoft Access MVP


>I am a new at this....
>
>I have 10 names and addresses in a table with other "stuff". Each name has
>a User ID #. I want to enter the User ID# in one form and have another form
>come up that displays all the other fields in that record. I don't want to
>add or edit; I just want the new form to come up with that record's
>information.
>
>I am not a programmer, don't understand Dlookup, but have figured out how to
>add the "button" macros. Help!!
From: Leza S. on 2 Jun 2010 19:52
I tried the button wizard--several times. Can you give me a little more?
Everything I have tried results in opening the same record--the first one.
It doesn't pull up the record I want.
--
Leza
New and Confused User


"Tom van Stiphout" wrote:

> On Thu, 27 May 2010 17:05:03 -0700, Leza S.
> <LezaS(a)discussions.microsoft.com> wrote:
>
> The Button Wizard can do this.
>
> -Tom.
> Microsoft Access MVP
>
>
> >I am a new at this....
> >
> >I have 10 names and addresses in a table with other "stuff". Each name has
> >a User ID #. I want to enter the User ID# in one form and have another form
> >come up that displays all the other fields in that record. I don't want to
> >add or edit; I just want the new form to come up with that record's
> >information.
> >
> >I am not a programmer, don't understand Dlookup, but have figured out how to
> >add the "button" macros. Help!!
> .
>
From: Jörn Bosse on 2 Jun 2010 20:25
Hi,

create a button with this code:

DoCmd.OpenForm "FormName", acNormal, , "ID = " & Me.YourTXTfield,
acFormReadOnly

instead of Formname you have du write the name of your Form. And instead
of YourTXTfield you have to use the name of your textfield.
If the column of your table is called ID, it´ll work that way. If not,
you have to change ID to the name of your tables primkey-column.

regards
Jörn


Am 28.05.2010 02:05, schrieb Leza S.:
> I am a new at this....
>
> I have 10 names and addresses in a table with other "stuff". Each name has
> a User ID #. I want to enter the User ID# in one form and have another form
> come up that displays all the other fields in that record. I don't want to
> add or edit; I just want the new form to come up with that record's
> information.
>
> I am not a programmer, don't understand Dlookup, but have figured out how to
> add the "button" macros. Help!!


From: kazuo kawaguchi on 3 Jun 2010 04:55


"Leza S." <LezaS(a)discussions.microsoft.com> wrote in message
news:582AED5C-5937-44F6-B5D3-2C17822E8D01(a)microsoft.com...
> I tried the button wizard--several times. Can you give me a little more?
> Everything I have tried results in opening the same record--the first one.
> It doesn't pull up the record I want.
> --
> Leza
> New and Confused User
>
>
> "Tom van Stiphout" wrote:
>
>> On Thu, 27 May 2010 17:05:03 -0700, Leza S.
>> <LezaS(a)discussions.microsoft.com> wrote:
>>
>> The Button Wizard can do this.
>>
>> -Tom.
>> Microsoft Access MVP
>>
>>
>> >I am a new at this....
>> >
>> >I have 10 names and addresses in a table with other "stuff". Each name
>> >has
>> >a User ID #. I want to enter the User ID# in one form and have another
>> >form
>> >come up that displays all the other fields in that record. I don't want
>> >to
>> >add or edit; I just want the new form to come up with that record's
>> >information.
>> >
>> >I am not a programmer, don't understand Dlookup, but have figured out
>> >how to
>> >add the "button" macros. Help!!
>> .
>>
 |  Next  |  Last
Pages: 1 2
Prev: Multiple selection filter - any help appreciated
Next: Link Dbase Tables as read only in Access Database