Queries in a Listbox

  • Thread starter Thread starter SeRene
  • Start date Start date
S

SeRene

Hi, I have two listboxes and two command buttons. Each
command button for each listbox.
My 1st question is, how do i allow not ALL queries in my
Access DB, but a few selected queries which i want, to
appear in the 1st listbox?
The same goes for the 2nd listbox. I need to know how i
can display not ALL tables but just a few tables from my
Access DB, which i want them to appear in the listbox.

As for the command buttons, they actually have the caption
of "Import".
My 2nd question is, how can i make the Access application
recognise the table or query which the user selects from
the listbox, so that the appropriate importation action
can take place.

Example: User just selected "Customer Name" from the
listbox which contains TABLES. When user select "Customer
Name" table from the listbox, they can click on
the "Import" command button and the correct data from an
external file, like MS Excel will be imported
into "Customer Name" Table.

Badly need help on this!
Thanks.
 
1. I would make a table, and populate it with the queries that the user is
allowed to see, and omit the ones they can't.

2. You can use VBA to build the Query SQL for you, and use the value from
the listbox. If you know VBA, ping back, and I'll help you with the syntax.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Hi there,

I cant really write codes so do you think you can help me
on this? I need help on this badly!!!
Thanks a million!!
 
Back
Top