Sparks,
First, you made the mistake of not doing the planning first and now you are
stuck with an iterative development cycle that is keeping you in hot water.
It's very helpful and does lots for job security if at the outset you lock
all the stakeholders in a room and hold them hostage until they produce a
requirements document. That way everbody is clear as to what was agreed to
at the outset. Projects almost always change over their lifespan so the
original agreement often only somewhat resemembles what gets built; but at
least you have a way to defend yourself if the bean counters get nervous as
the budget is spent and the go-live date passes in the wind.
Second, Jet SQL allows you to include file names in the FROM statement so
the data can exist in any Access database located anywhere Windows is able
to connect to. So, having data in multiple databases isn't a problem as
long as you give the full UNC of the contributing databases in the FROM
clause of your SQL statement. This way, the make-table statements are not
needed. You can run the query and it will pull the most current data from
each contributing database each time the query is run. This means that your
filter can be done in any database as long as you set up a query that shows
the data from the other database.
Third, it sounds like you are fuzzy on the idea of joins, relations, and
constraints. Rather than explain them here I'll assign you some homework.
Go look up "joins" in the help files. What you want is a join between your
personal information and the data you are reporting on.
"sparks" <sp****@here.com> wrote in message
news:ho********************************@4ax.com...
They have a machine that records raw data for each person.
Database 1 just takes this raw data and displays reports on the person
Database 2 has all the personal information on that person.
Well since they can't understand that they can get the reports, BUT
NOT view them while they are looking at the personal information on
one tab and the report on another tab they are mad...WHATS NEW LOL
its the ones that if I can thunk it you should be able to do it.
I said I can put a print preview on the form...just press the button.
Well that sucks. yep you guessed it they are never satisfied.
BUT this is what they finally agreed to
I do have another question.
if database 1 has a query1 that builds a report1
I made query1 a maketable query to make table1 linked it into
database 2 to display the report I copied over and this works fine.
but one thing. I need to filter the report on ID.
can I pass an ID from database2(the personal database) to database1
(the raw data database) to filter the maketable query when It makes
table1?
So if you are in person one record I would pass a 1 to the other
database to get the maketable query to output table1 with only person
one records for the report.
is this do able, and the correct way to do this?
jerry
On Fri, 15 Oct 2004 09:36:53 -0400, "Alan Webb" <kn*****@hotmail.com>
wrote:
Sparks,
I tried in Access 2002 to click & drag a report to an empty form and it
wouldn't let me. I'd guess that your users are more interested in the
data
for the report than whether it is displayed in a report object or in a
nested subform. Go do another meeting and negotiate this so you identify
what it is that they need in the new tab then build your query & form to
satisfy the requirement. And by the way, did you plan this thing and
document the requirements *before* you started? If not, boy, am I glad I
am
home in my PJ's and not working with you to build it.
"sparks" <sp****@here.com> wrote in message
news:oo********************************@4ax.com. .. We have a database that reads in and formats raw data. We were using
queries to format the data per person and outputing reports.
The other database has the persons personal information. I changed the
queries on the raw data to maketables, copied the reports into the
personal info database and they have the reports from the raw data
available for the reports.
NOW they want the reports to be displayed as a new tab in the forms.
I am not sure if you can put a report on a subform, is this possible?
Will it run as a std report that is working now?
has anyone done this before?
thanks big time maybe I am missing something but I don't think you can
put a report in a form. Or am I just crazy
jerry