Hiding Values

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 Replies


ADVERTISEMENT

Hiding Null Values?

Jul 18, 2005

Hi, when doing an Access query is it possible to hide null values?

Thanks

View 1 Replies View Related

Hiding Access

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

Hiding Fields

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

Hiding Decimals

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

Hiding Access

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

Hiding Prompts

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

Hiding A Row In A Table

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

Hiding Fields

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

Hiding Buttons

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

Hiding Forms

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

Hiding Controls

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

Hiding The Menu Bar

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

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 9 Replies View Related

Hiding The Important Bits

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

Hiding Command Buttons...

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

Hiding Records From Users

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

Hiding Access Environment

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

Hiding Tabs On A Tab Control

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

Hiding The Built In Menus

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

Hiding And Viewing Subforms

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

Hiding Label Text

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

Opening/minimising/hiding

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

Hiding Record Numbers

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

Hiding And Resizing Columns

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

Hiding Columns In Subform

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







Copyrights 2005-15 www.BigResource.com, All rights reserved