Search results for query: *

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

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

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.

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

please can I get some help on this

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

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

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

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

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

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

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.

How exactly do you set up the combo box?

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

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

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

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

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)

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.

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