Automatic Screen Resolution

Dec 8, 2006

Hello,

How can I make my DB dectect the users computer screen resolution and adjust my forms and reports to it?

What is hapening is that is I make the DB on 1024/168 and than the user uses 800/600 the forms and reports look huge..... Is there a way to fix this automaticaly?

View Replies


ADVERTISEMENT

Screen Resolution

Apr 4, 2005

Is there a way a form can resize themselves depending on the screen resolution different computers use??

View 3 Replies View Related

Database And Screen Resolution

May 15, 2006

I couldnt find a search facility to see if this had been covered before, so apologies if it has been answered before.

I have created an application in Access (2002) which from the users side of things will start in a form and give them no access to the back end.

Unfortunately, it is entirely possible that different users will have their screens set at different resolutions and so the application will be unusable on some and too small on others.

I was wondering if it was possible for access to automatically resize according to the users screen resolution.

I have searched the MS Knowledge Base and help files etc, but I think it is looking less likely that it is possible. Creating 5 or 6 different versions for different screen resolutions would be a none option.

Thanks for reading.

Taker

View 3 Replies View Related

Changing Form Size According To Screen Resolution

Oct 13, 2005

Hello this is my first post in the definetely best Access & VBA forum on the net and i hope i am in the correct forum to ask this.
I would like to know if there is any way in access to change the size of the for my users view according to their screen's resolution.
E.g. i am creting the form using 1280 x 1024 resolution and my users have 1024 x 768 resolution how go i make the form adapt to their res.
Thanks for any replies :D

View 3 Replies View Related

Forms :: Text Box Layout As Per Screen Resolution

Jul 13, 2013

I want to place a text box at the right bottom corner of a form. I tried but its position is changing as per moinitor sizes.

View 1 Replies View Related

General :: Fitting Form According To Screen Resolution

Nov 21, 2013

I created a form which fits to my screen resolution. When I open it through an another computer which has different screen resolution then my form is opening according to my 1st screen resolution.

I wanted to fit the form resolution to the desktop on which it it opening. Is it possible?

How to set the form the screen resolution on which the form is opening.

View 3 Replies View Related

A Simple Login Screen / Also Access In Full Screen

Jul 27, 2006

I have tried to make a login screen, I have also searched for information and tried some of the examples but, I just can't get one to work.
Is there someone or somewhere where I can get information on how to build one step by step in simple easy instructions....(access 2003).

Also, how do you get access to open all the windows, tables, queries etc in full screen mode.
I have expaneded them and shut it down and then reopened it but they still want to open out of full screen mode.

Thanks, everyone has been a great help in creating my first Access program.

View 3 Replies View Related

Monitor Resolution

Sep 20, 2006

I just bought a new computer. It came with a GIGANTIC (for me) 19 inch monitor.

Here's the question. What resoution should I set the screen to?
I make databases for others.
If my forms are too big for their monitors they have to use the scroll bars all the time.
If my forms are too small it doesn't look professional.

Advise greatly appreciated.

View 3 Replies View Related

Access Chart Too Low Resolution.

Nov 22, 2006

Is there a way to have the same printing options for a chart in access as in excel.

View 1 Replies View Related

Resolution Requested - SQL Statement In VBA

Jul 14, 2004

I have an Append Query that I developed and am wanting to use the SQL View statement in a piece of VBA code that I am writing. The problem is that it is not working.

Here is the SQL View when I am in Query Design View.
Code:INSERT INTO tblMasterAccountList ( AccountNum, AcctName, [Account Type], [Billing Spec] )SELECT TEMPAcct.Acct, TEMPAcct.Name, TEMPAcct.Type, TEMPAcct.BillingSpecFROM TEMPAcctWHERE (((TEMPAcct.Existing)=False));

Here is the code I have in VBA...
Code:Dim strSQL As StringstrSQL = "INSERT INTO tblMasterAccountList (AccountNum, AcctName, [Account Type], [Billing Spec]) "strSQL = strSQL & "SELECT TEMPAcct.Acct, TEMPAcct.Name, TEMPAcct.Type, TEMPAcct.BillingSpec "strSQL = strSQL & "FROM TEMPAcct "strSQL = strSQL & "WHERE (((TEMPAcct.Existing)=False));"DoCmd.RunSQL strSQL

The code runs fine in that no errors are generated, but it does not append the records. When I run the query outside of VBA, it does append the records. Is there something special that needs to be done with an action query for the SQL statement to work in VBA?

View 4 Replies View Related

Forms :: Export Form To PDF Resolution

Dec 4, 2013

After a user completes a form, they click a button at the end that uploads the information the back-end database and creates a PDF copy using the DoCmd.OutputTo function. It has been working fine, but one user just had an issue where the form was very zoomed in and cut off. So I have 2 questions:

1) What is the cause of this problem? Is it based on screen resolution?

2) Is there a way to fix the problem to make sure it does not happen?

View 8 Replies View Related

Help Needed To Change Form Size/resolution

May 2, 2005

I hope I can explain this clearly.
I have a subform that has a lot of information and I was wondering
if there is a way to make the subform appear as if one turned up the
resolution, thus making it's contents smaller, allowing me to pack more info
in it. I would love to leave the size of the main form alone.
I'm using Access 2000.
The sub form is currently displayed as datasheet.

View 1 Replies View Related

Reports :: Unbound Object Frame Failing To Display Linked Image At Correct Resolution

May 18, 2013

I am using an unbound object frame to display an .png image file which is set in vba.

The image is an excel chart saved as a .png

The problem I have however is that the image I save from Excel is great quality, and is pretty tack sharp, but when I display the same file in the unbound object frame in access, it is not nearly as sharp.

