How do I use the Command Button to look for records in form???

[Guest]

Hello there. I hope someone can help me with this issue:

I have a table named PriceList with the following fields that contain data
as following:

AssemblyPartN "for example 1111-123456"
UnitPrice "for example $15"
CustomerName "for example IBM"
Assembler "for example Kevin"

I want to create a form that will search for the UnitPrice, CustomerName,
and Assembler by using the Command Button and pop up the record in the form
view.

This I what I'd like to do:

When I open access, I will go to FORMS OBJECTS and double click on PriceCheck

After PriceCheck is opened, it will ask me the following:

Please enter your Assembly Part Number: then I'll enter 1111-123456 and
click or enter on "COMMAND BUTTON"

If I click or enter on the Command Button, it will display a form that says
$15 for the price, IBM as customer name and Kevin is the assembler.

Please help me with this issue. It's a long message, but I hope you experts
would understand what I mean.

Thankz

 

[Guest]

First not an expert but just saw the question

Create a query with all of your fields in

Create a form (called "general" in design view with a text box on it where
you would enter 1111-11233. (lets say text0)

within your query under part place
Like [Forms]![general]![Text0]

now create a macro that opensquery - and select the query from the list

back on your general form insert a command button that runs a macro (under
the wizard its misc) and choose the part no macro you created

This would open it in query view which I find more usefull as it will show
multiple results in a datasheet view, I used a form view once and found I
missed results due not looking at the record selectors

You could use the macro to then further run a form based on the query and
close the original query


Good luck

 

[Guest]

I just created a query called PriceList query.

What do you mean by created a form general with a text box called text0????
I understand the Form Called General but what about text0???

First not an expert but just saw the question

Create a query with all of your fields in

Create a form (called "general" in design view with a text box on it where
you would enter 1111-11233. (lets say text0)

within your query under part place
Like [Forms]![general]![Text0]

now create a macro that opensquery - and select the query from the list

back on your general form insert a command button that runs a macro (under
the wizard its misc) and choose the part no macro you created

This would open it in query view which I find more usefull as it will show
multiple results in a datasheet view, I used a form view once and found I
missed results due not looking at the record selectors

You could use the macro to then further run a form based on the query and
close the original query


Good luck

Hello there. I hope someone can help me with this issue:

I have a table named PriceList with the following fields that contain data
as following:

AssemblyPartN "for example 1111-123456"
UnitPrice "for example $15"
CustomerName "for example IBM"
Assembler "for example Kevin"

I want to create a form that will search for the UnitPrice, CustomerName,
and Assembler by using the Command Button and pop up the record in the form
view.

This I what I'd like to do:

When I open access, I will go to FORMS OBJECTS and double click on PriceCheck

After PriceCheck is opened, it will ask me the following:

Please enter your Assembly Part Number: then I'll enter 1111-123456 and
click or enter on "COMMAND BUTTON"

If I click or enter on the Command Button, it will display a form that says
$15 for the price, IBM as customer name and Kevin is the assembler.

Please help me with this issue. It's a long message, but I hope you experts
would understand what I mean.

Thankz