Search results

When reading on m2m relationships, i was under the impression that if I wanted one piece of equipment to have multiple accessories attached to it, that was the way to go. The way it should be set is that I can pick mutliple different accessory types (ID's 2, 5, and 11 for example) and attach...

I can pass the ID of the project into my subsubform for the equipment information wth openargs. Could I not then take that ID and couple it with the new ID of new equipment object and when the record is complete have it use SQL to Insert a new record in the junction table of the two ID's required?

The way i read them they seem right unless my logic is off. Each Entry in tblTipMM can have multiple entries from tlbAccessories, etc (i.e. multiple types of accessores) added to it. Looking at it again, the connection between tbleProjTipsMm and tblTipsMM may be wrong. Each project can...

Was just about to post the image actually :) I have a form based on the project (tblProjects). This form has a subform showing a list of equipment on the project. That is currently a query as i'd like it show the equipment type/size/mtl which i've not been able to do otherwise. I'm trying to...

Can you be more specific as to where you think the issue there? My Project table has but a couple fields. The Equipment table has an autonumberPK, material and size fields. Attached to that are 5 more junction tables consisting of other aspects of the piece of equipment. I don't really have...

it's probably an explanation issue on my end, sorry. I have a main table/form of projects. This is connected to an equipment table by means of a junction table. Essentially Main.ID links to JunctionTable.MID and JunctionTable.EID links to tblEquip.ID I can connect that on a form with...

Perhaps i'm over thinking this, i don't know. What i'm trying to do is add a new record to a subform. The problem is, I couldn't use a subform based on a table in order to achieve this. I needed extended information for it to be useful, so I made the visible part of the subform based on a...

I meant that when working with sample data that I tend to fill in all my fields leaving nothing out. Most people opt to leave a field blank instead of putting in NONE or something. Thing is, you can different results if fields aren't filled in and I just forgot to check for that occurence in...

When reading your code that actually jumped out at me. Each step looked at three things" Was it AND, OR, or no selection. It's one of the things you get when working with a limited amount of information. You tend to fill in all the blanks so you can check stuff and forget about what to do when...

I so didn't realize how big a chunk i'd bitten off with this :) Thank you! That update I think is exactly it except i don't need the choice of and/or on each field. They're all And's. However, I do like the ability and the example of showing both of them. This example adds a lot of new stuff...

That's the thing, I built it in the QBE first to get the format for the joins then converted it into code. Apparently it was fine, some hiccup in Access that was straightened out on a restarting of the program.

Don't know what happened. Closed Access, reopened it and then it decided to work. I guess it got scared that i went to the experts for help :)

Here's the statement sqlfinal = "SELECT Employees.ID, Employees.Name " sqlfinal = sqlfinal & "FROM ((qryDeptVBA INNER JOIN qrySkillVBA ON qryDeptVBA.ID = qrySkillVBA.ID) " sqlfinal = sqlfinal & "INNER JOIN Employees ON qryDeptVBA.ID = Employees.ID) " sqlfinal = sqlfinal & "INNER JOIN...

I think JHB has done what i was shooting for in about 1/3 the amount of code that I had :) I'll need to re-create it on a step by step basis to verify my understanding, but I think i've got a good idea of what it's doing right now. If that's the case, it's a matter of exanding to 5 junction...

Your last comments got me past a major block. I think i've got it functioning pretty well in this simple version of it. This searches two different m2m tables for matching criteria. It works as long as you make at least one choice per column, but i've got to figure out how to write a final...

I believe I understand that. I have 5 tables in parallel relationships, therefore, i'd need to have 5 queries - each query looking up 1 relationship. Makes sense when I think about it. That leaves me with 2 questions... 1. Can you point me to a link that explains how to set up a query that...

That's the main input form. I haven't begun a search form because I can't figure out exactly how to search for more than one thing in one column multiple times. That form is how it's input and also largely how it'll need to be searched. People will want to be able to look up multiple pieces...

I'm not sure that does what i'm trying to do. I see that it takes an existing query of all information and then does a query of that data based on a form that lets you choose multiple criteria. However, the first query seems to generate unique records. I don't see it having records that...

I've been searching exhaustively and I hadn't seen that one, so thank you for pointing it out. Hopefully I can figure out what it's doing since the database is written in Croation for the most part. Being able to translate the fields would help as well, but I doubt babelfish would help much...

Maybe i didn't explain it well enough.Short short version would be I need to be able to find products that exist in both red and blue and also come with widgets 3 and 4 and gadgets 2, 8, 14.I've really hit a wall on this and am completely blocked.