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

[Gustav Brock]

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