Search results

I understand. Will post a copy. I don't think it is that simple because of the links I have. Thank you!

Hi everyone, I will attempt to explain this best I can by taking an example other than what I am doing... to simplify my request. Let's say you have a classroom diagram - student seat, windows, blackboard... and so on. It is in the report as a picture. I want to position the name of the...

Hi Arnel, I don't see the answer I need... I would like my combo box to autocomplete on typing BUT still have it set at : Limit to List = NO. Further, I DO NOT want the new data to be added to the underlying table. How would I accomplish that? Thank you!

Excellent. Thank you~!

Wow - explanations are detailed - terrific! So, if the report footer is not satisfactory, adjust the number in red to a lesser value... Great. How do you test with me.top value? You insert that in the query? Should I keep my other code (module) that works in the other reports? And simply...

Thank you for the quick response Arnel. Here is a sample where the following reports work fine: rptLease_AnnexA, rptLease_AppenA, rptNotice_MovingOut. With the same coding, used and working in all other reports, the rptLease_AppenC does not. Very confusing to me. Thanks for your help! I...

Dear Arnel - please help! I used the above module and it worked great! But now, on a much longer report, with subreports, I get the blue circle spinning non stop, then the report show "not responding". Can you assist? I love that module!

Here is what worked great for me: Copy and insert this function into your database: Public Function fnENdate2FR(ByVal vParam As Variant) As String Dim arrFrenchMonths As Variant arrFrenchMonths = Array("janvier", "février", "mars", _ "avril", "mai"...

Tried: Docmd.openform "frmUnitUpd_ParkingFees",,,"[PkgID]="& PkgID. Opens the form, does not enter the PkgID. Also ignores that the form is continuous despite having "Yes" to : Control Box, Navigation buttons, Record Selector. When I open the form - not using the command button - it looks...

Glad it works somewhere, lol ! English (UnitedStates) - English language MS Access 2010 Does this help? Can you send me a working copy of the dtb sample I provided? THANK YOU!

Thank you Ben. Replacing comma with minus sign did nothing. No rush - Happy Easter!

You mentioned the Parking table but what about fixing the first combo box that you assisted me with - the TransactionTo combo box? It is not retaining the data. Again, could be something I have not copied properly...

"Remember that in your parking table, you have unitnum = 1 without a link to tenantID. So when starting the database, you're mainform starts with Unitnum=1, so your results in this combo are 0 at start." I am confused here - in tblParking, there is a field TenantID. I don't see where I have...

Hi, Perhaps with my limited knowlege, I am not using the proper terminology. It is a continuous form, set to PopUp = Yes. I believe I cannot "imbed" the form as both the frmUnitUpd_Parking and frmUnitUpd_ParkingFees are continuous. So this is the reason I put a command button. But, as I...

Here it is. THANk YOU!!!! I also want to do the same thing with the Parking section where you see the label "Owner"

Preparing it right not (sorry had deleted it after incorporating in my Master)

Hi all ! I think I found the coding I need on this site. But I would not know how to adapt it. I would like an auto text completion combo box that will save NEW data entry so it can be used in the following records. This is what I found. If this coding is correct, can you please identify...

Hi everyone! I have a form: frmUnitUpd with a subform: frmUnitUpd_Parking based on tblParking. In the subform, I have a command button to open a popup form called : frmUnitUpd_ParkingFees, based on tblParkingFees. The Parking and the Parking Fees table are linked by : PkgID which is the...

Been reading... and testing. Explanation is great. Got a major problem though: On the procedure you gave me initially, the drop down DOES NOT retain the data. I had not noticed that before. Have no idea how to fix this. Please assist.

I am playing with it for another subform. No success yet. It here what I need to understand: cboTransactionTo_2.RowSource = " SELECT tblTenant.tenantid, tblTenant.LastName & "","" & tblTenant.FirstName " & _ Ok that part seems easy: It is the name of the control + an underscore and a 2...