Set the DatabaseName Property using no path 
Author Message
 Set the DatabaseName Property using no path

I am using a number of standard data controls to bind DBCombo boxes to
fields and have them filled with the list of data. This all works fine
except that I have browsed to the database with the data control for
the DatabaseName property and again I want to get around having the
database in the specified path.
How can I set the DatabaseName property using no path?
How can I use SQL to select only required data when the RecordSource
has been bound to tables for these DBCombo boxes? - I have tried
putting the SQL in the RecordSource property but this falls over with
required parameter or something. So to get these to work I have bound
the controls to the tables and put the SQL in DBCombo_Click as below:-

Private Sub ADD1_Store_Click(Area As Integer)
Data1.RecordSource = "SELECT STORE.Store_Code FROM STORE WHERE
(STORE.User)=LoggedUser))"
'Data1.Refresh
End Sub

But although the records come back from the table (all records), the
SQL does not refine the search???

Sent via Deja.com http://www.*-*-*.com/
Share what you know. Learn what you don't.



Sat, 29 Dec 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Setting databasename property.

2. set databasename property of many datacontrols

3. Set Database Name property using no path

4. VB3: using .ini for DatabaseName property

5. 3024 error when using DatabaseName property

6. databasename and path...

7. Weird problem assigning path to DatabaseName

8. Relative Paths for DatabaseName

9. databasename property of datacontrol

10. changing data control DatabaseName property

11. changing data control DatabaseName property

12. DatabaseName Property Problem

 

 
Powered by phpBB® Forum Software