I’m not exactly sure where you are with things now, but I’ll try to walk you
through it. Can you create a Macro to do what you want to do? All you have
to do is modify the code, so it does exactly what you need, and fire the
code, right. Make that part work, then create a button on your Form >
right-click > Miscellaneous > Run Macro > click the name of your Macro > Next
Next > Finish. Form View then run your Macro. Does that work? In Design
View, you can click Build Event and then you will see the code that the
button is linked to. If you don’t want to create a Macro, just modify the
code and point the button straight to the code; Button Cancel > right-click >
Build Event > Code Builder ok . . . that needs to point to your code.
Try that, and experiment a bit, and see how you get along. I think you have
everything you need to make it work. It’s thrilling to see it work for the
very first time! For the more general things, usually you have to figure
these out on your own, but if you have a specific question post back with the
details.
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
:
Hi Ryan,
I am sooo close to making this thing work. I tried making the subform and I
tried to carefully follow the instructions that you wrote out below, but it
just did not work. What code can I enter into the Code Builder for the "OK"
button in my dialog box with my drop-down menus so that when users click
"OK", after choosing what they want on the drop down menu, that only the
records that apply to their search will show up, but in form view of the
form? I can lock the form so that they can't make any changes. My form view
is really nice, and I just want users to be able to see all of the
information on there.
:
Ah yes, ‘only in view mode’. You mentioned that in your first post and I
neglected to answer that. This is how you make a Form read-only:
1. Open the form in Design View
2. Double-click the Form Selector (to open the form's property sheet).
3. In the AllowEdits property box, click No.
4. In the AllowDeletions property box, click No.
5. In the AllowAdditions property box, click No.
As for the rest, it will take a bit of work on your part. Look at the
sample here.
http://www.databasedev.co.uk/text_search.html
Download from here:
http://www.databasedev.co.uk/downloads.html
The file’s name is ‘How to create a simple text search facility’
Maybe that will give you some additional ideas. I still think you will need
a SubForm as well.
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
:
Good morning! I watched all three Youtube videos, and it still isn't quite
what I am looking for. Rather than create a subform, I would like for users
to be able to view only records that they may want to see - in form view of
the form. So for example:
1.) Let's say that I have a United States Database with 50 records - each
record contains information about each state (i.e. population, state bird,
sports teams, governor's name, etc.)
2.) Once the database is opened, the user will go to a switchboard, and
they will choose what they want to search for. Pressing any "search for"
button will run a macro that will lead them to a drop down menu for that
category.
Now let's say that the user wants to see all records where the governor's
name is John Smith, and there are 5 states whose governor's name is John
Smith. How do I get Access to show me only those 5 records (in form view),
to where they can ONLY view and not edit or add?
:
I think there was a problem with my last attempt to post. This may be a
double. . .
Aaahhhhhh, I think I get it now. I think this is what you want:
Hope that helps!!
:
Hi Ryan,
No, I would like them to view the form. My form contains a lot of
information, and I want them to be able to view the form in its entirety when
opened. So for example, if they search for company ABC, I want the database
to pull all records to where "company ABC" is in it. Or if they want to see
all of the companies that manufacture red balls, Access would display only 5
out of 25 records (if there are 5 companies out of 25 that manufacture red
balls_ - something of that sort. I tried putting all of the information in
report form, but it just didn't look like I wanted it to. So I figured that
just them viewing the form (not in add or edit mode) would work best.
:
Why is it a Form? Do you really mean to display your data in a Report. You
may find this t be helpful:
http://www.fontstuff.com/access/acctut19.htm
Download and run this file at the bottom of the page to see how it works:
AccessAndSQL6_2000.zip [115KB]
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
:
My switchboard contains a button that when pressed, will run a macro to open
up a dialog box. Once the user chooses an option in a dialog box, I would
like for the form containing only that chosen record, to pop up as a result
of their search. I would like for the form to open up only in view mode,
where they cannot add or edit. How can I do this?
