Search results

I didn't understand that at all. I'm starting to think since I only have 3 people to email these reports to, that it might be easier just to make 3 different reports that are already filtered vs. trying to filter via a combo box & VBA.

I found some code that I think you posted in another thread. I'm tinkering with it now.

Team, I'm trying to figure out how to get access to filter a report based off my selection in a combo box before emailing. So, when I pick "The boss" in my combo box then hit my email button, it would filter all my reports by whats with the boss then email it to him. I'm pretty sure I need...

Nah that didn't work in a macro. It just shows up like you typed it in. [Forms]![Decor6].[Name] I'm not good with VBA at all, i'll keep researching.

Team, I'll try to explain this as best I can. I want to put a button on my form that sends an email that pulls data from the current record i'm on. Example: I'm on Mr. Smiths record. My button should send an email with Mr. Smiths name in the subject line. His name is the data I want my...

Got it. The - was messing everything up. Thanks everyone for the help! As always, ya'll are awesome.

Hmm...not working. It just pops up as #Name? I tried =DateDiff("d",[Decor6 Sent Date],[Date()]) Also tried =Date(), Now(), Today(). I can't seem to get it to calculate todays date - the sent date. Update. Okay I did =DateDiff("d",[Decor6 Sent Date],-Date()) but it just fires out the date...

Team, I'm trying to use an unbound text box to calculate how many days have passed since another date in a form field. All I want the unbound box to show is a number like 12. For example if today is Aug 7 and the date in the form field is Aug 6, my calculation should show 1. I've tried...

Disregard, after some tinkering I figured it out. Instead of trying to add multiple values to filter by, I put in the values I didn't want to show. So in the criteria block I put <>"AFAM" And <>"AFCM" That worked.

Team, How do I add multiple criteria for a report filter? Right now i'm using the Criteria block in the query builder. I know I can type in "MSM" to have it show everything marked as MSM. I need to add 2 more values to the filter. I need the report to only show me only items MSM, BSM and...

Alansidman, that was EXACTLY what I was looking for. I watched the vid when I got home and it worked perfectly. :D

Sorry, yes it's a list box. I checked and multiselect is set to "none". What do you mean set a breakpoint? I'm a rookie.

Okay I followed the link and I think I put the code in right. What happens though is that now when I push my button, it prints a blank report :confused: Here's the modified code: DoCmd.OpenReport "Decorations Pending", , , "Status = '" & Me.List99 & "'" Decorations Pending is the name of...

Team, I have a button called "Run Report" that is supposed to open up a report that is filtered by a selection made in a combo-box. Only 1 selection can be made in the combo-box and there isn't a blank space. For example, if I pick "for signature" as my combo-box selection then hit my...