Search results for query: *

Might check the report footer, make sure the height is 0 or the minimal amount of space. Sarah

That's what I started with because that's the conclusion I figured, however for some reason when I do that it will only return data if the diffuse or passive is checked. Thanks Sarah

I use the below stored procedure to run a report. SELECT dbo.tblEmissionUnit.EmissionUnit_ID, dbo.tblNOCs.DateApproved, dbo.tblNOC_EmissionUnits.NOC_ID, dbo.tblAPlant.FacilityCode, dbo.tblAPlant.PlantName, dbo.tblALocation.Location_Desc, dbo.tblEmissionUnit.AEI_ID...

Thank you so much for all your help. I took your comments into a meeting and we all came to the consensus that your right. It will still be confusing the route we thought we wanted to go, so we are exploring some other options. Thanks again for attempting. The code you did provide was an...

It's getting really close. It still isn't numbering right for the total report. It's numbering every page. I am hoping that if a group spans more than one page than it will only number the first page in succession with the report and not the rest of the group, than continue the succession...

Thanks Tom for the information. Problem is I don't want the new group to reset to one. I want it to continue with the page count. I would like evertime the new group starts a page is continues to count. The reason for this is that often times the group may add or remove pages throughout the...

I have a report that has a group. Going through the threads I have figured out how to page number my groups. What I am looking for now is if I can do a total page number of the report but have it only count the pages that start a new group. The below example would be for a five page report...

Thank you. I kept putting the format in front of the txtDueDate. Your awesome. Star for you. Sarah

To add to this post, is there a way to long date format the date if you are concatenating? For example here is what is in my control source for a textbox: =[Forms]![frmrptRAP]![txtDueDate] & "." & " You may submit your acceptance by mail or fax to:" Can I format the...

I have a subreport that provides a list on the report. It's record source is a stored procedure. It get's it's data from a list box on a form. What I am trying to do is have it return all the items the user has except for certain ones. For example, if the user selects dog, cat, horse...

I am only a technical user with limited programming, however I run a lot of subreports off main reports using their own stored procedure or view and I have never had to put EXEC in the recordsource. I just have the name of the subreports stored procedure/view. Sarah

Paul - Thank you for all your help. I solved my last problem. The form had allow edits and additions set to no. Thank you again. Sarah

I apologize if this is all basic and I am not quite getting it. I did as you said, however I cannot get the text box to allow a number to be added. It will let me set a default value so I can tell the code works that you gave me. The form I added the text box to runs a variety of reports from...

Paul Thank you. How do pass the value for I from an 'input box'? I put the code in the format event and it started the page number with 0? Is there something more I need to do to create an 'input box'? Sarah Sarah

Is there a way to have a report ask a user what page number to begin with and then have it insert that requested page number into the page footer? it would also need to have each page go sequential with the given page number? Any help would be appreciated.