Hiding Fields
Aug 12, 2005On a form, what is the best way to hide a label or text box? I'm guessing that I can do a checkbox which would work for me and just write a macro to hide on a false value?
View Replies
ADVERTISEMENT
Hiding Fields
Apr 15, 2005Hi can you help. I am developing an access database for an alarm installation company. The database will consist of five tables (stock, supplier, customer, stocksupplier) all with forms.
The customer table holds data for three customer types business, private, caravan. Each customer type has different data stored for it for example the business customer has more than one contact address whereas the private has one.
The problems is on the form I do not want all the fields present as this would look a mess. Is there a way of clicking a radio button or choosing from a drop down list that would make the fields relevant to that customer type appear or grey out the fields that are not needed.
I would appreciate any help as the only alternative I can come up with is have them all on one form. I do not want separate tables as this would complicate the design. I hope this makes sense and thank you in anticipation
Kind Regards :) :)
Peter
Hiding Or Showing Input Fields And Formatting.
Apr 30, 2008Firstly, thanks to everyone for help so far. My first access project in a proffessional environment has been successful and mostly down to the people who have helped me here. I know i didnt really do it all myself but i have learned things that will hopefully serve me well going forward!
Secondly, i apologise for the ambiguously titled thread, i'll explain what i mean.
Basically i have my form that looks like the below
What i'm trying to do, is make the questions below ("Risk in Authority" and "If Not, Risk Referred?") hidden, unless the answer to "Are All Policies Acceptable?" is No.
I have managed to make it happen, but it's far from perfect. As below:
I'd set the value for Visible to No in the properties for every object in the Questions (the pretty boxes are all named things like Box123 and Label 53, all set to hidden). Then i set the "On Click" event of the No in "Are All Policies Acceptable" (called Option168) to
Me.Box60.Visible = True
Me.Box121.Visible = True
Me.Box122.Visible = True
and so on.
This works ok, but if you click on the same option twice it reverses the action.
Is there a more effective way of doing this? maybe through Validation?
Thanks for any help once again. (I've also recommended this board to a couple of guys in the office who are already proficient with Access and SQL who can hopefully contribute to the community )
Edit: As an Addendum - this formattign should only apply to one record at a time. So if the question are visible on record 1, they could still be hidden on record 2. If that's even possible.
Forms :: Hiding Certain Fields Based On Number Amount
Jun 13, 2013I search around online and did come across much info on code to how to hide fields. But, the problem is I cant seem to find a way to hide a certain amount of fields based on a number amount.
example: Lets say I have a 12 text fields to show 12 months of monthly payments, and lets say a client only has a 3 payment term. How can I list 3 under installment field and have remaining 9 fields auto hide since they wont be necessary? this way I only see what applies and not additional text fields.
Forms :: Access 2010 / Showing / Hiding Fields Based On Previous Entry?
Mar 26, 2014I am using Microsoft Access 2010.
I have a form, having following fields
Nationality, Combo box, Options are Indian/foreign State: With list of States in India.
What I want is, when data entry operator , select, Foreign, State field automatically hides.
And when data entry operator , select Indian, State field shows in the form.
How this can be done in Access 2010
Queries :: Hiding Date Picker From Date Fields
Nov 5, 2013The query is there to query data, not to edit data or manipulate data in anyway. However, I am disgusted by the appearance of the date picker when I pick a field that is a date field.
Is there a way to hide/remove these date pickers from the query sheet?
Within the table itself I turned the "Show date picker" property to "Never" but that didn't make a difference.
Hiding Access
Apr 13, 2006I'm trying to hide access(i.e. toolbars etc.), and only view a form. Is this possible?
View 5 Replies View RelatedHiding Decimals
Aug 31, 2005Hello,I was wondering if anybody knew if it was posslble to show an aproximated value of a field with decimal records. I would like to see only integer values on my form.
View 3 Replies View RelatedHiding Access
Aug 26, 2006Here's another one on this subject... But can't seem to find the answer in the "Search" Currently I am using the "Call fSetAccessWindow(0)" method.... Well, all works fine until I start getting into reports. I have read in some post of other methods to hide Access. But I have yet to find any examples of the "easier way"..... Can anyone direct me to a post or link??
Thanks
Curtis
Hiding Prompts
Apr 26, 2007How do I hide prompts asking the user are they sure they want to update fields, etc?
View 2 Replies View RelatedHiding Values
Aug 16, 2005Hi, I'm haven't much experience working with Access and I'm hoping someone out there can help me :)
I have a list of products with technical data in tables, however sometimes not all the products have the complete set of data. Is it possible to hide the cells where there is no data present when linked to a page?
Hiding A Row In A Table
Oct 19, 2005Hello all,
I was wondering if anyone know how to hide a row from a table so that 1: viewers can't see it from a web site 2: i don't have to delete it...
I can't figure it out, but there must be a way...
ARW
Hiding Buttons
Mar 1, 2006I have a database where people are entering data into in constantly. Now I was told that someone else needs to go into the database and check integrity of data entered. There are a few buttons that I don’t want a “data verifiers” to click on, but “data entry folks” should be able to. Is there any way to may be password protect certain buttons and only be visible if a password is typed or something like that? I know how to password protect a form, but that’s not really exactly what I need and want to do. Any ideas would be greatly appreciated!
Thank you!
Hiding Forms
May 15, 2006Having trouble getting the code right to hide and unhide forms.
I have a main menu from which users can open other forms. When another form is opened, I want the Main Menu to be hidden, so it doesn't appear in the task bar.
For example, from the Main Menu
Me.Visible = False
DoCmd.OpenForm "Review frm", acNormal
However, from Review frm, I can't get the Main Menu to be visible again. I've tried
Forms!Main_Menu.Visible = True
but it says it doesn't exist. (Note the name of the form, Main Menu, has spaces, which is why it has the underscore between the two words. Don't know if this is relevant or not.)
Could someone tell me what's wrong with the code?
Thank you.
Hiding Controls
Jan 22, 2005I know this was mentioned and dealt with in another post, but I can't seem to find it.
Basically, I have a couple of text boxes that I would like to hide, unless told to be visible by a command button.
I'm trying to do this to save space on the form.
Someone a while back had mentioned setting the height of the control to zero and also setting the control to canGrow.
I tried this on a particular field and it didn't seem to work.
Any ideas would be a total help. Thanks all.
Hiding The Menu Bar
Jul 17, 2005I have created a custom toolbar but the default (access) menu bar still appears every time I open the database. I can uncheck it under toolbars but this doesn't hold on re-opening. How do I do it?
View 3 Replies View RelatedHiding Data
Mar 9, 2008Hi there (first posting on site - and an access newby too!)
I have managed to generate a report which shows me how many students undertook courses throughout the year. I have been able to put totals to my report for each intake and for each campus, and have hidden the student data on the report. However the report is many pages long as although the student data is hidden it still takes space on the page.
How can I get the report to just give me the totals of each intake and a total for each campus?
Answers appreciated.
Hiding The Important Bits
May 9, 2005Hi,
I've developed my little database and it works a treat... now I want other people to be able to access it input info via forms (add data), and see reports and run searchs etc... all of which is done through a central switchboard menu.
What I dont want is other users getting into the setup of it all - basically i just want to hide the background workings, relationships, queries etc so nothing can be messed up...
What can i do, and how?!
bear in mind, i still want to be able to have full access myself.
Cheers
amx
Hiding Command Buttons...
Jun 22, 2005I have a form listing clients. Each has a command button linking to another form with client details and other option. One the bottom of the form is an Add Client button. I want the user to only be able to add a max of 6 clients, and the buttons to these clients be invisible until the Add Client button is pressed and the information about the client is filled out. Then back on main form listing clients, the client name will appear with a command button that will link to client details. How can this be done? I've seen it done, but can't figure it out.
tritonvt
Hiding Records From Users
Sep 8, 2005I am somewhat lost and would really appreciate your help!
I am using a database to classify newspaper articles. There are several users - and they need to be trained to the classification rules.
Waht I would like to do have is a way to let different users classify the same sources. However, the "trainee-user" should not be able to see the data already in the database. Also I would like to flag all "trainee-user" records to compare them to the original results.
My questions are thus:
How Do I hide records from a user and yet allow him to use the database (and see the stuff he entered himself)
How can I save information on a user in a table?
Thanks a lot in advance!!
BM.
Hiding Access Environment
May 30, 2006Hi guys, i read about this before but it did not work.
i am trying to hide the access environment but i couldnt.
i read in this forum that if i have a bmp with then same name than the db, the picture would replace the access environment. I have done this but the only thing that i achieved was to see the picter before access env. comes and then it desapears and the access env. shows up.
any suggestion?
thx max
Hiding Tabs On A Tab Control
Feb 7, 2008I have on one of my forms a tab control with 5 different tabs on it. Each of the tabs has a different set of fields but all from the same table. I was wondering if it is possible to hide a tab if none of the fields on it have any data in?
So for example tabs 2 and 3 have data on them but tabs 1, 4, and 5 dont. I would want to hide tabs 1, 4 and 5.
Hiding The Built In Menus
Mar 15, 2008Hi
I went into tools, startup and unchecked allow full menus. Now when I open the DB, I don't have the tools menu so I can check the allow full menus. I need to get this back so I can continue working on the DB. There must be someway to get this back/reverse it.
Access 2003
Thankyou
Garry
Hiding And Viewing Subforms
Jan 26, 2005I have a form with a subform on with the visible value set to false. After a value has been selected from a combo box i then want this subform to show. Tried calling the form using me!formname.visible = true in the afterupdate but it says it cant find the form.
Any Ideas how
Hiding Label Text
Feb 6, 2005i want to make a condition that if an OLE object of mine is empty then the label won't be visible. (visible=no)
The reason i want it is that the ;label is placed inside the OLE object frame, and when i fill the ole object i want that the label will disappear
Opening/minimising/hiding
Apr 24, 2005hello, i have 7 forms, each of which is opened by a main form. on the main form is 7 buttons which should each open a different form. on opening this form the main form should hide/minimise and the opened form should come to the front and be visible. on closing the form the main form should come back into view
i have tried frmName.Show, frmName.Visible, frmName.minimize and so on but just cant get these things to work, using them on events such as OnLoad of the new form and OnClick of the button.
always just get error etc, can anyone provide me with a procedure to do this sort of thing.
Thank You