Search results

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

Stupid error on my part. I had some code in the underlying query that was filtering everything else out. :rolleyes:

I think this code is going to work great for me, but I am running into one little snag. I only want to allow the user to filter for 1 option in a group at a time, but when I use the code listed below it will only show the s in the sex column. Even if I change that to H (for Heifers) it still...

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 would like to export the report into a snapshot/excel before it closes. I do not know what other event to add my code to to prompt the user to export.

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:

That is sort of what I had to do to get it to work. I had to unformat the filter form and just use the "m/dd/yyyy" format in order for it to even format at all. I will try what you suggested and see if that works. It might be a better solution to this issue. Thank you so much for the response.

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

After starting to work on the query I am not sure that the dcount function would work either. I have the records counted in the subreport query, such as each record has a 1 in that field so I just need a way to add it up. Can you think of any reason the formula that you suggested in your other...

I will try that one and see if it produces the results that I am looking for. Thank you so much for your quick response!!!

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

I finally figured out the answer... forms!formname!field or forms!formname!field is null Thanks anyway

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

You have put quite a bit of thought into this. Sam is short for Samantha, you were right. No need to apologize. I am not sure if pdf995 is the same or not. Acrobat Distiller is the program we use to convert regular files into PDF format. Anyway, I will look into further and thanks for the help.

Both suggestions are very much appreciated. I will give them a try and see which one works best. Thanks for your help!!

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?

Thank you so much!! That worked like a charm.