General :: Pop Up Process Running MsgBox And Close Automatically On Execution
Aug 23, 2013
I have a form that loads when the database is open, and the form has buttons etc. that leads to queries and reports in the database. (Queries open in a form). Since most queries take a while to load, I was wondering if there is a way to Pop up a message box stating "Please Wait, Query is running..." (or something like that), and once the form opens the MsgBox should close automatically. (The user should not have to hit Ok button.)
Most users of this database would have restricted access such that they would not have navigation pane and toolbar visible - hence I want to make it a touch more interactive when a process is running...also if someone is new to access they might not notice that taskbar status and I don't want them thinking the program is stuck etc..
View Replies
ADVERTISEMENT
Jul 1, 2014
I'm on Access 2010
I am using a web browser control on one of my forms The problem is that when I close my application down, after using the form with the wbc, an access process keeps running in the background. More severe: every time I start my app again and close it, another access process is added to the processes that are already running.
View 14 Replies
View Related
Jun 19, 2006
I have a form that runs a timer every 5 minutes. Depending on what I have put in another table it displays a message (or not) to the user with message details. However, if the user has multiple applications running and the Access application is not currently being used by the user (i.e. they may have Word running and have minimised Access) then the msgbox does not appear. So...
When I display the MSGBOX how can I make it override any application running so that the user is always immediatly aware of the message?
Thanks
View 4 Replies
View Related
Apr 4, 2006
hi all,
Is there a way to make message box disappear automatically after few seconds....
Thx,
Jatz
View 2 Replies
View Related
Oct 12, 2006
We are having a problem with mulitple users leaving an Access db open and then I am not able to make new reports, etc. without calling everyone to close their session.
Is there a way to automatically close a db if user has not used in certain amount of time?
Thanks, Noreene
View 5 Replies
View Related
May 3, 2014
In my database i need two process in the database one is SOD(Start of Day) and the 2nd one is EOD (End Of Day). The purpose of these process to run multiple hidden queries in back-end. In both processes there are several queries to run. How i can built this but this is necessary for database. another thing these process execute only once a day. after login i want to run a form that will check that SOD is performed or not if not then SOD (Run SOD) Screen will appear if SOD not perform yet then system ask for SOD Process to run otherwise disable my dashboard items. and 2ndly if EOD not performed last day then system will run normally and not ask for SOD process.
View 4 Replies
View Related
May 19, 2015
I have to write a code in a form so that if nobody is doing any activity for 5 minutes then after 5 minutes automatically press Close button named BtnClose in that form.
View 5 Replies
View Related
Jan 23, 2007
Behind a command button, i have 3 queries being run. 2 of these queries are append queries, copying the specified record into another table (criteria set to ID of the main form) and the other query is to delete the record from the current table once it has been copied. This is then followed by another delete (not query)
When each of these are run, boxes pop up asking if you're sure you want to do it. I was wondering if it would be possibly to bring up my own box to ask if the user is sure they want to continue, and when they click yes, all the questions that the query asks about wanting to do it, are automatically chosen as yes.
I.E there is only one option box, yes and no, and no others appear.
Is this possible, if so, how?
Thanks
Aidy
View 4 Replies
View Related
Jan 14, 2014
I have a form with tab set one tab called "Enter Receipt" and another that houses 2 queries called "Reconcile". My issue is when I open that form, I have an On Current Macro to go to NEW record for my Enter Receipt, but I am getting a delay while the query status bar runs the other queries. I was hoping not to have those ran until i enter the parameters and hit the run button on that "reconcile tab".
Everything else works, i just need the queries to keep from running when i load the form. my queries i moved from EDITED to NO LOCKS thinking the On Current new record may affected them, not change in delay.
View 3 Replies
View Related
Jan 8, 2014
I have a subform with two fields [status] and [process], i am trying to get the backcolor of procces to change to red if the status field contains the text "expired".
I have tried vba. plced on the after update
if me.status = "expired" then
me.process.backcolor = vbred
else me.process backcolor = vbwhite
end if
this
Changes the color of the field [process] but also all process field colors to red even if the status field does not contain "expired".
I think conditional formatting is the way to go but i think i need an expression to complete this.
View 7 Replies
View Related
Aug 18, 2014
I'm not sure if I am biting off more than I can chew. I have a text field in each record in my database (Inherited) The db has nearly 5,000 records. I would like to split the field into records in a seperate table. An Example of the table as is now;
Code:
MemberIDBoats
5882Opossum(78-80) (87-89) Otter(80-84) Opportune(91-93) Turbulent(97-00).
5883Astute Auriga Aeneas Affray Amphion
2407H34 O10 Porpoise Trenchant Tapir.
I want to create a table as follows;
Code:
MemberIDBoatFromTo
5882Oppossum19781980
5882Oppossum19871989
5882Otter 19801984
5882Opportune19911993
5882Turbulent19972000
5883Astute
5883Auriga
5883Aeneas
5883Affray
5883Amphion
Etc.
Is this possible in one hit or do I need to process the records without dates first and then run another process to split those with Dates? I say dates but the field is a text field. About 15-20% of the records contain dates which are always enclosed in parenthesis.
View 14 Replies
View Related
Nov 14, 2012
Is there a way to get a msgbox to show only when the db is open for the first time. So basically what I want is when I push an update it will auto check to see if the db is current if not then it closes an opens the new db. When it opens the new db i want it to display a msg box or form that shows the new updates. Then if they exit an reopen it wont show the option.
View 10 Replies
View Related
Dec 25, 2014
I am using Access 2010.
Under options, current database I have DESELECTED "compact on close"
Still all my databases are compacting on close. How can I prevent Access to compact on close?
Problem is that we work under Citrix and sometimes things happens with Citrix that they have to reboot all the servers.
The databases tries to close and compact and don't get enough time, so I get mdb copies.
Besides I recently had only the compacted database1.mdb while my file Name.accdb was gone, so again the compact was wrong.
View 3 Replies
View Related
Apr 3, 2015
I currently manually run a compact and repair on the backend of a database at work, but was wondering if it might be sensible to set it to compact on close so that (in theory) it is done at least daily and therefore shouldn't take much time?
The back end resides on a network server, which is backed up continuously, so in theory it should be easy enough to roll back to a backup copy should anything untoward happen.
View 6 Replies
View Related
May 30, 2015
I am trying to close a form with a subform.
I enter data in the main form and then the subform.
The main form has a save btn with an on click event which includes at the end of code
If Me.Dirty then
Me.Dirty = false
DoCmd.Close
DoCmd.OpenForm "FormName"
However the Form will only close and open the required form if I remove the two "Dirty" Code lines.
I am obviously trying to ensure that the data is saved on both the main and subforms using the If Me.Dirty......code
View 7 Replies
View Related
Feb 12, 2015
I have this code that I want to close the database when a file is not found:
Option Explicit
Dim boolCountDown As Boolean
Dim intCountDownMinutes As Integer
Private Sub Form_Open(Cancel As Integer)
boolCountDown = False
[Code] ....
A form with this code is opened when the database is loaded. The form refreshes every 10 seconds. When the form refreshes, it searches (is supposed to search) for a file name and if not found, close the database. but if it's found it does nothing. I rename the file when I want the database to close. But the code runs no matter what and closes the database even if the file is in the correct location with the correct name. the file path above is a network drive but it doesn't work no matter when I put the file. I bolded the parts that are supposed to be searched.
View 6 Replies
View Related
Aug 23, 2012
I have Access as front end and SQL Server as back end. The Access application is placed on a common network drive for theusers to access it. The compact on close option is enabled when the access application is closed.
I have a local copy of the access app. When I close the app, it takes ony a few seconds. But when on a network drive, it is taking 2 mins.I just wanted to know if the time taken to close the application on the network drive can be brought down without disabling the compact on close option.
View 1 Replies
View Related
Jul 18, 2013
how to disable the main close button so the user is forced to click the Quit Application button on my main switchboard?
View 8 Replies
View Related
Apr 17, 2013
How would I use the Access 2010 setting, 'Compact on close'?We have a back end on a server and many users with front ends on their computers. So would I set 'Compact on close' on the back end? And then it would compact when the last user logged out?
View 3 Replies
View Related
Oct 31, 2012
How to disable the Minimise, Restore and Close Buttons at the very top right hand corner of the Access application?
I have got buttons on my database to open / close everything so no need for them, even to hide the full Title bar probably be okay.
I am running Access 2007.
View 12 Replies
View Related
Oct 14, 2014
Everytime i want to make some changes to my "Testing" Database , always got somebody using it / opening it...
I am trying to create a button , the function of the button is close "Testing" access database who using it or opening it , Example : 5 users included me in a company , when I click a button , 4 of them will received a notification with close "Testing" database message , can do that ?
View 1 Replies
View Related
Feb 12, 2006
i have created a new utility DB that has only one form..when it opens I set the startup form "Main" and on the OnOpen event of this form I have some code to open another database and close this one...
this means that whenever i open this database, it opens, opens up the other one and this utility DB closes...and i cannot access it coz it always opens and closes automatically...how can I stop it from executing to be able to edit its VB code?!
Thanks, this is driving me mad !
View 2 Replies
View Related
May 23, 2007
Hi Folks,
I am wondering if it is possible to execute a DTS package via Microsoft Access. I have done a bit of research and cannot seem to really find anything that claims this is possible or how to go about to get it to work. I am running SQL Server 2000 which has quite a few DTS packages ... it would be really neat if I could just create a small interface in Access whereby a form has a few buttons on it that can be clicked and the DTS packages can be executed on the server, this way folks won't need to log on to the server and run the DTS packages via SQL Server Enterprise Manager. What would REALLY be awesome would be if values can be passed between SQL and Access but I think if that is possible it would be quite an animal to achieve (I know it is possible via Visual Basic programming but not really worth all the work to create an independent program just to run a DTS package or pass a value). If anyone can provide me with any information or where to look I would appreciate it.
Thanks,
Joe
View 3 Replies
View Related
Jul 3, 2005
Hi everyone,
This is my problem. Almost all the time(90%), I open the main form of my application and a large part of the form is blank(white). If I open it from the Database window it often work well and all the form is visible.
When the bug occur, If I just switch from Access to another application like Internet Explorer and I come agian to Access then all the form is visible.
Is someone ever seen that kind of bug. What that can cause that problem. How can I solve it?
N.B. There is a lot of controls on my form and I guess that bug can be linked with it. Seems like Access is trying to open my form too rapidely.
View 1 Replies
View Related
Jan 3, 2006
I have a query, it joins a local table to a remote table (Oracle Database Table) which makes it slow(ish).
When I am in design mode and i click the "View Datalist" button, which visually shows me the results, the query executes in about 12 seconds.
When I use the "!" Button to physically Execute the Make-Table Query, it takes hours.
What things should i look for that might cause this problem? Where do I need to optimize.
To me it seems rather odd that the query would execute so fast when i view the data than when it physically executes the data.
Same speed problems when i just run the query as a Selection Query as opposed to the Make-Table Query, so it's not an issue of writing to disk/etc.
View 2 Replies
View Related
Mar 14, 2005
Hi,
how can i create a comand button that open a form at predifined date?
example: if current date=2005/14/12(yyyy-dd-mm) then open form "example"
thnks,
Kopas
View 4 Replies
View Related
