Report Text Box
Jul 19, 2006
I have a report that is opened from a form and is based on a query. There are three text boxes. The first two text boxes come from the query and their values are ratios computed in the query. The value for the third text box is based on the values in the other two. If the value in the first text box is greater or equal than .95 and the the value in the second text box is between .90 and .95 then the value for the third should be .03. If the value in the first text box is greater or equal than .95 and the the value in the second text box is greater than .95 then the value for the third should be .05. If the first box value is less than .95 and the second text box value is less than .90 then the third should have a value of 0. I have tried several If Then.. statements in the On Click event of the command button in the form and a Select Case in the On Format event in the Report Section but it never works. If anybody could help me with this problem it would be greatly appreciated!!
Thank you in advance
View Replies
ADVERTISEMENT
Jun 23, 2015
I am using Access 2007 and 2010. I would like a text box (or label) on a report to autofil using fixed text from a label on a different (closed) form.
View 8 Replies
View Related
Jan 30, 2015
Is it possible to use find and replace to modify text in report design - or else is there something else I can do to get the same effect? I have a really useful report and I want to modify it for use with a different dataset. To do that I will need to change the text in over 150 text boxes. I have seven different fields which each occur over 20 times in the control source formulas in the text boxes, because they are used in different ways in different calculations. If this was excel I could do a simple find and replace to change e.g. every reference to fieldname OLD to fieldname NEW, but I cannot see how to do that within access report so am haveing to click on each text box in turn, go to properties and edit the text box .
I am trying to switch to a more general naming system in the modified report so then I will be able to assign data with the required fieldnames for the report within a query. But the report I am starting with has field names based on years 2013, 2014, 2015 etc.I want a quick way to change each reference to those field names to my more generic new field names.
View 2 Replies
View Related
Oct 5, 2005
I have a report in an Access file that someone created for me. I have
NO real experience in Access, it was all done for me, and now I want
to do some editing.
What I have is a letter with "letter head" at the top (text box 1.) This text is centered.
The date (text box 2),then body of the letter follows in the main
larger text box 3. This text is left justified.
When our Principals change I need to change the first text box sometimes
this means there are more or less lines in this box. I have done this successfully, although I'm not sure if it was "correctly" I have replaced names, and made the box smaller to get it to wrap so there is the correct amount of text (Name) on a line. I'm not sure what I would do if I had a line that I don't want to wrap that is longer than the line I do want to wrap. but that is working for now.
The first thing I'm trying to do is put the date in the third larger
text box instead of a seperate box. To do this I figured I needed to
add a blank line before the first paragraph of the 3rd text box, then
enter the current date code. I tried to copy and paste the code from
its current seperate box and paste it into the third box, but then the
report only shows the code/no date and the following paragraph isn't
aligned properly since the only way I could figure to move it down was
with spaces. I tried ctrl/enter, and that just gave me some pop up
dialog box with some tools in it that I don't know what to do with.
The second thing I wanted to do is bold only part of the text in the
large/3rd text box.
Some how I ended up with some blank space between 2 paragraphs so what
I did to get the bolded text paragraph I want is add another text
box, bold it and place it on top of the existing larger text box, but
I always have to move the 2 boxes (3 if you count the date) when I
need to shift the text up or down for any adjustments I do in the
first box. Is there a way to only bold one paragraph of a larger text
box?
I have tried different things, and I have searched "help" as they like to call it, but it is NOT!
I hope this is clear.
TIA
Susan G
P.S. I have tried different things, and I have searched "help" as they like to call it, but it is NOT!
View 3 Replies
View Related
Jun 5, 2006
Hi people,
I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"?
Something like:
Private Sub Report_Open(Cancel As Integer)
If txtFireType = "N/A" Then
txtFireType.Visable = False
End If
End Sub
This doesn't seem to work by the way!
Really appreciate all of your help.
View 2 Replies
View Related
Mar 15, 2005
Hi! Don't know if you remember me, but I'm back again with a weird question.
A while ago, I built a database with a report in it that served as a schedule for my hospital. Names down the side, dates across the top, with counts in the data fields. Like if So and so works on 3/16/05, there would be a '1' in the field at the intersection of that date and her name. Now, because we have so many different shifts and the directors want everything in the grid fields, I'm trying to figure out a way to put in the actual shift symbol (7A, 7P, 12, D, E, N, etc.) in the grid for them so that if they have 7 nurses on the 7A shift and 3 paramedics on the 12 shift, and one unit secretary on the D shift, they will all show on the same schedule. Here's the data from the query I am using. It's a crosstab query and I'm not quite sure how to tweak it to get it right. Thanks for any help/advice you might be able to give me.
PARAMETERS [Forms]![frmDates]![Date] DateTime;
TRANSFORM Count([Staffing Query for Department].Title) AS CountOfTitle
SELECT [Staffing Query for Department].ERName, [Staffing Query for Department].Department, [Staffing Query for Department].Title, [Staffing Query for Department].Shift, Count([Staffing Query for Department].Department) AS [Total Of Department]
FROM [Staffing Query for Department]
GROUP BY [Staffing Query for Department].ERName, [Staffing Query for Department].Department, [Staffing Query for Department].Title, [Staffing Query for Department].Shift
PIVOT "d" & DateDiff("d",[Forms]![frmDates]!Date,[Date Scheduled]) In ("d0","d1","d2","d3","d4","d5","d6","d7","d8","d9","d10","d11","d12","d13","d14","d15","d16","d17","d18","d19","d20","d21","d22","d23","d24","d25","d26","d27");
I am going to try an Iif statement and see if it helps. Thank you!
Kelly Jo
View 1 Replies
View Related
May 10, 2005
I have a need to take two fields and make them appear as one with the first one bold and the second one nonbold.
The text needs to look like:
FOOD tomato
HOUSING STYLE log cabin
FISH cod
COLLEGE DEGREE BA - Biology
These are all from the same table, two fields (type, value)
To have a report look like this I figure I need to know the width of the first field and then position the second field near that position.
Any ideas.
Thanks
View 7 Replies
View Related
Jun 5, 2006
Hi people,
I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"?
Something like:
Private Sub Report_Open(Cancel As Integer)
If txtFireType = "N/A" Then
txtFireType.Visable = False
End If
End Sub
This doesn't seem to work by the way!
Really appreciate all of your help.
View 2 Replies
View Related
Mar 12, 2007
Hi,
I looked through your forums and didn't see this question answered. Forgive me if it is already there and I couldn't find it.
I have a report that I want to add a new text box to. When I create a form there is no problem choosing the different control sources of data that I want to put into the text boxes on the report. However, once I have created the report I can't seem to go back and make the data come through correctly if I am adding a new text box.
Example: I want to add a text box that is pulling through data from a field named "Duty" in a table named "Container_Vendor_Information". I put the text box into the created form and navigated through the control source choices to get the text box to point to where I want it to. Something goes wrong after that. When I close the form and try to reopen it I get a pop up box that is asking me to enter the parameter values for "Container_Vendor_Information."
I know there has to be an easy way to do this. All I'm doing is looking to add a new text box to an exsisting form. Any thoughts would be most welcome.
I would attach the database but I guess I don't have enough posts yet to have that option.
Thanks
Eddie.
View 2 Replies
View Related
Aug 6, 2015
I have a report and want to set the value of a text box to a value from a query (Field "Week1Start" from Query "qryWeekDates") that is not part of the record source of the Report.
I have tried setting a On Load event:
Private Sub Report_Load()
[Text70].Value = qryWeekDates!Week1Start
End Sub
How can I change the code to get it working?
View 5 Replies
View Related
Jun 27, 2005
Hi, I want to insert an Expression in a text box of a report using VB.
This is what I wrote in the code builder section of report header.
Me.totalBox.Value = strTotalExp
Me is the header section of the report.
totalBox is the textbox.
strTotalExp is the expression that I want to enter, it is a string.
How should I do this?
Thanks.
View 12 Replies
View Related
Oct 2, 2005
Not sure if this is possible but I have a few text boxes on a report set to vertical yes under properties. They print fine, but on the pre-printed forms I'm using they print upside down. Is there a way to realign they way the text prints when using the vertical yes setting? I really need they text to be inverted. I'm I asking an impossible question? Thanks..
View 1 Replies
View Related
Apr 21, 2006
In my database I would like my report to run every 30 seconds and export that data to a text file. I am not sure if that is best with a Do While or Do Until.
What I am looking to accomplish is to populate a map with data from the data base report. it needs to rerun the report and write the text file every 30 seconds to 1 minute.
Any help with the coding would be greatly appreciated.
View 1 Replies
View Related
Feb 8, 2007
Am I missing something simple here? I have several text boxes, which I want to add the values. I have tried these formulae, but dont work:
=Sum([Postage],[ProgTotal])
=Sum([Postage] + [ProgTotal])
=DSum([Postage],[ProgTotal])
Any help would be greatly appreciated!
View 7 Replies
View Related
Oct 17, 2005
Can anybody tell me this:
i want one textbox on form to be entered by user.When this form is submitted, enteredf text on form must be displayed in report.
How can i do this ?
View 4 Replies
View Related
Feb 7, 2005
I have a date field in a form which is not compulsory.
I then pull this date field into a query to create a report.
If the date is not entered then is it possible for "Date not entered" to be written into the report automatically. I have tried playing around with nulls but have had no luck.
View 1 Replies
View Related
Sep 10, 2005
How do you format text for output into a report for initial caps?
Thanks much
View 2 Replies
View Related
Jun 27, 2013
When I send a customer a work order, I want the final page to be a list of conditions of the current sale. In Word, it is nearly a full page of 7pt font with bold and italic. What is the best way to add this to the end of my report in Access?
View 14 Replies
View Related
Mar 11, 2014
I am trying to add text to a report. I am using Access 2007.My report is tied to a query. The query contains 2 fields-Hostname and MAC Address
I want run a report against the query, but need to add several commas. So the output of the report would look like this: hostname,MAC Address.
I then want to export the report to a plain CSV file.I thought I could just add a textbox with a comma in the report, but that didn't work well. When I added the text box, Access also created a column header that I did not need.I've also noticed that when exporting a report to CSV format, there are several characters (pipes and such), that work with the formatting of the report. Is there any way to remove this formatting?
View 6 Replies
View Related
Apr 16, 2015
I have a text box in a report that was calculated,
=IIf([RemainingGrantFunds]<([Grant_Amount]*0.2),"1","0")
So, if certain criteria are met, either a 1 or a 0 will be shown.
Then in my OpenReport VBA I have,
DoCmd.OpenReport stDocName, acPreview, , "ExpiryTag = 1"
'ExpiryTag' is the name of the text box from above.
When it equals 1, I want the report to show those records. I have done this for other reports and it worked so easily, and for some reason it just doesn't want to work on this report. I believe the difference is that the text box is calculated in the report and not in the query (for this report I can not calculate it in the query). I think it might have something to do with the output of the 1 and 0
i.e. "1" versus '1' or just 1.
I have also tried every iteration of "ExpiryTag = 1"
i.e. "ExpiryTag = '1'" or "[ExpiryTag] = 1" etc.
View 4 Replies
View Related
Oct 27, 2014
SELECT Count([Unsafe Act ].[Tag]) AS [CountOfTag], [Unsafe Act ].[Audit], [qryTag].[Tag]
FROM [Unsafe Act ] LEFT JOIN [qryTag] ON [Unsafe Act ].[Tag] = [qryTag].ID
WHERE ((([Unsafe Act ].Date) Between [Forms]![frmSafetyReportOut]![startDate] And [Forms]![frmSafetyReportOut]![endDate]))
GROUP BY [Unsafe Act ].[Audit], [qryTag].[Tag]
HAVING ((([Unsafe Act ].[Audit])=[Forms]![frmSafetyReportOut]![cboConditionAct]))
ORDER BY Count([Unsafe Act ].[Source Of Tag]) DESC;
I am trying to run this query and query works fine however I am trying to run a chart on the report which shows ID's of Tag instead of txt of Tag.
View 2 Replies
View Related
Feb 15, 2008
I am using a combo box to enter Employees names for training hours...I want to use a pivotchart but when i use the training hours table/form the pivotchart gives me the combo box numbers instead of the names. I know there is a formula or something I am suppose to use here or even a query but I don't have a clue as to how to do this....if someone would be so kind in directing me with instructions and help...thanks
:confused:
View 4 Replies
View Related
Jan 23, 2007
Hello all
i need to create a text field and button in a form that will show all the records for a particular JobNo in a report once the txt has been typed and the button is clicked, i.e if I type JobNo001 I need to to create a report showing all the information for that JobNo(but there can be multiple JobNo's).
Do i have to create a query for this. I am new to this so please be gentle
Thanks
Chris
View 1 Replies
View Related
Nov 7, 2005
I am trying to create a report based on a table field called "ClassNo".
I would like there to be a pop up that asks for the begining and ending "ClassNo".
View 2 Replies
View Related
Feb 21, 2005
In a table called Appointments and the field called Plastics we enter the initials of surgeons.
However in a report i want the initials converted to full text - in the example below the initials are HJC
The expression below doesn't work - it just returns everything in the Plastics column.
Any ideas?
Expr1: IIf(HJC([tblAppointment]![Plastics]),"Heather Cleland")
View 1 Replies
View Related
Apr 12, 2005
Dear All:
I have created a form with students information, name, address, ID number, etc.
Is there a way to place a checkbox on this form that when it is checked, it displays text on a SPECIFIC AREA ON A REPORT?
I wish it to return this text on a report: "HONORS COLLEGE"
Many thanks in advance,
Dion
View 2 Replies
View Related
