Search results

Referencing a Subreport I have searched through the forums, but have not found an instance of this yet. I apologize if i overlooked something. I have a very complicated report which is a main report that is unbound and 3 subreports in the detail section of the unbound main report. I am getting...

I am trying to create a report that looks much like a spreadsheet. Such as this: Location1 Location2 Location3 label1:location1data...location2data...Location3data label2:location1data2...etc....etc They would like to only see the label once and the data in columns...

I have been working all morning to figure this out and I can't seem to find any information on it. I am trying to produce some code to check a query and see if it is empty. Here is what I am using: Option Compare Database Public Function VersionChk() DoCmd.OpenQuery "Version Qry" If...

I am sure this is a simple setup, but for the life of me I can't get it to work correctly. I have 7 pivot charts that I would like to display on one report for easy viewing. They don't have any parameters or anything fancy. Right now they are all displayed in one form, but when trying to print...

I have been working on this for about 2 days and I really need some help. I am using this following syntax in a form =DLookUp("[%DM]","[RATION INFO]","[YARD]= forms![BREAKEVEN FRM]![YARD] And [RATIONDATE]=Forms![BREAKEVEN FRM]![RATIONDATE]") and after I enter this I get an error that says...

I have a calendar control that is simply hidden on my form and is visible when clicking on certain fields and it work fine, but what I can't get to work is I would like to put some place on the calendar to close it if they don't want to use the control. Right now it is seutp so that if you click...

I am trying to use a form to sort and filter a report with an underlying query. Everything works great except one thing. I have a field, Lot #, that I had to setup as a text field because it can contain a letter at the end from time to time, so when I sort by that field it sort incorrectly. (ie...

I have a report that is based on an underlying query. I have a form that the user can pick which fields they would like to sort by, but it won't sort correctly on the report. It sorts in the query correctly, but not the report. Here is the syntax I have in the query. (There are three of these...

I have a filter form that lets the user define the filters they want the report to have, but I need a way to show all if they don't want to filter out information. The fitler options are radio buttons and the user can choose one option and I would like to have an "All" option, but I can't get...

I am wanting to run some code to allow the user to choose whether or not they are ready to email a report, so they need to be able to view the report first. I want to put my code on the close event, but in order to do so I have to be able to cancel the close event. Anyone know how to do this for...

I have read several threads about merging a report to word, but no instructions as to how. I have a report that is going to end up 3 pages wide (I know that is not a good thing, but that is how the user wants it) and I need a program that allows easier setup of some such report. I think that...

This is probably a very simple issue, but I have a report I need to span across 3 pages landscape on letter size paper. The report is limiting me to 22" and I need 33". Is this possible? Please help :confused:

I have a query that I am trying to filter by date range using a form that I have created. It almost works, but I think I have a format issue and it is returning incorrect ranges. Okay, in my query the date is formatted as "m/yyyy" from the normal "mm/dd/yyyy", which is done in the query and the...

Rich...if you are out there please help :confused: I have used the hasdata to help sum the information on a subreport, however, it will only display the last number totaled in the subreport. The subreport displays several different bunches of data that are linked to the main data in the...

I need to take data from two different tables and reconcile the data...much like a bank account. For the life of me I can't figure out the best way to do this. I thought maybe putting information from both tables on a report and grouping the data appropriately, but how would I be able to get...

User Specified Filter I have looked through the forum, but I have not found an answer to this issue yet, so maybe someone can help me. I am using a form with 4 unbound fields to filter my main form. The problem I am having is if the user leaves the filters blank it won't show any records...

I am needing to search through a table for a specific number matching a number on a form and then enter that number into a subform. I have been trying to use the EOF or Do Until, but don't know if I am on the right track. Can anyone send me in the right direction?

For-Next Loop I have a For-Next loop that I am using to make the correct number of fields to appear. I have a textbox65 and textboxes 1 through 10. Here is my code: for n = 1 to me.text65 me.text(n).visible=true next n Can someone help me fix this code please? I would be eternally greatful!

I have a form setup so that my users can define the filters they want on their report which is just a query. I am having some trouble though because I am not sure how to setup the filter so that the user can choose the order in which they want the query sorted. I was using combo boxes with field...

I am using a form to allow the user to choose the sort and filter of the query. I have seven different fields that I need to allow them to sort by and I also need to allow them to pick the order in which they sort. This is the "Order By" code I am using but it is not working...can anyone fix...