Navneet Kakkar
|
Posted: 02/08/2004, 11:41 AM |
|
I want a list box to show the names of the fields of the table whose name is
input in a text box. this list box will be shown after submission of the
first input form
is there any way to get the names of the fields of a table.
i am using access and asp.
--
Thanks
luv
Navneet
aquananu@yahoo.com
9811153443
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.577 / Virus Database: 366 - Release Date: 2/3/2004
|
|
|
Edd
Posts: 547
|
Posted: 02/08/2004, 2:24 PM |
|
MS Access is not like other databases where you have ready access to the system tables without a lot of hassles.
I would suggest you create a separate table that you can freely populate from vb code such as in http://www.experts-exchange.com/Databases/MS_Access/Q_20833280.html
This is NOT perfect but it will get you around a couple of security hassles that MAY occur if you host off site,
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
Navneet Kakkar
|
Posted: 02/10/2004, 10:46 AM |
|
Dear Edd which is the hassle full path, i wud love to tread the same.
any one from yes software - please guide me, how does ur query builder has
access to field name from an mdb.
i want to build a webbased query generator rather sql generator and executor
which cud interact with the users and on the go generate sql and execute.
a simple form, but only problem is how to list fields in a listbox.
--
Thanks
luv
Navneet
aquananu@yahoo.com
0919811153443
"Edd" <Edd@forum.codecharge> wrote in message
news:64026b72f406f5@news.codecharge.com...
> MS Access is not like other databases where you have ready access to the
system tables without a lot of hassles.
>
> I would suggest you create a separate table that you can freely populate
from vb code such as in
> http://www.experts-exchange.com/Databases/MS_Access/Q_20833280.html
>
> This is NOT perfect but it will get you around a couple of security
hassles that MAY occur if you host off site,
>
> _________________
> a simple idea....
> www.syntech.com.au
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.581 / Virus Database: 368 - Release Date: 2/10/2004
|
|
|
|