Search results

I got it. It was because the criteria I used was WHERE ((([Service Call Log].[Model Number #1])=[Forms]![HOME]![NavigationSubform].[Model Number])) but what it was supposed to be was WHERE ((([Service Call Log].[Model Number #1])=[Forms]![HOME].[NavigationSubform].Form.[Model Number])) That...

I see. I'm guessing you don't like the layout view cuz you're a pro at this. I'm kind of new so it's a lot friendlier to me. I took your suggestion and went into design view and selected the border. you can see it here in the picture (http://easycaptures.com/4451338221). In the "Other" tab in...

It seems like this would most likely be the case. How do I check what the subfom control name is? Is it the "Name" from the property sheet when I click on the text box while in layout mode?

Yes, I have. That was the code I kept seeing and then I also saw variations that would include periods instead of the exclamation point. I just tried it again right now and I got the popup that asks me to type in the "parameter value". Is this feature I'm trying to do just not available?

So, I'm fairly new to Access so there's still a lot of things I am trying to figure out. Hence, I may make some mistakes in explaining my situation so feel free to correct me. I created a form that is user friendly name "HOME". In that form, I added navigation controls which include a form in...

This seems to be the popular opinion. I guess I should combine all the tables into one large table and then create queries which would then kind of replace the current tables. Does that sound like a good idea?

I've tried moving around the queries and made other queries making sure that all the tables work properly. The only time I get any issue with it is when I have more than 6 tables which I'm still trying to understand why.

Oh, I see. They are both short text but the PRF is a calculated field (not sure if that matters). I tried to move it around so PRF was called up first but it seemed to give the same issue. I'm guessing I have no choice but to make some intermediate queries then huh?

No, they are both short text. If they were different types, wouldn't that cause the union query not to work even if it was less than six tables?

Each different table is for a specific line of products. I set it up in a way so I can use the data and have it linked to visio, which is essentially the output of the data. They do all use the same structure but I separated them so I can run queries in the future more easily.

Hi all, I have created a union query which joins together multiple queries into one. It was working fine until I added more than 6 queries. Now I am getting an error message saying "Could not start transaction; too many transactions already nested." I looked this up and the description said...

Hi all, I'm new to this forum and somewhat new to access. I've been tinkering with it for about a month now but I've been able to learn a lot about how it works and how databases work in general. It's nice to be able to learn some harder things as I am very picky with certain features and...