Hi Chris, Sorry, for the delay.
I tested this macro against an ODB file connecting to an MDB. The bad news is, it runs just fine. No errors and does just what it is supposed to. If you are still having problems, perhaps you can copy and paste the actual macro you have into an email and post it here. I know that I have spent more time then I would like to admit starring at some little bit of code snippet I've written looking for an errant keystroke, only to have some one else walk up and in 10 seconds point out the mistake...a trait of the human brain I think. Drew On 6/26/07, Chris Moore <[EMAIL PROTECTED]> wrote:
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]
