Reports :: Why Does A Completely Unreferenced Text Box Disappear
Apr 5, 2013
In a report there is a text box that disappears if certain data appears in a record. It is supposed to disappear but I cannot determine why it is disappearing and I need to fix the criteria that make it disappear.
The text box is unbound (the control source is ="Bonus Point Legend"), and there is not any code that refers to it, nor are there any references to it in a query (I can delete the text box and the report runs just fine). Interestingly, if I add a new text box and use the paint brush to format it based off the one in question, it also disappears and acts just like the one in question. But I can't find any code that even references a generic control and makes it invisible. The tag field is not in use either.
View Replies
ADVERTISEMENT
May 23, 2013
I have an image field on a report that keeps showing up even if the field value is null.
=IIf(IsNull([Image_tbl4mgr21]),"",[image_tbl4mgr21])
How to make the white space completely disappear when that image field is empty?
View 3 Replies
View Related
Sep 17, 2013
In Access 2010 I have a Data Entry Form on which I have an unbound textbox in the header that the user can put a default date in. In the body of the form is a bound textbox that records the date and the default value is set as =defaultdatestat (obviously the name of the box in the header).
Problem: The default date shows up perfectly until a value is put in any of the other text boxes.
For further info : If you put values in text boxes default value disappears; if you then push escape the default value reappears when the values in the text boxes disappear.
View 4 Replies
View Related
Nov 9, 2005
Good afternoon all,
Really struggling with my structure and have been looking at it for so long my head hurts so any advice would be great. (see attached)
Basically, I want a DB for keeping track of service / repair of electronic machines. Many of our customers also call us for tech support. There are a number of other items like purchases but once I have worked out one, I can then copy the methods.
Are my relationships even remotely correct?
I cannot get the calls log to work - loosly based on the sample a supplied with Access "contact managment".
:confused:
Any help / advise would be greatly received
View 3 Replies
View Related
Sep 6, 2006
I've been working with this access database for a professor for about a month. Each time I try to do totals, I always get a larger value than it is suppose to be.
Say, I'm suming three fields that have 3, 4, 5 in them, instead of getting 12, I get 50. This happens all the time and I've had to redo the output data several times because the result I got was always outrageously wrong.
Any idea what is going on, or maybe some advice?
View 2 Replies
View Related
Feb 5, 2006
Hi.
As you know it's not possible to set the "BorderStyle"-property of a form during runtime.
But thats a kind of functionality, i need to use in my Access 2003 application.
I need to 'simulate' the value "none" during runtime, that means that there is absolutely no frame/border around the form.
Design-mode is not possible, because i need to use a MDE file.
So i dealed with the APIs and nearly got it.
But i always have had a kind of very thin 'sunken'-frame around my form.
I also played with the extended window-styles, but the result was that i got a 'raised'-frame around the form.
Over all i really got wired in my head.
Maybe someone already did that too and can post the right api-calls / styles here?
I would be really thankful, because i quit that now after hours...
Regards,
AtzeX
View 4 Replies
View Related
Jul 9, 2014
I have a form with a drop down that links to a table where a user can select or type a record, If they type a record that isn't in the table, the form goes completely blank.
Is there a afterupdate event I can do so that if the record doesn't exist, then a msg prompts and the form isn't completely blank?
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
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
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 9 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
Jul 11, 2006
Hi all
I am trying to give a new user access to the front end of a DB.
When I copy the FE from the server to the local C drive ( Windows XP)
the FE loses all its relationships and the user is not able to query anything.
I go back to the server and find that the FE is just fine on the file server.
I also tried running the FE from my PC ( Windows 2000 SP4) and it works fine.
Do any of you know what the issue could be.
I also checked to see that the new user has permissions on the folder on which the file is located on the server and she does...
Any thoughts on what the problem could be would be highly appreciated.
Thanks.
View 4 Replies
View Related
Oct 27, 2006
Recently
I have noticed that the "warnings" in my access 200o database no longer pop up. As example, if I went to delete a table or record, I used to get a pop up warning from MS Access asking for confirmation. Now the record just deletes without a warning. This seems to be happening with other things too.
Any thoughts ???
Thanks
Jackson:eek:
View 3 Replies
View Related
Feb 17, 2006
Hi, I am new to access and I have found important tricks in this forum. Thanks to everybody
Now, I am trying to use a query with multiple criteria. In particular it has to query a table that contains info about candidates tblCands using text boxes, check boxes etc etc present in a form.
First, it works correctly but if I close the form and re-run it, statements in query disappear.
Could someone indicate me what would be the problem?
Thanks in advance
View 2 Replies
View Related
Mar 31, 2005
Well this is going to take a bit of explaining, because my colleagues and I are totally baffled.
I have an Access 2000 front end connected to a Sql production server. I went to make some changes to my forms and subforms, but I did not want to do it with the live data. So I made a copy of the database to my own Sql server on my desktop. So far so good . . . Now when I opened my main form, my subform appeared, but its controls were invisible--I still had not touched the code.
I looked at all the properties for my form and subforms and it is set to Visible and Display always. Now, even stranger, when I advanced my records, if the subform had data its controls would become visible, and then disappear again when I reached a record that had no data for the subform (the main form and the subform are bound to two seperate tables within my database, all the subform controls are bound as are the majority of the form's controls).
Then I went to the code. Nowhere do I change the Visible related properties within the form/subform code. I decided to put a Stop in the Form_Current code of the subform and see what happens as I advance from record to record. What happened was that when I reached a record with subform data present the stop would be read and I would toggle through the Form_Current code. When I would reach a record with no subform data, the Form_Current code would not be read as evidenced by there being no Stop action.
Anyone have an idea of what's going on? Something gets changed when I connect to my local SQL server. Even when I reconnect to the production server the problem remains. Its like some property changes, although I cannot find it, and it is changed permanently. The only property I play with by code is that I enable the controls of the subform when there is NO data in the subform, and I disable the controls when there is data. This code follows:
Private Sub Form_Current()
On Error GoTo Err_Form_Current
If Me!AssignedNumber = True Then
Me!AssignedNumber.Enabled = False
Me!txtWTNumber.Locked = True
Else
Me!AssignedNumber.Enabled = True
Me!txtWTNumber.Locked = False
End If
Exit_Form_Current:
Exit Sub
Err_Form_Current:
MsgBox Err.Description
Resume Exit_Form_Current
End Sub
Finally I tried to set Visible to true within my code for the individual controls, but that still did not overide the problem. I connect to my server via an ODBC connection to a .dsn.
Thanks in advance for bearing with me,
Tony
View 1 Replies
View Related
Feb 27, 2008
Sometimes when I send a copy of an Access 2003 application to a remote user, a stored procedure or function will disappear. What causes this, and how can I get the entire application over to the users?
Thanks in advance!
View 6 Replies
View Related
Jun 3, 2015
I use Access2007 under Windows 8.1 64 bits.Just ignore any message related to a splash form.The form will register revenues in the table TblLanc Receita sPJ. When either saving record input or closing the form, incomplete records must be eliminated from the table. When opening the form you should be able to see the unbound list of revenue inputs made. The list will show empty though because the last time I closed the form thru the button Close, table data disappears. Also, the same happens if I get into the form design mode to analyze the code and re-execute the form.
Please, click on the button Add to input a couple of revenue records thru the form to verify what I just said.I translated relevant input fields so the input should not be a problem. Fields named Quotation, Direct Purchase, and Contract, can be filled in with any data... just make sure only one of these fields per record be input, otherwise you'll get a pokayoke message. Save each input. After 2 or 3 record inputs, close the form and re-open it. Table will be empty. Redo and save new inputs. Go to the form design mode just because. Re-execute the form. Table will be empty again.
Another point is I want to click on a record of the unbound list and have the clicked record fields properly filled in the form. From that point I would decide if the record would be deleted or changed. The functionality of the entire code works but the selection on the list. In other words I do not understand why I am not able to fill in the form with the selected record fields. My code should do that but it does not.
View 1 Replies
View Related
Apr 12, 2007
Hi
I am using MS Access 2003. I would like to setup table link to sqlServer 2005.
sql server and access 2003 is in on the same pc. I have setup ODBC Data source to this sqlServer database. I tested the setup and it work fine.
Then I go to access and action; File/Get External Data/Link Tables.
On lick Link Tables, It open link popup windows. But when I select ODBC Databases() from the Files of Types dropdown, windows disappeared.
It doesn't open odbc datasource windows.
Please could you help to solve this problem.
many thank
View 1 Replies
View Related
Apr 4, 2006
hi all,
Is there a way to make message box disappear automatically after few seconds....
Thx,
Jatz
View 2 Replies
View Related
Oct 2, 2007
Hi,
My property sheet has disappeared I don't know what I did. How can I make it reappears? I have try by pressing the SHFIT key but it won't work. Also, I have created a new database and open it, the property sheet isn't appeared. The icon are still there but when I press on it, it does not response.
Thanks,
Le
View 10 Replies
View Related
Sep 13, 2006
Hello Access experts,
I am using MSAccess 2002. I have removed the tables and queries to reduce file size. I have set database password as "planning". In the form named "Form1" I have created a Shift-Key Enable/Disable button with password "SIMON". In Menu Starup, I have also disallowed Display Database Window, disallowed Built-in Toolbars and disallowed Toolbar/Menu Changes. Now I have problem because I cant unset the Security password and make changes in Startup.. because the Menu Tool/Security, Startup..etc have disappeared. How do I get them back again?
Thanks in advance.
View 2 Replies
View Related
Aug 28, 2005
hey, i hav seen a similar thread about this (i think bout a year ago or so) and i didnt no whether to continue it or start a new thread.Option boxes - Making items visible
that thread did not fully answer my question and after searchin around n finding nuthin i hav decided to ask
in my form i have the payment methods=> cash, cheque, credit. i did have these in a drop down menu, but i wasnt sure how to do what i wanted...which is based on the selection either make a couple of fields (credit card details etc) visible or invisible. so what i have done is changed the drop down list into an option group with radio buttons.
i currently have this coding
Code:Private Sub Frame_Click()If Me.Frame.Value = 3 ThenMe.CardHolder_Name.Visible = TrueMe.Credit_Card_Number.Visible = TrueMe.Expiry_Date.Visible = TrueMe.Type.Visible = TrueElseIf Me.Frame.Value = 2 ThenMe.CardHolder_Name.Visible = FalseMe.Credit_Card_Number.Visible = FalseMe.Expiry_Date.Visible = FalseMe.Type.Visible = FalseElseIf Me.Frame.Value = 1 ThenMe.CardHolder_Name.Visible = FalseMe.Credit_Card_Number.Visible = FalseMe.Expiry_Date.Visible = FalseMe.Type.Visible = FalseExit SubEnd IfEnd Sub
this seems to work although say if my first record has credit card selected, then all the fields are visible, but wen i move onto the next record which is cash or cheque...they are still visible until i reselect cash or credit again..(and vice versa)
i hope this makes sense :P
thanks
View 3 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
Nov 22, 2013
I have a query that's been working fine for years, however...the powers that be have requested a change. We need to track the lining owners in cars. We've recently gone to SQL on the back end (which I basically know NOTHING about) but I set up the new table, refreshed the connection, etc.
I can see the table fine and it says it has a primary key, auto numbers, etc. however, as you can see from the jpg below when I add the table to the query and link the id as in all the other tables, for some reason, this one makes all the data disappear when in datasheet view.If I delete the table from the query - it all comes back.
View 5 Replies
View Related
Jul 17, 2013
I seem to be having an issue with a split form I've been working on. I created this split form on Monday and it was working just fine but today, I have added a couple minor text boxes. Since then, I can view the form contents in Design View but when I switch to "Form View" or "Layout View", it's all gone minus the logo in the top left corner and the title for the split form.
View 12 Replies
View Related