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  

Table not in List to Append to



 
 
Thread Tools Display Modes
  #1  
Old July 8th, 2008, 05:51 PM posted to microsoft.public.access.queries
MIG
external usenet poster
 
Posts: 18
Default Table not in List to Append to

I must be missing something really obvious, but I want to append some
rows to a table I've created, but when I change my query type to
Append, the list of tables I can choose to append to omits the table I
want, while showing the others.

The one I want to append to does appear if I try to show a table to
select from (but it has nothing in it yet).

What could prevent the table from being available to append to?

Thanks.
  #2  
Old July 9th, 2008, 12:24 AM posted to microsoft.public.access.queries
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Table not in List to Append to

MIG,
this can happen with A2003 with SP3 and hotfix - if the table you want is
the first one on your list of tables.
The work around is to create a new dummy table with a name like A1.
This new dummy table goes to the top of the list and when you want to append
to your other table you should be able to see it in the list.


Jeanette Cunningham -- Melbourne Victoria Australia


"MIG" wrote in message
...
I must be missing something really obvious, but I want to append some
rows to a table I've created, but when I change my query type to
Append, the list of tables I can choose to append to omits the table I
want, while showing the others.

The one I want to append to does appear if I try to show a table to
select from (but it has nothing in it yet).

What could prevent the table from being available to append to?

Thanks.



  #3  
Old July 9th, 2008, 10:43 AM posted to microsoft.public.access.queries
MIG
external usenet poster
 
Posts: 18
Default Table not in List to Append to

On 8 Jul, 17:51, MIG wrote:
I must be missing something really obvious, but I want to append some
rows to a table I've created, but when I change my query type to
Append, the list of tables I can choose to append to omits the table I
want, while showing the others.

The one I want to append to does appear if I try to show a table to
select from (but it has nothing in it yet).

What could prevent the table from being available to append to?

Thanks.


An update to this. I renamed the problem table, and then it appeared
in the list of those that I could append to, but one of the others
disappeared.

I think I have worked out the context of the bug. The drop-down when
you try to select a table to append to doesn't include the first table
in alphabetical order. This was only particularly noticeable when I
had a very small number of tables.
  #4  
Old July 9th, 2008, 12:15 PM posted to microsoft.public.access.queries
MIG
external usenet poster
 
Posts: 18
Default Table not in List to Append to

On 9 Jul, 00:24, "Jeanette Cunningham"
wrote:

Thanks, this has crossed with my realisation that this must be
something to do with the first alphabetical filename.

Unfortunately, the Google Groups archive seems to be about a day out
of date at the moment, so my follow-up to my own message won't appear
for a while (nor will this).


MIG,
this can happen with A2003 with SP3 and hotfix - if the table you want is
the first one on your list of tables.
The work around is to create a new dummy table with a name like A1.
This new dummy table goes to the top of the list and when you want to append
to your other table you should be able to see it in the list.

Jeanette Cunningham -- Melbourne Victoria Australia

"MIG" wrote in message

...



I must be missing something really obvious, but I want to append some
rows to a table I've created, but when I change my query type to
Append, the list of tables I can choose to append to omits the table I
want, while showing the others.


The one I want to append to does appear if I try to show a table to
select from (but it has nothing in it yet).


What could prevent the table from being available to append to?


Thanks.- Hide quoted text -


- Show quoted text -


 




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 10:21 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.