Search results

This is where I'm getting confused, there is a drop down arrow where I would assume a list of tables should be but the list is empty. The only other thing I have available to me here is the expression builder but I'm not sure what to do with this.

Hi Ryker, there isn't a relationship between these tables no as I am using a field in the first table purely as a lookup to populate a field in the second. I had to go about it this way because initially I had max'd out the amount of indexes allowed per table (I think it's 32) so after a bit...

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

Well, to say that I am a complete beginner might be bending the truth a little. I studied ICT while at college and where I had my first encounter with Access. This was some 13 years ago now and I haven't had a job position where I have needed to use Access until now so as you might...

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

Ok I shall keep that in mind and give it a go later. Many thanks for your help

There aren't any fields that the head offices have that the branches don't so given that I guess it makes sense to put them all in one table. What I ultimately want to achieve is when producing a from, I want to be able to select the dealer name from one drop down list and have it filter all...

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