Saving Information To A Report

Apr 2, 2007

Hi all - I'm new here and am very glad to find this forum for some help!

I've been using Access for several years and I do the same type of reports over and over and all of a sudden I'm having trouble.

I typically modify existing queries - changing the name of the department in order to pull up their info - and then I format a report and modify that same report over and over with the "Properties" key where I pull in the new query info and then use SAVE AS to save the report with that department's information.

For the first time ever it will not let me SAVE AS with the new info. Sometimes it just does nothing at all - appearing to save but then the report isn't there - sometimes giving me a pop up box that says it couldn't find the search key - I don't even know what that is!

I can SAVE AS with queries, but not reports. HELP!

Thanks!

View Replies


ADVERTISEMENT

Lookup Tables Not Saving Information

Dec 8, 2005

Hi ppl,

Anyone who thinks that they may be able to help me, there is a copy of the database at :

http://members.iinet.net.au/~a.beardsley/database/StaffProLearning.mdb

Here is my problem, as you will see. In the from called frmStaff, I have created 2 lookup tables that work fine in the main form. In the subform under activites though, I have attempted to create a lookup form for Name and Location of activities. It does not appear to be storing the information from previous entries though. My aim is so that when someone goes to enter a new activity name or location, the data will be saved and be in the list for the lookup next time with a different entry, however, it does not appear to be storing the information in the appropriate table. Any ideas on how to fix this?

Regards,
sugar05

View 3 Replies View Related

Forms :: Saving Information In Subform?

Dec 3, 2013

I have a subform and I want to save the username to the bound table in this subform.

I've tried creating a textbox (CompBy) and then setting the default value to = Environ("UserName") but this doesn't work.

I've tried placing the following in the afterupdate event of the subform:
Me.CompBy = Environ("username")
DoCmd.Save
But this doesn't work either.

View 1 Replies View Related

General :: Saving Information From Form To A Different Table?

Nov 26, 2012

I have created a form and a subform within it, I have managed to populate all the dropdown boxes from the tables I need. but I need to save all the information in putted to a table called bookingstbl and I do not know where to begin?

View 6 Replies View Related

Forms :: Print Preview Of Currently Entered Information Without Saving To Database First?

Nov 5, 2014

If you are using a form as a sort of user interface and you've got a user entering in information into the form, is there any way possible to print a preview of the currently entered form information without saving it to the database first?

I'm thinking a kind of validation thing. Like, "Click here and preview what you've entered. Sure this is what you want?" type of thing.

View 1 Replies View Related

Saving Report In Access 97

Apr 6, 2006

Thanks for the help so far...

I have managed to export areport to file but I lose all the formatting. I get the option to output as html, xls, txt, rtf or snapshot format.

Is there a way I can output the file whilst maintaining the look of the report as it is in print/preview??

Cheers

View 2 Replies View Related

Saving Form As Report

Dec 19, 2005

Hello all!

I would like to have one stupid question, because I could not find any answer on this forum.
I want save the Form as Report. I can do that from "Menu bar", but I want to do that from the code (VBA or Macro) without inputting the output parameters by users.
Do you have any idea how?

Many thanks.

Krava

View 7 Replies View Related

Close Report Without Saving

Oct 14, 2004

Can anyone tell me how to have Access automatically close a report without saving any changes.
I do not mind if the user closes the report manually but do not want Access to prompt the user to save changes. I want it to automatically abandon any changes that were made.

View 6 Replies View Related

Report Formats Not Saving

Jan 17, 2005

I have built several reports and I have set the layout to Landscape. When I go into the reports after a few days, it puts the format back to portrait. How can I stop this from returning to portrait?

View 2 Replies View Related

Report: Saving Print Settings

Feb 9, 2005

I have a report that prints labels.
Every few times of opening the report, the page setup settings revert back to default i.e. 1" margins, 1 column etc.
how can i assure that these settings remain unchanged??
thanks!

View 3 Replies View Related

Reports :: Saving Report To A Map In Macro

Oct 3, 2013

What I want to do is save a daily report to a map source, each day the map name changes so for today the map name is "Report2013-10-03", and tomorrow the map name will be "Report2013-10-04".

Is this possible? is there some function like save(Report%s) where %s = date() ?

View 4 Replies View Related

Run Query Or Report On New Information

Feb 20, 2006

Hello all:

Every week I download new information into a table. The download has all the information, but the table will spill out any information from the download that is already existing in the table.

How do I print a query or report right after the download, that will provide a list of the new information just downloaded.