I am setting the picture property of the control as:

ubImageUserChart = "c: empmyChart.png"

It displays alright, but is just a bit fuzzy - still quite legible, but it is a complex graph with a lot going on - has regressions and formulas etc on the graph, and they need to be very clear.

BTW - the unbound frame is the same size as the Excel chart which gets saved as a .png file. If I tile the images (Access unbound frame and original file in picassa preview) side by side - they are identical - size, orientation etc.

It is not practical for me to try and do the chart natively in access as it is way to complex. I am using access vba to drive an excel session to do all the statistical yack work and chart rendering, then displaying a png image of the resulting chart in an unbound object frame in access.

View 7 Replies View Related

"Do Not Show This Screen Again" : Splash Screen

Aug 1, 2006

Hello all,

I have this splash screen, which welcomes all the users. It has an OK command button that exits the screen, and a checkbox that says "Do not show this screen again". I still do not have the code behind the checkbox. Thus I was wondering if there is a way where I could entirelly close or "get rid" of the splash screen until the user loggs in again. Because right now there is no code behind it, so everybody that checks it and click OK, leaves the screen. But they can still open it, if they select the "splash form".

View 11 Replies View Related

Splash Screen

May 25, 2005

i have spash screen that runs for about 10 seconds, would like to reduce to about 4 seconds any ideas

seee script below.

Option Compare Database
Option Explicit

Private Sub Form_Close()
DoCmd.OpenForm "Switchboard"
End Sub

Private Sub Form_Timer()
On Error GoTo Err_Form_Timer

DoCmd.Close

Exit_Form_Timer:
Exit Sub

Err_Form_Timer:
MsgBox Err.Description, , "ASSETSonTRACK"
Resume Exit_Form_Timer

End Sub
Private Sub Command21_Click()
On Error GoTo Err_Command21_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Switchboard"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command21_Click:
Exit Sub

Err_Command21_Click:
MsgBox Err.Description
Resume Exit_Command21_Click

End Sub
Private Sub Command23_Click()
On Error GoTo Err_Command23_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Switchboard"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command23_Click:
Exit Sub

Err_Command23_Click:
MsgBox Err.Description
Resume Exit_Command23_Click

End Sub

View 1 Replies View Related

Splash Screen Help

Oct 14, 2005

Hi all,
I was wondering if it is possible to use a splash screen in the middle of your program? Ex. Can I have a splash screeen to display at the beginning of my database and then have another splash screen open during my program. If i click on a command button to display a form, cause I have a splash screen appear before that form load?
Is till possible while using Data Access Pages as well?
thanks in advance

View 3 Replies View Related

Full Screen

Aug 29, 2006

Hi,

I searched in this form and on the internet on how to display a form in Full screen; however, I could not find an answer that worked.

Does anyone knows how to display forms full screen please?

Thank you,
B

View 5 Replies View Related

Flickering Screen

Nov 7, 2006

Hi,

I used a tab control in a form. However, when I move the mouse over the form, the form flickers.

Has anyone ever experienced the same problem?

Thank you,
B

View 4 Replies View Related

Logon Screen

Nov 28, 2006

Hi, i want to add security into my database, but i dont want to use the built-in workgroup security.

Is it possible to create a login screen that will allow different access rights depending on the username? If so can sum1 please help me with the code?

Cheers Guys :)

View 1 Replies View Related

Navigation Screen

Jun 4, 2007

hey

i build a navigation screen

the problem : i want to activate this in the tools-operation , but i can't (i dont see the name of the navigation screen there ...

View 2 Replies View Related

Navigation Screen

Jun 27, 2007

is there a way to put more then 8 button's operation in a navigation screen ?

View 8 Replies View Related

Not Go To Next Screen Without Entry

Oct 6, 2005

i am editing the user interface for operators.

here is the issue:
operators are entering data but sometimes forget to put the part serial number. they then go to the entry.

this is what i want to do:
the operator will not be able to go the next screen (complete the entry) unless they enter the part serial number. where and what should i enter that will prevent the issue?

much thanks.

View 10 Replies View Related

Screen Positioning

Apr 13, 2005

How to I get the screen to show the top of the form?
Solid lines and xs show what is shown on the screen.

This is used for bigger resolutions. I am modifying the layout of the forms depending on the screen resolution.
Also what is the highest resolution anyone has seen an access database running at?

Auto resize and Auto Centre are both already set to no.
Using access 2000. There are no scroll bars on the form.


--------
|.........|
|.........|
|.........|
_______
|xxxxxxx|
|xxxxxxx|
|xxxxxxx|
|xxxxxxx|
|xxxxxxx|
_______
|.........|
|.........|
|.........|
--------

View 2 Replies View Related

Screen Updating

Aug 3, 2006

I have a button on a form which closes the form and opens a different one. This causes the screen to "flash" as one is closed, the main menu becomes visible very briefly and then the new form opens.

In Microsoft Excel I used to use the VBA code:

Application.ScreenUpdating = False

to prevent this and only allow the final state to be displayed. I've tried this with Access and it doesn't seem to work.

Is there an equivalent?

Gary

View 14 Replies View Related

Bar On Form Screen

Oct 8, 2011

I have a form that has a bar down the left side of my form that is right next to the navaigation bar. It has a arrow pointing toward the form. If I click on it nothing happens. Don't know what it is and would like to get rid of it if possible.

View 2 Replies View Related

Turn Off Screen Updating

Jun 15, 2005

I've had a search and can't find anything along these lines...

I've got some code which plays about with reports and it looks awful when it's running - is there an equivalent of Excel's "Application.ScreenUpdating = False" functionality in Access (2000)?

Dave

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved