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!!
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.
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!
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
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!
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
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.
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
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..
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.
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.
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?
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?
'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"
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.
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:
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
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.