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.
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.
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
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.
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
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
I've got 5 time zones showing on the main screen of my db, just by doing date() and subtracting number of hours for each time zone. Only problem is need a refresh button on it for people to click. Can you get a realtime clock ticking away on an access form?
View 1 Replies View RelatedI am trying to update an Access 2000 Database used by our Shipping Dept. The Shipper currently runs 3 Queries to populate 3 local tables with data from a SQL Server 2000 database used by our production process, he then will run another query that populates another local table with the data from the 3 local tables. His next step is to open a form where he scans a barcode from a label on the finish material tote to field #1 that is a Select Query. This allows for minimal scanning in the load makeup routine. The problem is that the data is not realtime and he must periodically refresh the tables. I need to find a way to use the linked tables to provide near Realtime data.
(Existing Barcode field1)
SELECT DISTINCTROW ProductionTable.BatchNo, ProductionTable.CmpdNo, ProductionTable.Recipe, ProductionTable.CustomerID, ProductionTable.Gross, ProductionTable.Tare, ProductionTable.Net, ProductionTable.expires, ProductionTable.PartNo,
ProductionTable.PONo FROM ProductionTable ORDER BY ProductionTable.BatchNo;
(Trial 1 – It Works for 1 production line only)
SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff1.BatchNo, Dbo_Mixed_Material_Batchoff1.CmpdNo, Dbo_Mixed_Material_Batchoff1.Recipe, Dbo_Mixed_Material_Batchoff1.CustomerID, Dbo_Mixed_Material_Batchoff1.Gross, Dbo_Mixed_Material_Batchoff1.Tare, Dbo_Mixed_Material_Batchoff1.Net, Dbo_Mixed_Material_Batchoff1.expires, Dbo_Mixed_Material_Batchoff1.PartNo, Dbo_Mixed_Material_Batchoff1.PONo FROM Dbo_Mixed_Material_Batchoff1 ORDER BY Dbo_Mixed_Material_Batchoff1.BatchNo;
(Trial 2 – Does Not Work)
SELECT DISTINCTROW
dbo_Mixed_Material_Batchoff1.BatchNo, dbo_Mixed_Material_Batchoff3.BatchNo,
dbo_Mixed_Material_Batchoff4.BatchNo, dbo_Mixed_Material_Batchoff1.CmpdNo,
dbo_Mixed_Material_Batchoff3.CmpdNo, dbo_Mixed_Material_Batchoff4.CmpdNo,
dbo_Mixed_Material_Batchoff1.Recipe, dbo_Mixed_Material_Batchoff3.Recipe,
dbo_Mixed_Material_Batchoff4.Recipe, dbo_Mixed_Material_Batchoff1.CustomerID,
dbo_Mixed_Material_Batchoff3.CustomerID, dbo_Mixed_Material_Batchoff4.CustomerID,
dbo_Mixed_Material_Batchoff1.Gross, dbo_Mixed_Material_Batchoff3.Gross, dbo_Mixed_Material_Batchoff4.Gross, dbo_Mixed_Material_Batchoff1.Tare, dbo_Mixed_Material_Batchoff3.Tare, dbo_Mixed_Material_Batchoff4.Tare,
dbo_Mixed_Material_Batchoff1.Net, dbo_Mixed_Material_Batchoff3.Net,
dbo_Mixed_Material_Batchoff4.Net, dbo_Mixed_Material_Batchoff1.expires, dbo_Mixed_Material_Batchoff3.expires, dbo_Mixed_Material_Batchoff4.expires,
dbo_Mixed_Material_Batchoff1.PartNo, dbo_Mixed_Material_Batchoff3.PartNo,
dbo_Mixed_Material_Batchoff4.PartNo, dbo_Mixed_Material_Batchoff1.PONo, dbo_Mixed_Material_Batchoff3.PONo, dbo_Mixed_Material_Batchoff4.PONo
FROM dbo_Mixed_Material_Batchoff1, dbo_Mixed_Material_Batchoff3, dbo_Mixed_Material_Batchoff4 ORDER BY dbo_Mixed_Material_Batchoff1.BatchNo, dbo_Mixed_Material_Batchoff3.BatchNo, dbo_Mixed_Material_Batchoff4.BatchNo;
(Trial 2 Does Not Work)
SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff1.BatchNo, Dbo_Mixed_Material_Batchoff1.CmpdNo, Dbo_Mixed_Material_Batchoff1.Recipe, Dbo_Mixed_Material_Batchoff1.CustomerID, Dbo_Mixed_Material_Batchoff1.Gross, Dbo_Mixed_Material_Batchoff1.Tare, Dbo_Mixed_Material_Batchoff1.Net, Dbo_Mixed_Material_Batchoff1.expires, Dbo_Mixed_Material_Batchoff1.PartNo, Dbo_Mixed_Material_Batchoff1.PONo FROM Dbo_Mixed_Material_Batchoff1 ORDER BY Dbo_Mixed_Material_Batchoff1.BatchNo; SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff3.BatchNo, Dbo_Mixed_Material_Batchoff3.CmpdNo, Dbo_Mixed_Material_Batchoff3.Recipe, Dbo_Mixed_Material_Batchoff3.CustomerID, Dbo_Mixed_Material_Batchoff3.Gross, Dbo_Mixed_Material_Batchoff3.Tare, Dbo_Mixed_Material_Batchoff3.Net, Dbo_Mixed_Material_Batchoff3.expires, Dbo_Mixed_Material_Batchoff3.PartNo, Dbo_Mixed_Material_Batchoff3.PONo FROM Dbo_Mixed_Material_Batchoff3 ORDER BY Dbo_Mixed_Material_Batchoff3.BatchNo; SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff4.BatchNo, Dbo_Mixed_Material_Batchoff4.CmpdNo, Dbo_Mixed_Material_Batchoff4.Recipe, Dbo_Mixed_Material_Batchoff4.CustomerID, Dbo_Mixed_Material_Batchoff4.Gross, Dbo_Mixed_Material_Batchoff4.Tare, Dbo_Mixed_Material_Batchoff4.Net, Dbo_Mixed_Material_Batchoff4.expires, Dbo_Mixed_Material_Batchoff4.PartNo, Dbo_Mixed_Material_Batchoff4.PONo FROM Dbo_Mixed_Material_Batchoff4 ORDER BY Dbo_Mixed_Material_Batchoff4.BatchNo;
Anyone have any ideas?
Many thanks in advance to all responders
Bob
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
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.
How to hide the layout of subform in main form?
View 3 Replies View RelatedHow to hide the layout of subform in Main form?
View 5 Replies View RelatedI 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 RelatedI 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.
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 RelatedI'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 Related1. 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.
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.
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] ....
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?
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!
I'm trying to hide access(i.e. toolbars etc.), and only view a form. Is this possible?
View 5 Replies View RelatedOn 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 RelatedHello,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 RelatedHere'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
How do I hide prompts asking the user are they sure they want to update fields, etc?
View 2 Replies View Related