Reports :: Tooltip / Popup Text Box / Floating Text Box?
Jul 5, 2014
I have a report that lists incidents for a specific day (reference number, a brief description and a few other fields). There is also an additional notes field, which I would like to be viewable from within the report.
For example, as a tooltip when the mouse hovers over the brief description text box. Or displayed in a textbox on the right (I don't want one textbox per line though, but instead a single re-usable textbox). Or a more information button/link that shows a "popup" containing the additional notes. I don't want to exit out of the current report, but stay within it.
I have tried to achieve this with a tooltip, but in fact even when I manually typed in a tooltip on the control's properties it wasn't displayed when I hovered over the text box.A pop-up or floating textbox would be preferable.
View Replies
ADVERTISEMENT
Jul 10, 2015
I have a Floating Holiday that doesn't happen every year how do I incorporate this in Access 2010, I have a report that calculates Paid Time Off for employees and when they have a year that has a Floating Holiday or doesn't have a floating holiday, how do I incorporate that into a query or report without losing the calculations from the previous year reports.
for example, this year a floating holiday is allowed so my calculations work, but next year if a floating holiday isn't allowed how do I make it a 0 without losing this years data.
I tried tblFLOATINGHOLIDAY with several years listed (at first used Yes/No) and a field that you either put 8 or 0 (8 hours or 0 hours). Then I used a query combining tblEMPLOYEES and tblFLOATINGHOLIDAY with citeria for FLOATINGHOLIDAY to be 2015 so all the records would show 8 under FLOATING HOLIDAY. But it comes up with no records.
View 3 Replies
View Related
Jun 4, 2013
I have a single field in a table called "Client Contact", where users enter a semicolon between the name, address, and city state & zip. My reason for this was so we could copy client info with a single copy and paste (like from an email). But, on the final report, it needs to have these three parts split up into different lines, or even different textboxes. I can't find a way to do that.
View 1 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
Sep 18, 2014
is it possible with transform, only uppercase text contained in a report textbox, to bold? How? Through VBA?....
View 1 Replies
View Related
Aug 7, 2007
I have a text box. when I right click on this text box, I want to show a popup menu with a shortcut: Shift to another department. when I click this shortcut, I want to execute instructions.
How can I make this.
Thanks,
View 5 Replies
View Related
Apr 6, 2008
I have a field on frmOutpatient which is called EpisodeID.
I need to populate this field from a selection in a pop-up form.
The pop-up form (frmSelect) is a continuous form with a number of different EpisodeID numbers according to the date the patient was admitted. At the end of each record I want to put a command button (cmdSelect) and when pushed I want this SelectEpisodeID to be transferred to the field on the frmOutpatient.
Any ideas??
View 6 Replies
View Related
Nov 20, 2013
I know how to do an action on doubleclick or mouseover but I want some simple text to come up, possibly with a white background behind it that has some details about the specific production number that the user is clicking on. Is there something like this? I tried a dialog but it brings up an ugly form, I just want the text or something simple. Can this be done?
View 2 Replies
View Related
Apr 11, 2013
I have a report that has Bill to and Ship to addresses. They are positioned across from one another (ship to on the right and bill to on the left of the page). The issue is that the 'can shrink' doesn't work when there is data in the same field on the other address..
View 1 Replies
View Related
Mar 22, 2014
I have 4 fields that are unbound on a form. img1 img2 img3 img4..When these are entered they are all combined and autofill another unbound textbox = imagename.. what i would like to do is from this unbound textbox 'imagename' ..i would like to populate a textbox that IS bound called FileName
[Event Procedure]
Private Sub imagename_Click()
Me.imagename = Me.FileName
End Sub
View 4 Replies
View Related
Apr 25, 2007
Is there any way to include tooltips on reports or anything that would work similar, besides using a form.
Thanks!
View 1 Replies
View Related
Mar 6, 2014
I use an Access database at work and there is little technical expertise for support. I have been using this database (or a copy of) for the last few years. I am not sure what happened or when but the problem now is that when you try to run a report (that I've ran a hundred plus times in the past) the text boxes only display 255 characters. The big question is what changed. I asked my team and the only logic is it happened during the annual transition when the database is copied into the next year and the CA table auto number is reset. We think that this started around this time. I was told the process used to reset the auto number was a combination of information found here support .microsoft. com/ kb/ 812718 and use of compact and repair.
So it was found that both the 2013 and 2014 databases are having this issue. We are hoping to avoid have to revert back to the 2012 database and import all the data and items (queries reports etc.) that have been created over the last two years.
View 4 Replies
View Related
May 24, 2012
In my form's text box I have noticed that I can;t write paragraphs ie use the TAB key to start a new line. If I use rich text I assume this will be possible. But are there any disadvantages to using rich text?
View 1 Replies
View Related
Nov 5, 2013
I have a text box that has an iif statement in it and a referenct to a numerical value that is suppose to be a currency.
The table that is providing the source for the report show the value as $x,xxx.xx and if a create a text box with just it in the report it shows as $x,xxx.xx but when I put it into the iif statement it shows as $xxxx.xx with no comma.
iif statement example in txtbox:
Code:
=iif([Happy]=true,"I am happy with " & [value] & " in profits","I am sad with " & [value] & " in profits")
[value] is suppose to be like $1,111.11 but instead their is no comma showing $1111.11.
View 2 Replies
View Related
Oct 25, 2014
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 Related
Jun 6, 2005
Hello Guys,
I am new to Access 2000 and issue is ,I have a field name product_name with datatype MEMO,when I chek my report at the place of product_name instead of the name of product it shows a squared symbol ,i dont understand how I can see the values of product_name.
SO anyone can help me out ,bcos of this I m stuck into my project.
Hope to get answer asap...
Thanks!
Vsap
View 14 Replies
View Related
Mar 3, 2006
I am creating a report based off a query. My problem is that I am trying to create conditional statements within a unbounded text box. I would like to say: =[Field] where [Field2] = X. Unfortunately, I can not find any support on this matter.
View 14 Replies
View Related
Mar 27, 2013
I have a report based on a parameter query. One of the parameters is TM Name. This parameter value is selected from a list box. The table on which the query is based also has TM Name as a look-up from a list. So ofcourse the ID is showing in the TM Name field on the report...not the actual name.
I am attempting to use a Dlookup to show the actual name than I will hide the field with the ID. Here's what I have as the control source:
=DLookUp("Name","TM_Names","[TM]=" & [Reports]![Report_TM_Records]![TM])
It is pulling in the value of the first row in the "Name" column of the "TM_Names" table. Doesn't seem to be looking at the value in the TM field on the reports.
My gut feeling is the report needs to be "saved" or "refreshed". I have tried a few macros to do this but I get errors.
View 1 Replies
View Related
Oct 15, 2013
I am trying to create another text filed if the first one is overflow in a report.
Text= If my time was right I would have taken the chance to find another job but it was not possible since there was nothing available at that time
Text count for above is 147.
Text1 width =85 characters
Text1= If my time was right I would have taken the chance to find another job but it was not
Text2 width =85 characters
Text2= possible since there was nothing available at that time
View 12 Replies
View Related
Mar 11, 2014
I am trying to display zeros in a report and at present I'm getting blank in text box where the value is zero. How do I display zero?
View 9 Replies
View Related
Jan 7, 2014
I have a textbox that has 3 columns in it (Rank, First Name, Last Name)...when the user selects the appropriate choice, it just shows the Rank.
Ex: Lt. John Smith --> just shows Lt.
To get around this I made an unbound text box and have it set to show all three choices when the selection is made in the drop down box. Unfortunately, it isn't working right. This is the code I am using for the text box:
=[OPRID].[column](1) & [OPRID].[column](2) & [OPRID].[column](3)
Is there anything that looks wrong with this code?
What it ends up showing in the text box is: JohnSmith (no rank, no space between the names).
View 3 Replies
View Related
Nov 19, 2013
I'm creating a form letter in Access 2002 and the letter is completed but I want to change the formatting from align left to justify but can't find a way to do this. The detail section contains 2 label boxes and 1 text box.
View 9 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
Feb 10, 2014
I have a textbox in a report that I would like to calculate the sum of values that are less than 600.Then have a second textbox that counts the number of records that have values less than 600..This is based off of a query with calculated fields..I have been working with a formula that looks something like this
=Sum(IIf([BaleETime]="<600",0))
But all I get is a value of 0.BaleETime is the elapsed time between bales.
View 3 Replies
View Related
Jan 17, 2015
I have a report that was created on my computer. When this report is opened on other computers (2 that I've tried) the text alignment is way off. Originally I thought it had to do with printer margins dictating something but that is not the case as the margins remain identical on all computers. It's not a font issue because it's Arial which all computers have. The text is written inside a "label".
View 5 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
