![how to select columns on microsoft access on mac how to select columns on microsoft access on mac](https://legalofficeguru.com/wp-content/uploads/2010/04/Word_2007_Insert_Column.png)
One of my pains is that it runs the query anyway, and the main form drags because it is running that query even before the user has chosen to run anything. See I open the summary main form and the subform is invisible. Ok, so it sounds like this just got more complicated.
![how to select columns on microsoft access on mac how to select columns on microsoft access on mac](https://www.exceltip.com/wp-content/uploads/2013/07/unnamed-1.png)
It is never too late to become what you could have been ~ George Eliot RE: Form with Datasheet Subform - Select Columns? MajP (TechnicalUser) 29 Mar 10 14:24
HOW TO SELECT COLUMNS ON MICROSOFT ACCESS ON MAC CODE
I am just not very advanced at VB for some of this, and I am not seeing where the listbox code is connected to the subform. I will keep looking at your demo and try to figure it out. you don't have to answer that if you don't want. If I have a group by in the query, will this regroup info? One summary may be useful to show a certain date field, but in another summary may just show duplicate information for all those dates, when the date is not important, and we would rather group on the othe fields. The reason we need to do this is because they can run many types of reports on this menu. Another question is that when a user hides a column, will the filter requery? What I mean is that if they hide 1 column, it may need to regroup the data. I guess I need to look closer to understand how the listbox is interacting with the fields on the subform, but that is just me needing to figure it out. I couldn't go to the site right away because it was blocked in my domain. RE: Form with Datasheet Subform - Select Columns? misscrf (TechnicalUser) Instead of picking the fields and then running the query, you run the query and then pick which fields to show or hide. I am proposing doing this in the reverse order. Clearly the list populates based on the source of the query. Not sure what part of this you do not understand. That is how you described it in your original post.ģ) How do I use the listbox that your code manages, to tie into the query that is the source of my subform You would put the list on the mainform and the datasheet is the subform. Would I put this listbox for choosing the fields on here too? "Due Date" but the bound field is "dtmDueDate" the actual name of the field.Ģ) I have 1 form that has a variety of list boxes, combo boxes and text boxes for filtering on 1 or more field. "dtmDueDate" could have a caption "Due Date", and that is what the user sees in table and data sheet view. When you build a table you can give each field a Caption. RE: Form with Datasheet Subform - Select Columns? MajP (TechnicalUser) 25 Mar 10 10:02ĭid you look at the Demo? I think it shows all of what you are asking.ġ)It looks like one of the columns in the source of your list box is "Caption". So you could stick different queries as the source object of your subform and reload the list. MsgBox Err.Number & " " & Err.Descriptionįrm.Controls(lst.ItemData(itm)).ColumnHidden = -1įrm.Controls(lst.ItemData(i)).ColumnHidden = 0 Me.lstChoose.AddItem (fld.Name & " " & fld.Name) Me.lstChoose.AddItem (fld.Name & " " & fld.Properties("Caption").Value) Me.lstChoose.RowSourceType = "value list" It is never too late to become what you could have been ~ George Eliot RE: Form with Datasheet Subform - Select Columns?
![how to select columns on microsoft access on mac how to select columns on microsoft access on mac](https://i.stack.imgur.com/TQh52.jpg)
How would I go about making a listbox of the fields that are available (with nice names) and letting them choose 1 or more of those for their output? I would need the query to only run on those columns so that records would appropriately group based on the columns chosen at that time. In those cases, we don't want those extra fields. The query is giving them all the fields, and in certain cases, that will repeat the records because of sub records. The problem is that the report menu lets them choose from a bunch of different options to filter on, and based on that, they may not want certain fields in the results. This is very useful to the end users, because they like to just take the grid and throw it in excel and email it. It has a subform that is tied to a query, and is invisible until they click the Run Summary button on the main form. I have a nifty Summaries and Report Menu for an application I developed.