473,320 Members | 1,861 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

not sure can this be done with reports on a form?

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

Nov 13 '05 #1
4 1630
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

Nov 13 '05 #2
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


Nov 13 '05 #3
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


Nov 13 '05 #4
Well I setup the queries to maketables and linked these tables in the
data entry database. As they add more raw data in one they will have
to hit a button that does the raw input into tables, then runs the
maketables to update the records for their reports.
It works fine. TOOO bad they can't understand why they have to update
the raw data database after they put the data in their
directory...can't it know when we add new files?
I told them it only updates new or updated files but it does not check
on what you are doing till you push the button..
WOW 1 button and bitch bitch bitch
ROFL
I can't win

thanks for the help

Sparks
On Sat, 16 Oct 2004 12:31:33 -0400, "Alan Webb" <kn*****@hotmail.com>
wrote:
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



Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Jonathan Smith | last post by:
I am thinking about attempting a program to help my colleagues at school to write their pupil reports. Each report has two sections: a list of skills with a seies of tick boxes to show the level...
6
by: strvariant | last post by:
I'd like to get some feedback on what I call 'Analysis Bleed'. In past jobs I have noticed a trend that starts to develop after about 6 months. Once an employer sees that the apps I develop are...
5
by: TD | last post by:
Hey All- I don't think this is possible, but we'd love it if it were. We would like to have a pane of our own design docked along the left side of our Access application's main window. This...
5
by: sulemanzia | last post by:
hi. i am working first time with query and reports. i have created a database. i have reports and query. i have a button in my form by the name of (View reports) if a user clicks on that button it...
2
by: Kil | last post by:
I designed a form that allows the user to enter dates, and click a checkbox so that certain forms may be loaded. However, I have had trouble getting the right information to load. I would like to...
1
by: badwal | last post by:
One of the requirements of our ASP.NET 2.0 web application (developed with visual studio 2005) is to create reports in form of excel spreadsheets with data coming from Sql Server 2005 database. ...
2
by: nandishp | last post by:
We need to automate download of Reports from Oracle CRM OnDemand. The reports in Siebel CRM OnDemand can be downloaded in the form of Excel, CSV, etc. We have a task of downloading several such...
2
by: Inna5683 | last post by:
I work for a big corporation and use access to run reports for branches that are located around the world. As I am new in this position I have some problems understanding how to create forms and...
4
by: mode67 | last post by:
In Access 2000, I have three reports, named as follows: rptCrew rptService rptWork All three reports pull information from the same table (e.g. tbl_Customers). I have one form called Customers...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.