Search results

I'll try again to describe what's happening with my database that is leading me to stay away from join statements. The level 1 parent form contains search criteria and buttons which trigger the VBA search function. The level 2 subform displays results from tbl_Document based on the level 1...

vbaInet - I took your advice and am rethinking my approach. I am still trying to avoid using Join queries as that breaks my subforms, however I did come with something that almost works using RecordSet. The following code works, but only returns 1 result. I want to return all results but have...

An inner join would work for that specific purpose, but has unintended consequences in my database. I'm writing qry_documents in lieu of a VBA built search function that feeds a form recordset. The form has subform fields containing multiple entries linked to the main record. I currently use...

I'm sure this is a simple issue, but I don't know what terms to search for. I want to display all fields and records from tbl_Document that meet the criteria specified from qry_Documents. I'm trying to do this using a WHERE statement, but every time I run the query I'm asked to provide a value...

In laymans terms, I have a database (attached), where I have a VBA search function that takes input from combo boxes on the top level form and displays results of the search in a subform. Currently, I can search by components, but not by component and piece part. I would like to search by...

YNWA, I'm not sure how I would include two queries in a single VBA function. Anyway, a DB with the essential elements is attached for your review.

Revisiting this issue, I noticed in the report design view for charts, there is a control OLEUnbound0 and another Report. Leaving the "Record Source" empty in the Report control property and using the query I want in "Row Source" in the OLEUnbound0 control property. Could this possibly have...

I have a VBA query building function that works well for sorting information from TableA. However, I also have various link tables TableB and TableC that are associated with TableA. Data from TableB and TableC is entered and displayed in subforms within the main form that pulls data from TableA...

I solved this issue. Somehow I managed to use the actual query values in the chart design instead of the default data and was able to format the chart as I wanted. So the question then is how was I able to pull real data when in the design view?

I'm using Access 2003 and trying to make a chart that displays data as 4 columns, 2 lines, and x-axis by month. I actually managed to get all this data into a chart, but the limitation I'm hitting in Access is that I can't just have 2 lines and 4 columns on the chart. :confused: Datasets A & B...

That was amazing Taruz! I am studying the SQL you shared and am learning a lot from what you shared. Thank you so much!

Hi, This is my first post, and I'm still new to Access (although not databases.) I'm working with the table below: MonthOpen ---- MonthClosed 4-2011 ---- 7-2011 4-2011 ---- 6-2011 4-2011 ---- 6-2011 4-2011 ---- 5-2011 ---- 7-2011 4-2011 ---- 5-2011 ---- 5-2011 5-2011 ---- 6-2011 5-2011...