Topics Search

Fixed column widths in SubForm

Fixed column widths in SubForm
Views: 212
I've got a SubForm with 9 columns. Default View is Datasheet and all values for allowing other views are set to No. Can Grow and Can Shrink values for the sub-form and every object on it are set to No. Everything looks great, but when I open the Main Form in View mode, I can still go into the SubForm and adjust the column widths, which is exactly what I don't want to happen.

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
Sponsored Links:

More topics

 

Cascading Combos in Subform v9999

Preview
Solved Thanks All

It feels like Ive trawled 10000 posts on this and tried almost as many attempts. Could somebody please look at this as Im bewildered. Not the normal problem. I have this set up just the way I want bar my 2nd combo after choosing the item from dropdown after update the control shows the Primary Key number. And yes I have bound and column count and widths right. (The column widths are set at .5;.5;3cm at the mo to try and let me see what is going on,,, it hasn't)
 

Autoresize column widths in Split Forms?

Preview
I have a Split form with the datasheet displayed at the bottom. Is there anyway to force autoresize of column widths everytime form is loaded? Even if I resized once the widths automatically resets again afters
 

Total Control Value in SubForm

Preview
I have a two controls on a continuous subform the row source for both is a query and Column(2) is a Name, Column(3) is a number.

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
=Sum([DestinationNo].[Column](3))
Also the subform record source is not the table where the values are stored which I feel is part of the problem
 

Access subform design question

Preview
I am designing a project management database. In the main form, I want to display main information about the project that corresponds to that record (project #, start date, milestone dates, etc.).

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.
 

Controlling subform resize

Preview
I'm using Access 2003 and have a form with a subform that always displays the same number of rows and columns in datasheet view.

Wondering if there is a way to display the subform without having to leave an empty space to the right of it and below it in the subform container to allow for scroll bars.

If I size the subform container in design view to fit the subform exactly, which is how I want it to look, the subform resizes when I update the underlying table and requery it with new data and it ends up with vertical and horizontal scroll bars that hide the bottom row and some of the right-most column. I basically want to freeze the column widths and row heights so the scroll bars do not appear and hide the data
 

Controlling subform resizing

Preview
and thanks in advance,

I'm using Access 2003 and have a form with a subform that always displays the same number of rows and columns in datasheet view.

Wondering if there is a way to display the subform without having to leave an empty space to the right of it and below it in the subform container to allow for scroll bars.

If I size the subform container in design view to fit the subform exactly, which is how I want it to look, the subform resizes when I update the underlying table and requery it with new data and it ends up with vertical and horizontal scroll bars that hide the bottom row and some of the right-most column. I basically want to freeze the column widths and row heights so the scroll bars do not appear and hide the data.
 

Fixed values in a column?

Preview
Is it possible for me to make a table and have a column with fixed values.

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
 

Fixed Format In The Report's Detail

Preview
Is it possible to have a fixed format in a report? If Yes, Could You help me by giving the procedures on how to do this or may be code.The report should have 2 columns with the data entry like most of you have probably done by just formatting the column width and height of the report. Now, My report should produce a hard copy with the same format everyday. What if only the first column has the data for this day and the next data should be filled up the next time. I want to display the Textbox in the next column even if there in no data entered to it. Got It? Any Idea on how to do this; fixed format in a report
 

Having problems with Combo Box (Form Control)

Preview
I have created several combo boxes which all have the same prefix in the name of the table: CB.

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
the settings.

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.
 

A Datasheet Conundrum

Preview
I've been playing with datasheets for weeks now. It seems like I've learned a lot, but I've been having problems setting column widths in certain cases.

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