Search results for query: *

in my database i have ten fields each containing user initials as a textfield. we need for each user we need to know how many times each user appears in each field and displayed in a number. Chris :D Chris :D

i have a combo box on my form linked into my query and when all is selected i want my query to select all possible field how do i do this Chris :D

i have a lookup with 3 colums but in my report it will only show 1 how can i display all 3 in my report?? Chris :D

Heres my problem i need to create a data base with the field called software. this needs to be input on my form but there can be more than one and they need to be input into my form. was thinking of having a txtinput and a number that inserted brings up the amount of txt boxes specified and the...

Cheers :-) Chris :D

from my switchboard i have about 6 reports i produce and at present i have the basic paremeter input box appering up when i load my report. I wish to replace the input boxes with a form that accepts the value and passes it to my report the same way my input boxes do. Chris :D

yeah i want to change the input for my report to a form Chris :D

yeah but i wish it to be a form not a table or query Chris :D

is there any way to replace the queries parameter input box that my report is based on so appears before my report with a form with the input? Chris :D

at the same time preferably Chris :D

Ok i get you thanks for all your help and quick responce much appreciated Chris :D

SELECT "All" From [tblLearner].[Surname] FROM tblLearner; is what u reccommend to use then Chris :D

ok so now my control source is empty and my rowsource is SELECT [tblLearner].[Surname] FROM tblLearner; according to the properties is this correct? Chris :D

i wish to have a small welcome form that apears above my popup form on startup with a click box that allows users to set it so that it doesnt show again any ideas how to do this?? Chris :D

no once ive searched once if i try to search again it saves the new surname as if the surname has changed which i do need to do my code i used is that above and row source is blank Chris :D

well i changed my Surname actual field to the combo box so when i search it the second time i input it changes. I need this to happen but i wish to be able to search again Chris :D

is there any way i could create a button to click which will allow me to re search the form rather than having to exit the form to search again? Chris :D

thanks alot guys :D Chris :D

I've looked all over for this but heres my problem: I have a form called frmLearner and At the moment i have a Feild names surname. Rather than when opened on edit mode having to scroll through all fields i want to add a extra input box which when a surname is entered it pulls out the specified...

ok thanks tryed it i found the problem and is fixed thanks a lot for all your help :D Chris :D