Recent content by Lyn Mac

KevinS. . . It's good to know that you were able to sort out the problem. :cool: My working code is actually a combination of those suggested by Ghudson and CollinEssex. Regards, Lyn Mac

I had that problem earlier. I found out that when a form with subform is displayed and edits are being done to the subform the active form is the parent form and not the subform. This seems to be the effect that this line in the Audit Trail had: Set frm = Screen.ActiveForm My...

Thanks Cosmos75 and Alexandre for your efforts. Lyn

You can remove "Dim OpenArgs As String " this is not needed. Replace: DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd, , OpenArgs With: DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd, , Me.SRNumb Me.SRNumb is the OpenArgs HTH, Lyn

Strange, Really Strange MS Access has the real propensity to push us to our limits and get the best in us. Anyway we come out the winner. That's the spirit Jerry. Congrats. Lyn

Another approach Try this on the GotFocus event of the control: SendKeys "^(')" 'Ctrl + ' When the control has the focus the code will execute and the value of the previous record in this control will be copied. HTH, Lyn

BTW, how is this done in an Access Report? Any pointers please. Anybody cares to respond? TIA, _____ Lyn

Many Thanks Alex. Your advice is always most valued. I have looked and copied the code at the Access Web for study. _________ Lyn

Hello folks! I have two tables tblVessel and tblEngine. At any given point in time a Vessel can have 1 or more Engines. So the table relationship is set-up that tblVessel is on the one-side while tblEngine is on the many-side bound by the pkVesselID . Typical field in the tblVessel is...

Access 2000 has this feature. In the Menu Bar go to Tool/Options then click the "General" tab. In the upper right portion of the form there is a rectangle with Name Autocorrect and below that are three check boxes with the first box = Track name autocorrect info. WARNING !!! MS has...

Fizzio: Thanks for the clarification.:o blueBeard: Good to know that you got it working:) . Lyn

On the form's OnCurrent Event try: If IsNull(Me.FieldName) Then Me.FieldName.Visible = False Else Me.FieldName.Visible = True End If Note: Substitute FieldName with the actual name of your field. HTH, Lyn

Assuming that President and Treasurer are Officers and Regular Member are not. In the format or print event of your report try: If Me.MemberRole = "President" Or Me.MemberRole = "Treasurer" Then Me.MemberRole.FontWeight = 700 'Bold Else Me.MemberRole.FontWeight = 400 'Normal End If Lyn

To vangogh228: I thought that your problem had been solved when we had this discussion of this topic on this thread: http://www.access-programmers.co.uk/ubb/Forum1/HTML/007966.html However, if you could post your feedback on what happened when you implemented that link from MS Knowledgebase...

DoCmd.OpenForm "NewForm",,,,acFormAdd