[AccessD] Can I have two Access databases at once?
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
> -----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?
> This gets the tables. Over to you to get the fields from them and populate
> 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
> 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
> Website: http://www.databaseadvisors.com
More information about the AccessD