How to make button to show just the subform ?

[Steve]

Hi,
Solving this is a long awaited dream !
I have a main form 'A' filling the monitor screen and off screen below it
and sitting within it a subform 'B' and within that another smaller subform
'C'.
Rather than keep scrolling down each time for entering data into my subform
'B' and 'C', I wish to have a button on my mainform 'A' to put on screen the
subform 'B' with its subform 'C' and on that subform 'B' a button to return
me to the main form 'A'.

....and to have design view still have the forms A and B one above the other,
with C inside B.

I have this on one dbase someone did for me but how he did it I dont know.
and I cant ask him anymore.

How is this done ?

I may in fact go for a button on 'B' to then show just subform 'C' as
sometimes I find the navigation buttons confusing as to which subform they
relate to !
Again with button to return to 'B'.

How is that also then done ?

I am experiencing screen refresh issues having added a subform. Bits of
previous text and the boxes remain until I scroll up and down to refresh,
damn nuisance. Not the graphics card as no other progs exhibit this and a
256Mb top of the range best there was video card on a 4Gb 3.2Ghz graphics PC
doesnt have problems, so thats a Msoft Access problem but how to solve it
....I dont know, hope the button method improves things.

Regards

Steve

 

[Damon Heron]

On your main form, have a cmd btn with this code:
Me.[the nameof your subform].SetFocus

On the subform (which is not a datasheet, but regular form), have a cmd btn
with:
Me.Parent.[some object at the top of your main form].SetFocus

As far as the screen refresh, I seem to remember something about
unassociated labels causing a flicker, can't remember what else. Try a
google for Access form flicker.

HTH
Damon

 

[Steve]

Hi Damon,
I created a command button, the wizard didnt seem to be giving me an easy
route to make a code, so exited thet, then r/click on the button,
properties, event tab, On Click code builder.

Option Compare Database
Option Explicit

Private Sub Command1107_Click()
Me.[F_BOBC_Book_SNT_PhotoBasics_subform].SetFocus
End Sub


exited that.

Now did I do the right thing in the approach above ?

tried it and got :-
Error Accessing File. Network Connection may be lost.

Now I had that message yesterday when just navigating forward one record in
the main form having added a subform.
deleted the subform, navigation still gave it.
re-launched access and it was ok.
added subform again and it worked.

Steve

On your main form, have a cmd btn with this code:
Me.[the nameof your subform].SetFocus

On the subform (which is not a datasheet, but regular form), have a cmd
btn with:
Me.Parent.[some object at the top of your main form].SetFocus

As far as the screen refresh, I seem to remember something about
unassociated labels causing a flicker, can't remember what else. Try a
google for Access form flicker.

HTH
Damon

Hi,
Solving this is a long awaited dream !
I have a main form 'A' filling the monitor screen and off screen below it
and sitting within it a subform 'B' and within that another smaller
subform 'C'.
Rather than keep scrolling down each time for entering data into my
subform 'B' and 'C', I wish to have a button on my mainform 'A' to put on
screen the subform 'B' with its subform 'C' and on that subform 'B' a
button to return me to the main form 'A'.

...and to have design view still have the forms A and B one above the
other, with C inside B.

I have this on one dbase someone did for me but how he did it I dont
know. and I cant ask him anymore.

How is this done ?

I may in fact go for a button on 'B' to then show just subform 'C' as
sometimes I find the navigation buttons confusing as to which subform
they relate to !
Again with button to return to 'B'.

How is that also then done ?

I am experiencing screen refresh issues having added a subform. Bits of
previous text and the boxes remain until I scroll up and down to refresh,
damn nuisance. Not the graphics card as no other progs exhibit this and a
256Mb top of the range best there was video card on a 4Gb 3.2Ghz graphics
PC doesnt have problems, so thats a Msoft Access problem but how to solve
it ...I dont know, hope the button method improves things.

Regards

Steve

 

[Damon Heron]

The Network connection msg is separate from your coding. It sounds like you
have the backend (tables) on a server.
For development, I would suggest that you don't split your db until you are
ready to deploy it.

