Quote:>I recently purchased Visual Basic. I am trying to learn how to
>studyoing the Microsoft Programmer's Guide. Occasionally I run into
>walls. I am looking for someone or group to help me get over
Quote:>First you add an Ado Data Control. The connectionstring is easy. I
>trouble with the record source. The book gives the example
>Select * From MyTableName Where CustID = 12
>When I type this into the SQL Space I get an error message telling me
>bata base cannot be found. I cannot figure out what is the correct
>statement. If anyone can help please let me know.
You're supposed to replace MyTableName with a valid table name!!!
In my version of the NorthWinds database, the following works:
Select * From Customers Where CustomerID = "ANTON"
You may have a different version of the database where any of the
following may be true:
- CustId is really called CustomerId, or perhaps something else
- CustomerId is not numeric, as your example implies, but
alphanumeric, so its parameter value must be enclosed in quotes
- CustomerId does not have a cusomer 12, but does have "ANTON"
Try having a look at your version of the NorthWind database, either
with some version of Access, or perhaps with an Access viewer, if you
can find one.
Help fight Alzheimer's, Cystic Fibrosis and Mad Cow Disease