Search results for query: *

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

I sure hope someone can help me with this. On the Open event of the Report I ask the user for a beginning date and an ending date to filter the data on as follows: Private Sub Report_Open(Cancel As Integer) Dim strFltr As String GStrapEd = InputBox("Please enter start date...

here is the ordeal. I have a subreport that I pull a total of invoices from and place that into my group footer and use the formula: =IIf([rpt_invo_bkup_lbr_sub].[Report].[HasData]=-1,[rpt_invo_bkup_lbr_sub].[Report]![lbr_csh_ttl],0) to attain this total. This works swimmingly until I do...

nevermind... I apologize for posting this... I just figured it out. Made it more complicated than it needed to be. ="Last Modified on " & Format(Date(),"Long Date") & " at " & Format(Time(),"h:nn am/pm") did the trick. Thanks

This is probably a quick fix, but I can't for the life of me figure it out. I have a text box in my page footer on my report where I would like it to turn out like the following: Last Modified on Monday, August 04, 2003 at 1:45 pm The problem that I am having is that it is not pulling this...

Doug I truly appreciate that. I am kind of confused as to why this worked. What is the reasoning in having this work instead of the currency field working? Do you know? I would really like to learn if you have the answer. Also, this has corrected the problem with the excel one, but what...