Damon

Hi Damon,
I created a command button, the wizard didnt seem to be giving me an easy
route to make a code, so exited thet, then r/click on the button,
properties, event tab, On Click code builder.

Option Compare Database
Option Explicit

Private Sub Command1107_Click()
Me.[F_BOBC_Book_SNT_PhotoBasics_subform].SetFocus
End Sub


exited that.

Now did I do the right thing in the approach above ?

tried it and got :-
Error Accessing File. Network Connection may be lost.

Now I had that message yesterday when just navigating forward one record
in the main form having added a subform.
deleted the subform, navigation still gave it.
re-launched access and it was ok.
added subform again and it worked.

Steve

On your main form, have a cmd btn with this code:
Me.[the nameof your subform].SetFocus

On the subform (which is not a datasheet, but regular form), have a cmd
btn with:
Me.Parent.[some object at the top of your main form].SetFocus

As far as the screen refresh, I seem to remember something about
unassociated labels causing a flicker, can't remember what else. Try a
google for Access form flicker.

HTH
Damon

Hi,
Solving this is a long awaited dream !
I have a main form 'A' filling the monitor screen and off screen below
it and sitting within it a subform 'B' and within that another smaller
subform 'C'.
Rather than keep scrolling down each time for entering data into my
subform 'B' and 'C', I wish to have a button on my mainform 'A' to put
on screen the subform 'B' with its subform 'C' and on that subform 'B' a
button to return me to the main form 'A'.

...and to have design view still have the forms A and B one above the
other, with C inside B.

I have this on one dbase someone did for me but how he did it I dont
know. and I cant ask him anymore.

How is this done ?

I may in fact go for a button on 'B' to then show just subform 'C' as
sometimes I find the navigation buttons confusing as to which subform
they relate to !
Again with button to return to 'B'.

How is that also then done ?

I am experiencing screen refresh issues having added a subform. Bits of
previous text and the boxes remain until I scroll up and down to
refresh, damn nuisance. Not the graphics card as no other progs exhibit
this and a 256Mb top of the range best there was video card on a 4Gb
3.2Ghz graphics PC doesnt have problems, so thats a Msoft Access problem
but how to solve it ...I dont know, hope the button method improves
things.

Regards

Steve

 

[Steve]

Damon,
I have no servers or network. Just a PC with Two HDs, data on the second (D
drive), progs on the first.
Access files are on the Data HD.
The message is erroneous. A perfectly good dbase exhibited it when I added a
subform. removed subform. still got message. relaunched access...gone.
redo subform, still gone.
Steve

The Network connection msg is separate from your coding. It sounds like
you have the backend (tables) on a server.
For development, I would suggest that you don't split your db until you
are ready to deploy it.

Damon

Hi Damon,
I created a command button, the wizard didnt seem to be giving me an easy
route to make a code, so exited thet, then r/click on the button,
properties, event tab, On Click code builder.

Option Compare Database
Option Explicit

Private Sub Command1107_Click()
Me.[F_BOBC_Book_SNT_PhotoBasics_subform].SetFocus
End Sub


exited that.

Now did I do the right thing in the approach above ?

tried it and got :-
Error Accessing File. Network Connection may be lost.

Now I had that message yesterday when just navigating forward one record
in the main form having added a subform.
deleted the subform, navigation still gave it.
re-launched access and it was ok.
added subform again and it worked.

Steve

On your main form, have a cmd btn with this code:
Me.[the nameof your subform].SetFocus

On the subform (which is not a datasheet, but regular form), have a cmd
btn with:
Me.Parent.[some object at the top of your main form].SetFocus

As far as the screen refresh, I seem to remember something about
unassociated labels causing a flicker, can't remember what else. Try a
google for Access form flicker.

HTH
Damon

Hi,
Solving this is a long awaited dream !
I have a main form 'A' filling the monitor screen and off screen below
it and sitting within it a subform 'B' and within that another smaller
subform 'C'.
Rather than keep scrolling down each time for entering data into my
subform 'B' and 'C', I wish to have a button on my mainform 'A' to put
on screen the subform 'B' with its subform 'C' and on that subform 'B'
a button to return me to the main form 'A'.

