John O'Malvern's latest activity
-
JJohn O'Malvern reacted to Gasman's post in the thread Debugger complains about [apparently] non-existant characters with
Like.
Is there actually a control in the form and a field called [Contact ID] in the report source? -
JJohn O'Malvern reacted to Minty's post in the thread Debugger complains about [apparently] non-existant characters with Like.
That would suggest (rather obtusely I'll admit) that Me.[Contact ID] is null. After you set strWhere add the following line Debug.Print...
-
JJohn O'Malvern reacted to CJ_London's post in the thread Debugger complains about [apparently] non-existant characters with Like.
I presume contact id is numeric?
-
JJohn O'Malvern reacted to The_Doc_Man's post in the thread Debugger complains about [apparently] non-existant characters with Like.
The error "can't find |n referred to in ..." suggests that something is spelled or referenced incorrectly. Since it is calling out |1...
-
JJohn O'Malvern replied to the thread Debugger complains about [apparently] non-existant characters.Ironically, ContactID /doesn't/ have a space, although many other FN do. so that wasn't helping, but Gasman suggested the actual...
-
JJohn O'Malvern replied to the thread Debugger complains about [apparently] non-existant characters.Spot on! I've illustrated the dangers of using something that already works in one situation, but now in a different way, and 'coming a...
-
JJohn O'Malvern posted the thread Debugger complains about [apparently] non-existant characters in General.I'm using this code to open a form in print preview: Private Sub cmdPrint_Click() Dim strWhere As String If Me.Dirty Then...
-
