A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can't see existing table in Design view for a QBE



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2010, 01:35 AM posted to microsoft.public.access.queries
DontKnow
external usenet poster
 
Posts: 47
Default Can't see existing table in Design view for a QBE

Hi Guys,

I can't see a table in QBE even when I have the scroll bar as far left as I
possibly can. I have joineed another table to the query and I can see the
relationship link but am unable to scroll left to view the table.

Does anyone know how to fix this??

Many thanks in advance,

Cheers,
  #2  
Old May 19th, 2010, 02:24 AM posted to microsoft.public.access.queries
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Can't see existing table in Design view for a QBE

On Tue, 18 May 2010 17:35:01 -0700, DontKnow
wrote:

Hi Guys,

I can't see a table in QBE even when I have the scroll bar as far left as I
possibly can. I have joineed another table to the query and I can see the
relationship link but am unable to scroll left to view the table.

Does anyone know how to fix this??

Many thanks in advance,

Cheers,


Open the QBE; select one of the tables, and release the mouse. Press the TAB
key repeatedly until you get to the vagrant table. You'll probably then want
to press the DEL key to delete it, and reinsert it.

Or, just go to SQL view; copy the SQL out to Notepad; delete the query;
compact; and recreate the query from the SQL.
--

John W. Vinson [MVP]
  #3  
Old May 19th, 2010, 03:25 AM posted to microsoft.public.access.queries
DontKnow
external usenet poster
 
Posts: 47
Default Can't see existing table in Design view for a QBE

Hi John,
Thnaks for your input...
I tried both of your suggestions and neither worked!

The only thing I can think of is to start the query again? ie start with a
new query add the tables and the linkages and the required fields... Is
their anything else that I can do??

Cheers,

"John W. Vinson" wrote:

On Tue, 18 May 2010 17:35:01 -0700, DontKnow
wrote:

Hi Guys,

I can't see a table in QBE even when I have the scroll bar as far left as I
possibly can. I have joineed another table to the query and I can see the
relationship link but am unable to scroll left to view the table.

Does anyone know how to fix this??

Many thanks in advance,

Cheers,


Open the QBE; select one of the tables, and release the mouse. Press the TAB
key repeatedly until you get to the vagrant table. You'll probably then want
to press the DEL key to delete it, and reinsert it.

Or, just go to SQL view; copy the SQL out to Notepad; delete the query;
compact; and recreate the query from the SQL.
--

John W. Vinson [MVP]
.

  #4  
Old May 19th, 2010, 04:08 AM posted to microsoft.public.access.queries
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Can't see existing table in Design view for a QBE

On Tue, 18 May 2010 19:25:01 -0700, DontKnow
wrote:

Hi John,
Thnaks for your input...
I tried both of your suggestions and neither worked!


WHAT???

You copied the (text only, no image information) SQL out.

Deleted the query.

Compacted the database.

Recreated the query by copying the SQL into the SQL window of a new query.

And it put the image back offscreen!???

What Access version?
--

John W. Vinson [MVP]
  #5  
Old May 19th, 2010, 05:00 AM posted to microsoft.public.access.queries
DontKnow
external usenet poster
 
Posts: 47
Default Can't see existing table in Design view for a QBE

Hi John,

I tried again with:
1. taking a copy of the SQL from the original query with the rogue table not
able to be seen on the QBE
2. copying the sql from 1 into a new query and it worked no problems, with
all tables able to be seen!! (without having to compacted)

many thanks for your assistance

cheers, Access 2003 by the way



"John W. Vinson" wrote:

On Tue, 18 May 2010 19:25:01 -0700, DontKnow
wrote:

Hi John,
Thnaks for your input...
I tried both of your suggestions and neither worked!


WHAT???

You copied the (text only, no image information) SQL out.

Deleted the query.

Compacted the database.

Recreated the query by copying the SQL into the SQL window of a new query.

And it put the image back offscreen!???

What Access version?
--

John W. Vinson [MVP]
.

  #6  
Old May 19th, 2010, 02:43 PM posted to microsoft.public.access.queries
Kathy R.[_3_]
external usenet poster
 
Posts: 25
Default Can't see existing table in Design view for a QBE

Is your query in a front-end and the table in a back-end? If so, make
sure they're linked correctly. I recently tried creating a query and
couldn't find see the tables after I had added them. Didn't receive any
kind of error message or anything; scrolled all over the place and still
couldn't find them. I finally realized I hadn't re-linked my tables.

Kathy R.

DontKnow wrote:
Hi John,

I tried again with:
1. taking a copy of the SQL from the original query with the rogue table not
able to be seen on the QBE
2. copying the sql from 1 into a new query and it worked no problems, with
all tables able to be seen!! (without having to compacted)

many thanks for your assistance

cheers, Access 2003 by the way



"John W. Vinson" wrote:

On Tue, 18 May 2010 19:25:01 -0700, DontKnow
wrote:

Hi John,
Thnaks for your input...
I tried both of your suggestions and neither worked!

WHAT???

You copied the (text only, no image information) SQL out.

Deleted the query.

Compacted the database.

Recreated the query by copying the SQL into the SQL window of a new query.

And it put the image back offscreen!???

What Access version?
--

John W. Vinson [MVP]
.

  #7  
Old May 20th, 2010, 12:03 AM posted to microsoft.public.access.queries
DontKnow
external usenet poster
 
Posts: 47
Default Can't see existing table in Design view for a QBE

Hi Kathy,

No the tables have not been split... and they defintely were linked
correctly.

Unfortunately for me one of the tables could not be seen. The only way that
I could see them, was as John pointed out was to copy the SQL into a new
query and switch to design view. Then the all tables were able to be seen...
Just doesn't figure does it!!

cheers,

many thanks for your input though,
"Kathy R." wrote:

Is your query in a front-end and the table in a back-end? If so, make
sure they're linked correctly. I recently tried creating a query and
couldn't find see the tables after I had added them. Didn't receive any
kind of error message or anything; scrolled all over the place and still
couldn't find them. I finally realized I hadn't re-linked my tables.

Kathy R.

DontKnow wrote:
Hi John,

I tried again with:
1. taking a copy of the SQL from the original query with the rogue table not
able to be seen on the QBE
2. copying the sql from 1 into a new query and it worked no problems, with
all tables able to be seen!! (without having to compacted)

many thanks for your assistance

cheers, Access 2003 by the way



"John W. Vinson" wrote:

On Tue, 18 May 2010 19:25:01 -0700, DontKnow
wrote:

Hi John,
Thnaks for your input...
I tried both of your suggestions and neither worked!
WHAT???

You copied the (text only, no image information) SQL out.

Deleted the query.

Compacted the database.

Recreated the query by copying the SQL into the SQL window of a new query.

And it put the image back offscreen!???

What Access version?
--

John W. Vinson [MVP]
.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.