Recent content by ukmale65000

Sorry alan just that when i tried to run the collect form and ticked either the collect from this address or deliver to this address boxes they remained blank. As i said im trying to understand access and found that if i copied the dealer address in the tbldealer table you created then paste the...

Any idea why the form for populating the original table is not creating a new record every time?

thanks Alan

Im getting confused myself now, when you created the second table for me, it is populated when a dealer fills out the new dealer form i have. The form (new dealer) asks for four pieces of information. The Dealers Name, The dealers address, and two new pieces of information i have added to the...

The database is now working fine with just one thing i cannot for the life of me work out how to do. I now have a lookup table which has 5 fields, one is the dealerid number, two is the dealer name, three is the dealer address, four is the collection address and five is the delivery address...

oh ok no problem will add to post you sent

Ok well it was just a way of keeping in touch and picking your brain, did you get my message about things not quite working in what you did for me already?

Hi Alan, have taken the liberty of adding you to my skype contacts, hope that is ok, if not please let me know and i will delete you Paul

OOPs one more question, when im adding new dealers manually to the db, do i add the details to my original table1 or the one you created tbldealer ?

Thanks Alan, i will look at the coding you have done plus the links you have suggested, you have been so helpful. My next task is to add to the form if the dealer is a new dealer who dosent have an allocated number. Im sure i will be back on the forums soon lol . Thanks again

Thanks Alan have uploaded the database again, feel free to play with it and delete all the rubbish that's in there and not necessary, i have been playing with macros, queries etc whilst waiting for an answer so its probably all rubbish. Ideally three problems can be solved 1. Dealer enters his...

i have also tried the following code in the after updatefunction of the dealer id box to no avail, no off the form boxes are being filled in at all. Private Sub Dealer_id_number_AfterUpdate() Dealername = DLookup("Dealername", "Table1", "dealerid=" & [dealerid]) Dealeraddress =...

I entered the following DLookUp("Dealer name","Table1","dealerid = 5") and get the result #Name? and if i enter =DLookUp("Dealer name","Table1","dealerid = 5") i get the result #error, im sure you guys can spot the simple mistake im making

Thanks so if i ave a dealer number say 1001 and they enter that in the dealer number box on the form, where do i put the dlookup code, if i want to populate the dealer name and dealer address boxes (two seperate boxes on the form) ? Is it in the dealer number box as an event "on enter" or...

Thanks, i have enclosed the database for anyone who can help me, you will see on the form that there should be several options which would auto populate the form if i knew how to do it i.e. entering a dealer number should populate the dealer address. Ticking the tick boxes should auto populate...