Forms :: Create A Message Box To Flash On Screen To Tell User That Update Code Is Running

Mar 6, 2014

I need to create a message box or a form or something to flash on the screen to tell the user that a piece of "Update" code is running. the update code will be updated reports from marketing returns, but the 3 branches who use the information are separate so I am creating an update form to download and update the table.

The code for the update is already working, but can take a while, so I thought a message or splash screen would be useful as the update runs on start up.

It would have another use, I have a report which is made mainly of calculated fields on an onPrint event and also takes a while to work it out, so a similar screen would be more useful than my current spinning circle and blank screen.

View Replies


ADVERTISEMENT

Modules & VBA :: How To Set A Message On Screen And Remove From Code

Jun 5, 2014

I would like to put a message on the screen for informing the user - mostly during some procedures that might take time or when, after a warning, I want to go on with the program but without action from the user.

Msgbox is obviously not the one I'm looking for as it needs customer acknowledge. Is there a solution for this task?

View 1 Replies View Related

Playing A Flash Animation Full Screen

Apr 18, 2006

Hey.
My database would like, to make itself feel complete, a rele snazzy opening form.
I have flash 8 and I've created a 1024x768 movie with some simple animation on it.
I've managed to add the movie to the database as a ActiveX flash object and the animations play.
The problem is making the object larger! It's staying very small no matter how I change the properties of the control.
Any help would be much appreciated. For the sake of my databases mental health... of course. :cool:

To attach the movie I did so:
http://www.databasedev.co.uk/flash_movie.html

JoeyTheBean

View 2 Replies View Related

How To Create My Own Message If A User Enter A Value Not Match With The Data Type?

Jul 26, 2006

In MS Access form, how can I create my own message if the user enter a value that not match with the data type of a field in underlying table? Thanks a lot!

View 3 Replies View Related

Forms :: Running Code On Individual Records

Mar 20, 2015

So in my database i'm creating a live form that will open up a list of patients and when they are seen. one of the bits is a button that before they arrive says "Not Arrived" and after they arrive it says "Arrived". The code works fine:

Code:
Private Sub Command68_Click()
Dim C1 As String
Dim C2 As String

[code]...

The problem is after clicking the button on any of the records, it changes the text on all records, to wit: I tried to attach images or links to images, but my post-count is too low. The before-click screenshot is /3QnBkgG on imgur. The after-click screenshot is 9VZWzzp on the same site.

Bear in mind I've only clicked the button (it's white, so it doesn't look like a button) on the top record.The form is set to continuous forms, not sure if that has anything to do with it.how I can get the code to run on individual records, rather than applying the first-record's results across all records?

View 12 Replies View Related

Forms :: Making Forms Invisible When Code Is Running

Jan 12, 2015

I'm opening forms to get data then closing using VB code.

Is there a way to stop the screen showing these forms as the code runs

something like Display refresh off then display refresh on.

Just to hide my workings.

View 1 Replies View Related

Forms :: Trying To Create A Running Total - DSUM?

May 9, 2015

So I'm trying to create a running total, to be able to graph a cumulative total. After looking around, I think I've figured out that I need to use a DSUM formula.I basically want to get a cumulative sum of profit in the 4th column.

View 7 Replies View Related

Forms :: Running A Query Based On User Selection Criteria On Form

Jan 9, 2014

I have a form which lets the user enter a contract ID and then a combo box that has a list of reports which run against whichever ID is entered.

What I want to know if I put the ID's in a table if theres a way to allow the user to select multiple ID's in one go and run the report against them the range rather than 1 at time?

I'm thinking about utilising the check/tick boxes would this be possible? or another way?

I'm using 2003 and have some VBA ability.

View 5 Replies View Related

General :: Display Progress Message On Screen

Jun 24, 2013

I want to display the message "Processing Record ? of ???..." on the screen while my vba code is running without interruption. Since the msgbox requires the user to click a button to continue, what is the simplest way to display this message on the screen without interrupting the program or requiring user interaction?

