Recent content by weckels

I have a form with a subform on it that uses a query as its recordsource. I would like to use the data in the subform as the recordsource for the subreport. Can this be done and if so how? Thank you very much!! Will

The fields are indexed but the problem is not that the query runs slow. It runs pretty quickly. The slowness comes from the query having to run 50 times. I am looking for a way that makes the query run only 1 time. That's why I thought that I could put a subform on my main form that has the...

I have a subreport that "runs" about 50 times in a report. It is in a group footer. The source for this subreport is a query. The report/subreport works fine except that it runs very slowly since the subreport makes the query run 50 times. Is there a way to have this query be the source of a...

I am trying to do the same thing but am having problems. I have checked Access Help and can't figure it out. I have created a sort group on the field 'Shift'. On the report it is called GroupFooter1. In this report footer I have placed text boxes that are needed to display 'Shift' data. The...

Randy, Thanks for the reply. I appreciate your thoughtfulness. I just recently came up with a solution, I hope. Right after the table is made with the make-table query, I rename it to (NOW). This way every time the table is made it can be renamed to a unique name. I set this unique name to...

mikey69, Thanks a lot for the help. I got it to work fine. I appreciate the help! Will

mikey69, Thanks for your reply. I have tried using if (iif?) many different ways and I always get an error, usually syntax or missing operator. Could you please be more specific? Sorry, but I'm not very knowledgeable about SQL statements. Thanks again, Will

In my union query I want to select * from up to three select queries depending on checkboxes on a form. I always want my union query to include SelectQuery1. If the first checkbox on the form is checked, I also want my union query to include the data from SelectQuery2 and if the first and...

I am reposting this from the Access Reports Forum. I still can't figure this out. I have a chart in the detail section of a report. The report is ran from a button on a form. I want the chart in the report to use data from a table specified on the form. In the chart properties - Row Source...

dtheriot, I added the .text and got the same result. Thanks for the suggestion. Will

I have a chart in the detail section of a report. The report is ran from a button on a form. I want the chart in the report to use data from a table specified on the form. In the chart properties - Row Source - I entered =[forms]![ins report form]![insdata]. Insdata is a text box that...

Steve, The form has other buttons that do the same thing. There could be six tables or more that need deleted. I could add more invisible fields to store the other table names and do if-thens to delete them with the close event. This could get ugly when I add more reports to the form but this...

Steve, Thanks for the reply. Yes, the report runs from a form with a DoCmd. There is a button with a click event that opens the report. If I put the deleteobject after the open report command it tries to delete the table right away after the report loads. On what form event should I put the...

I have a report that gets its data from a table. When I close the report I want to delete the table. If I use DoCmd.DeleteObject acTable, TableName in the report close or deactivate event it tells me I can't lock the table because it is in use. Any thoughts? Thank you! Will

I have a report that displays the data from a query. There are potentially two other queries that have data that need to be combined with the first query's data. I have check boxes that the user can check if they want the second and/or third query's data added. I tried using a make-table...