Thanks for all your help!

View 2 Replies View Related

Only Show The Report If There Is Information

Jan 18, 2006

I have a form with a list box that shows a number of reports that are ultimatly built from queries.
Depending on what information I have put in, some of the reports will not show any information, which is fine. Is there a why that I can tell the report to open only if there is information present or maybe change the colour of the name of the report in the list box.
This sounds a bit complicated but hopefully I have explained enough for someone to help, thanks in advance.

View 4 Replies View Related

Modifying Report Changes Information...

Mar 16, 2008

I have a report I am generating with the design wizard. It uses 1 Query and all the information I want and order is correct when its finished. However, there is more information then what I want to display (I choose it to sum up everything, but I want to get rid of the thing that says 'summary of blah : 3 records) and I want to move the sum label to the far right and change it to total.

However I am finding out that any attempt to modifying the report in any way is changing my information. When its correct and working the report is 24 pages, each client has 3 sub types that come up and shows totals. However, if I make something invisible, move a label, change the text in a label or ANYTHING, then my report is completly screwed up, it drops to 3 pages, and loses all but 5 clients and only 1 sub type appears.

Why is modifying the report doing this?

Edit: its access 2003

View 4 Replies View Related

Automatically Saving A Report As An Excel File

Jul 7, 2006

Hi,
I was wondering if there was a way for a report to be automatically saved as an excel file. Also, the Access database is stored on the company's server so would you be able to choose the path where the excel file would be stored?

Cheers,
Ben

View 1 Replies View Related

Reports :: Producing A Report And Then Saving As Attachment

May 29, 2013

I am building a database which produces a report which I have formatted as a letter, I know I could have done this via a mail merge etc however...

What I am wanting to achieve is when this report(letter) is run, is there a way that when it is produced from a macro button embedded in a form that this report can then be saved as a pdf attachment within the same access database attached to a client record?

View 3 Replies View Related

Reports :: Making And Saving A Report Template

Aug 15, 2014

I have developed an Access Database for my Co-Op work term workplace, and everything seems to be running smoothly with the exception of the report generation phase. The company I am at has a set template for all reports (Clients column always goes in a specific place on the page, and the report always contains the same categories in the same locations; things like that). The problem is that, every time I go to make a new report, I have to re-format and re-make the report. Is it possible to save a report`s format so that, when I go to make a new report, it automatically applies that format to the data being used?

View 3 Replies View Related

Take Information From A Form, Use To Print Out A Report

Dec 11, 2007

I have a patient information database which uses a filtered form to show records for only one patient at a time. All the records in the database are linked together using one number, the patient's unique identifier.

I have designed a report which draws information from separate tables and generates a complete summary of information. This report depends on having the ID number of the patient to generate the report.

Originally, I had envisioned having a command button on the data entry form, which would then automatically take the ID number from the form, and generate the report. Though good in theory, it never worked out in practice, as I could never figure out how to make it happen.

Is there a way to design a macro or some other thing that would take the ID number from the field on the form, and use it to generate the report? Currently, I have it configured to prompt me for the ID number. When I enter it manually, the report is generated perfectly.

Thank you in advance,

View 2 Replies View Related

Reports :: Splitting Out Information In A Report

Oct 9, 2014

I need to split out information in a report and I'm not sure how to do it.

The report is based on the following query:

Code:
SELECT tblHazardClass.HazardClass, Product.ProductName, Product.Package, Product.Size,
tblStoreProducts.Cases, Product.Units, Product.ReportUnits, tblStoreInformation.StoreName,
(([tblStoreProducts].[MaxUnits]*[Product].[Size])/[Product].[ConversionRate]) AS QOH, tblStoreProducts.StoreKey
FROM tblStoreInformation INNER JOIN (tblHazardClass INNER JOIN (Product INNER JOIN tblStoreProducts ON Product.UPC = tblStoreProducts.UPC) ON tblHazardClass.HazardKey = Product.HazardKey) ON tblStoreInformation.StoreKey = tblStoreProducts.StoreKey
WHERE (((tblHazardClass.HazardClass)<>"NON-HAZARDOUS"))
ORDER BY tblHazardClass.HazardClass;

My issue is that the products can have a PhysicalState of 'L' (liquid), 'S' (solid) or 'G' (gas). As of right now, only one of the HazardClass entries has multiple physical states (L or S).

My report details each product in the hazard class and totals the amount of that hazard class. Obviously, one cannot add gallons to pounds and come up with an answer that has any meaning whatsoever. How to have the report total the S and the L within a hazard class separately.

Do I do this within the query, or within the report itself? I've already considered making 2 separate Hazard Classes for the one in question (Corrosive). However, since these Hazard Classes are official classifications per the International Fire Code, that's not really an option.

View 1 Replies View Related

Reports :: Table Information On A Report

Oct 10, 2014

I am trying to get some totals on a report, but the totals are from a table that the form is not related to as such.I am trying to get a textbox to show how many records in a query match the given criteria and show me the number of records that match. I was thinking DCount, but not sure if it will work?

I have a query called 'VehiclesAllocatedToday' which is already filtering records to show only those allocated today. On a report that shows Unfit Vehicle (and is related to a different query), I would like a text box that shows me how many records there are where the text "Type One" is in the TypeRequired field.

View 8 Replies View Related

General :: Saving Report As PDF Without Save Button Showing

Nov 6, 2013

I have generated a report in acviewreport, after viewing the details I want to save the report as a pdf file with the client name, invoice number and date. In the report design view I added a cmd button and successfully coded it. However, it saves the report WITH the cmd button showing. I don't want this button saved. Is it possible to remove the button from the report AFTER I have clicked it?

View 4 Replies View Related

Transfer Information From A Form To A Report Then Print

Mar 16, 2005

Hi there

This im sure is an easyone to most of you but for me I cant find away around my problem!!

I have a form I use to enter infomation and I have also made a report that I am trying to get the infomation from the form onto the report.

I would like to have a command button on the form that once I click it, it then prints out the report.
How do I get the information from a form to a report as when I have tried doing this myself it only allows me to use information from a query or table.


Any suggestions would be great for this newbie!!!


Thank you

View 2 Replies View Related

Reports :: Open Report From Information In A Form

May 28, 2013

I have a Table with Emp_ID and Details of my Employees. I have created a query and set parameter [Enter Emp_ID]. When I pull up a report, I get a pop-up and it asks me for the Emp_ID. When I input same, I get the information I need. Everything is good so far...

My Question... I have designed a report when user will need to enter Emp_ID and click on a button and they will get the report "EMPReport" without having the pop-up window asking for EmpID.

I have been using the below code but I get the pop-up again and I need to enter the Emp_ID again to view the report

See below Code:

Code:
Private Sub Image11_Click()
If IsNull(Me.Emp_ID) Or Me.Emp_ID = "" Then
MsgBox "You must enter an Emp ID.", vbOKOnly, "Required Data"
Me.Emp_ID.SetFocus
Exit Sub
End If
DoCmd.OpenReport "Rpt_HR1", acViewPreview, , "[Emp_ID]= " & "" & Me!Emp_ID & ""
End Sub

View 13 Replies View Related

Reports :: Adding A Chart That Represents Information On Report

Apr 2, 2013

I have a popup form that prompts for a value and has a button defined with an OnClick,OpenReport with a WHERE clause. The value the user enters is placed in the WHERE clause.

The report is generated using a Query and the WHERE clause.
I was very surprised -- it works!

Now I'd like to add a chart to the report that represents the information on the report. How can I do this without calling the query again? Can I somehow reference the information that's in the report?

View 1 Replies View Related

Send Report (Job Information) Individually By Email Address

Sep 17, 2013

I have a template report (R_CurrentJobs) with fields from database.

Fields: FirstName, LastName, Email, JoB Number, TechID, TechName, JobLocation etc...

The query Q_CurrentJobs is a list of jobs to send to the tech for today. (These are open jobs queried).

I need to run this query on the report (R_CurrentJObs) and send the report to each tech based on their individual jobs. The jobs are connected to each tech by its TechID.

The report list the job information for each tech (JOb number, Location details etc.)

When I click the button to send the email. I want to email each tech individually based on the Q_CurrentJobs query using R_CurrentJobs. (DoCmd.SendObject)

View 11 Replies View Related

Huge Report With Visits Per Customer - Get Information Of Last Visit

Dec 2, 2013

We have a huge report in our company that includes all our customers, all the visits done by our sales reps, all the products they have and if a product was out of stock in the visit or not.

I want to create a querry that exports a table with 3 columns:

1-->customer
2-->date of last visit
3-->average of out of stock products on the LAST visit

I tried to make a pivot table, managed to grab the last visit (setting the date to maximum) but the average of out of stock products were aggregated totally and not for the last day.

How to handle this in MS access 2010?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved