Field aliases not being returned properly in A2007

[Dale Fye]

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Duane Hookom]

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

 

[Dale Fye]

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Duane Hookom]

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Chris]

Hi,
I'm having a similar problem with a query running again a sharepoint list.
When I run the query, the column appears with the field name instead of the
alias name.

Here is my post
http://www.microsoft.com/office/com...a6c3&mid=82abe986-08be-46a8-889e-b111e1ffa6c3

If I run my same query against my original access tables, I get the expected
results.

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP


:

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Duane Hookom]

I'm not sure what would cause this. I will ask tomorrow in a meeting room
with 26 Access MVPs from around the world (and a few MS staff).
--
Duane Hookom
Microsoft Access MVP

Hi,
I'm having a similar problem with a query running again a sharepoint list.
When I run the query, the column appears with the field name instead of the
alias name.

Here is my post
http://www.microsoft.com/office/com...a6c3&mid=82abe986-08be-46a8-889e-b111e1ffa6c3

If I run my same query against my original access tables, I get the expected
results.

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP


:

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Chris]

Hi,
Did anyone have any ideas to why this is happening?
Or any ideas how to make my query work again?

Thanks.

I'm not sure what would cause this. I will ask tomorrow in a meeting room
with 26 Access MVPs from around the world (and a few MS staff).
--
Duane Hookom
Microsoft Access MVP

Hi,
I'm having a similar problem with a query running again a sharepoint list.
When I run the query, the column appears with the field name instead of the
alias name.

Here is my post
http://www.microsoft.com/office/com...a6c3&mid=82abe986-08be-46a8-889e-b111e1ffa6c3

If I run my same query against my original access tables, I get the expected
results.

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP


:

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP


:

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Chris]

To simplify the query, I removed the team table for now, and just rewrote the
query by hand.

so all I have is this now

SELECT E1.EmployeeName As Employee, E2.EmployeeName AS Supervisor FROM
EmployeeName E1
Left JOIN EmployeeName E2 ON E2.ID=E1.Supervisor_Manager;

When I run this against my Access based tables, I get the results I
expected. 160 records, Each employee and the supervisor if they have one
listed.

I then use this exact same query on my linked Sharepoint lists, and it comes
back with 1000's of recrods. Some employees are listed serveral dozen times.

Again, the alias does not appear in the column header of the query, it
lists the field name instead.

Something is way wrong here, is this a bug in Access or Sharepoint? There
has to be a fix, or a different way to design my query to get the results I
need. This has really delayed the project I'm working on.

Hi,
Did anyone have any ideas to why this is happening?
Or any ideas how to make my query work again?

Thanks.

I'm not sure what would cause this. I will ask tomorrow in a meeting room
with 26 Access MVPs from around the world (and a few MS staff).
--
Duane Hookom
Microsoft Access MVP

Hi,
I'm having a similar problem with a query running again a sharepoint list.
When I run the query, the column appears with the field name instead of the
alias name.

Here is my post
http://www.microsoft.com/office/com...a6c3&mid=82abe986-08be-46a8-889e-b111e1ffa6c3

If I run my same query against my original access tables, I get the expected
results.

:

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP


:

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP


:

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Chris]

Another Update,

so I decided to import the list right back into Access (not link) and then I
ran the exact same query on it, now it runs fine. I get exactly the results
I should be getting.

What is going on here?
Why does the query work fine against the Access Tables, but running them on
the Sharepoint List, causes it to blowup and gives me over 200k records.

There has to be a solution to this? Anyone have any ideas?

To simplify the query, I removed the team table for now, and just rewrote the
query by hand.

so all I have is this now

SELECT E1.EmployeeName As Employee, E2.EmployeeName AS Supervisor FROM
EmployeeName E1
Left JOIN EmployeeName E2 ON E2.ID=E1.Supervisor_Manager;

When I run this against my Access based tables, I get the results I
expected. 160 records, Each employee and the supervisor if they have one
listed.

I then use this exact same query on my linked Sharepoint lists, and it comes
back with 1000's of recrods. Some employees are listed serveral dozen times.

Again, the alias does not appear in the column header of the query, it
lists the field name instead.

