Hiding Data
Mar 9, 2008
Hi 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.
View Replies
ADVERTISEMENT
Sep 24, 2014
I have a table of about 250 items that are sorted based on two fields. I created a query of the table and hide one of the fields because it is only there for sorting purposes to group the data.
For example, I have a "Type" field. In the type field, I differentiate the items with different categories, such as "Materials", "Safety", etc. My next field is "subtype" which assists the "Type" field being sorted properly for my needs. In the "Materials" category, all of the items are either "Fencing", "Plastic", "Wire", or "Miscellaneous". I am sorting the "type" and "subtype" fields in ascending order so that all the "materials" are grouped together, and all of the "fencing, "plastic", etc are grouped together within the materials field.
I am creating a printable report and I do not want the "subtype" field to be on the report, but I need the "subtype" field's sort to be affecting my data so it is grouped properly. I'm having difficulty, is there a way to hide fields in reports?
View 3 Replies
View Related
Apr 13, 2006
I'm trying to hide access(i.e. toolbars etc.), and only view a form. Is this possible?
View 5 Replies
View Related
Aug 12, 2005
On 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 1 Replies
View Related
Aug 31, 2005
Hello,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 Related
Aug 26, 2006
Here'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
View 4 Replies
View Related
Apr 26, 2007
How do I hide prompts asking the user are they sure they want to update fields, etc?
View 2 Replies
View Related
Aug 16, 2005
Hi, 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?
View 2 Replies
View Related
Oct 19, 2005
Hello 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
View 1 Replies
View Related
Apr 15, 2005
Hi 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
View 3 Replies
View Related
Mar 1, 2006
I 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!
View 3 Replies
View Related
May 15, 2006
Having 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.
View 4 Replies
View Related
Jan 22, 2005
I 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.
View 5 Replies
View Related
Jul 17, 2005
I 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 Related
May 9, 2005
Hi,
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
View 3 Replies
View Related
Jun 22, 2005
I 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
View 1 Replies
View Related
Sep 8, 2005
I 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.
View 3 Replies
View Related
May 30, 2006
Hi 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
View 4 Replies
View Related
Feb 7, 2008
I 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.
View 4 Replies
View Related
Mar 15, 2008
Hi
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
View 2 Replies
View Related
Jan 26, 2005
I 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
View 3 Replies
View Related
Feb 6, 2005
i 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
View 3 Replies
View Related
Apr 24, 2005
hello, 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
View 3 Replies
View Related
Jun 6, 2005
I would like to hide the record number scrolling feature in my forms. How is this done? I have searched through the properties of the form but am missing something I suppose.
Thanks, Joe
View 7 Replies
View Related
Jul 11, 2005
What I have: I have a main form with 3 subforms viewed as datasheets.
I have read the post about hiding columns by using me.<object>.columnhidden = True and that kind of works. Once the user goes to resize the columns they can get the hidden columns back. This is a problem if I'm trying to hide a priority column only admins should see.
Is there a way to specify the width of a column and restrict the user from resizing it? That way the user can not resize and get hidden columns back.
If there is a better way if doing this please let me know. Ultimately, I just don’t want the user resizing or unhiding columns I have sized and hidden.
Thanks
View 1 Replies
View Related
Aug 1, 2005
Hello All!,
The results of a query by users are shown in a subform (in datasheet view) similar to this:
Months 2004-22004-32004-42005-12005-2
2004-06 0.9840
2004-07 0.9969
2004-08 0.9800
2004-09 0.9850
2004-10 0.9850
2004-11 0.9879
2004-12 0.9879
2005-01 1.0000
2005-02 0.9900
2005-03 0.9900
2005-04 0.9900
2005-05 0.9900
2005-06 0.9936
The second column onward denotes Years-Quarters. Where I need help is in hiding columns I don't need to show if outside of the range the user's chosen: for example, if user chooses Jul-04 to Mar-05 then I'd like hide columns 2 and 6.
For whatever reason I can't get the monthly values to line up with the Yr-Qtr columns, but I hope you all know what I mean :o, i.e., 2004/07-2004/09 lines up with 2004-3, 2004/10-2004/12 with 2004-4, and so on.
As always, any help provided would be greatly appreciated.
View 1 Replies
View Related