View 2 Replies View Related

Forms :: User Click Code

Feb 17, 2014

Code:
Private Sub Check237_Click()
If Me.Check237.Value = "yes" Then
Me.Text239.Visible = True
Else
Me.Text239.Visible = fasle
End If
End Sub

I am using the code above and what the desired action is when the Check237 is checked then the Text239 is visible for the user to put in a comment. However, as of now when the check237 is checked the textbox dissapears.

View 3 Replies View Related

Forms :: Password Validation - Message Pop Up With Specific Error User Has Made On Entry

Jan 6, 2014

I am looking at the public function routine, that validates the password entry. I want to know how i can make a message pop up with the specific error the user has made on entry.

Public Function ValidatePwd(varPassword As Variant) As Boolean
Dim blnValid As Boolean
Dim blnValidCriteria As Boolean
Dim intChar As Integer

blnValid = Len("" & varPassword) >= 4 And Len("" & varPassword) <= 12

[Code] ....

View 11 Replies View Related

Splash Screen Code

Aug 14, 2007

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

View 1 Replies View Related

Forms :: Create A Form / User Can Add Data Only

Mar 12, 2013

Is there a way to create a form that anytime i open it , i enter the data, when i hit save. the fields in the form goes blank and the data is saved in the table. Also when i open the form again, and repeat this process , it just adds to the table and does not delete previous data.

View 4 Replies View Related

User Login In Screen

May 3, 2006

hi,

i am a new memebr so i want to say hello to everyone, anyways i have created a database in microsoft access and have created a login screen where i have created different users and given them different access rights and permission in using my database, and that all works fine when i log on to the database from where the computer i created all these rights i get a login screen where the user enters the username and pass and then that opens up the database and allows the to view parts of the database which they are allowed to however my problem is this...

it works fine on the computer i created these access using the security (user-level security wizard) feature in microsoft access but when i open the database on a different computer it doesnt bring up a user login screen, meaning it lets anyone access the database etc so what do i do??? please help

regards rix :eek: :confused:

View 3 Replies View Related

Forms :: Option To Create A New User Or Exit Database

May 20, 2015

I have a fully functioning login screen with a combo box for name and a password box. It also has an option to create a new user or exit the database. On my main form I want the employees to have to log out of the database as opposed to close it out. How would I go about this? Also I need tracking login and logout times for each employee.

View 3 Replies View Related

Forms :: How To Use Data On A Form When Running Code Before Closing The Form

Feb 4, 2014

I have a bound form with a few fields. I would like to run a sub after some of these fields are modified, but not others. I would like it to run only once, after user finishes his work on the form.

When using the Unload event - the form on the form is not there anymore (or did I get something wrong?).

Is there a way to trap Data on form just before the form closes?

View 4 Replies View Related

Forms :: Create A Counter To Log How Many Times A User Login To Database

May 22, 2013

I have made a very simple log on form that requires the user to type in a user name and password. The user name and passwords are stored in a table. New users are added to this table to allow access to the database.

Is there a way I can add a counter to see how many times a particular user has logged onto the database?

Is there a way to make the password expire every 365 days requiring the user to reactivate their account and log in details.

View 2 Replies View Related

Forms :: How To Make Text In A Listbox To Flash Red

Mar 25, 2015

I'm working on a series of forms for a company that I'm currently employed at, and on one of them I've made a listbox which will display records which need action in the next 2 weeks.

That's all going fine. However, it it possible to make the items in the listbox flash red? Just so that our external worker REALLY has no excuses!

Just to clarify, I want the text identifying the records (E.g. Name, FinalDate) to flash, but not the headers for the columns in the listbox.

View 10 Replies View Related

User Security Levels And Password Login Screen

Jul 13, 2006

Does anyone have any sample code or a sample database?

I'm looking for a login form that has security level and passwords.

thanx

View 5 Replies View Related

Forms :: Create Set Number Of Identical Records Based On User-defined Text Box