Something is way wrong here, is this a bug in Access or Sharepoint? There
has to be a fix, or a different way to design my query to get the results I
need. This has really delayed the project I'm working on.

Hi,
Did anyone have any ideas to why this is happening?
Or any ideas how to make my query work again?

Thanks.

I'm not sure what would cause this. I will ask tomorrow in a meeting room
with 26 Access MVPs from around the world (and a few MS staff).
--
Duane Hookom
Microsoft Access MVP


:

Hi,
I'm having a similar problem with a query running again a sharepoint list.
When I run the query, the column appears with the field name instead of the
alias name.

Here is my post
http://www.microsoft.com/office/com...a6c3&mid=82abe986-08be-46a8-889e-b111e1ffa6c3

If I run my same query against my original access tables, I get the expected
results.

:

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP


:

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP


:

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Chris]

Nobody has any thoughts to what the problem might be?

This has totally delayed the project I'm working on, I need this query to
work correctly for reports. It doesn't make any sense to why it doesn't
work against the Sharepoint Lists.

Is this a flaw with how Access and Sharepoint work together?
The query isn't complex, and works fine when ran against the tables in
Access. Been using it for years that way, but now I need to move these to
Sharepoint and it now all of a sudden doesn't work.

I hope someone knows how to fix this.

Another Update,

so I decided to import the list right back into Access (not link) and then I
ran the exact same query on it, now it runs fine. I get exactly the results
I should be getting.

What is going on here?
Why does the query work fine against the Access Tables, but running them on
the Sharepoint List, causes it to blowup and gives me over 200k records.

There has to be a solution to this? Anyone have any ideas?

To simplify the query, I removed the team table for now, and just rewrote the
query by hand.

so all I have is this now

SELECT E1.EmployeeName As Employee, E2.EmployeeName AS Supervisor FROM
EmployeeName E1
Left JOIN EmployeeName E2 ON E2.ID=E1.Supervisor_Manager;

When I run this against my Access based tables, I get the results I
expected. 160 records, Each employee and the supervisor if they have one
listed.

I then use this exact same query on my linked Sharepoint lists, and it comes
back with 1000's of recrods. Some employees are listed serveral dozen times.

Again, the alias does not appear in the column header of the query, it
lists the field name instead.

Something is way wrong here, is this a bug in Access or Sharepoint? There
has to be a fix, or a different way to design my query to get the results I
need. This has really delayed the project I'm working on.

Hi,
Did anyone have any ideas to why this is happening?
Or any ideas how to make my query work again?

Thanks.

:

I'm not sure what would cause this. I will ask tomorrow in a meeting room
with 26 Access MVPs from around the world (and a few MS staff).
--
Duane Hookom
Microsoft Access MVP


:

Hi,
I'm having a similar problem with a query running again a sharepoint list.
When I run the query, the column appears with the field name instead of the
alias name.

Here is my post
http://www.microsoft.com/office/com...a6c3&mid=82abe986-08be-46a8-889e-b111e1ffa6c3

If I run my same query against my original access tables, I get the expected
results.

:

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP


:

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP


:

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Dale Fye]

Chris,

Don't know what to tell you. I've been working this Access app using
Sharepoint Lists as my data repository for about 3 months now. Have not
encountered the problem that you are encountering (wrong number of records
returned). It might have to do with the data type Sharepoint is giving to
the IE or Supervisor_Manager, since as I recall, it really only gives you one
option "Number" instead of Integer, long integer, ...

My problem was/is with aliases, and I've just worked around it. Hopefully,
Duane will get a chance to discuss this at the conference he is at this week.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

Nobody has any thoughts to what the problem might be?

This has totally delayed the project I'm working on, I need this query to
work correctly for reports. It doesn't make any sense to why it doesn't
work against the Sharepoint Lists.

Is this a flaw with how Access and Sharepoint work together?
The query isn't complex, and works fine when ran against the tables in
Access. Been using it for years that way, but now I need to move these to
Sharepoint and it now all of a sudden doesn't work.

I hope someone knows how to fix this.

Another Update,

