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 have used the line method to create a rectangle as follows: Me.ScaleMode = 1 Me.ForeColor = 0 Me.DrawWidth = 2 Me.Line (6.4681 * 1440, 0.2083 * 1440)-(1.2 * 1440, 14400), 0, BF And I can't get this to be sent to back. I tried DoCmd.RunCommand acCmdSendToBack and keep...

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

..."N:\Shared\HVAC\One_Source\Timesheets\2003\" & stDogName & ".zip", _ "N:\Shared\HVAC\One_Source\Timesheets\2003\*_ppe_" & stDogName & ".snp", "-yp" mailoutlook.Display dbsreport.QueryDefs.Delete...

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

...date below:") If GStrappING() = "" Then GStrapIng = GStrappED() End If If DCount("*", "qry_po_log_rpt") = 0 Then strTemp = MsgBox("There are no invoices for this period" & Chr(13) & _...

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