go to control in access 2007

[Guest]

i am trying to convert my access 2000 db into the 2007 version. I have run
into alot of problems.

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.

 

[Guest]

I have a problem. I have created a database for the company, and in the
switch board, t has the buttons (command buttons) I've created.

1question: My buttons work in my 1st switchboard stage for one of my jobs.
There are 4. I have went to the others in the switchboard and did everything
like I did in the first form, it still doesn't work. one button is EDIT and
the other one is save. they work in one stage, but there are 3 other stages
to go through. How do I get this to work?

2ndQuestion: I can input the the data in the switchboard. What do I have to
do join or link forms where once entered, it can be saved where others can go
into it? Or if it can be saved to a table ot autopopulate to the spreadsheet
that was inported? the fields are coming from an inported spreadsheet. So
while My workers are entering their data as it changes hands, it will be
doing the numbers in the background to generate number combining with wht my
employees are entering. I need to save record and beable to no have to go
into access to get them/ the employees have to open one form...enter their
stage in the process, the second has to be able to go under the same number
which was saved frm the 1st person at their stage, save the record, go
through it's third stage, save record, and the last person will open the same
record, enter their info, and save. I need to be able to view the whole
process in full instead of having to open this one, closing, opening that
one, closing etc. I hope this isn't too much. I believe it's a simple
process, but then too, I am basically new to access.

Any help id appreciated for this has to roll out on the floor for everyone
byt the weekend!!!
Julia
--
Julia Green
Production Network Specialist

i am trying to convert my access 2000 db into the 2007 version. I have run
into alot of problems.

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.