so I decided to import the list right back into Access (not link) and then I
ran the exact same query on it, now it runs fine. I get exactly the results
I should be getting.

What is going on here?
Why does the query work fine against the Access Tables, but running them on
the Sharepoint List, causes it to blowup and gives me over 200k records.

There has to be a solution to this? Anyone have any ideas?

To simplify the query, I removed the team table for now, and just rewrote the
query by hand.

so all I have is this now

SELECT E1.EmployeeName As Employee, E2.EmployeeName AS Supervisor FROM
EmployeeName E1
Left JOIN EmployeeName E2 ON E2.ID=E1.Supervisor_Manager;

When I run this against my Access based tables, I get the results I
expected. 160 records, Each employee and the supervisor if they have one
listed.

I then use this exact same query on my linked Sharepoint lists, and it comes
back with 1000's of recrods. Some employees are listed serveral dozen times.

Again, the alias does not appear in the column header of the query, it
lists the field name instead.

Something is way wrong here, is this a bug in Access or Sharepoint? There
has to be a fix, or a different way to design my query to get the results I
need. This has really delayed the project I'm working on.


:

Hi,
Did anyone have any ideas to why this is happening?
Or any ideas how to make my query work again?

Thanks.

:

I'm not sure what would cause this. I will ask tomorrow in a meeting room
with 26 Access MVPs from around the world (and a few MS staff).
--
Duane Hookom
Microsoft Access MVP


:

Hi,
I'm having a similar problem with a query running again a sharepoint list.
When I run the query, the column appears with the field name instead of the
alias name.

Here is my post
http://www.microsoft.com/office/com...a6c3&mid=82abe986-08be-46a8-889e-b111e1ffa6c3

If I run my same query against my original access tables, I get the expected
results.

:

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP


:

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP


:

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Chris]

Hi Dale,

Thaks for replying, I was wondering if you found a fix for the alias
problem. What did you end up doing? I'm still wondering if the alias
names not appearing correctly is causing any of the problems I'm having?

I was wondering, since you're working with Sharepoint too. Would you be
able to see if you can duplicate the problem I'm having?

Create a list, 2 columns. Employee and the other Supervisor.

Enter a few rows of names, then in the supervisor column add some ID's
from the employee column. Leave some a couple rows blank, just to make sure
it pulls them too.

then in Access link to the list and create a query similar to this

SELECT E1.EmployeeName AS employee1, E2.EmployeeName AS supervisor, E2.ID,
E1.Supervisor_Manager
FROM EmployeeName AS E1
LEFT JOIN EmployeeName AS E2 ON E1.Supervisor_Manager = E2.ID;

If you don't have time I understand, it's just driving me nuts that this
doesn't work. And so far, havne't been able to find any reason why it
doesn't

Chris,

Don't know what to tell you. I've been working this Access app using
Sharepoint Lists as my data repository for about 3 months now. Have not
encountered the problem that you are encountering (wrong number of records
returned). It might have to do with the data type Sharepoint is giving to
the IE or Supervisor_Manager, since as I recall, it really only gives you one
option "Number" instead of Integer, long integer, ...

My problem was/is with aliases, and I've just worked around it. Hopefully,
Duane will get a chance to discuss this at the conference he is at this week.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

Nobody has any thoughts to what the problem might be?

This has totally delayed the project I'm working on, I need this query to
work correctly for reports. It doesn't make any sense to why it doesn't
work against the Sharepoint Lists.

Is this a flaw with how Access and Sharepoint work together?
The query isn't complex, and works fine when ran against the tables in
Access. Been using it for years that way, but now I need to move these to
Sharepoint and it now all of a sudden doesn't work.

I hope someone knows how to fix this.

Another Update,

so I decided to import the list right back into Access (not link) and then I
ran the exact same query on it, now it runs fine. I get exactly the results
I should be getting.

What is going on here?
Why does the query work fine against the Access Tables, but running them on
the Sharepoint List, causes it to blowup and gives me over 200k records.

There has to be a solution to this? Anyone have any ideas?

:

To simplify the query, I removed the team table for now, and just rewrote the
query by hand.

so all I have is this now

