[AccessD] Table Names in ComboBox

Terri,

A query:
"Select * From MSysObjects In 'db-Path' Where Type = 1"

Michael R. Mattys
www.mattysconsulting.com

----- Original Message -----
From: "Terri Jarus" <jarus at amerinet-gpo.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, June 05, 2003 8:12 AM
Subject: [AccessD] Table Names in ComboBox


> Here's my sob story - someone accidentally overwrote a database that I
didn't specifically backup to another location.  Our network people say that
databases don't restore correctly from their backup - my bad!  Can't believe
I didn't save my own backup - I usually do.
>
> Anyway, I have done this before but can't remember how I did it.  I need
to populate a combobox (listbox?) with the table names from another
database.  The user then selects a table name from the list to import into
the current database.
>
> I apologize for asking for help with this, but I need to recreate the
database structure ASAP and don't have time to play around.
>
> I appreciate any input - thanks so much for your help.
>
> --------------------------------------------------------------------------
-
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individuals or entities to whom they
> are addressed. If you have received this email in error please return
> it to the sender, and erase any copies thereof.
> Copyright 2003 Amerinet 1nc.
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com