The FrontEnd is published on a Citrix server, so is the backend. It works well, but I have issues with images in report.
We have a lot of suppliers that demand that we use their standardized forms for entering customer information.
Most of these forms are quite simple and basic (logo in the corner and so on), and this does not represent an issue to just mock them in a new report.
However, one of our suppliers has multiple pictures, their own font for text, "complicated" boxes with text (for example they do not use rectangles, but cut of corner rectangles) and so on. It's a nightmare to recreate.
The FrontEnd file was about 25mb when i startet, and after creating 2 reports of 6 pages, the frontEnd size increased to over 350mb.
I have saved the pdf as an image (jpg). I need high resolution because of small tekst in the pdf that needs to be visible. I have managed to get the size down to 2mb, some 4mb. Any lower and the image is unreadable. I have also tried BMP (I've heard that bmp i preferable).
All of this is quite time consuming, and I have used hours after hours recreating these reports, without satisfactory results.
Sometimes the images are visible on the print, other times not. The same with the print preview.
So my question is... How can I "create" a report, based on a PDF?
I'm trying to create a report that has certain rows filled with a background color. In excel, the fill color is complete across the row. That is, there are no gaps between cells. In Access, each individual "cell" or field is filled with the color but inbetween each cell/field there is white space. I tried changing the control padding to "narrow" but there is still too much white space. Changing control padding to "none" changes the alignment of the cells to look off. They aren't exactly lined up in a row anymore. It looks terrible.
I have a report. In this report I have a start date and an end date. I also have a date that is going to be checked. The report checks to see if the date the user entered on a different form is between the start and end date of an individual. if it is, a txt box at the end of the line will turn red. If it isn't the box will stay default of green.
What I would like to do is not even show the lines that have a green box. I want to just show the lines that have boxes as red.
I looked into If statements but I'm not quite sure what event I should put them on, nor am I certain I have the syntax right.
I had it: If (lblAvailability.BackColor = "#CCB13D" Then txt1.Visible = False and so on... making all the txt fields invisible. I would rather have them not even show up because I'm pretty sure invisible things still take up room. End If
I have a form that that contains a button that opens a report. The code I use to open said report is:
Code : DoCmd.OpenReport "Comp and NB Targets Q4", acViewPreview, , strWhere
The issue is that occasionally when the user prints from that preview, it can instead print out the form in the background that was used to open the report.
This seems to happen at random and I have not yet found a pattern or solution to the problem.
Is there a reason this could be happening and is there anyway to stop it?
How do I change the background colors and text formatting in all of the reports in one database at the same time? If this is not possible, is there an easier way to change the report formatting without going through every report?
Hi, I'm running into a problem where parts of a Report are printing with a gray background. Not all of the report does this, just certain sections. Background colors aren't set to anything.
I did find this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=16054&highlight=background+print+color
problem is.. the print IS from a report-- and I don't want to see a color on screen, I want it to NOT print gray.
how to change background color of MSAccess Reports using VBA? How can I do border coloring. What are the vba codes for all color options like light green, light blue etc. How to change the font type to bold etc using vbaI did some changes to text box coloring in Detail Section on format click event.
I have been an MS Excel man all along my career and I am a novice in MS Access.I have created a table, [Initial Customer Approval] which records data from a Form, [Initial Customer Approval]. Once the data is entered in the Form, I need to do some calculations based on the data entered in some of the fields in the form.I created 6 different queries for the six possible values in those fields. now for each of those queries I created respective reports.I placed a Print command button in the Form.
1. When I press the Print button it should open the report for the current record in the Form. (Currently It Opens all the reports simulatneously, with only one relevant report containing the current record; other opened reports being blank.)
2. If user presses the Print button before pressing Save button then system should prompt user.
Here is the code (Please note [reference number] is the unique ID generated for each record entered in the tabe through form):
Private bSaveClicked As Boolean Private Sub Form_BeforeUpdate(Cancel As Integer) If Not bSaveClicked Then MsgBox "You are trying to navigate away from the active record. Please either save your changes, or press ESC to cancel your changes.", vbOKOnly + vbInformation Cancel = True
I am trying to create a P&L statement in access. I know what I want to come out at the end. I am just starting to play with access and having trouble getting what I want to come out of it.
On the sales side I have a query that gathers all the revenue sources and calculates a total for each date. I then use a second query to just take out the data I want for the P&L report. I created a sub-report that displays the data I want. I use the grouping and grand total features to get the total into the report footer. So far so good.
On the expense side I created a form of a query to manage the one to many relationship to capture the data for expenses (one purchase with many line items). I created a query based of this query to get the relevant data for my expense sub-report. I created the sub-report and got everything looking and calculating the way I want it to. I use the same grouping and grand total features to display the data in the report footer. Still good.
I created a new main parent report with the two sub-reports (sales & expenses) on it and even was able to pull the totals from the sub-reports into the main (so currently the subtotals of the two sub-reports are displayed twice). Now when I try to use the textboxes I used to pull the sub-report totals into the main report to perform additional calculations (sales - expenses) I get #error. I have tried different things and gotten ?name.
Control source for the two textbox controls on the main that display correctly, but don't let me do any further calculations.
=[rptP&LExpensesOverview]![AccessTotalsAmount]
=[rptP&LSalesOverview]![AccessTotalsTotal Sales]
To do the subtraction I have tried using the references above, as well as just using the names of the unbound text boxes in the report that bring the totals into the main report.
As a work around, I tried to build one query with all the data from sales and expenses, but can't "filter" based on date and get the data I want in the query results because the two sets of data are not necessarily related. I either get a long list of records, or no records (I am currently only playing with about 5 days of data).
The aim of what I am doing is to create a monthly statement to give to our intermediaries that shows the commission they will receive each month for the deals they have referred. I have managed to create this report, HOWEVER I can't figure out how to filter out which month I need, so I a report for Jan, Feb Mar etc... The idea is that at the end of each month I need to run the report so only the latest month shows...
I've done this once entirely by accident and can't seem to duplicate it...
I have a report. It has the following:
Report Header: Logo and title Department Header Supervisor Header Group Header Detail Department Footer: Totals Report Footer: Overall Totals for all departments
Here's my question. I have combo boxes on my main form that filter this report. The combo boxes are referred to by the query that runs the report. How do I get proper unfiltered overall totals in my report footer?
I have a report that displays incidents, their details, consequences and a photo. Among the details is a severity rating high medium or low, I have been asked to make the report shorten the records which have been given a low severity (because it takes up as much space as the more important/severe ones).
The only method I can think of is to use the onformat event, to shrink and make invisible all the fields that I don't want to see if the severity field shows 'low'.
We have a shift log that includes both personnel actions during any given day as well as operational actions. (We recently switched from a word document to an Access Database to allow multiple users to input events while another has the logbook open already (which you couldn't do with Word))
At the beginning of each day, my manager reviews the previous days log and forwards up pertinent data (some personnel, some operational) to our higher authorities. Is there a way to allow him to select which records he'd like to include on that higher-authorities report straight from the local-level report?
I'm not a fan of allowing him a "Save As" feature because that kind of defeats the data integrity purpose of an events log where he could save as an RTF and then edit any of the log entries without any checks or balances.
I have an odd thing happening with my reports. There is a main report that gives class information (from query). There are two subreports (from queries also ) with scores (one for each type of test). There are some unbound controls on the main form that display a count of how many scores are recorded which are totals from the subreports. The controls all report the correct numbers however, when I scroll down to view each record, some of them change to #error, or #name, or similar for a moment. Sometimes they will stay in error form when I stop scrolling but change to correct if I scroll up just a bit. Is this because the controls won't calculate unless that report record has focus?
Is there a way to have say five different reports that give out information and at the bottom the totals. I would like to take each of those separate reports to create one report with just the totals.
So I have a text box in a report that I want to pull in data from a field in another report, so the 'control' for my text box looks something like this...
=[Reports]![rptSalesReceiptSub]![Text141] (i.e Text141 is the data I want to pull into my report)
...the path is completely correct but when I run my report I get.#Name? If I run the report that has the data I want, it's fine (in other words Text141 has valid data in it)
I am wondering if it is possible to send a report as xls file and keep the format exactly as the report looks.When I try to send it now, it automatically changes back to the column names from the table, which I in the report have changed and want to keep in my excel output!
I have an unbound form with an associated report. When the user hits the 'print' button on the form/screen, the report is launched in the background. In the On Load event of the report I populate the report fields from the forms field as so:
This works like a charm as long as I call the report in Print Preview mode (i.e. with acViewPreview). But if I send the report directly to the printer, none of the fields print.
I've read about using other report events to populate the fields (e.g., On Format and On Print) and also something about using TempVars to pass the data. But I haven't read anything that's clear and definitive about the full answer.
I created a Microsoft Access database that has a data entry form. This “parent” form has two sub-forms. Each sub-form can have many records that map to the same parent record.
I created VBA code to perform a dynamic query based on the fields I select and their associated values (e.g. query by form). The VBA code creates an SQL string that I use to run a query and present the results. I present the results via a report that looks just like my data entry form. The report includes two sub-reports (one for each of the sub-forms used in my data entry form).
On the main page of my report, there is a field called Gen_Comments. This field is of type “memo”. I see that the data in this field is truncated after 255 characters. This is not the case for any of the fields in my two sub-reports. My SQL statement uses the keyword DISTINCT. (Please refer to the SQL statement below). I’m pretty sure that this is what is truncating my memo field because if I remove this keyword and do a query, I do not get the truncation. However, if I remove this keyword, I then get duplicate records in my query.
HELP!! Can anyone determine if there is something wrong with my SQL statement below (which uses two nested inner joins)? Or, is there something else that I can do in conjunction with the DISTINCT keyword to eliminate the truncation? Any help would be GREATLY appreciated.
SELECT DISTINCT [PR_TABLE].*,SubTbl_DefectClassification.DefectNum,SubTbl_Ac tionItems.StepID FROM (([PR_TABLE] INNER JOIN SubTbl_DefectClassification ON PR_TABLE.ID = SubTbl_DefectClassification.DefectNum) INNER JOIN SubTbl_ActionItems ON PR_TABLE.ID = SubTbl_ActionItems.StepID) WHERE (((InStr(1,[PR_Table].PR_Gen_Comments,"The Wavecom",1))<> "0") AND (([SubTbl_DefectClassification].SevLevel) = "Minor") AND ((InStr(1,[SubTbl_ActionItems].Description,"Just a test",1))<> "0"))ORDER BY [PR_Table].ID
I sincerely thank you, in advance, for any help that you may be able to provide.
-Al Oberneder International Truck and Engine Corporation
The query shows the total rent collected per property and the total expense per property. It then has a sum in it to work out the total profit - SUM(rent collected - expense paid.).
This works fine and the report works fine. But i want to add the totals in the bottom of the report.
So i have three unbound text boxes, one for each column. And the control source is
Sum([rentcollected]) Sum([expensepaid])
these two work fine, but then i have tried to work out the total profit but can't get this working. If i do Sum([profi]) this doesn't generate the real profit as it just totals the profit column which might have negatives.
If i put in sum([txtTotalRentCollected]-[txtTotalExpensePaid]) then when running the report it prompts for the values of the text boxes - these are the names of the text boxes the totals are calculated in.
I have a report based on a query with a between two dates parameter (Begin date and end date). This parameter is fed from a form. All works well - query, form and report. My question is can the date parameter appear on the report header so users know the report was based on a start date of 1/1/2008 and an end date of 1//2009 for example?
After changing data source , header and name of report, only the design view tab changes to the new name of the report. i.e. Changed copy of "Fiscal Quarter 01 Report" to "Fiscal Quarter 02 Report". When open in design view, name tag of report is "Fiscal Quarter 02 Report". In any other view, name tag of report is "Fiscal Quarter 01 Report". If I need to have both reports open in report view, they both have "Fiscal Quarter 01 Report" on the name tab - Very Confusing! How do I get all tabs for a renamed report changed to the new name?
