Search results

Thank you, that is just what i needed!

Hmm, that brings up a nice little box for me to enter the order number into, but no luck on bringing up any data... I have attached the database to give you more of a clue into what i'm going on about.

Thanks, i'll have a go

Lol, i'll have a look into it, but i think you should do a search in the forums Mstef. Search for : Mstef DATABASE NORMALISATION :D PS, everything is in one table so that i can just glance over the table if needs be and edit what i need. Might think of splitting it up in the future though...

Right i have got my nice shiny new combo box with the order numbers in it, but how do i prompt for the data to be pulled from the table? In the form i bring up the customers surname and any additional notes in an uneditable text box to show that the right entry is selected and i have a number...

And in reply to Mstef, i need the 3 forms, as they are used by different people. customer service to add a return, the warehouse add the details when the return has arrived back with us, and the accounts department fill in when an item has been refunded

The problem is that there will eventually be a lot of entries in the database, and scrolling through a list of hundereds of order numbers could be a bit of a pain in the neck for a system i am building to speed the whole process up (we currently use an excel spreadsheet with 24 columns and...

Hi, I'd like to see if anyone can help. I'm not a complete beginner in access but i have been having some problems and i think it may be that i dont know some better techniques for what i am doing... I have a fairly simple database which i am creating for the storage and reporting of our...