...and to have design view still have the forms A and B one above the
other, with C inside B.

I have this on one dbase someone did for me but how he did it I dont
know. and I cant ask him anymore.

How is this done ?

I may in fact go for a button on 'B' to then show just subform 'C' as
sometimes I find the navigation buttons confusing as to which subform
they relate to !
Again with button to return to 'B'.

How is that also then done ?

I am experiencing screen refresh issues having added a subform. Bits of
previous text and the boxes remain until I scroll up and down to
refresh, damn nuisance. Not the graphics card as no other progs exhibit
this and a 256Mb top of the range best there was video card on a 4Gb
3.2Ghz graphics PC doesnt have problems, so thats a Msoft Access
problem but how to solve it ...I dont know, hope the button method
improves things.

Regards

Steve

 

[Damon Heron]

This sounds like the problem documented in Microsoft KB article Q304548.
You running Access 2000?
Note that a db corruption problem will not get fixed by the MS fix.
For db corruption:
1.Create a new mdb, import everything except the form causing the problem.
2.Compile before you close the mdb.

You will then have to re-create the form or get it from a recent backup mdb.
Damon

Damon,
I have no servers or network. Just a PC with Two HDs, data on the second
(D drive), progs on the first.
Access files are on the Data HD.
The message is erroneous. A perfectly good dbase exhibited it when I added
a subform. removed subform. still got message. relaunched access...gone.
redo subform, still gone.
Steve

The Network connection msg is separate from your coding. It sounds like
you have the backend (tables) on a server.
For development, I would suggest that you don't split your db until you
are ready to deploy it.

Damon

Hi Damon,
I created a command button, the wizard didnt seem to be giving me an
easy route to make a code, so exited thet, then r/click on the button,
properties, event tab, On Click code builder.

Option Compare Database
Option Explicit

Private Sub Command1107_Click()
Me.[F_BOBC_Book_SNT_PhotoBasics_subform].SetFocus
End Sub


exited that.

Now did I do the right thing in the approach above ?

tried it and got :-
Error Accessing File. Network Connection may be lost.

Now I had that message yesterday when just navigating forward one record
in the main form having added a subform.
deleted the subform, navigation still gave it.
re-launched access and it was ok.
added subform again and it worked.

Steve

On your main form, have a cmd btn with this code:
Me.[the nameof your subform].SetFocus

On the subform (which is not a datasheet, but regular form), have a cmd
btn with:
Me.Parent.[some object at the top of your main form].SetFocus

As far as the screen refresh, I seem to remember something about
unassociated labels causing a flicker, can't remember what else. Try a
google for Access form flicker.

HTH
Damon

Hi,
Solving this is a long awaited dream !
I have a main form 'A' filling the monitor screen and off screen below
it and sitting within it a subform 'B' and within that another smaller
subform 'C'.
Rather than keep scrolling down each time for entering data into my
subform 'B' and 'C', I wish to have a button on my mainform 'A' to put
on screen the subform 'B' with its subform 'C' and on that subform 'B'
a button to return me to the main form 'A'.

...and to have design view still have the forms A and B one above the
other, with C inside B.

I have this on one dbase someone did for me but how he did it I dont
know. and I cant ask him anymore.

How is this done ?

I may in fact go for a button on 'B' to then show just subform 'C' as
sometimes I find the navigation buttons confusing as to which subform
they relate to !
Again with button to return to 'B'.

How is that also then done ?

I am experiencing screen refresh issues having added a subform. Bits
of previous text and the boxes remain until I scroll up and down to
refresh, damn nuisance. Not the graphics card as no other progs
exhibit this and a 256Mb top of the range best there was video card on
a 4Gb 3.2Ghz graphics PC doesnt have problems, so thats a Msoft Access
problem but how to solve it ...I dont know, hope the button method
improves things.

Regards

Steve