Closing a form using vba

[Rockape]

Hi,

Thanks for reply,..... but how can i change these settings for the report?

Your suggestion is ok for a form, but how can it be done for a report?

Thanks once again.

check my last post! should do the trick

 

[danflipper]

these settings are the same as on a form
in the report properties

 

[Rockape]

Hi,

I'm afraid not, these settings do not appear on the report settings (unless i'm doing something odd!!!)

these settings are the same as on a form
in the report properties

 

[danflipper]

hi,

could you post a sample copy of your database so i could have a look?
mabey sort the problem

 

[Rockape]

Hi,

I've attached a copy.

hi,

could you post a sample copy of your database so i could have a look?
mabey sort the problem

 

[danflipper]

you havnt??

 

[Rockape]

Hi,

I'll try now View attachment Copy.mdb.zip

hi,

could you post a sample copy of your database so i could have a look?
mabey sort the problem

 

[danflipper]

i hope this is what you are looking for?

if its not i must be honest im stuck with what you would like to do!

here we go

View attachment db1.zip

 

[Rockape]

Thanks for the effort, much appreciated.

However, the form still stays on top. In a nutshell, what I had hoped for was that on clicking the button I would simply have the report maximized on screen (only).

Kind regards

i hope this is what you are looking for?

if its not i must be honest im stuck with what you would like to do!

here we go

View attachment 20492

 

[danflipper]

hi,

thats what i did
when i clicked on prev report, the report maximized on the screen and the form was behind it!

everything works this end - just how you described.
i have uploaded pictures to prove it.



you must have a problem somewere else

sorry

 

[Rockape]

Hi,

You may be right. maybe there is an error on my side. What it is I don't know because when I run your amended routine the smaller form stays in front !!!!!!!!

Its getting weirder and weirder...

Kind Regards
Eddie

hi,

thats what i did
when i clicked on prev report, the report maximized on the screen and the form was behind it!

everything works this end - just how you described.
i have uploaded pictures to prove it.
View attachment 20527

View attachment 20528
you must have a problem somewere else

sorry

 

[danflipper]

Hi,
when I run your amended routine the smaller form stays in front !!!!!!!!

Eddie

try setting the property !!modal!! on that smaller form to no but keep the pop-up yes

then vise versa if no luck!

 

[DanSnaith]

I know this is over 2 years old now but to anybody experiencing the same problem I wanted to share this.

I had the same problem this morning with a login form that I wanted to close after successful login.

I downloaded your copy of the database and had the same problem as you (the form was still overlapping the report)

I used,

Dim stDocName As String
Dim stDocNam As String
Dim stDocNa As String
Me.Form.Visible = False
stDocName = "rep_Cheques collected"
stDocNam = "frm_reports"
stDocNa = "Main Menu"

"Me.Form.Visible = False" worked perfectly for me and did exactly what you were looking for.

 

[meenctg]

For close current open form just simply use
DoCmd.close

For more about details : here