Data Cotrol (DAO) and Index 
Author Message
 Data Cotrol (DAO) and Index

Your database has no key,

you could try this code instead

dim strParm as string
dim strSearchme as string

strSearchme = InputBox("Please enter info to search for")
if not strSearchme = "" then
strParm = "Select * from [Name of your Table here] _
where [Field name here] = '" & strSearchme & "' Order by _
[Field Name] ASC"
data1.recordset.recordsource = atrparm
data1.refresh
end if

'This just passes an SQL search to an access database you
'attached to data1 hopefully this is self explanitory if not
'email me    Jason

   -**** Posted from RemarQ, http://www.*-*-*.com/ ****-
 Search and Read Usenet Discussions in your Browser - FREE -



Tue, 14 May 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Data Cotrol (DAO) and Index

2. DAO - Fill in foreign key with correct PK index from a string-data table

3. Data Cotrol Question?

4. HELP! Using queries w/ Data cotrol

5. vb5 data cotrol sorting?

6. ADOC Data cotrol

7. How to insert data from un-indexed tabel to indexed table

8. Too many indexes - Wierd hidden indexes preventing index add

9. Creating Indexes with DAO

10. Add field to index thru DAO

11. Add field to index thru DAO

12. DAO and Adding Index to a Table

 

 
Powered by phpBB® Forum Software