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...

How do you do that in Table properties under Validation Rules property? How can you combine two rules into 1 statement? Thanks. Your Help is Appreciated.

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...