Search results

In the trades tab of the data entry form. I'm going to the "tradeid" field of the subform which I have set to show the trade name as a lookup. I'm selecting "plumber" as I know that I have already put a couple of plumbers into the workertrade table but when I tell it to apply the filter sort it...

Yes, the trade details are supposed to be in the trades tab. I would expect the type of result you had if I had been trying to do a filter on the name, however I wanted to do a filter on the trade id within the trades tab and it is that which is giving me the wrong answer.

In the attached database which I'm trying to build (try being the operative word!), I seem to have hit a problem with one of my forms. When I'm in the contact details form, go to the trades tab and try to find for example all the plumbers (there's only dummy data in there so far), using the...

Thanks for the reply, I'll go ahead and delete the ID field from the form and sub-forms I've been working on today in that case.

I am just creating my first ever form and it needs to have two sub forms included in it because of the one to many relationships between the data. On the main form, do I need to have a field for the worker id as it would be automatically assigned and would I also be able to use the same form to...

I hadn't thought about that!

Thank you very much for your help. I'd been trying to restrict the number of queries I was using as boss (who hasn't used access before) told me last week that he doesn't want to see loads of different queries etc when he opens the database up as he thinks it will be too confusing and take extra...

Hi everyone, I'm trying to build up a database for work to replace the old multiple simple tables that we were using. The tables that I've now constructed are relational but I seem to have hit a snag with my very first query (see attached). The data I've entered into the various tables so far is...

I think I must have got something wrong en route or else I'm expecting too much of the tables. The first two records pulled into a query fine but the later ones haven't gone in despite telling it to refresh and I think I may need to alter the link between the worker and firm table as well...

Ok, I'll do that later today. Thanks for the advice Mark.

So adjusting my table structure to the attached would be better?

Thank you Gina, I've just read through it and I think it will suit a lot of what I've got in mind. I'm especially pleased to see the bit about searching between dates as one of my co-workers mentioned that he would like to see something along those lines at work today! Will the same type of...

Many thanks Gina. I've bookmarked the link you gave me and will give it a thorough read later on.

Thank you very much for the suggestion Gina, I will certainly look into it. Can I choose more than one item at a time from a combo box, for example say I wanted to look in two or three different nearby towns for a plumber without having to repeat the search?

Thanks for all your help Mark. Hopefully by the end of the coming week I'll have managed to sort out everything that I want to do with the new database!

Hi, I only joined this forum yesterday and I feel I've learned quite a bit already about relational tables, so now onto the forms. I've been trawling the web for quite a few hours today after discovering that I could use a form to do a filter from the advanced bit in the filters part of the...

Thanks for that link and the warm welcome Goh. I just hope I can stay awake at work tomorrow after spending most of my time off (4 days) at the pc from the time I get up until much later than I would normally go to bed trying to figure it all out!

Don't I need to have a SQL server to do that or will access just let me do that sort of thing anyway? So count will tell me how many trades that worker has but how would I get it to display the actual trade names?

Thanks for explaining that Mark, I see where you are coming from now. I understand what result the code will tell me from using the count function in Excel but where would that code be typed in?

I suppose I could add a site location field into the client table and many thanks for pointing out about the two separate trade tables. I can see know that I need to amend the way I had set my initial trade table out, I was going to allow for all combinations of skill level such as fully...