473,898 Members | 2,624 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1661
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.co m> wrote in message
news:oo******** *************** *********@4ax.c om...
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*****@hotmai l.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.co m> 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.co m> wrote in message
news:ho******** *************** *********@4ax.c om...
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*****@hotmai l.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.co m> 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*****@hotmai l.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.co m> 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*****@hotmai l.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.co m> wrote in message
news:oo***** *************** ************@4a x.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
1799
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 reached, and an area to write a comment underneath. Each subject is slightly different in the number of skills and their description and therefore the position of the eomment is slightly different. I realise that I can create different forms to...
6
1417
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 doing what they wanted I always get asked to provide reports. Okay --- that's a primary function that the app provides, I'll write the reports like you want. But this seems to always lead to the employer requesting more and more reports and putting...
5
1432
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 pane might have any number of things on it... buttons, a treeview, etc... and have a layout we would specify. It would need to be truly docked to the main window, like a toolbar is, and be resizable. (Some of the things we've found for doing this...
5
2001
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 opens another form with 3 options 1) Problems all report 2) problems resolved 3) Problems not resolved Now what i really want is when a user clicks on Problems all report it should go directly into excel worksheet based on my query which i have...
2
2187
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 enable certain reports to be displayed as the user checks the box and the clicks the cmdReport button. Also, is there a certain way to combine reports, loaded separately, to load into one for printing (e.g. report1 and report2 are checked, how...
1
1389
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. Some points are as follows: 1) User should be able to filter data included in reports like choose among cycles, cars etc or all of them (I.e. Sql query is generated dynamically based on user choice) 2) Data is retrieved from database and...
2
2643
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 reports in Excel format everyday. The requirement is to automate the download of Reports by providing the URL of Excel format of report, Username and Password to logon to Oracle OnDemand. Using CSHttpUnit, we could logon to the OnDemand instance...
2
1255
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 macros... Basically here is what I need: The data in our company is stored on DB2 tables. I ran a query to get certain information which uses three DB2 tables. The results of the query went into a table from which I created a report. So anytime...
4
2660
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 and I original had 3 buttons each printing a specific report. base on the customer shown on the form. I want to create a single button that will print all 3 reports. Everything I tried, its printing every record. I just want to print the record...
0
9839
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11254
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10853
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10943
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10480
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9658
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5876
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4701
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3303
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.