Prev: Multiple selection filter - any help appreciated
Next: Link Dbase Tables as read only in Access Database
From: Leza S. on 3 Jun 2010 15:57
Thanks, Jorn, I tried this and although it worked, it pops up a parameter
search dialog box, which I do not want. I want to be able to type the ID
number into the form I made, click on a "button" and have it go directly to
another form displaying the contents of that record only.
--
Leza
New and Confused User


"Jörn Bosse" wrote:

> 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: Jörn Bosse on 3 Jun 2010 16:26
Am 03.06.2010 21:57, schrieb Leza S.:
> Thanks, Jorn, I tried this and although it worked, it pops up a parameter
> search dialog box, which I do not want. I want to be able to type the ID
> number into the form I made, click on a "button" and have it go directly to
> another form displaying the contents of that record only.

Hey,

whats the name of your textbox in which you want to inser the code?
Do you have a query with parameters as recordsource for your new form?
Whats the name of your ID-column?


Jörn


From: Leza S. on 3 Jun 2010 19:26
In response to your questions:

1. Regarding name of textbox, I don't have a textbox. I was using a field
pulled
from the table.
2. No query set with parameters for new form
3. The name of my ID-column is AlienID (set to key field)

The name of form I want to open first: InitialVerify

Hope this helps you help me :). This is for a new job I have. Thanks for
being so helpful.

Leza
--
Leza
New and Confused User


"Jörn Bosse" wrote:

> Am 03.06.2010 21:57, schrieb Leza S.:
> > Thanks, Jorn, I tried this and although it worked, it pops up a parameter
> > search dialog box, which I do not want. I want to be able to type the ID
> > number into the form I made, click on a "button" and have it go directly to
> > another form displaying the contents of that record only.
>
> Hey,
>
> whats the name of your textbox in which you want to inser the code?
> Do you have a query with parameters as recordsource for your new form?
> Whats the name of your ID-column?
>
>
> Jörn
>
>
> .
>
From: Jörn Bosse on 4 Jun 2010 03:28
Am 04.06.2010 01:26, schrieb Leza S.:
> In response to your questions:
>
> 1. Regarding name of textbox, I don't have a textbox. I was using a field
> pulled
> from the table.
> 2. No query set with parameters for new form
> 3. The name of my ID-column is AlienID (set to key field)
>
> The name of form I want to open first: InitialVerify
>
> Hope this helps you help me :). This is for a new job I have. Thanks for
> being so helpful.
>
> Leza

Hey,

the field, where you enter your number has a name. you can see that name
in the properties of this fiel if you open your form in the design-mode.
If think that your id is an integer, thats what it should be as primkey.

DoCmd.OpenForm "InitialVerify", acNormal, , "AlienID = " &
Me.YourTXTfield, acFormReadOnly

check the name of the field, you enter your values and change
YourTXTfield to that name.

If your AlienID is a string you have to type it like this:

DoCmd.OpenForm "InitialVerify", acNormal, , "AlienID = '" &
Me.YourTXTfield & "'" , acFormReadOnly

An integer value has only numbers and a string can include numbers,
letters etc.

integer: 123
string: "Hello%123"

Regards
Jörn

First  |  Prev  | 
Pages: 1 2
Prev: Multiple selection filter - any help appreciated
Next: Link Dbase Tables as read only in Access Database