Search results

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

Thanks Alan but that website seems to only talk about filling in combo boxes, as a rank amateur at databases im not sure if it does what i want to do.:banghead:

I have created a form for a car collection/delivery service. The form has a field for the customers address. Also in the form i have 3 items which i would like to automate ?? if possible. Firstly there is a dealer id box which when filled in i would like to autofill a box which is the dealer...

I Currently have a button which i press to log users out of my system when i wish to do any maintenance. This solution was fine when i set up the database as there were only ever 1 or 2 user in it at a time and i could advise them individually when the system required closing down. Now the...

Hi Dont know if what i am trying to do is possible and i am a complete novice at PHP and MySQL. I hope to set up a website, where customers are asked simple questions, and then the answers given are stored in a database, which i can either receive the input answers automatically or manually. I...

Thanks that works great Access world forums to the rescue again !