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 Replies


ADVERTISEMENT

Hiding Columns In A Subform Datasheet

Jun 3, 2005

Morning all, I'm trying to hide a column of a datasheet in a subform I have... if I run the form and right click and hide the column, it doesen't save that the next time I load it (wasn't sure if it was suppose to, but after reading http://office.microsoft.com/en-us/a...2362201033.aspx it would appear so) I'm using SQL Server 2000, not 7 so I would think that problem shouldn't come up for me yet it is, I need to hide a couple columns from the user (mostly ID columns) while they are entering in data, anyone have any advice they could throw my way?

Much appreciated

- Chris

View 5 Replies View Related

Hiding Columns Realtime In Subform

Sep 23, 2005

Hello!

The problem at hand for me is to be able to hide columns in a subform wherever "#Name?" appears. My VBA experience is minimal to non-existent, but if a not so complex sample code exists out there then I'd appreciate any suggestions you may have.

I have attached a print screen document that shows the result of a query in the subform I just talked about. My anticipated thanks for your help.

View 2 Replies View Related

Forms :: Hiding Columns On Subform Based On Multi-Value Lookup Field

Aug 7, 2013

I want to use VBA to hide columns in a subform based on what is checked in a multi value look up field.

I am creating this DB for use with sharepoint as a web database, which is why I am using the lookup field to begin with. There will be a client DB to use with some VBA code

So what I have is a lookup field with tests "Test 1, Test 2, etc" on form sample.

There is a subform called results, and I want to hide certain columns based on what tests are performed.

I tried using an If Then statement (code is being run on subform load)

If Me.Parent.fieldTest = "Test 1" Then
Me.Test1Col.ColumnHidden = False
Else Me.Test1Col.ColumnHidden = True

That is basically the code I was trying to use. I am getting an error 13, which I assume is because fieldTest can not = something since it is a multi value look up field.

View 3 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

Forms :: Subform Is Not Hiding

Dec 8, 2014

I cant get my subform to hide. Main form is called 'frm_main_add' and the subform is called 'tbl_transaction_subform'.I am rying to get it to hide the subform (tbl_transaction_subform) if a field in the main form(frm_main_add) is null but its doing nothing.....

I put this code in the 'on current' and 'on load' in the frm_main_add and nothing..If (Expense_Name = Null) Then tbl_transaction_subform.Visible = False Else tbl_transaction_subform.Visible = True

View 2 Replies View Related

SubForm Hiding Text Field

Jun 15, 2005

Ok this is a bit long winded and I will try to explain,

I have a main form, with a title at the top, then a row of buttons underneath and underneath the buttons I have a sub form.

Some of the buttons can have a dual function (or multiple function) so rather than open up another form I have hidden text below the button, so that when the mouse moves over the button, the text becomes visible. this gives the impression of a drop down menu off that button.

However I cannot get the text to appear over the top of the subform, it only appears behind it.

To give an example of what the buttons and drop downs are for, one of the buttons is a reports page, rather than open another form I can have a list of the differnt reports I wish to run (currently they are text boxes with an on click event).

any advice woudl be much appreciate and even an alternative to what I am doing if anybody has one.

Many thanks

MattP

View 5 Replies View Related

Format Subform After Hiding Scrollbar

Jul 18, 2005

Hello.

I want to hide the scollbars on a subform. I selected "neither" for scroll bars under properties, and it works. However, the formatting is ugly. I have a blue background but get grey boxes where the scroll bars are supposed to be. Can I get rid of this and have the area blend in with the background?

Thanks in advance.

View 4 Replies View Related

Hiding Subform Layout In Main Form

Nov 28, 2013

How to hide the layout of subform in main form?

View 3 Replies View Related

General :: Hiding Subform Layout In Main Form?

Nov 28, 2013

How to hide the layout of subform in Main form?

View 5 Replies View Related

Forms :: Autowidth For Columns In SubForm

Jul 10, 2014

I have developed an Access app, which has different navigational tabs which open up different forms. e.g. Tab A has Form A inside it and Form A has SubForm A1 inside it. For some reason, the following code is not working on any of the fields Me.YourFieldName.ColumnWidth = -2...some workaround so that all the fields in the subforms will have auto width adjustable to fit in the text.

View 8 Replies View Related

Auto-width For Columns In SubForm

Jul 10, 2014

I have developed an Access app, which has different navigational tabs which open up different forms. e.g. Tab A has Form A inside it and Form A has SubForm A1 inside it.

For some reason, the following code is not working on any of the fields Me.YourFieldName.ColumnWidth = -2...

What to do that all the fields in the subforms will have auto width adjustable to fit in the text.

View 13 Replies View Related

General :: Split Form And Subform Columns Not Saving

Oct 25, 2013

For some reason when I change the order around of the columns in a split form or subform 90% of the time it wont save (right click save, file save, etc..) and have to constantly redo it until it finally works. Am I missing something obvious as to why this is happening?

View 3 Replies View Related

General :: Main Form With Two Lists Boxes - Show / Hide Datasheet Columns In A Subform

Aug 24, 2012

I've got a main form with two lists boxes. I want to show the visible columns in my subform (which is a datasheet) in one listbox and show the hidden columns in the other. Also I want to allow the user to hide / show columns using right or left arrow buttons between the list boxes. My subform is bound to a stored procedure using ADO.

View 5 Replies View Related

Using Subform For Search Criteria And Relating One Search Field To Several Columns

Apr 21, 2015

1. I created a form with some search-fields which are related to a query. Then I added a Subform in which I put some more Search criteria (So that I can easily hide and unhide those additional searchfields). It sounds strange but is necessary ;-). Now I related those searchfields in the subform to the same query. When I run that query a window pops up that I should put in a value in all those searchfields which are in the subform. But I told Access that it should display all rows, if there is no value in those searchfields. Just as I did it with the Searchcriteria in the Main form. Do I have to do something special, when I have a query which is related to two Forms?

