Recent content by ffleitas

Hi pwise, I noticed that the ctl was misspelled. Thank you it worked.

Hi pwise, I added the red data but it still does not show. Let me know? Felix

Hello programmers, I have this code in the detail section of the report. The problem is that all the checkboxes are not visible eventhough they have check marks. What can I change to make the checkboxes that are checked to be visible and of course the not checked not visible? Private Sub...

Hello programmers, I have this code on a drop down box in a form. It works well if the numbers are greater or equal to 100. If I select for example a number 28 it brings up 128. Please take a look and let me know where I have gone wrong. Thanks for your assistance. Dim rs As DAO.Recordset...

What I would like is for the propertyid to equal 1 also 2 and also 3 so the report will only print those propertyid's instead of 4, 5, 6, etc. I hope and a bit clearer now? Thanks.

Great it transferred over. How do I get the propertyid to = 1 & 2 & 3 on the report now that propertyid = 12? In other words I only want the values of the propertyid field of 1 & 2 & 3 to show on the report since the value of 12 was transferred. Thanks.

Hello, How can I get the propertyid to equal 1 & 2 & 3 if the propertyid selected from the form = 12? I have the code below placed in the form which is transfered over to the report. On Error GoTo Err_Preview_Click Dim strWhereProperty As String strWhereProperty =...

It worked! Thank you very much. Good Eye.

Hello programmers, I entered this code below in the after update of a drop down box in a form. The string strFilter works well after the selection is made but the strFilterTwo doesn't unless you select it again from the drop down box and then it does the update. Any insights? Private Sub...

Thanks for responding. I tried looking for it in Microsoft's knowledgebase but had no luck. Do you happen to have the Article Number? Thanks, Felix

Hello programmers, How would I go about a report that is half the size of an 8 1/2 x 11 laser printer sheet print the same information that is on the upper half to the lower half of the same sheet in order to save paper and print on the upper half page one and the lower half page two? Thank...

I am selecting Case 2 and changed the <= to just = in order to get the [PaymentsDate] on the 10 of every month. The expression I am using is this one: Case 2 For x = 1 To 12 DoCmd.OpenReport &quot;rptDueDatesBySelection&quot;, PrintMode, , &quot;[PaymentsDate] = #&quot...

I did some test with the values of x by changing For x =1 to 12 to x=9 to 10 and the results only reflected the months of 9. Maybe the loop is not processing all the x values rather the first value only. Hope this helps? Thanks, Felix

Almost there. Does not ask for x anymore. But, the dates retrieved are from ex. 10/10/02 11/10/02 from only one Member. Is there an adjustment to be made to the DateSerial for finding this month and prior months? Thank you, Felix

Sorry, I tried it but it still asks me for x.