SELECT E1.EmployeeName As Employee, E2.EmployeeName AS Supervisor FROM
EmployeeName E1
Left JOIN EmployeeName E2 ON E2.ID=E1.Supervisor_Manager;

When I run this against my Access based tables, I get the results I
expected. 160 records, Each employee and the supervisor if they have one
listed.

I then use this exact same query on my linked Sharepoint lists, and it comes
back with 1000's of recrods. Some employees are listed serveral dozen times.

Again, the alias does not appear in the column header of the query, it
lists the field name instead.

Something is way wrong here, is this a bug in Access or Sharepoint? There
has to be a fix, or a different way to design my query to get the results I
need. This has really delayed the project I'm working on.


:

Hi,
Did anyone have any ideas to why this is happening?
Or any ideas how to make my query work again?

Thanks.

:

I'm not sure what would cause this. I will ask tomorrow in a meeting room
with 26 Access MVPs from around the world (and a few MS staff).
--
Duane Hookom
Microsoft Access MVP


:

Hi,
I'm having a similar problem with a query running again a sharepoint list.
When I run the query, the column appears with the field name instead of the
alias name.

Here is my post
http://www.microsoft.com/office/com...a6c3&mid=82abe986-08be-46a8-889e-b111e1ffa6c3

If I run my same query against my original access tables, I get the expected
results.

:

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP


:

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP


:

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Dale Fye]

Chris,

I already have a heirarchical table in my Access/Sharepoint application, and
that aspect of it appears to be working properly. But, I created my
Sharepoint lists by publishing the tables from Access to Sharepoint. I did
not "create the list" and then import or link them to access. You might want
to give this a shot.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

Hi Dale,

Thaks for replying, I was wondering if you found a fix for the alias
problem. What did you end up doing? I'm still wondering if the alias
names not appearing correctly is causing any of the problems I'm having?

I was wondering, since you're working with Sharepoint too. Would you be
able to see if you can duplicate the problem I'm having?

Create a list, 2 columns. Employee and the other Supervisor.

Enter a few rows of names, then in the supervisor column add some ID's
from the employee column. Leave some a couple rows blank, just to make sure
it pulls them too.

then in Access link to the list and create a query similar to this

SELECT E1.EmployeeName AS employee1, E2.EmployeeName AS supervisor, E2.ID,
E1.Supervisor_Manager
FROM EmployeeName AS E1
LEFT JOIN EmployeeName AS E2 ON E1.Supervisor_Manager = E2.ID;

If you don't have time I understand, it's just driving me nuts that this
doesn't work. And so far, havne't been able to find any reason why it
doesn't

Chris,

Don't know what to tell you. I've been working this Access app using
Sharepoint Lists as my data repository for about 3 months now. Have not
encountered the problem that you are encountering (wrong number of records
returned). It might have to do with the data type Sharepoint is giving to
the IE or Supervisor_Manager, since as I recall, it really only gives you one
option "Number" instead of Integer, long integer, ...

My problem was/is with aliases, and I've just worked around it. Hopefully,
Duane will get a chance to discuss this at the conference he is at this week.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

Nobody has any thoughts to what the problem might be?

This has totally delayed the project I'm working on, I need this query to
work correctly for reports. It doesn't make any sense to why it doesn't
work against the Sharepoint Lists.

Is this a flaw with how Access and Sharepoint work together?
The query isn't complex, and works fine when ran against the tables in
Access. Been using it for years that way, but now I need to move these to
Sharepoint and it now all of a sudden doesn't work.

I hope someone knows how to fix this.

:

Another Update,

so I decided to import the list right back into Access (not link) and then I
ran the exact same query on it, now it runs fine. I get exactly the results
I should be getting.

What is going on here?
Why does the query work fine against the Access Tables, but running them on
the Sharepoint List, causes it to blowup and gives me over 200k records.

There has to be a solution to this? Anyone have any ideas?

:

To simplify the query, I removed the team table for now, and just rewrote the
query by hand.

so all I have is this now

SELECT E1.EmployeeName As Employee, E2.EmployeeName AS Supervisor FROM
EmployeeName E1
Left JOIN EmployeeName E2 ON E2.ID=E1.Supervisor_Manager;

