Search results

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!

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!

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!

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

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

AutoNumber (Long Integer)

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

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

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

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

bumpity bump bump

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

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

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

/facepalm thanks, access.

I just need to have a detail section for every group I create and it will work perfectly. Is that possible?

I have absolutely no idea why this fixed it, but it did. http://forums.techguy.org/business-applications/795546-solved-return-without-gosub.html

I'm making a report that needs to have more than one detail section.. one for each group I create. Each group shows a different activity: Projects, Misc., Special Assignments. The header for each group shows different captions (in bold on the attached picture) which differ depending on which...

The database is in a trusted location. There weren't any set until today, after this started happening. Like I said this wasn't a problem at all until this morning.. I've been working on this for several weeks. I've set the exact folder it's in on a network drive to a trusted location in Access...

Bob- Thanks for the reply. I have "Enable all macros" selected by default. I switched to the option you show selected, but that didn't cause any change. But wouldn't I want my macros enabled?