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!

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

Search results for query: *

  1. chigley3

    Using combo box for two field search

    I try to check the box and it says Name conflicts with existing module, project, or object library I did come up with a long winded solution by associated the search wih the unique field. Once i read the unique field no, I can search that unique field number to pull up the same record. Just...
  2. chigley3

    Using combo box for two field search

    hello aceman, it still doesn't work. on the debugger, rst.findfirst cri comes up yellow. It did that with the first code you sent too. What do you think it is? thanks a lot
  3. chigley3

    Easy way to do Find as you type

    Yeah I did, where do I start? I have a combo box called Combo169... I dont really understand the instructions, could you give a break down.
  4. chigley3

    Easy way to do Find as you type

    Find as you type meaning that all other informations is not available to select when you have entered certain values. for example, if i enter 428 500a 530a 427a 428a 428b 429a all i want to see is 428a and 428b
  5. chigley3

    Using combo box for two field search

    please can I get some help on this
  6. chigley3

    Easy way to do Find as you type

    Hello there, I have a combo box that finds claim numbers for example 499a, 456a Named MANUFACTURER Claim No in a combo169 which runs off a normal query to give the result. How can I use Find as You Type within this? I have seen similar postings but have tried to code and cant get it working...
  7. chigley3

    Selecting data by combobox

    Where is the coding for that? i copied everything there but it comes up with an error Cheers
  8. chigley3

    Using combo box for two field search

    Thanks for the code but there still seems to be a problem. The debugger doesnt like rst.FindFirst Cri. When I press the combo box, the data comes from a query. For example when I press the combo box I see, MANUFACTURER Claim No/Dealer Code 248A 10001 249A...
  9. chigley3

    Using combo box for two field search

    Hello there, I have created a combo box within a form in order to search for a specific manufacturer claim no. However, the 'job form' can have records that have duplicate manufacturer claim nos within a specific Dealer code. I have the code to search for the manufacturer claim no Private...
  10. chigley3

    Search function in form

    duane, I checked the combo box function and I got it working. Thanks duane.
  11. chigley3

    Search function in form

    Ok, I can use the combo box to look at all the previous claim numbers but I want the ability to click on the number and then the form updates to bring up all of the information related to the claim number. It's not that hard to understand is it? If claim number 23A has dealer info, total...
  12. chigley3

    Having calculating field in form to appear in table

    I just worked it out myself, If you put for example, after update and then go into Code. you put labourcost.value = [labourrate]*[labourhours] This then updates it on the form AND on the table. No need for queries whatsoever.
  13. chigley3

    Search function in form

    How exactly do you set up the combo box?
  14. chigley3

    Search function in form

    All of the information in the form is linked to a table. At my job I enter a claim no and then i can enter dealer name, dealer region, right up to labour cost and total paid. When I do the search for example for claim no, I need all of that information (dealer name, dealer region.....) to...
  15. chigley3

    Search function in form

    Hello, I thought about doing it differently, Can I use a FindRecord in a macro to search for the claim no? Will it then pull up all of the associated information to that claim number so i can see the whole of the record? thank you
  16. chigley3

    Having calculating field in form to appear in table

    i can possibly keep going back to the same form and doing the formulae over and over again. I need the results of a calculation stored because i use those result in other areas. The point is to cut down on work not increase it. if a + b = c then I want to be able to look at c when ever i want...
  17. chigley3

    Search function in form

    The information is on the form, which was linked to a table but because I wanted use maths I put expressions in the control source and now it is not linked in some fields
  18. chigley3

    Having calculating field in form to appear in table

    i got the formular working in the query, how does that then update in a linked table? and if i create a field how does it store and if i enter it onto a form how does it update onto the original table. (form derived from the query)
  19. chigley3

    Search function in form

    OK sorry about that, If i type in the previous claim no I want dealer code, dealer name, dealer claim no, region, dealer customer, VIN, speedo, date of sale, date of repair....and so on to appear in the same form so that it can be looked at and edited if needed. Thank you, C.
  20. chigley3

    Search function in form

    I tried that to now joy, is there anything else I should know about that, Thanks by the way....please whereever i need to type the field name type in a different colour, Im new to this stuff

Part and Inventory Search

Back
Top