2. I want a searchfield to search in three different columns. Usually the value will just be found in one of those columns. As the Table I search is very long and has many searchfields and multiple of those will relate to more than one column, is there an easy way to do it in VBA? As I did it by using the "or" field when designing a query, but this seems very slow and unstable.

View 6 Replies View Related

Modules & VBA :: Union All Query - Transposing Columns To Rows With Variable Columns?

Aug 8, 2013

I was able to use the UNION ALL qry. But, when I have another file (like original2) that does NOT have all the columns listed in the UNION ALL qry, I get a Parameter value box asking for the missing columns when I run the qry.

Example:

original1IDDateGroupChristianJohnnySteve 18/5/2013A1528/5/2013B338/5/2013C2348/5/2013D2358/5/2013E5

original 2IDDateGroupChristianJohnny18/6/2013A212528/6/2013B2338/6/2013C2248/6/2013D22

The UNION ALL qry includes all the possible resources ( includes all the possible column fields Christan, Johnny, and Steve).

When I run the UNION ALL qry with the original2 file, An "Enter Parameter Value" box is displayed with the mssing column name "Steve".

Is there a way to Map the original2 table into a working table with all the columns, or use VBA code to construct the UNION ALL qry to only include the existing columns? My data has variable columns and I'm trying to avoid the parameter popups.

View 2 Replies View Related

Queries :: Consolidate Multiple Columns Into Two Columns

May 14, 2014

I have a MS ACCESS 2010 database with a data table which i am trying to create a query from. I have 6 columns of data( one with an ID Field and 5 Name Fields). Below i have made examples of how it first appears as a simple query and the second will show you what i would like it to look like.

What the simple query looks like: [URL] ...

Second what I want the query to look like: [URL] ....

View 2 Replies View Related

How Do I: Sum Of Selected Columns & Linking Columns

Oct 30, 2007

Currently I'm building tables and forms. My first table (called Clients) lists the details of fictional clients. My second table is for invoices.

In my invoices table, I wish to link the column for client reference (note: stored in the Clients table) to the column that precedes it. This column will list the clients’ names and is selected from a drop down list that is linked to the Clients table.

What I want to do (if its possible) is to have the respective client ref. automatically show up in the next cell once I've selected the client to whom the invoice relates?

Am I making sense? Is that possible? If so, how do I do it?

Secondly, how do I do a sum of selected columns for my “totals” column? Basically, I want to add the figures found in several cells that precede it?

View 4 Replies View Related

Totalling Columns & Rows Into Columns

Mar 22, 2007

I'm affraid my confusing topic title is an indicator of how confused I am by this. I can't even understand the variables well enough to fully utilize Access Help or the Search function here...

What I have is a database hat has column headers that look something like this:
Customer_Name, Order_Date, Qty_Ord, Unit_Price, Total_Price

What I'm trying to get is a query output that will have

Customer_Name, Total Orders (in Dollars) for January, Total Orders (in Dollars) for February, Total Orders (in Dollars) for March, etc.

I've been able to set it up to SUM for one month, but not multiples.

I know I'm totally lame (for proof read any of my previous posts) but you guys totally bailed me out the other time I asked a lame question.

Thanks in advance!

View 3 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 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 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







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