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 =...
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...
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 "rptDueDatesBySelection", PrintMode, , "[PaymentsDate] = #"...
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
Paul Bricker: I tried your suggestion. Nonetheless, a windows pops up asking for the value of x. Any ideas?
Thanks.
Ken Reay: To explain my situation better, I am trying to get the code to check every month of the year on a certain day 1, 10, 15, and 25. I changed the code from <= to just = to...
Thanks for responding,
I tried your suggestion but I can't seem to get it to work. I am positive that it is my fault. Maybe if I give you a bit more info it would help you assist me. Here is more of a sample of what I am trying to do:
Select Case Me!ReportToPrint
Case 1...
Hello programmers,
I have this code in Visual Basic and I would like for it to check for the first of every month rather than current month. How can I change this code to correspond with my request?
<= DateSerial(Year(Date()), Month(Date()), 1)
Thanks,
Felix
Hello programmers,
I have a module called mdlQuantity. And I would like to run the module from a macro. The only option I see in the macro action is OpenModule. How can I get this module to execute from the Macro?
Sincerely,
Felix
Hello programmers,
I am trying to set the setfocus command to an option box. The error I get is:
Run-Time error '438':
Object doesn't support this property or method
This is what I have in code:
If IsNull(Forms!frmMembersEdit!RepresentativeID) Then
Me!Cleared = No...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.