When I run this against my Access based tables, I get the results I
expected. 160 records, Each employee and the supervisor if they have one
listed.

I then use this exact same query on my linked Sharepoint lists, and it comes
back with 1000's of recrods. Some employees are listed serveral dozen times.

Again, the alias does not appear in the column header of the query, it
lists the field name instead.

Something is way wrong here, is this a bug in Access or Sharepoint? There
has to be a fix, or a different way to design my query to get the results I
need. This has really delayed the project I'm working on.


:

Hi,
Did anyone have any ideas to why this is happening?
Or any ideas how to make my query work again?

Thanks.

:

I'm not sure what would cause this. I will ask tomorrow in a meeting room
with 26 Access MVPs from around the world (and a few MS staff).
--
Duane Hookom
Microsoft Access MVP


:

Hi,
I'm having a similar problem with a query running again a sharepoint list.
When I run the query, the column appears with the field name instead of the
alias name.

Here is my post
http://www.microsoft.com/office/com...a6c3&mid=82abe986-08be-46a8-889e-b111e1ffa6c3

If I run my same query against my original access tables, I get the expected
results.

:

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP


:

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP


:

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Chris]

Actually that's what I did originally, this is an existing db that we are
moving to sharepoint. So I exported my tables over to sharepoint and then
linked to them.

So you have a similar query, and it works for you. Odd, so I must just
have something not set right somewhere. Thanks for your help, hopefully I
can figure out what is causing this, and I can move forward with this.

Chris,

I already have a heirarchical table in my Access/Sharepoint application, and
that aspect of it appears to be working properly. But, I created my
Sharepoint lists by publishing the tables from Access to Sharepoint. I did
not "create the list" and then import or link them to access. You might want
to give this a shot.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

Hi Dale,

Thaks for replying, I was wondering if you found a fix for the alias
problem. What did you end up doing? I'm still wondering if the alias
names not appearing correctly is causing any of the problems I'm having?

I was wondering, since you're working with Sharepoint too. Would you be
able to see if you can duplicate the problem I'm having?

Create a list, 2 columns. Employee and the other Supervisor.

Enter a few rows of names, then in the supervisor column add some ID's
from the employee column. Leave some a couple rows blank, just to make sure
it pulls them too.

then in Access link to the list and create a query similar to this

SELECT E1.EmployeeName AS employee1, E2.EmployeeName AS supervisor, E2.ID,
E1.Supervisor_Manager
FROM EmployeeName AS E1
LEFT JOIN EmployeeName AS E2 ON E1.Supervisor_Manager = E2.ID;

If you don't have time I understand, it's just driving me nuts that this
doesn't work. And so far, havne't been able to find any reason why it
doesn't

Chris,

Don't know what to tell you. I've been working this Access app using
Sharepoint Lists as my data repository for about 3 months now. Have not
encountered the problem that you are encountering (wrong number of records
returned). It might have to do with the data type Sharepoint is giving to
the IE or Supervisor_Manager, since as I recall, it really only gives you one
option "Number" instead of Integer, long integer, ...

My problem was/is with aliases, and I've just worked around it. Hopefully,
Duane will get a chance to discuss this at the conference he is at this week.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

Nobody has any thoughts to what the problem might be?

This has totally delayed the project I'm working on, I need this query to
work correctly for reports. It doesn't make any sense to why it doesn't
work against the Sharepoint Lists.

Is this a flaw with how Access and Sharepoint work together?
The query isn't complex, and works fine when ran against the tables in
Access. Been using it for years that way, but now I need to move these to
Sharepoint and it now all of a sudden doesn't work.

I hope someone knows how to fix this.

:

Another Update,

so I decided to import the list right back into Access (not link) and then I
ran the exact same query on it, now it runs fine. I get exactly the results
I should be getting.

What is going on here?
Why does the query work fine against the Access Tables, but running them on
the Sharepoint List, causes it to blowup and gives me over 200k records.

There has to be a solution to this? Anyone have any ideas?

:

To simplify the query, I removed the team table for now, and just rewrote the
query by hand.

so all I have is this now

