Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jacko999

  1. jacko999

    sum up user occurences in a 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
  2. jacko999

    qry in cbo on form

    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
  3. jacko999

    access lookup/report problem

    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
  4. jacko999

    setting up input boxes?

    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...
  5. jacko999

    query form?

    Cheers :-) Chris :D
  6. jacko999

    query form?

    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
  7. jacko999

    query form?

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

    query form?

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

    query form?

    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
  10. jacko999

    Startup welcome form ontop of form

    at the same time preferably Chris :D
  11. jacko999

    Filter using a input box

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

    Filter using a input box

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

    Filter using a input box

    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
  14. jacko999

    Startup welcome form ontop of form

    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
  15. jacko999

    Filter using a input box

    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

Part and Inventory Search

Back
Top