ACCESS 2007 ERROR 2538

[AUDREY @ SIG]

HELP. I AM TRYING TO GO FROM ACCESS 2000 TO 2007. MY OPEN FORM HAS A TOGGLE
THAT WON'T WORK CAUSING AN ERROR MESSAGE 2538 AND 2950 WITH A REFERENCE TO A
SUBFORM. I AM TOLD THAT ONE OF MY LISTING IN SQL COULD REFER TO MORE THAN
ONE TABLE. THIS FORM WORKS IN 2000 AND NEED IT TO

 

[ruralguy via AccessMonster.com]

Hi Audry,
Start by turning off your Caps Lock. That is considered shouting.

How about posting the SQL that is giving you problems?

 

[boblarson]

Audry:

And posting the same question 5 times is not conducive to people wanting to
answer your question. It makes you seem demanding and selfish, since there
are a lot of people asking questions here.

 

[AUDREY @ SIG]

my caps are off but you are the one yelling? where did you see 5 postings.
the last person suggested that include the code? and i did just that while
taking off the caps. my mistake - i thought you were supposed to respond to
requests. i guess you are supposed to ignore suggestions and get attitude

 

[Pieter Wijnen]

We're not supposed to do anything.
Anybody responding to anything in this group are volunteers.
Somebody might be able to help you out if you could provide a bit more
information about the exact problem

Pieter

 

[boblarson]

I do apologize for the post because I went back and looked and it was someone
else, with a very, very similar email address who had posted the other 4
posts. I am sorry that I mistook you for that person.

 

[AUDREY @ SIG]

it takes a big man to apologize. thank you. now lets hope i get some answers.

 

[ruralguy via AccessMonster.com]

Audry,
Bob is indeed a sincere and caring person.
Maybe my reader is not working properly but I do not see any additional
details about your problem.

it takes a big man to apologize. thank you. now lets hope i get some answers.

I do apologize for the post because I went back and looked and it was someone
else, with a very, very similar email address who had posted the other 4

[quoted text clipped - 20 lines]

 

[AUDREY @ SIG]

good afternoon: please be patient the code that is not working in access
2007 comes from the following:


the first being that i have a macro that wants to bring you into a subform
using the gotocontrol but microsoft is telling me that the gotocontrol
command is not available in 2007.

my second problem is that i am receiving a error message when i try to
retrieve info from a subform. it says that my information from a table
called managed and partners has a field called letter that "could refer to
more than one table" i get an error 2538 and 2950. my letter field is the
field that is common to all of my tables. the section of my db that is coming
under complaint has code as follows:

SELECT [TABLE LEDGER COMBO].PARTNERSHI, [PARTNERSHIP NAMES]![DATE] AS [CUR
DATE], [TABLE LEDGER COMBO].NUMBER, [TABLE LEDGER COMBO].[#UNITS],
[PARTNERSHIP NAMES].NAV, [#UNITS]*[NAV] AS [CUR VALU], [QUERY FOR MANAGED &
PARTNERS FORM (2)].[SumOf#UNITS], [#UNITS]/[SUMOF#UNITS] AS [%OFPARTNERSHIP]
FROM ([TABLE LEDGER COMBO] INNER JOIN [PARTNERSHIP NAMES] ON [TABLE LEDGER
COMBO].PARTNERSHI = [PARTNERSHIP NAMES].PARTNERSHI) INNER JOIN [QUERY FOR
MANAGED & PARTNERS FORM (2)] ON [PARTNERSHIP NAMES].PARTNERSHI = [QUERY FOR
MANAGED & PARTNERS FORM (2)].PARTNERSHI
ORDER BY [TABLE LEDGER COMBO].PARTNERSHI, [TABLE LEDGER COMBO].NUMBER;


anything you can do to get my db going would be greatly appreciated.

 

[ruralguy via AccessMonster.com]

Well Audry, I don't have ac2007 and don't use macro's either so I'm not sure
how much help I can be here. I can offer a bit of advice though. You are
using several reserved words as fields in tables that can easily drive Access
nuts. Here's a list from MVP Allen Browne's site:
Problem names and reserved words in Access
http://www.allenbrowne.com/AppIssueBadWord.html

You should really try and change some of those field names if it is not too
late in the development.

good afternoon: please be patient the code that is not working in access
2007 comes from the following:

the first being that i have a macro that wants to bring you into a subform
using the gotocontrol but microsoft is telling me that the gotocontrol
command is not available in 2007.

my second problem is that i am receiving a error message when i try to
retrieve info from a subform. it says that my information from a table
called managed and partners has a field called letter that "could refer to
more than one table" i get an error 2538 and 2950. my letter field is the
field that is common to all of my tables. the section of my db that is coming
under complaint has code as follows:

SELECT [TABLE LEDGER COMBO].PARTNERSHI, [PARTNERSHIP NAMES]![DATE] AS [CUR
DATE], [TABLE LEDGER COMBO].NUMBER, [TABLE LEDGER COMBO].[#UNITS],
[PARTNERSHIP NAMES].NAV, [#UNITS]*[NAV] AS [CUR VALU], [QUERY FOR MANAGED &
PARTNERS FORM (2)].[SumOf#UNITS], [#UNITS]/[SUMOF#UNITS] AS [%OFPARTNERSHIP]
FROM ([TABLE LEDGER COMBO] INNER JOIN [PARTNERSHIP NAMES] ON [TABLE LEDGER
COMBO].PARTNERSHI = [PARTNERSHIP NAMES].PARTNERSHI) INNER JOIN [QUERY FOR
MANAGED & PARTNERS FORM (2)] ON [PARTNERSHIP NAMES].PARTNERSHI = [QUERY FOR
MANAGED & PARTNERS FORM (2)].PARTNERSHI
ORDER BY [TABLE LEDGER COMBO].PARTNERSHI, [TABLE LEDGER COMBO].NUMBER;

anything you can do to get my db going would be greatly appreciated.