Ever Improving
Last Activity: Nov 12 '12, 12:16 AM
Joined: Oct 26 '12
Location:
-
zmbd I will take everthing you have said under advisement and get back to you. I really appreciate your detailed attention to this matter. -
zmbd: Used the code you suggested, adjusted to fit my intended application, as follows:
...Code:Private Sub List114_Click() Dim selectedrow As Integer, Upline ID As Integer, Upline First Name As String, Upline Last Name As String On Error GoTo List114_error_trap ' 'Fetch the details about the selected item in the listbox selectedrow = Me.List114.ListIndex [Upline ID] = Me.List114.Column(0, selectedrow)
Last edited by zmbd; Nov 11 '12, 10:42 PM. Reason: PLEASE, please, please, use the <CODE/> button to format your code.Leave a comment:
-
Thanks zmbd. Will let you know how it turns out.Leave a comment:
-
NeoPa Thanks for the info. Will let you know how it turns out.Leave a comment:
-
NeoPa Although, I still have not found a solution to the problem at hand I have begun to review your information related to debugging. Again, I appreciate your attention to this matter. It is good to know that you feel I am heading in the right direction.Leave a comment:
-
zmbd I appreciate your contribution to this dialogue. To answer your earlier question: Yes, the fields are bound to a table.Leave a comment:
-
First of all; I appreciate both your responses.
zmbd: It was suggested that I could use: =[List114].[Column](3) in one of the receiving field's, control source property. The prhase: "Doesn't work", means the fields don't auto-populate when the selection is made from the combo / listbox. I have tried both possibilities.
NeoPa: I am taking your instructions under advisement. However, I am new to coding and even...Leave a comment:
-
Would someone be so kind as to provide an example of how to filter from the example I cited with the manager report and staff report , so that only, one, not all the managers appear on the report.
What would be great is if I could put a combo or listbox on the form and have the person select the manager and have only his / her report and subreport appear and ready to print. Or even a pop-up criteria box would suffice. I tried to filter...Leave a comment:
-
Auto-filling fields on a Form using a Selection from a Listbox
I have tried these and multiple combination of codes (from multiple websites) and non of them work for this seemingly simple task. I am using Access 2007. I have 3 fields I would like to auto-populate from a selection in a list box. The list box is controlled from a query. All the fields are included in the query grid. The query is listed as the control source
The following code worked for me in Access 2003:
...Code:Private
Last edited by zmbd; Nov 4 '12, 02:07 PM. Reason: Please use the <CODE/> button to format your posted code. -
Thanks to both The SmileyCoder and Rabbit. I'll try your suggestions and report back.Leave a comment:
-
Creating a report from a subform
I have created a report from a subform. However, there is one nuance I have not been able to formulate. To give a little background. I have a table (Managers) and table (Staff). The main form information is related to the managers table. While the sub form is related to the staff reporting to that manager. It all works fine, except that I would like to create individual reports for each manager, rather than one continuous report that includes...
No activity results to display
Leave a comment: