Search results

Hi there, I have learned how to make a combo box filter data for the next combo box but I have now added a link table to create a many to many relationship (in this case it is contacts to store chains) so a particular contact can serve more than one store. I know why the filtering has stopped...

Hi all, I have a form which has a combo box to display a list of dealers which worked fine until I added a field from a different table. Now when I try and select from the combo box list it says join key is not in recordset. Can anyone please explain what this means? Thanks : )

Hi all, I'd like to know how to return a prefix based on year to a text box in a form. Each trailer we build will have this code on it, much like a vin plate on a car and the prefix will change when a new year begins and the numbering will start again from the beginning. For example the year...

Hi all, Can anyone help me with combo boxes? I have a form which I am using as a Build Form to create specifications for trailers that we manufacture. I need the combo box to look up data from one table and then place it into another table which will hold all the specification details for each...

Ok, so I have created a table which will eventually contain all the information about the suppliers to my company. Some of them will only supply us with the odd product every now and then whereas others supply us with several different products on a monthly basis. I would imagine that I...

Hi all, I am aiming to create a database that will help me record any warranty issues/claims that might occur with the products we manufacture. We sell products to various different dealers and most of these dealers have more than just 1 branch/depot and will also have a 'head office'...

Hello all! I am new to the forum and used access when studying ICT for my A Levels at college. Years have passed since and have never had a need for Access in a job until now and found myself a little rusty to say the least! I am a design engineer using 3D CAD modelling software and also...