Search results

  1. J

    Tab Page Making me crazy

    That was it. Thanks!
  2. J

    Tab Page Making me crazy

    I've got a tabbed page with a number of labels and controls. I'm trying to create a second tabbed page and for some reason one label and control keep appearing on the new tab page. If I try to delete them from the new tab page they get deleted from the original tab page as well. I've tried...
  3. J

    Graph in a report

    Thank you so much! Really appreciate it!
  4. J

    Graph in a report

    Hummm...that could be a problem. Here it is again.
  5. J

    Graph in a report

    Here you go. Now I can actually see data in the charts, but it doesn't update the data with the selected user. To see what I'm talking about, when you launch the DB the form that opens will have a column on the far right for a summary report. That's what you'll want to select. Thanks for...
  6. J

    Graph in a report

    Thanks for the suggestion. I tried it several different ways, but no dice. I created a new query so the report would only be pulling data from one instead of two queries, but that did help either. I'll open the form and the filter will be applied to the report and the non-graphical data...
  7. J

    Graph in a report

    Hello all: I currently have a form from which users can select their name and it will open a report listing events they have attended. It does this through a macro running a filter (I know, macros suck...but I suck even more at coding in VBA). What I would like to happen is the same criteria...
  8. J

    Dynamically generating a report title based upon a date criteria

    No, there are "Prior Quarter", "Current Quarter" and "Year to Date" buttons. The Year to Date button will work with what you've suggested, but the Prior and Current quarter buttons will not. Example, if I click the Current Quarter button today I would like the report to be titled "First...
  9. J

    Dynamically generating a report title based upon a date criteria

    Hey plog, That makes sense to me up to a point. In your example, where would the value for the str_title come from? Where would that value be grabbed from to dynamically change the title from "First Quarter" or whatever, to "Second Quarter"? Thanks
  10. J

    Dynamically generating a report title based upon a date criteria

    Hello all: I currently have a report setup and the higher ups would like to generate the report by quarters or YTD when ever they feel like it. I've created buttons that allow them to simply click for the prior quarter, the current quarter, or YTD. The problem is I would like the report...
  11. J

    making report monthly,yearly and weekly

    Weekly report: DatePart("ww",[yourdatefield])=DatePart("ww",Date()) and Year ([yourdatefield])=Year(Date()) Monthly report: DatePart("m",[yourdatefield])=x Where x is the numerical value for the month you want Year to Date: Year([yourdatefield])=Year(Date()) and...
  12. J

    Report Sorting Numbers Oddly

    Thank you, sir. I appreciate your help, which was actually useful.
  13. J

    Report Sorting Numbers Oddly

    Okay, so there's nothing odd about the sort. Is there a way to make it sequential?
  14. J

    Report Sorting Numbers Oddly

    Hello all, This is driving me nuts. I have a query the field "Objective" and the data in that field is "A.1", the next record is "A.2" and so forth all the way up to "A.18" I have a report that is pulling its data from that query, but in the report the data shows up in the following...
  15. J

    Yes/No Data on Report

    Ugh. So simple. **Beating my head on desk** Thanks. Sorry for wasting your time.
  16. J

    Yes/No Data on Report

    Hi All, I've got a table that has several yes/no data type fields. I'm trying to the data into a report and show either yes or no as opposed to -1 or 0. Any thoughts?
  17. J

    Converting a check box to Yes or No in report

    You, sir, are the man. Thanks for the quick response!
  18. J

    Converting a check box to Yes or No in report

    This is probably so simple that I'm overlooking it, but I have a check box in a form (set to yes/no in the table) and when I generate a report I would like the check box value to show up as yes or no in text box, but I can't seem to figure it out. Thoughts? Thanks in advance!
  19. J

    Masking data in a report

    You, sir, are a gentleman and a scholar...not necessarily in that order. ;) Worked like a champ. thanks!
  20. J

    Masking data in a report

    Hello all: I just wondering if anyone know if it's possible to mask data in a report? I have a report that contains a field for an ID number. Depending upon who is receiving the report only a partial ID number can be shown. Example: Instead of showing ID#: 123456 the report can only show...
Back
Top Bottom