Search results

Private Sub Form_Click() Dim whereStr As String whereStr = "[BuyerID] = " & Me![BuyerID] & " AND [PropertyID] = " & Me!PropertyID DoCmd.OpenForm "frmBuyersInterestedPropertiesDirectory", acNormal, , whereStr End Sub When I run the form, I was prompted with a screen...

Hi there, Please refer to this line of code below: DoCmd.OpenForm "frmBuyersInterestedPropertiesDirectory", acNormal, , "[BuyerID]='" + Me![BuyerID] + "'" I have tried to customise this (where) statement to display "frmBuyersInterestedPropertiesDirectory" from frmBuyerPropListing when the...

Hello there, How do you build an expression for a text field in the table where it cannot be left blank and the length of the text entered cannot be greater than 10? Is Not Null, is this a valid statement? If so, how do I conbine it with a check for the length of text entered. Thanks

Dear Gurus, I will like to create my own Menu Bar under the following headings and organisation. I have create a toolbar called myToolbar. But I cannot add New Menu from command list the after selecting New Menu from the categories Files View...