Search results

anilvaghela I haven't ever found that can be done directly. Instead, consider one of these: 1) create a query that returns the information that would be in table+subdatasheet and export that. 2) create a (very simply laid out) report using a query like that in (1) as its source, grouped and...

A query is meant to take multiple tables and make them into one "table" if you will, so that might be why it is exporting as one table. Can you explain a little more what it is you are trying to do?

No, no data without the iif's either. There are no errors, but no data.

Thank you for trying to help. The database is too complex with linked tables, etc. I might try to setup a similiar one that isn't linked and post it. Thanks again

Thank you for the reply and the example. I can see how that would work and I have actually used that option before, however this situation seems to be a little more complicated for some reason. I would have to somehow use an iif statement because the information needs to match correspond to the...

Sorry, I was unclear From a subreport I have a text box with the mentioned iif statement. I don't get an error, but it doesn't find the information I am looking for either.

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...

Thank you for the reply, but I have already tried that. In order to only have one label this option does not work. Thanks anyway.

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...

Thank you Pat. Right now I have them all set to text, but I will keep that in mind in case I make any changes. Thanks again

I am sure it won't have more than one, but your code looks like it is going to work great. I am going to give it a try right now. Thank you so much!!! ***That worked great.****

Thank you for the reply. Is there a better way to compare the two values in the table? There will never be more than 1 value in either table and they will either match or not. If they don't match I am going to run a batch file which I have setup and that works fine. This is my only problem area...

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...

Thank you for the response. I thought about doing that and figured that would be my only option, but I was just making sure I hadn't overlooked something obvious. I will give that a try and see what I can come up with. Thank you

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...

Thanks for the reply Eddie...It will sort just fine if I make the field val([lot #]), but I don't always want to sort this field. The user will define which fields they want to sort by selecting from a combo box. I ended up making another query and making one field that is just the val([lot #])...

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...

Thank you for the reply. Once you said that I remembered I had some code on the report open that controlled the group/sort properties. That was what was causing it. Thank you!!