Recent content by Noel2

Thanks Remou, but the issue is not addressed in any of those posts. It appears that the issue that I already know how to fix is addressed where you can set it up to look like the following: group header1 ' ' group header2 ' -----end of page----- group header2 (continued) ' ' ' But, what I am...

I would like to get my group header to produce a message stating continued on next page whenever the group continues onto the next page. I know how to get continued to show up in the group header when it repeats on the next page, but not how to put in "continued on next page". What I have...

The only other thing that I could think of is to check the format of the table beneath the query. Double check and make sure that it is date/time. It really shouldn't matter, but it may be a good thing to check. Just to troubleshoot, I would input this into the control source...

What version of access are you using? Can you e-mail the file? noelbaggett@cox.net

Sorry for the confusion. Make sure you input just this: =Format([Entry Date],"dddd"", ""mmmm d"", ""yyyy") If you are still getting an error, please let me know what the error is and if you have any controls on your report named [Entry Date]. Thank you, Noel

Please show me what exactly you are putting into the control source, and is it coming from a table, query?

In the field where you need the date, put the expression as follows: Format([yourfield],"dddd, mmmm d, yyyy"). This is where yourfield is what ever field that you are pulling the date from. Please post reply if you run into a problem using that.

I would like to create a rectangle to go behind the text boxes and sub reports in the detail section on my report. The problem is that the detail section does not stay the same height and the rectangle needs to expand to the end of the section. I need the rectangle to be filled in black. With...

Graham, I just wanted to let you know that your post was very helpful to me and took care of my problem which was very similar to the other persons problem. I can't tell you how thankful I am that I found your post. Thanks, Noel

I have a problem where I have code that first outputs several different variations of a report into snapshot files, saves them, zips them into a zip file, and then is supposed to e-mail them out. The problem that I have is that I am getting the same error over and over again: Run-time error...

please note that this is the code that I have come up for a combination of the two. But, I still want to zip all of the snapshot files together before I e-mail them off. Please let me know if you have any thoughts: Function RockinLikeFreightTrain() Dim dbsreport As Database Dim...

Thank you very much for the advise

Here is my situation. I have a function that opens up a report that prints out a single report for each value in a query that I have for certain job numbers. I know that I can manipulate this to output each report to a snapshot file and then send them on to each of the co-workers using a...

The only reason I wanted to use the filter property is because I just wanted to learn how to work the filter property in combination with the input boxes and to see if it was possible to do what I was asking. Also, if it wasn't possible, then why it wasn't possible. I could definitely use the...

you know I have that set up right now as a work around. Take a gander at this: on the forms button I have: On Error Resume Next Dim strTemp As Long GStrapEd = InputBox("Please enter start date below:") If GStrappED() = "" Then Exit Sub...