SELECT E1.EmployeeName As Employee, E2.EmployeeName AS Supervisor FROM
EmployeeName E1
Left JOIN EmployeeName E2 ON E2.ID=E1.Supervisor_Manager;

When I run this against my Access based tables, I get the results I
expected. 160 records, Each employee and the supervisor if they have one
listed.

I then use this exact same query on my linked Sharepoint lists, and it comes
back with 1000's of recrods. Some employees are listed serveral dozen times.

Again, the alias does not appear in the column header of the query, it
lists the field name instead.

Something is way wrong here, is this a bug in Access or Sharepoint? There
has to be a fix, or a different way to design my query to get the results I
need. This has really delayed the project I'm working on.


:

Hi,
Did anyone have any ideas to why this is happening?
Or any ideas how to make my query work again?

Thanks.

:

I'm not sure what would cause this. I will ask tomorrow in a meeting room
with 26 Access MVPs from around the world (and a few MS staff).
--
Duane Hookom
Microsoft Access MVP


:

Hi,
I'm having a similar problem with a query running again a sharepoint list.
When I run the query, the column appears with the field name instead of the
alias name.

Here is my post
http://www.microsoft.com/office/com...a6c3&mid=82abe986-08be-46a8-889e-b111e1ffa6c3

If I run my same query against my original access tables, I get the expected
results.

:

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP


:

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP


:

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[VoiceOfTheBear]

Hi,

just thought I'd ask to see if anyone has come up with an explanation for
this behaviour yet.

Adding a little more info to the pile, I've discovered that if I export the
results to text (using the wizard), I get the aliased field names appearing,
but exporting to Excel will use use the original field names.

Chris

I'm not sure what would cause this. I will ask tomorrow in a meeting room
with 26 Access MVPs from around the world (and a few MS staff).
--
Duane Hookom
Microsoft Access MVP

Hi,
I'm having a similar problem with a query running again a sharepoint list.
When I run the query, the column appears with the field name instead of the
alias name.

Here is my post
http://www.microsoft.com/office/com...a6c3&mid=82abe986-08be-46a8-889e-b111e1ffa6c3

If I run my same query against my original access tables, I get the expected
results.

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP


:

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP


:

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Chris]

Nope, never got a response back to why this happens.
Doesn't make any sense at all, not sure if it's a Sharepoint problem or
Access problem, but either way it should just work.

Hi,

just thought I'd ask to see if anyone has come up with an explanation for
this behaviour yet.

Adding a little more info to the pile, I've discovered that if I export the
results to text (using the wizard), I get the aliased field names appearing,
but exporting to Excel will use use the original field names.

Chris

I'm not sure what would cause this. I will ask tomorrow in a meeting room
with 26 Access MVPs from around the world (and a few MS staff).
--
Duane Hookom
Microsoft Access MVP

Hi,
I'm having a similar problem with a query running again a sharepoint list.
When I run the query, the column appears with the field name instead of the
alias name.

Here is my post
http://www.microsoft.com/office/com...a6c3&mid=82abe986-08be-46a8-889e-b111e1ffa6c3

If I run my same query against my original access tables, I get the expected
results.

:

The only thing I think of, is when I have something like this happen, I have
forgotten about the code I have written that dynamically changes the Row
Source.

--
Duane Hookom
Microsoft Access MVP


:

No, never use caption property, but am using Sharepoint List as my data
source. Have not had this problem with other tables associated with
sharepoint.

No, turned off Name Autocorrect a long time ago.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

Just a shot in the dark, but do you use the field Caption property? Do you
have any Name Autocorrect stuff checked?

--
Duane Hookom
Microsoft Access MVP


:

I have a query I'm working on for a listbox in my application. Because I
want to display column headers in the listbox, I am attempting to alias the
field names, but when I run the query, it is returning the original field
names, not the alias.

Anybody have any ideas:

SELECT tbl_Learning_Demands.LD_ID,
tbl_Learning_Demands.LD_NUM AS [LD #],
tbl_Learning_Demands.LD_Name AS [LD Name],
tbl_Learning_Demands.Sponsor_Priority AS Priority
FROM tbl_Learning_Demands

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.