May 12, 2015

I'm trying to create a database for a construction company, as an experiment more than anything, and my problem is this:

I need to create a set of identical records in the table "buildings" based on the information entered into a text box by a user on the form for registering a new project. I want each record to be identical except for the "plot number" field, which I want to start at one and increase to the number of buildings defined in the text box.

"Projects" is one table and "Plots" is in the other.

View 1 Replies View Related

Queries :: Remove Message While Running Query

Sep 15, 2013

I have a count and store data INTO a table named USTATE

When I run the query it works within 30 seconds. but when i add INTO USTATE then it takes 4-8 minutes to complete it and asks for if i want to delete the existing.

View 1 Replies View Related

Forms :: Update And Save Button Code Is Getting Error

Aug 24, 2014

Quote:

Private Sub Save_Click()
If IsNull(cboEmpName) Then
MsgBox "Please Select Employee Name"
Me.cboEmpName.SetFocus
End If
If Me.txtNoofDaysWorked.Value = "0" Then
MsgBox "Please Enter No of Worked Days"

[code].....

View 1 Replies View Related

Forms :: Database Update From Forms By User

Apr 8, 2013

Is there a way of allowing user to reference/update from either databases ? If user enters an item code and it is not found in database A, can the program direct it to retrieve/update from/to database B ? Assuming database A and B are item databases with different contents.

View 1 Replies View Related

Forms :: Label On Form Will Not Update As The Code Runs In The Background

Mar 17, 2014

I have a userform that pops up when I am implementing a VBA subroutine. The nature of the form is simply to update the user what progress through the operation the code is using a label called lblProgressText.

So, I have a form called frmProgress and in my loop I use:

Code:
DoEvents
Form_frmProgress.lblProgressText.Caption = Format(rsLongItems.PercentPosition / 100, "0.00%") & " - Long items"
Form_frmProgress.pbProgressBar = rsLongItems.PercentPosition
Form_frmProgress.Requery
Form_frmProgress.Refresh
Form_frmProgress.Repaint

I know I don't need the .requery, .repaint and .refresh lines but I put in there just to check it wasn't that causing the issue.

When my code runs, the form is opened using:

Code:
Form_frmProgress.Modal = False
DoCmd.OpenForm Form_frmProgress.Name, acNormal, , , , acWindowNormal

The form Popup property is set to Yes.

The lblProgressText control just wont update (but earlier today it was so maybe I have broken something).Btw, all this code is run from a Module, not in the form object.

View 3 Replies View Related

Forms :: Save User Name That Update Record For Multiple Yes / No Box

Sep 6, 2014

I am creating a form that has a bunch of yes/no box for daily task. Is there a way for access to record which user selects yes/no.

For example

yes/no box1 - user 1 completed this task
yes/no box2 - user 2 completed this task
and so on

So when i look back i can see which user complete which task. I did a bit of research and saw that i can save a user that update a record. But since this is a daily task, each new record will be a new day.

View 3 Replies View Related

Forms :: Create Form To Update Multiple Tables At Once

Jan 9, 2015

I'm working to create a staffing database that houses changes to staffing week over week.

I have one primary table, the "empMaster" table, that stores the employee's name, contact information, etc. I have other individual tables for noting which employee reports to which manager, what their business title is, what group they're in, their training history, etc.

Once I've populated the empMaster table with employee information, I want a form that allows me to update each of the other tables IF there as a change. Some weeks will have a manager change, some only a business title change, some a group change, some a training change, some all of the above. The problem I run into is that I will sometimes process hundreds of changes a week, sometimes only 10-20 so I almost have to use datasheet view for mass edits. I'm relatively new to Access and I'm having a hard time getting my form to allow this level of flexibility and to update all fields needed.

When I build a form that includes more than two tables (let's say I want to update a Manager and a Business Title), the form will not work and populates nothing. I believe it's because Access wants there to be an existing record to match to across all three tables and there will not always be.

View 4 Replies View Related







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