Dialog box for "search"

[Guest]

Is it possible to create a dialog box that allows the user to search one of
two parameters (name or document #)? If I am using a Menu created from
design view with control buttons, do I need to call the data screen prior to
opening the dialog box?

 

[krzysztof via AccessMonster.com]

when you create a dialog box ( i am assuming you mean a combo box?) you are
assigning or manually entering the data that is supplied. When you use that
combo box as a key for searching, you need that to match up with a key in
your table/form.

a different way is to use a textbox, and that allows the user to input a
name or document number, and then searching the data, you can match the name
field or document number field.

without more information, it is hard for me to tell you the best way to go.

are you using a form to search by? is you search controlled by a query?

 

[Guest]

I would love your help. What I'm working on is a basic "form filler"
program. This particular program is using one table in Access with about 25
fields in a form for data entry. After the data is entered, (on update on
the last field) I need a print option for "all forms" or separate form
controls. At a different time/day it needs to be accessible to "call up" a
particular record to print additional forms for a different contract
transaction without having to handwrite or enter the data again.

The data will merge in Word fine. I just need to put some "bells &
whistles" to make it user friendly without having to click too many times to
get there.

I keep reading and trying different things but am totally confused right
now. Thanks for any help you can give or direction to go in.

 

[krzysztof via AccessMonster.com]

this seems to be not that bad...

on your form, you can assign buttons to to all the tasks you have listed
below, with the exception of the "call" operation, which can be done easily
as well, in a different way.

How familiar are you wil VBA code? any experience?

when you are in design view of your form, be sure to open your toolbox. this
gives you access to what we need. first we need to create a 'combo box'.
find the combo box control in the toolbox, and then place it in your form.
when you do that, a menu appears, and asks you a question, and select the
bottom option. That should be: find a record on my form based on the value i
select in my combo box. Sounds just like what you need, huh? lol select
that option, and then click 'Next'. Now you want to choose what field you
want to use for the box, like order number or id number, it should be a
primary key that would identify each record, choose that and then proceed.
Adjust the width of the box, then proceed. Give it a name, and then 'Finish'.
Save your form, and then open it in form view, and try it out!

once you do that, we can get to the other stuff!

I would love your help. What I'm working on is a basic "form filler"
program. This particular program is using one table in Access with about 25
fields in a form for data entry. After the data is entered, (on update on
the last field) I need a print option for "all forms" or separate form
controls. At a different time/day it needs to be accessible to "call up" a
particular record to print additional forms for a different contract
transaction without having to handwrite or enter the data again.

The data will merge in Word fine. I just need to put some "bells &
whistles" to make it user friendly without having to click too many times to
get there.

I keep reading and trying different things but am totally confused right
now. Thanks for any help you can give or direction to go in.

when you create a dialog box ( i am assuming you mean a combo box?) you are
assigning or manually entering the data that is supplied. When you use that

[quoted text clipped - 13 lines]

 

[Guest]

GOT IT! Is it possible to look up a name as well? Is it possible to do
these operations from a main menu?

this seems to be not that bad...

on your form, you can assign buttons to to all the tasks you have listed
below, with the exception of the "call" operation, which can be done easily
as well, in a different way.

How familiar are you wil VBA code? any experience?

when you are in design view of your form, be sure to open your toolbox. this
gives you access to what we need. first we need to create a 'combo box'.
find the combo box control in the toolbox, and then place it in your form.
when you do that, a menu appears, and asks you a question, and select the
bottom option. That should be: find a record on my form based on the value i
select in my combo box. Sounds just like what you need, huh? lol select
that option, and then click 'Next'. Now you want to choose what field you
want to use for the box, like order number or id number, it should be a
primary key that would identify each record, choose that and then proceed.
Adjust the width of the box, then proceed. Give it a name, and then 'Finish'.
Save your form, and then open it in form view, and try it out!

once you do that, we can get to the other stuff!

I would love your help. What I'm working on is a basic "form filler"
program. This particular program is using one table in Access with about 25
fields in a form for data entry. After the data is entered, (on update on
the last field) I need a print option for "all forms" or separate form
controls. At a different time/day it needs to be accessible to "call up" a
particular record to print additional forms for a different contract
transaction without having to handwrite or enter the data again.

The data will merge in Word fine. I just need to put some "bells &
whistles" to make it user friendly without having to click too many times to
get there.

I keep reading and trying different things but am totally confused right
now. Thanks for any help you can give or direction to go in.

when you create a dialog box ( i am assuming you mean a combo box?) you are
assigning or manually entering the data that is supplied. When you use that

[quoted text clipped - 13 lines]

design view with control buttons, do I need to call the data screen prior to
opening the dialog box?

 

[Guest]

I'm not that familiar with VBA but keep studying different usages for it on
the "sample" database that comes with Access. Got the combo box complete and
it works. Awesome.

this seems to be not that bad...

on your form, you can assign buttons to to all the tasks you have listed
below, with the exception of the "call" operation, which can be done easily
as well, in a different way.

How familiar are you wil VBA code? any experience?

when you are in design view of your form, be sure to open your toolbox. this
gives you access to what we need. first we need to create a 'combo box'.
find the combo box control in the toolbox, and then place it in your form.
when you do that, a menu appears, and asks you a question, and select the
bottom option. That should be: find a record on my form based on the value i
select in my combo box. Sounds just like what you need, huh? lol select
that option, and then click 'Next'. Now you want to choose what field you
want to use for the box, like order number or id number, it should be a
primary key that would identify each record, choose that and then proceed.
Adjust the width of the box, then proceed. Give it a name, and then 'Finish'.
Save your form, and then open it in form view, and try it out!

once you do that, we can get to the other stuff!

I would love your help. What I'm working on is a basic "form filler"
program. This particular program is using one table in Access with about 25
fields in a form for data entry. After the data is entered, (on update on
the last field) I need a print option for "all forms" or separate form
controls. At a different time/day it needs to be accessible to "call up" a
particular record to print additional forms for a different contract
transaction without having to handwrite or enter the data again.

The data will merge in Word fine. I just need to put some "bells &
whistles" to make it user friendly without having to click too many times to
get there.

I keep reading and trying different things but am totally confused right
now. Thanks for any help you can give or direction to go in.

when you create a dialog box ( i am assuming you mean a combo box?) you are
assigning or manually entering the data that is supplied. When you use that

[quoted text clipped - 13 lines]

design view with control buttons, do I need to call the data screen prior to
opening the dialog box?

 

[krzysztof via AccessMonster.com]

i am very glad it works for you!

it is fairly simple, no?

Yes, you can do that from a main menu, the process is the same, just apply
the combo box on your 'Main Menu', and be sure to select the appropriate form
that displays the data.

Access is said to have many limitations, but it is still a microsoft product,
and it carries about 80% of what VB or any other method does. I have been
programming access for about 10 years now, and with each new edition, there
is much to learn. Happy programming!

I'm not that familiar with VBA but keep studying different usages for it on
the "sample" database that comes with Access. Got the combo box complete and
it works. Awesome.

this seems to be not that bad...

[quoted text clipped - 38 lines]