[AccessD] Can I have two Access databases at once?

Arthur Fuller fuller.artful at gmail.com
Wed Aug 24 03:48:24 CDT 2022


Thanks a lot, Paul and Gustav and Stuart. Much appreciated.

On Wed, Aug 24, 2022 at 2:08 AM Gustav Brock via AccessD <
accessd at databaseadvisors.com> wrote:

> Hi Arthur
>
> The field list is a no-code part. For that combobox use:
>
> RowSource:              TableName
> RowSourceType:  Field list
> ColumnCount:            1
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> På
> vegne af Stuart McLachlan
> Sendt: 23. august 2022 23:53
> Til: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Emne: Re: [AccessD] Can I have two Access databases at once?
>
> Yes.
> This gets the tables. Over to you to get the fields from them and populate
> comboboxes.
>
> Function ListTables(myDB As String) As Long Dim db1 As dao.Database Dim
> tdf As TableDefs Dim td As TableDef Set db1 = DBEngine.OpenDatabase(myDB)
> Set tdf = db1.TableDefs For Each td In tdf
>     Debug.Print td.Name
> Next
> End Function
>
> On 23 Aug 2022 at 10:11, Arthur Fuller wrote:
>
> > I have a utility module which, as written so far, works with the
> > CurrentProject. Unfortunately, that means I have to import it into
> > each database I want to work with. What I'd rather do, if possible, is
> > to pass in the name of the database to process, so that this utility
> > could stand on its own.
> >
> > Is this possible?
> >
> > --
> > Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur


More information about the AccessD mailing list