If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
[ACC2003] Add tables and queries dialog does not show queries
Hi,
I, and some collegues of mine, are running into a weird problem with Access 2003. If I want to define a new query (or want to add a table or query to an existing query), Access shows a dialog with three tabs: Tables, Queries and Both (the exact names may be off, I am using a Dutch version of Access). From this dialog, you can select the tables and queries to use in your new query. However, the problem is that switching the tabs does not seem to have any effect: the list of database objects just displays all the tables, but no queries. This is very annoying, as I frequently build queries on existing queries. The only way to add them to the visual query designer now is to switch to SQL view, enter some SQL with the query name in it, and then switch back to the visual designer. I have tried to search for a solution online, but the problem is that I can not think of a set of set of search terms that yield anything usefull. The terms all seem to general to use here unfortunately. Can anybody here point me in the right direction? André |
Thread Tools | |
Display Modes | |
|
|