How to select another DatabaseName while running



Hi,

I want to be able to select another database for my query while running
a form. Does anyone know if this is possible. In this case I don't mean
hardcoding it like: qry1.DatabaseName := 'XXX';
What I actually need is pull down list with the avaiable data sources,
just like u get in the Object Inspecter. Please help.
Thanx,

Peter

.



Relevant Pages

  • help with sql
    ... Sangster, Derek; Williams, Mary G; Phillpot, Mark ... 29 Cunningham, Peter; Richards; Peter ... I am query database so can only use SQL and not procedures PLSQL. ...
    (comp.databases.oracle.misc)
  • help with sql
    ... Sangster, Derek; Williams, Mary G; Phillpot, Mark ... 29 Cunningham, Peter; Richards; Peter ... I am query database so can only use SQL and not procedures PLSQL. ...
    (comp.databases.oracle.misc)
  • Re: sort out one months
    ... MS Access MVP ... >I have a database of projects. ... > specific month how can I make query etc. ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • New Column to DataSet.DataTable
    ... I am making a query to a database, ... and datasource is not to be updated. ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Multiple Time criteria
    ... I have a database that records several times. ... I need to report on time ... I am using a select query to gather the data. ... Prev by Date: ...
    (microsoft.public.access.queries)