Generic page setup for Access

[sha7jpm]

I have noticed that my database which is used by a variety of users has different page settings depending on the pc.

for example.
reports which show up fine on my machine span two to three pages on other peoples machines,

and the size of the forms which fit completely on the screen for some users, others need to use the scroll bar to navigate through the forms.

is there anyway to solve this? other than going to each machine and checking the page setup,and resolution I am stumped.!

ta

John

 

[Autoeng]

Because you developed the application at another screen resolution than your users you are going to have this problem. You can do one of three things.

Redo all of your forms and reports with your scrren resolution set to 800 X 600 which is probably what your users have set their's to.

Have all of your users reset their screen resolutions to match yours (good luck because as you know, change is bad).

Integrate a form resizer into you application. There is a good (free) one at www.developershandbook.com. I use it all the time and it works great. It requires some coding experience but I can help you if you don't know how and want to pursue this alternative.

Autoeng

 

[sha7jpm]

no change is a good thing!

cheers!

think the developers idea is the best,

as I dont know all of the users and like you say change is indeed a bad thing!! to some!

so I will explore the form resizer option.

will reply again once I have had a look.

many thanks for this.

ta

John

 

[Autoeng]

No problem John. It is pretty simple to integrate into you application and the instructions included in the Adobe file are really good and infomative. The hardest part for most people is remembering to set the new VBA reference.

Autoeng

 

[sha7jpm]

Update!

well, have put in all the syntax, but unfortunatly nothing happens!!

when I put in screen co-ordinates for 800x600 it still comes out in 1024x*** etc.

any ideas?

I have :

Option Compare Database
Option Explicit

Private frmresize As ADHResize97.FormResize

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "menu for DE"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command0_Click:
Exit Sub

Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click

End Sub
Private Sub Command1_Click()
On Error GoTo Err_Command1_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "menu for DPG"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command1_Click:
Exit Sub

Err_Command1_Click:
MsgBox Err.Description
Resume Exit_Command1_Click

End Sub
Private Sub Command2_Click()
On Error GoTo Err_Command2_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Maintenence Menu"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command2_Click:
Exit Sub

Err_Command2_Click:
MsgBox Err.Description
Resume Exit_Command2_Click

End Sub
Private Sub Command3_Click()
On Error GoTo Err_Command3_Click


DoCmd.Quit

Exit_Command3_Click:
Exit Sub

Err_Command3_Click:
MsgBox Err.Description
Resume Exit_Command3_Click

End Sub
Private Sub Command4_Click()
On Error GoTo Err_Command4_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "reports index"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command4_Click:
Exit Sub

Err_Command4_Click:
MsgBox Err.Description
Resume Exit_Command4_Click

End Sub

Private Sub Form_Open(Cancel As Integer)

Set frmresize = ADHResize97.createformresize
Set frmresize.Form = Me
Call frmresize.SetDesignCoords(800, 572, 120, 120)
End Sub

 

[Autoeng]

I assume that you just cut and pasted from the sample database so I didn't check all of the code but I did notice that in Form_Open you have

Call frmresize.SetDesignCoords(800, 572, 120, 120)

when it should be to convert your form developed at 1024 x 768 to display at 800 x 600

Call frmResize.SetDesignCoords(1024, 768, 96, 96).

Also, did you creat a module with the following?

Option Compare Database
Option Explicit

Private frmResize As ADHResize2K.FormResize

Also, in VBA did you go to Tools - References and select

ADHResize2K

You might have to browse to the directory holding the sample database to find it if it is not in the list.

Change the settings of your system to 800 x 600 and start the db and see if these suggestions helped.

Verify these and if you are still having problems post back.

Autoeng

 

[sha7jpm]

hmmmmmm

hi there,

cheers for your patience,

well still no luck I am afraid.....

verified all that you mentioned. but no change.

a Q.... does it matter what the module is called where you declare the ADHresize??

at present I have it called as frmresize...

ta

John

 

[Autoeng]

Name of mod doesn't matter.

Note that it does not work in datasheet view of a form.

Other than that I can't think of anything else. If your db is small I can take a look at it if you want to post it. If you don't want to post it send me a private message with your e-mail address and I'll respond so that you can send it to me.

Autoeng