Access Structure Design (form process), open message box with multiple options on error

[Heathey94]

Oh, I see.

I'm willing to do it myself with assistance, I just don't know where to start and what's going wrong... Is the solution in this thread somewhere?

[aytee111]

I believe it has been spoken about, but I too didn't reread everything! I said something about it being similar to opening forms from the homepage, opening to a new child or an existing one. See if that helps.

[Heathey94]

OK, I'm really struggling here. Could you give me a pointer as to where/what the problem is?

[aytee111]

Sure. My first question is - are team/district/org required fields on tblAssessment?

[Heathey94]

Yes, I believe I have gone through to make all of changes like that on the database now.

[aytee111]

In the meantime, get your Back buttons working - I presume it is to go back to the prior form? It is changing the ID however.

[Heathey94]

Yeah, I'm not sure why that is though, as the process looks fine to me. I've changed it now though, and it does appear to be working.

[aytee111]

I once got a message about "must enter a Document PK" but can't seem to find where it happens or even it get it to happen again. When I click on Behaviours, however, you need to check all the fields that should be entered before leaving the form. You can do this in BeforeUpdate and set Cancel=True if anything is missing.

(Note, I am making small changes here and there and will send you a new copy, this will make it hard if you are also working on it)

[Heathey94]

OK, so - this is where I'm at.

I've managed to fix a few things, with just a few problems left:
Adding an assessment to a child who already has an assessment (from the "Add New Assessment button on the AssessmentRecord form)

Private Sub Form_BeforeInsert(Cancel As Integer)
    Me!ChildID = Me!HoldChildID
End Sub

My first thought is to just remove this code as I don't believe it is needed now, and this works - although this is what happens (I suspect this is not to do with the code I'm removing, but something elsewhere which is failing):

It looks like the subform is not displaying due to nothing being entered in the AssessorID dropdown, but I'd like it to appear - with nothing entered in the fields (as there is nothing to lookup) if possible.
Also, for some reason the child name is not displaying?

Adding an assessment to a child who does not already have an assessment (from the view assessment button on the ChildRecord form)
After the above changes, the form displays as above, but the child details are no longer pulled through from the ChildRecord page.

If a form is too big for the screen, the screen seems to position itself halfway down the page - I'd like it to always show the top.
A prime example of this is the behaviours form. Also, the tabs seem to be of a fixed height, can this not be changed?

[aytee111]

Remember I had that problem right from the start, your forms were too big and there were no scroll bars. I had to tell you that you need to design this for small screens. Your form headers are large, there is a lot of white space. I always design my forms with the controls starting from the top left. Another golden rule is that always set the Tab Stop of the subforms to No, that causes the screen to be displayed with the subform at the top.

Another nice thing would be to get your tabbing in the right order (Tab Order).

[Heathey94]

I will put a banner in the header, which will enable the user to get to the homepage from any page on the database, hence the white gap.

The user will have the same size screen as me, which is why I have attempted to make it fit the screen as best as possible, I was just curious to know why it started in a random position, but I was unaware there was a setting to alter this, where is it? I see there is an "Auto Center", but this is set to no.

Yes, sorry - I knew there was something else I needed to do.

[aytee111]

"set the Tab Stop of the subforms to No"

[Heathey94]

Right, sorry - I must have missed that section. What about this bit?

I always design my forms with the controls starting from the top left

[aytee111]

Preference, that's all.

[Heathey94]

Yeah - I think that's how I want mine too, is there a setting I need to change?