Recent content by kroenc17

  1. K

    Manual selection of items, creating report from them..

    When I get the problem down to something that specific ie. one piece of code I should be able to figure it out - but starting from scratch? Couldn't have done it without your help, so thanks again!
  2. K

    Manual selection of items, creating report from them..

    Thanks for that - Can I have the report open in 'Report View' instead of just go straight to print? Form is closing now :) Edit 2: AcViewReport ... got 'em. Thanks again for everything!
  3. K

    Manual selection of items, creating report from them..

    So two little things... how do I change the code to have the form automatically close once you generate the report, and how do you generate the report in report view and not print preview? I'm having a go at it now trying to figure it out. Thanks so much again for your help!
  4. K

    Manual selection of items, creating report from them..

    It works PERFECTLY! Thank you so much for your help - LIFE SAVER!
  5. K

    Manual selection of items, creating report from them..

    I thought I'd run into this is an issue... my ID fields name is "Project ID". There's a space (I know that's a no-no, but I'm not the original creator of this DB). After I hit the report button I get the error: I surrounded Project ID with ""s and then I tried ''s, no luck... am I SOL because...
  6. K

    Manual selection of items, creating report from them..

    AutoNumber (Long Integer)
  7. K

    Manual selection of items, creating report from them..

    Thanks for your reply again.. I that one myprojkeys was a mistake, didn't mean to highlight it. My ID field is also the first column in my table, so I'm guessing that my list box should likewise be bound to column 1. It's already a part of the query for the report. For your list box, I noticed...
  8. K

    Manual selection of items, creating report from them..

    So here's your code: Private Sub cmdClear_Click() Me.lstProjects = Null End Sub Private Sub cmdPrintPreviewRPT_Click() On Error GoTo Err_cmdPrintPreviewRPT_Click Dim lngloop As Long Dim strIDs As String Dim myprojkeys As String If Me.lstProjects.ItemsSelected.Count <> 0 Then If...
  9. K

    Manual selection of items, creating report from them..

    THANK YOU this is perfect! Yes, I've been trying to use a List Box for this, not just a check box next to all the projects because there are several. I've been trying to get this to work by macroing a requery of the list box on the after update and setting the data source for the "Project Name"...
  10. K

    Manual selection of items, creating report from them..

    Access '07 1. I need to create a form that lists all the Projects in my database. They need to have a check box next to them. 2. I need to be able to select multiple projects and then generate a report based on which projects are selected. 3. I need a report which shows the selected projects...
  11. K

    Query to show only last entry

    bumpity bump bump
  12. K

    Query to show only last entry

    Pretty simple question: I have a report that shows status entries from the last 7 days. The idea when this was made is that it SHOULD show 1 entry per project assuming the employee entered the status on the right day. Which doesn't always happen. So I want to change the report to show the last...
  13. K

    Need extra detail sections

    Okay thanks Bob, I'll have a crack at this on Monday
  14. K

    Need extra detail sections

    Maybe you can help me, Bob.. I'm overwhelmingly new to Access so forgive me.. the instructions with the tab method wen't completely over my head. I see the Format event but beyond that I'm lost. This creates separate tabs at the top of the report? I've attached the report and design view of...
  15. K

    Need extra detail sections

    /facepalm thanks, access.
Back
Top Bottom