Search results

Pat, thank you so much for your time. I am working to make the necessary adjustment. Do you have a sample report that generated from two tables? Again thank you. Van

Hi Pat, Thanks for getting back, Each loan can have multiple requests (requestdate), it starts with "New Loan" as transaction type, then its can be modified as an "Amendment" or a "Renewal". Each Transaction, there will be documents generated and dated (different from the request date). On the...

Hello, I am learning access and need help with a report that I am trying to generate from two tables. The PDF attachment is a sample of that what I am trying to achieve or something similar, I would greatly appreciate some pointer. If this is not possible, I would greatly appreciate that you...

The result from that short tutorial is close to what I am trying to achieve with the exception that I have an additional table (for exemple OrderComment). Its has OrderComment_customername, OrderComment_date and OrderComment_Comment, I would like all comments to be inserted between costomer and...

Hi Linq, How can I modify your suggested code so that values in the unbound boxes not only update new record but also those are dirty. Thank you. Van

Hi Paul, To better understand, I would greatly appreciate if you could explain the purpose of those apostrophes ( ' ) Me.cboTransactionType = DLookup("TransactionTypeID", "T_TransactionType", "TransactionType='" & strOpenArgs(1) & "'") Thank you. Van

Yes, yes, yessss, thank you! thank youuuuu!!!

What I want to achieve, when a user double on any selection in the list box, the value of the last column (new loan, renewal or amendment) to pass onto the unbound combo box "cboTransactionType" of F_LoanDocuments. Then that value will be the default value for "TransactionTypeID" of new record...

Thank you for your help. Please see attached.

Still no luck, different kind message: "Run-time error '2471': The expression you entered as a query parameter produced this error: 'TransactionID'"

Thanks Paul for your suggestion, but that would not solve my problem. Yes, I think you are right, it is a data miss match. Little background of what I am trying to accomplish, in form one there is a list box (generated by a query) that has 4 columns, but column 1 and 2 are IDs and also hidden...

I found my error, but now I am having another issue with the second value in the strOpenArgs(1). I am keep getting an error message: "Run-time error '-2147352567 (80020009)': You can't assign a value to this object." Is it because that I am trying to pass a alpha value (form one) into a...

Thanks Paul for the reference, What is the meanning of "Run-time error '9': Subscript out of range"? I double checked for spelling, but keep still I am getting that error message "Run-time error '9': Subscript out of range". In my list box contain 4 columns, I need info from column 3 and 4...

Private Sub ListBoxRequest_DblClick(Cancel As Integer) DoCmd.OpenForm "F_LoanDocuments", , , "LoanInfoID=" & LoanInfoID & " And RequestDate = #" & Me.ListBoxRequest.Column(2) & "#", , , Me.List38.Column(2) & Me.List38.Column(3) End Sub Hi John, I added a second column to your...

Hi Linq, What is the meanning of "Method or data member not found"? Your suggested code works fine for the text box, but I keep getting an error above after making a selection in combo box. The combo box contain 2 columns, but the column for ID number is hidden. What did I do wrong? Is it...

Thank you for your time and explanation! I learned something new. Again thanks Van

You nail it, its works. Many many many thanks!!!

Hi Linq, They do, but having those unbound control on the top of the form this will allow user to enter one time only and will eliminate the repetitiveness for the requirement for each record. Information from those fields will automatically feed as default value for the lower section of the...

Hi Linq, Thank you for getting back, I am learning Access and my knowledge is very limited, currently I am trying to build my FIRST data base. Due to my limited knowledge I understand that my data base won't be efficience as suppose to be. I am very thankfull all of you in this forum for...

Its works, Thank you so much Big John for your help and reference!!!!!!!