Fixed column widths in SubForm
I'm obviously missing something somewhere, but I can't find any more sizing-related parameters to disallow. What else should I be looking at
Thank you for taking the time to report an issue.
What's wrong... Please write below.
These are displayed by setting Column Count and Column widths to suit. The whole picture is - the Main Form will have a Calculated Value I want to enter a number of entries in the subform and depending on the value allocated to each Name (location) I will then allocate a portion of the Total Cost to each name.
It's taken me ages to get a cascading combos where the 1st is on the Main and the Second is on the subform now I cannot total this value on my subform so until I can do this I cannot get apercent to allocate each Location Cost (does this make sense)
I'd hoped this might work but I don't think Column count can be used in an expression
Also the subform record source is not the table where the values are stored which I feel is part of the problem
I also would like to have a subform that lets users add dated notes or updates to the project record. It seemed like something I could do with a subform, but I've never usedthem before,
What I did was to create a separate table called Updates that has the following fields: ProjectNumber, UpdateDate, UpdateText. I then linked the ProjectNumber from the Updates table to the ProjectNumber in the main table.
I was able to successfully insert the subform displaying the data from the Updates table, but had a few problems. First, I can't quite figure out how to NOT show ProjectNumber in the subform.
Really all I want to show is Date and UpdateText. Is there a way to exclude ProjectNumber? I noticed that I could drag the border of that column to make its width zero, but that doesn't seem like the most elegant way to solve the problem.
In fact, I'd like the column widths to be fixed if possible. Is there a way to do that?
Finally, I would like the entries in the subform to be sorted by date. How do I implement that? I played around with some stuff, but couldn't get it to work.
My plan is to have a table that records can be added to (with one column already assigned).
The records will be added via a query.
I don't know if this is possible, is it possible to have fixed a column that records can be deleted and inserted without the values changing in one column?
Almost like an autonumber, but that does not change if you delete and insert records? That would be perfect
For instance, in the CB YNDK, there are two columns. The first is the ID, and the second is a column with the following: Yes, No, Don't Know.
Until recently, when I use the combo box (Form control) button, I am not able to choose the CB table I want to use but it creates a combo box which attached to the CB by checking the Table/Query data.
I then have to change the Column Count to 2 and change the Column Widths to 0. And sometimes this change doesn't happen and I have to keep playing with
1) what's going on with the Combo box (Form control)? Why can't I select
which CB Table I want to use; and
2) What's going on with the column count and column widths settings?
I haven't made any changes (I.e. updates) to my Access 2007.
There are three fields that vary widely in widths and I've found I can use the On Current event to resize them on the run. I have two forms. On one it works like magic. On the second one I am stumped. I've been using the .columnwidth = -2 very successfully, but on Form 2 it ignores whatever value I put in.
Here is an example I used to test the code.
' Me.ID_1.ColumnWidth = 4000 ' MsgBox "Column width is " & Me.ID_1.ColumnWidth
The message I get back is
Column width is 1860
This gives me the same result.
' Me.ID_1.ColumnWidth = -2 ' MsgBox "Column width is " & Me.ID_1.ColumnWidth
What's weird is that now I cannot change the column position or width on any column in this subform. I've tried design view, datasheet view, layout view, and nothing works. I click save each time I change it before switching to another view. But when I reopen the form, they've gone back to the way they were before.
I can easily change column width and position on other subforms not related to this one.
I have moved the column from the end to the position that I want it in in Design Mode, Layout View, Datasheet View, and saved each time before I switch views again, but no matter what I do, the column goes back to being the last visible column and the column width adjustments that I've made revert back to what they were as well
One of the columns in subform A is computed with another column in subform A, and a column in subform B, and I'd like that column to be updated whenever the user changes the values pertinent to that calculation.
and the after_update events work. but the change doesn't appear on the subform.
I have to change the record twice each time, and then the data shown is always one change back. I've tried requery, refresh, repaint, etc on that form after the update is done, and I can'tseem to get it to display the updated value, despite the fact that I know the calculation occurred and saved the record in vba via .edit and .update.
It work as I would expect it to when I open the subform all by itself. The second control gets the value and it is passed to the query.
However, when I run the the form/subform I get an error saying that it can't find the subform.