I have a report that prints lab tests. One section has 4 columns that are framed. Only the first control (STest) expands to more than one line. The Can Grow works on this control and subsequently the section expands. I need a code that expands the height of the other three controls to match that of STest. I am using office 2010.
View RepliesIs it possible to make it so that whatever the dimensions of the image i paste the OLE object's frame will also be the same? I'm having a problem, not necessarily a problem more like a preference, I'm inserting pictures of each individual inside a database and whomever last took these pictures didn't make sure there was a standard size So all the images are different sizes and when they're put inside the OLE frame you can see the image inside it but the frame itself also shows its white background because the image isn't the full dimensions of the frame. I was thinking if it's possible to make the frame automatically adjust to the image's width & height.
View 3 Replies View RelatedHow do I make the blank line disappear after the control is no longer visible? I tried to set the Height property to 0 in the OnPrint Event but I got an error message 2191, you can’t set height property after printing has started.
Thank you,
UongSaki
Hi,
When the user click the button, then it will give out a popup form to the screen, but I want to make the popup form's height as same as the screen/window/monitor's height, because the popup form's height is larger than the screen's height, and every user's monitor's height is different. So, I have to make it flexiable change of the height of the popup form.
How can I check the screen/window height by VBA function?
In Excel, it has Application.Height to check. In MS Access Form, I cannot find one for doing that.
Please let me know if you have one.
Thanks.
I am trying to make something like custom bar chart on a form using rectangles. I made 4 rectangles (BarBZ, BarBA, BarKI and BarMA) and have the following code:
Code:
Dim PctBZ As Double
Dim PctBA As Double
Dim PctKI As Double
Dim PctMA As Double
PctBZ = Me.BZ / (Me.BZ + Me.BA + Me.KI + Me.MA)
[Code] ....
It works perfectly except... the rectangles grow/shrink downwards and not upwards. As a result the bars are aligned to top, while I would like to have them aligned to bottom.
I am working on a report that will have 16 sub-reports, one right below the other. Because of the complex nature of the calculations in the groupings it seemed easier to "build" the report using vba rather than using the report's built-in grouping ability. The issue I am running into is that there seems to be no simple way to control the height of the sub-reports. I had hoped that setting "can grow" to yes would change the height of the sub reports and move all subsequent sub reports down (Allas)
As an alternative I thought too that I might be able to set the height of the sub-report control, which would make for a tricky but not impossible bit of programming, but (Again allas) I can't seem to find a reasonable way to determine the required height of the sub-report's control.
I have an existing report with a number of fields arranged horizontally in a tabular fashion in the detail section. The first field is an identifying line of text and the remaining fields are numerical calculations. The report is basically a simple profitability estimate report for a number of different products.
Behind the fields of data is another text box that is blank, which stretches across all the horizontal fields, and which changes background color using conditional formatting. When printing, this colors the whole row according to that criteria (it changes color based on the relative profitability of each product in the report).
The problem I'm having is that the first line of identifying text can sometimes overflow.
I've set the Can Grow property to Yes for this and all other controls in the Detail section. But the result is sometimes some funny-looking formatting. The identifier (like "Product XYZ with a really long description") will word-wrap, but every other field in that row maintains their own height. In particular, this makes the coloring of the conditionally formatted row look off, because it provides only one line's worth of color, even though the product description has wrapped to two lines.
How I can resize all the controls in the Detail section based on the height of the tallest control, and keep the whole thing dynamic?
Things I've tried: I've tried putting some VBA in either the OnFormat or the OnPrint events that iterates through the controls in the section and resets their heights. In the "OnFormat" event, nothing happens (no errors and no apparent changes in the appearance of the report). In the "OnPrint" event, I get an error that says the height property cannot be changed during a print or print preview.
The VBA I tried using was as follows:
Code:
Dim ctlIt As Control
Dim lngMaxHeight As Long
For Each ctlIt In Me.Controls
If ctlIt.ControlType = acTextBox Then
[Code] ....
I have a report which will be printed on preprinted paper. On this paper a footer is printed with e.g. address info.
The report has a detail section with a height of 3,5 inch and canGrow=true.
The reportFooter contains totals. The size of this footer, and placements of the fields prevents printing data on the pre-printed footer of the paper.
But when the report has multiple pages, the report footer will be printed on the laste page, and the detail section is expanding to the bottom of the paper, overwriting the pre-printed footer. I need a max height of the detail section, or another solution.
How to fix the height and width of a report. I would like the report to stay landscape, 100mm wide, 62mm high. This is required by a label printer.
The issue is that a A4 laser printer has to be set as default (for other software) so when the report is launched the size is set to the default printer size, when I select the label printer it fails as it is the wrong size.
In the detail section of my report, I recently added a second row which has only 1 text field. When the value of the textbox in the 2nd row is null, I want the total row height equal to just the first row. When the value in the textbox in the 2nd row is not null, then the total row height is equal to row 1 and 2. I tried to make the textbox in the second row invisible when it had a null value thinking that when it was null, the report would shrink to the first row height, but that didn't seem to work.
View 1 Replies View RelatedI have to print address labels. 10 x 3.8 cm labels 2 per row 14 per page on an A4 paper. Pretty straightforward one should say. But no. I play around with the margins, column heights and widths, row and column spacing page size wasting time. Is there a hidden and not documented relationship between those elements? For example how is the column height and row spacing linked together? How is this normally done in a professional way?
View 3 Replies View RelatedLooking for advice on how to make changes required in my database designed to track health wellness. Here is a breakdown of what I have now:
Membership Query built off membership table that isolates one employer group and creates age off birthdates that will change as the months go by.
Category table that gives up to 9 different items included in the wellness program along with the criteria. Shown as A through I with corresponding age and time restrictions.
Compliance Log – results come from compliance input form that updates each member’s data relative to the wellness items that are listed. Based on restrictions in place for their age group, we have been indicating them as either compliant or non-compliant.
Scorecard – built of some of membership query details, including the group # and the age of the person. Contains a subform that is built off the compliance table that lists the Wellness Category, Time Frame, Criteria, Compliant (yes, no, na, unknown) and complaint date of activity.
Everything was perfect until one of the larger employers now wants the scorecard to be more specific. In other words, under criteria, wants specifics spelled out according to gender and age. Previously we were showing “to be completed within time frame”. Even though everyone’s scorecard showed the same category/criteria information, we internally applied the age/gender rules based on our data input. Now they want the criteria to reflect the rules applicable for each member only on his/her scorecard. Example: Health Maintenance exam, age 19-39, every 12 months (if member within that age group) or 40+, every 12 months etc.
I have struggled most of last night trying to figure out different ways to make this happen in an automated way, and I am at a loss as to how to reconstruct some of my work to allow for this. I am looking for some ideas here. For starters, I did expand the category table to include the different gender-age groups but cannot figure out how to get this related to my members, their changing age, and the scorecard.
I am attaching a brief copy of my DB with hopes that someone can help me. We need to send scorecards out on Friday and short doing lots of manual things; I am not sure where to go with this.
:confused:
I'm trying to perform a task that I'm absolutely certain is simple to do.. if you know how to do it. I'm trying to add three check boxes in the form header to affect the query related to the form.Each is a simple Boolean, and simply want to apply a "WHERE col1 = val1, col2 = val2, col3 = val3". Like I said, very simple.
It seemed like I could just use a Macro in the click event of the check boxes, and use a SetFilter within the macro that applies a Where Condition = [Shipped] = [chkShipped].
This... almost works. When I click the checkbox it asks for the value (it doesn't know how to process [chkShipped], which is the name of the corresponding checkbox). So that's broken, but if I provide 0 or -1, then I get the expected result.I would like a 3-state checkbox, but I can't even get this working. I can tell I'm either close, or in the entirely wrong direction.
I can't find anything in "access reports 2010" which allows me to adjust the line spacing. The default spacing is "huge", yet line spacing is set at 0cm.
Quick note: line spacing is the distance between detail lines.
hello all
i have a problem, i have a form bounded to a query
that displays the books infos, in this form i have a list control
that displays the list of authos based on the code of the book
the problem is when i have more than one record in the opened
form ie more than one book and i move to the second record
the list doesnt change and displays the authors of the first book
when the form first opened
anyone has an idea how can the list be updated automatically when
i move between records
thanks a lot
I have created and saved a form in access automatically from database table. But when I change Display Control of a field from text box to combo box,it is not reflected in the form automatically after I refresh the form.
View 1 Replies View RelatedI have tab controls, each of which holds a report. If the report is longer than the tab control the report is stuck there. no slide bars, no overflow. I have set scroll bars but they dont seem to take or work. I need to find a way to add verticle scroll bars to the reports within the tab controls so that you can view the entire report. I have included a screen print of what I mean.
View 1 Replies View RelatedIs there a way via code in a module to automatically create a snapshot of a report, save it in a specifed folder location in the code and save it as the current date as the file name when a button is clicked.
I'm looking on how to do this as I have many reports to create, move to an intranet folder and then name it to the current date. It will save me lots of time if this can be done automatically.
I am using MS Access 2000 and the folder location will be on my hard drive.
Thanks
Aden
Relatively speaking, I've got a pretty simple database. The presenters at our community radio station fill out a form of what song they play and this (along with the system time) is stored in a table.
I have a wildcard query to bring up all entries from a certain date and at present, I export a report of this by hand on a Saturday for everyday of the previous week - but I want to automate this?!
I can change the query to be a standard one to just bring up entries for today. I then, somehow, need to automatically export a report of this query as a PDF at midnight every night into a certain folder with the file name being today's date.
currently i have to open my report and export manually to save report as pdf.
This is my code to open for specific user :
DoCmd.OpenReport "myreport", acViewPreview, , "[User_ID] = " & Me.User_ID
now I want to output my report to pdf automatically to a certain location.
how do i filter with specife userid ... by using DoCmd.OutputTo
DoCmd.OutputTo acOutputReport, "myreport", acFormatPDF, "C:Userspublic empCourse " & [UserID] & " - test.pdf", False
is there any other way i accomplish this..
I have created a report that includes 4 subreports. The subreports are displaying survey results from 4 different survey channels. New survey data is added to the tables monthly so the subreports will grow in size. Is there a way to have the subreports automatically resize and push down the subreport below? Currently what is happening is a subreport will grow and the additional data disappears underneath the next subreport. Is there a better way to create a report that displays information from multiple reports that will change in size?
View 1 Replies View RelatedI have a multi-field search form with a tickbox that is tied to 2 queries that is tied to 2 reports. The form works great and I get all the results I want, but my report doesn't display on my monitor, it simply prints up! How can I get it to stop doing this and show only on my screen?
My code on the "run search" button is:
If Me.[OptionalCheckBox]=True Then
DoCmd.OpenReport "rptReport1" acViewNormal, acWindowNormal
Else
DoCmd.OpenReport "rptReport2" acViewNormal, acWindowNormal
I have put together some Access 2010 Databases and I am about to embark on another soon. I have been given a request that I can't seem to solve yet so I am goint to ask it here as a good starting point. The goal is to build a database for a magazine. They want to be able to run a report to generate slips for subscribers whose subscriptions have expired. I would like to, if possible, generate reports and send them to the respective clients via email, all with the push of 1 button. I don't want to have to find each subscriber and do one off reports.
View 1 Replies View RelatedI have created some Crystal Reports to open out of MS Access. Everything works great for me and all the users, except one.
The one user when they try to open the report gets nothing (no error, no lock-up, nothing). It is only on their machine (we have tested them logged into other machines and the report works just fine).
My guess is there is something wrong with the Crystal Viewer on their machine (in our case Crystal 8.5 ActiveX viewer control). I looked on their machine, and they have the same .ocx control as myself and the other users C:Winntsystem32Crystl32.ocx
I even went into their Access and Registered this ActiveX control (design view of a form) and still was not able to get the control to work. We were thinking about re-imaging this users machine, but this is the only error they currently have. I was wondering if anyone else had run into this error, and if so is there an easy fix?
Thank you for your time.
T.J. Bernard
I am currently working on a project that is almost complete, but my only problem is that I am clueless as to how I can get a text box in my report to hide base on if a text box in my form is hidden. Meaning that whenever this particular text box in my form is hidden then the text box on my report should be hidden too. how to get my form and report text boxes in sync with each other.
View 14 Replies View RelatedI've many items to be put on a form. However, I can't expand the height of the form. The max height I can get is 55.873cm. Could anyone please teach me to expand it?
Many thanks.