[AccessD] Can I have two Access databases at once?
gustav at cactus.dk
Wed Aug 24 01:07:51 CDT 2022
The field list is a no-code part. For that combobox use:
RowSourceType: Field list
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 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
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?
More information about the AccessD