Search results

I'm missing something probably small but it's not obvious to me how to get the Entity_ID in frmMain (which is based on tblMain) and the Entity_ID in tblsupportingmaterials to match up. This list box on frmMain is based on and queries tblsupportingMaterials.

Hi Thanks for that input. So my form is called frmMain and the text box that is already on the form that has Entity_id is called Entity ID. So where would I put Forms![frmMain]![Entity ID] on the form? The unbound list box is also on the form and has the following query in it's row source...

Hi, I'm just trying to add a simple command button on a form based off of a table called tblMain. This table has a key called Entity_id. So on the form, I added a command button to open another form based on tblsupporting materials. This table also had a value called entity_id. So when I use the...

Hi, I haven't done any Access in a while and cant remember how to do this simple thing. I just want to query a suppporting materials table so that all the supporting filenames appear in a list box for a particular person. So I have two tables, One is called Main with all the people each with a...

Oh Never mind..I'm an idiot lol The 3 columns are called Donation1 , Donation2 , and Donation3 NOT Donations1, Donations2, Donations3 Thanks!

Hey, Hmm well I tried that buy am doing something wrong. I put the code below in the sql window but when I try to run it, it asks for the parameter value tblFinancialConnections.Donations1 etc.. But I have a table called tblFinancialConnections and a field called Donations1. I double checked ??

Hi, I'm trying to make this work. How do I implement this within a query? The table name is tblFinancialConnections and the three columns to be stacked are Donantions1 , Donations2, and Donations3. I started building a query and pulled those columns into the grid but where to I put the sql text...

Oh I just saw the last response. Ya thats exactly what I need. Thanks!! :)

Hi, Thanks for the reply. Actually that will just concatenate the fields. That's not what I need though. I need to stack the columns into one column. so if there are 10 observations in column 1 to column 3 then the stacked column would need to have 30 obs.

Hi All :) I have an issue that seem like it would be an easy thing to do but not sure how. I just basically need to get three columns in a table into one column to I can do a query on that one column. But before I do the query I need all the data from the three columns. Whats the best way to do...

Hi,:o I'm stuck on what seems would be fairly easy but its not quite working right. Basically, I just want to do a 2 level query. I have a main table with alot of peoples names (first, middle, last). I have an affiliations table with people who are affiliated to the people in the main table...

Thanks Guys!! I put It worked great! :)

Hi, Thanks for the reply. No I can't just hit Ctrl P because Im not going to be the one using the database. The database will allow the user to do a search and have the results display in a subform. The report is based on this and will update as the search changes. I have a button for the user...

Hi All :) I have a pretty basic question but I've never done it before. I built a report called 'rptPrintSearchResults'. I just want to write vba to print it to printer. How do I do that? It's based off a query that will change depending on the search the user does. Once the user does his/her...

Hey Thanks!! I used your suggestion of copying the value on my form and making the text box invisible. Then I just called the value of the text box when I run the print subroutine. Thanks! :)

Hi, Thanks for the reply. Yes I can but the btnSearch_Click routine does a complex query and then diplays the results based on the search string it pieces together called 'strFilter' . In Print_Click routine, I was trying to build a query that I could based a form off of to print the results...

Hello, :)What is the best way for me to get the value of a variable from a subroutine into another subroutine ? The code I'm running is below, it calls the btnSearch_Click subroutine (a very long complex piece of code) in the same module. I just need to get the value of 'strFilter' from this in...

I checked that. It is sfSearchResults. ?? not sure why I have to close the main search form and then when I reopen and click the find button it will have the data from the previous search criteria in the subform (the data from the previous query output). But the query itself (which the subform...

Hey :) I need some help figuring out why my subform will not update with new data. The subform is based on a query. The query is based on the search criteria a user selects on the main form. So a user selects a name to search on then click the 'Find' button. This runs code that sends a new query...

Hello All:) I have a pretty basic question ... Whats the best way to go about giving a user to print out a spreadsheet in Access. I have a couple query forms where the user can make several selections and certain fields. Based on those selections, a subform pops up that is based on a table (in...