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?
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 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.
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
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?
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?
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 see Access has security features, such as creating group accounts with varying levels of permissions....This all works great for my computer, as I want an administrator and read-only user accounts. The problem is that these setting seem only to apply to my machine and are not present when the database is accessed from another terminal. Is there any way to attach these security measures to the database itself as opposed to just the local settings on my machine? Thanks.
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.
I have created a report in MS Access. When I choose the option to Publish to MS Word, I loose all of the background colors. Is this correct or am I doing something wrong? Is there a way to maintain all of the Format features when I publish?
I am considering the possibility of revamping the employee onboarding & off-boarding process for our organisation to make it more efficient.
Current State: We use InfoPath forms in SharePoint Servers 2010 to handle onboarding/employee change/off-boarding requests submitted by the related department. With the Workflow process, the respective manager will receive email to approve the requested intake form and once it is done, the form will be assigned to someone in the business support team for processing. Once all the required logistics are completed, we shall enter the new hire's profiles into our MS Access employee database through an employee input form.
It works well although it seems like a duplication of work since the support team has to manually input the employee information, which is already captured on the InfoPath form, into the Access database. We also need to align the field options (such as data on drop down lists) in the InfoPath form with similar field on the input form in the database whenever there are new field added or changes made on existing fields.
Future State: I wonder if there is a way in Access to set up a similar request/approval process so that we can get rid of the InfoPath form when the requester can input the employee information on a onboarding intake form in Access with data stored in a temporary table. After the request is approved and subsequently completed by the business support team, we can say, click a button and transfer the employee data from the temporary table to the employee table. Of course, some sort of validation rules should apply before the transfer takes place to ensure data integrity.
I think the major challenges would be to build an approval process within Access to provide similar notification features as from InfoPath.
I know this might be a wild thinking but just want to look for possible options to save manual work and improve the efficiency of our process.
I am trying to run a query and display the results in a report (the report side of it is childs play and not a problem). The problem I am having is that I have a search form which should allow the user to search any one of 6 fields (text boxes) or a combination of each.
If the user enters something into a field then that search criteria must match. I wanted to have it so if all fields are left blank then it will show all entries in the database (but it isn't, it shows a blank report). I also wanted it to allow partial completion of boxes.
So for instance if I have 5 customers (Jones, Jonson, Jonus, jimjonkins, Janis) and I type "Jon" into the name field then I would like it to show the first 4 records as they all contain "jon" somewhere in their name but its not, its only allowing exact matches.
I currently have '[forms]![Search_Customer]![Search_Name]'.
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?
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?
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?
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.