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
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
I have learned how to create animated command buttons within a form. This works out great, but this brought on new ideas.
Currently, all I have is a stand alone picture (our logo) that is stored in the same directory as the db and to my knowledge this has nothing to do with access at all (other then it pulling the .bmp). I would like our Logo to be animated (simple rotating) during the Intro Splash screen.
Is this a possible task?
John
I need to add another lbl to the following code. Just where to I add the other lbl. I pick this code up somewhere. The code works great. But all I would like to do is add another lbl to the Splash Screen.
Option Compare Database
Dim intEndingRed As Integer
Dim intEndingGreen As Integer
Dim intEndingBlue As Integer
Dim intIncrementRed As Integer
Dim intIncrementGreen As Integer
Dim intIncrementBlue As Integer
Dim sngRemainingDiffRed As Single
Dim sngRemainingDiffGreen As Single
Dim sngRemainingDiffBlue As Single
Private Sub Form_Activate()
'* 4370509 is a shade of green
'* 13883752 is a shade of cyan
bcg_SetColors Me, 14977294, 14098070
End Sub
Private Sub Form_Deactivate()
bcg_SetColors Me, -2147483645, -2147483620
End Sub
Private Sub Form_Load()
Me.lbl1.Width = 0
Me.Image1.Width = 0
DoCmd.Restore
End Sub
Private Sub Form_Open(Cancel As Integer)
'PlaySound ("V:Contractswelworld")
End Sub
Private Sub Form_Timer()
If Me.lbl1.Width = 6000 Then
' I think this is where it should go,
GoTo ImageExpand
Else
Me.lbl1.Width = Me.lbl1.Width + 100
Me.Repaint
Exit Sub
End If
ImageExpand:
If Me.Image1.Width = 4000 Then
Exit Sub
Else
Me.Image1.Width = Me.Image1.Width + 100
Me.Repaint
End If
If Me.Image1.Width = 4000 Then
Me.lbl2.Visible = True
End If
End Sub
Private Sub lbl1_Click()
End Sub
Private Sub lbl2_Click()
MsgBox "Close this splash screen and take user somewhere else."
DoCmd.Close
End Sub
Private Sub Command13_Click()
On Error GoTo Err_Command13_Click
Dim stDocName As String
stDocName = "MacOpenSwitchboard"
DoCmd.RunMacro stDocName
Exit_Command13_Click:
Exit Sub
Err_Command13_Click:
MsgBox Err.Description
Resume Exit_Command13_Click
End Sub
I have just created a splash screen for my database.
I was wondering if anyone knows anything else that is good to add to this form which would make it look pretty impressive?
I would like to add a loading bar (Similar to the one that appears at the bottom the page on internet explorer). Does anyone know if this is possible? If so how do you do it?
I've done some searching here, but don't see exactly what I am looking for. I am wanting to attach some code to the timer on a slash screen, or on the close event, to fade the splash screen out. I have looked at the "Cadice Tripp" site. It's fine, but not a fade out. What I want is a simple fade in.... fade out, on the splash screen. Anyone seen any code for this?
Thanks
I would like to have an animated opening screen when the database opens with the autoexec.
I have an animation package called Xara that makes some wonderful 3d animations. I would like to use this in an Access form. Is this possible? Animated GIF or Flash?
If the answer is no, can I call another application to show the animation?
Thanks in Advance - John
I want a progress bar in a form that will increase from bottom to top . The data will from Access table. The bar will start from 0 to Maxvalue. The Maxvalue will be calculated as below:
Total number of batches in the table/ No. of working days between 14072014 and 31112014 / 2
So the above calculation will define the range of a progress indicator.
And now we have to show the % percentage that means how many batches have been scanned for today. For this the following calculations will be used:
Count total batches where scandate=today and scannedby<>null
Now this will show the percentage in the bar that means hopw much work has been completed.
The progress bar should move from bottom to top when % increases.
I have on very large form in my db that takes several seconds to load. I want to optimize things, so I am trying to have it load hidden in the background when the db first starts up, this way it can be immediately called on when it is needed later. Please read further :
I want to have a splash screen that loads as well. I have set the splash screen to the default form when the database opens. However, I am not quite sure how to get the other form to load in the background as hidden, AFTER the splash screen opens and appears. I tried calling it with the oncurrent event of the splash screen, but then splash screen wont appear until after the other (hidden) form has finished loading. I have tried different orders of events, but am having no luck getting the desired results.
Summary: I want the splash screen to show first, then the big form to open (hidden) in the background. The user can click on a continue button on the splash screen and then the main switchboard will open.
All access application is realized as MDI container. (if I'm right)
In this case it is possible to set the MDI object background image instead develop splash screen. This picture always in background form open another forms or reports, does not depend on the screen resolution, etc, etc ... Splash screen must be removed in order to realize the other forms or reports.
How to set Access 2013 application backgroundimage, and backgroundImageLayout?
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".
I've changed my splash screen for a database using the method of creating an alternative bitmap.Is there a time setting for this or an alternative?
View 6 Replies View RelatedI 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.
I created a splash form, then activated, when ever I go into access
splash form popsup. Is there any way I can disable the splash form, and update my table structure ?
Thanks,
I have a splash page and Id like to add a button that will take me to a excel sheet. Is this possible? I cant import the excel sheet into access as it needs to be kept seperate so it can be edited by other people in the section. So Im after more of a shortcut link type effect. is this possible at all?
Thanks
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
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
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 :)
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 ...
is there a way to put more then 8 button's operation in a navigation screen ?
View 8 Replies View Relatedi 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.
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|
_______
|.........|
|.........|
|.........|
--------
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
Is there a way a form can resize themselves depending on the screen resolution different computers use??
View 3 Replies View RelatedI 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 RelatedI'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