Recent content by brosenfelt

Thanks for the perspective. The principal outstanding is actually a field value - and not a calculated one - but I get the point. I've followed your thoughts on two queries and have found a good solution that way - thank you!

Hello, I'm using an IIF statement to display the results of another expression I've created in the query (i.e. if one of them is blank, select the other). I'm getting a syntax error when running the query: SELECT [Credit Portfolio].[Credit Specialit Assigned], [Credit...

ARgh! I'm a dummy -- the field was formatted as text. Changed the field definition to DATE/TIME -- and works fine.

Tried that - but same results. When I change the query to =#9/9/2015# it returns that value. Maybe need to check on the format of the field in the table?

Makes sense / will try when I log in later tonight

I feel dumb asking this -- but I've been banging my head against the wall all day. Here's the query: SELECT pipeline_won_lost.Business, pipeline_won_lost.[Primary Officer Last Name], pipeline_won_lost.Status, pipeline_won_lost.[Actual Close Date] FROM pipeline_won_lost WHERE...

Eureka!!!!!! Works Phew. Thank you for all of your help!!!!!!

I think I got it (will test when I get home): Dim i As Integer Dim lbox As ListBox Dim myPath As String Dim strReportName As String Dim varItm As Variant Dim str As String str = "" Set lbox = Me!List0 myPath = "C:\Users\ROSENBR\Documents\BRC\Report\" If lbox.ItemsSelected.Count = 0 Then...

OK - went back and used the code you wrote: Private Sub Command3_Click() Dim ctrl As Control Dim i As Integer 10 On Error GoTo btnrun_Click_Error 20 Set ctrl = Me.List0 30 For i = 1 To ctrl.ItemsSelected.Count 'Process/loop through selected...

I tried it -- but kept getting the first X number of salespeople in the list...not the specific ones I picked. Ideas?? I've been playing with using "For Each varItm In lbox.ItemsSelected", but having trouble passing the resulting salesperson value to the OpenReport line: Private Sub...

Thanks for doing the mock up. Following your logic, I've got the following (ignore the commented lines from a previous version of the code): Private Sub Command3_Click() Dim i As Integer Dim lbox As ListBox Dim myPath As String Dim strReportName As String Set lbox = Me![List0] myPath =...

Yes, for each salesperson, a report (based on that salesperson) is generated and saved. Then the next, etc. Once complete -- that's it.

Sorry if my last couple of posts were unclear -- several of them were made late last night! The reason I need looping, is that I want to create a SEPARATE report for each salesperson selected from the LIst Box. So, as an example, if I select Bob, Joe, and Mary, I want to create three separate...

So - I've re-written the code a bit....not getting errors....but the code is not passing the value from the List Box to the report -- so I'm getting a blank report. Private Sub Command3_Click() Dim i As Integer Dim lbox As ListBox Dim myPath As String Dim strReportName As String Set lbox =...

And yes....I plan on select multiple salespeople from the List Box on the form prior to running the code.