| View previous topic :: View next topic |
| Author |
Message |
shivdasn
Regular
Joined: 19 Jun 2005
Posts: 58
Location: India
|
 Posted: May 23rd, 2006 08:21 AM Post subject: How to write a code for "Find" in vb + Access |
 |
|
Hi,
I am writing a kind of a "phonebook" program. But i dont know how to do a "find" a record.
Am using VB + Msaccess as backend db. If any1could just gimme the raw code, i would b "greatfull"......errr.....grateful !!
Thanx a lot in advance.
_________________
..::-- '' D a s ''--::.. |
|
| Back to top |
|
dougthomas
Moderator
Joined: 27 Jul 2005
Posts: 271
Location: Essex, UK
|
| Posted: May 29th, 2006 02:12 AM Post subject: |
|
|
Hi,
You need to use the WHERE clause in the SQL statement
eg
SELECT * FROM phonebook WHERE surname = "Blogs"
will return all entries in the phonebook where the surname is Blogs.
Regards
Doug
_________________
If you can see the light at the end of the tunnel, it probably means there's a Train coming. |
|
| Back to top |
|
|
