Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Noel2
  • Order by date
  1. Noel2

    group header "continued on next page"

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

    group header "continued on next page"

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

    Date Format for Report

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

    Date Format for Report

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

    Date Format for Report

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

    Date Format for Report

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

    Date Format for Report

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

    Rectangles and Line Methods

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

    problem with rounding!

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

    E-mailing Zipped Reports

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

    zip up several reports and then send

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

    Refiltering a report on No Data

    Thank you very much for the advise
  13. Noel2

    zip up several reports and then send

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

    Refiltering a report on No Data

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

    Refiltering a report on No Data

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

    Refiltering a report on No Data

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

    problem with running sum and total in sub report

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

    am/pm not registering in calculation

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

    am/pm not registering in calculation

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

    Problems with Formulas after transfer

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

Part and Inventory Search

Back
Top