Andrew,
As odd as it may be 'DocNo:' is actually the column name, not my doing.
I'm accessing the data for this table from an in use Access table, that
I didn't create, so I'm kinda of stuck with the field names for now.
Here's a query that works to bring up the data I need, SELECT * FROM
`ABD` WHERE ( ( 'DocNo:' = :x ) ), just for example.
I had tried the change you suggested from looking at some other macros,
but now I get an error saying "The data content could not be updated.
Syntax error in SQL expression"
Andrew Jensen wrote:
HI Chris,
No the basic with OOo is not the same as VB, or VBA.
OK, you have two problems with the change you made.
oDataForm.Filter = "DocNo: = '" & otextBox.Text "'"
First - DocNo:, just a guess but I bet that isn't actually the Column name
in your database.
Second - the syntax error a second concat character.
oDataForm.Filter = "DocNo: = '" & otextBox.Text & "'"
Let me know if that helps.
Drew
On 6/26/07, Chris Moore <[EMAIL PROTECTED]> wrote:
Andrew,
You mentioned in your example "First - since ClientID is assumed to be a
numeric value there was no need to single quote the text value." for
this line, oDataForm.Filter = "ClientID = " & otextBox.Text. I'm using a
string that is a combination of numerals and letters, ex 'abc123', and I
tried to adjust the line to this, oDataForm.Filter = "DocNo: = '" &
otextBox.Text "'", adding my field name and the single quotes to
encapsulate the alphanumeric string. I keep getting a syntax error and
was wondering is this the proper way to handle an alphanumeric string?
One other question, is the BASIC language used to create the macros just
like Visual Basic or is it Visual Basic?
Thanks for your time and help,
--
Chris Moore
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Chris Moore
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
