Cut Off at Bottom of Form View

[wscwt01]

Hi Mike,
Have you applied a change to the attached?
I am not clear on what you class as Sub-Form?


When I open attached I still get the cut off at the bottom.
Cheers,

Hi
You needed to make the subform longer to display all of the Controls

[mike60smart]

My apologies

Here with the correct version

[Micron]

I guess it depends on your monitor, but for me, everything needs to be moved around and resized so as to be appropriate for the data being displayed. No need for a 2" wide control that will show a single digit number, for instance. Also, records Id should not be visible on the form (it is the autonumber PK). If you need it for development purposes, then fine for now, but place it somewhere out of the way and make it invisible when done. This issue is what you get when everything doesn't fit and you turn off all scroll bars as you have done. Allowing them is another option?

Does no one else get 2 error messages? One for missing type library and one "there is no object in this control"?

[wscwt01]

Thanks a million Mike.

My apologies

Here with the correct version

[mike60smart]

Hi
No problem but as Micros said. There are issues with the database when opening - Missing Reference and No Object.

Also you are using Lookup fields in your tables. This is a No No is Access.

You are using Reserved Words in your Master table. Year and Date

In your Lookup tables it is recommended that you have an Autonumber to identify each Record.

[Micron]

@wscwt; the reason for the error re: the control is that the built in date picker has been deprecated in later versions because it automatically appears by default for a textbox whose data type is date. I can't tell you what the alternatives are for your version (aside from a custom date picking form, which would be more work than it's worth). In addition to what Mike said, you also have spaces in object names, which is also not recommended. I didn't look at the rest of the db to see how the db schema (tables and their relationships) is, so no comment there at present. I got something to fit by playing around, but it's probably not how I would do it.

[Micron]

This more closely resembles what I'd do. However, I'm not a fan of having 5 extra controls to do what one navigation control can do, so I'd be ditching those.