Shoutbox

Hi. I've made a database of my films in Microsoft Access which works fine.

I was wondering if anybody knew how to make a form that you could open on the swithboard that would have an automatic search box pop up and to type in for example the name of an actor that would then work as a query and show all of the films he is in.

If anybody thinks they know how to do this I will explain more details of my forms etc.

Thanks.

create a query in design view put the fields iin the design view in the order u would like to see them. in the field that says 'actor' or w.e. type [which actor would you like to display?]

the [  ]  are paramter queries

hope this helps. you may have to design a macro to place on a command button but i think you can create a command button and the wizard has 'open query' on click in it alredy though.. should work...

quote:

---

Originally posted by may73alliance
should work

---

yeh it will work !!

if u don't want to mka ethe quite u can make a macro that will search !! but the query is the easest option !!

macros are annoying lol. i can make it search and show you what you want in a report. can it do it for a datasheet view?

with forms, i can make the tabbed menus but how do i make it so that its one form but i press a button and it goes to a completely new (form?, view? or something) because atm ive got comman dbuttons to open other forms but i want them as one. you can do it my mate has got it on his but i cant figure it out

thanks.

now onto my problem !!!

is there anyway to make a drop down box (combo box) that will only show sources that haven't been used ???

what i have is 2 tables with details in (with an ID field in both tables) and then have a third table that matches the ID's in the first table to a certain ID in the second table. i only want to use the ID from each table once (so i have "No Duplicates" on) so is it possible to have the ID not appear in the drop down list once it has been used

bloody ell     would you have to have something like [cars]![registration] = [table 2]![used] = no           sorry kinda confused

i cant even figure out how to have it so if on a drop down menu u select bmw, that in another drop down box ud have the models u sell, but only the bmw models. btw you know how to do dis?

quote:

---

Originally posted by may73alliance
i cant even figure out how to have it so if on a drop down menu u select bmw, that in another drop down box ud have the models u sell, but only the bmw models. btw you know how to do dis?

---

don't really get what u mean (so this maybe totally wrong)

you need to have the models and the make in a realtionship !! so then in your form have to boxes, one to select the make !! and another one to select the model !! so that when u select a make it only shows models for that make

(bit hard to explain, but could show you)

show me? how?

omdz. COMPLETE n00b question but how can i set the image as a BACKGROUND, i can have da image in it but not locked. so if i want to select a button it always selects the image...its really annoying. thanks

quote:

---

Originally posted by may73alliance
show me? how?

omdz. COMPLETE n00b question but how can i set the image as a BACKGROUND, i can have da image in it but not locked. so if i want to select a button it always selects the image...its really annoying. thanks

---

background on what ??

a form ???

go to the properties of the form, then go down to picture, and select which picture to use

THANK YOU SO MUCH. my ict teacher couldnt even tell me how to do that