Search results

Sorry, I'm not quite sure what the terminology is. I "drag and dropped" the query onto the form. When I got to the properties of the query on the form the window says "Subform/Subreport : qryPartFinder" So I guess it's a subform...?

I have a form that is to be used to browse through parts using various filters (like category, snippets of part number or description) to find particular components, and then draw information from those components onto the form to be used for other things. Queries I seem to understand - I've...

What about if there's an unknown (and very large) number of relationships within the same table? I'm trying to construct a similar thing to this family tree, but with components, rather than people. A bolt, for example, is a part, which is also in many other assemblies (which are listed as...

Okay, I've found subdatasheets. That seems to be what I want to do. The question then becomes, can a subdatasheet include data from the parent data sheet? My spaghetti example above is a bit silly so let me choose a better one: Take a BMX bike for example. Say I have a table of parts that...

Hi everyone, I've recently begun building a database to keep track of stock at work. Nothing particularly special or difficult. I have a little bit of prior experience with Access and VB, but not heaps. Basically, I've created a tables for parts, companies etc, and am relating all the data...