B
Bart Mermuys
Hi,
Sorry for the late reply, but unfortunately i don't know such place. But
there is a jetsql reference file, if you have Access2003 installed, do a
local search for the JETSQL40.CHM file.
HTH,
Greetings
max said:Hi,
Bart Mermuys said:Hi,
max said:Hi Robin,
I have an access db; in my form I have a textbox; on it, click on data
menu, added a new query, gave it a name and put it in query text:
SELECT * FROM table WHERE name LIKE name + '*' (I'm not really sure it's
the right syntax for querying an access db).
Try:
SELECT * FROM table WHERE [name] LIKE ? + '%'
JET uses unnamed parameters (?) and % as wildcards.
HTH,
Greetings
It works fine!
I just add a query from the TableAdapter Icon using the query wizard,
paste the code you wrote, then designer adds a button and a textbox, and I
wrote on it just some digit to get the results I was expecting!
It was an Access issue. I didn't expect it was so hard to work with Access
db in VS2005, I find only sql samples in internet...
Do you know a place where I can learn more about SQL statements for Access
db in a VS2005 environment?
Sorry for the late reply, but unfortunately i don't know such place. But
there is a jetsql reference file, if you have Access2003 installed, do a
local search for the JETSQL40.CHM file.
HTH,
Greetings