Is there a way to automatically shut down Access after a given amount of time?
I have an Access application that runs across a network. Access is the front end of a SQL Server 2000 database.
Some of the users forget to close their application at night when they leave for the day. When I come in in the mornings, I like to run the Compact and Repair, but can't because someone is still logged in. So then I have to go to each and every computer to see if they are still logged in. By the time I vist each computer, the morning is almost started and people ARE logging in for the day.
So I'm hoping to find an application that will automatically either log each computer off across the network, or that will log the application off of each individual computer after a given amount of inactivity.
The MS Access 2000 application I have developed for my remote client, when deployed, occasionally shutsdown with no error message and no clue as to why.
There is no common pattern that I can establish. Compact and Repair makes no difference. Have tried re-writing objects that I suspect may cause this. I have tried creating new front end and back ends and re-importing all the objects. Have tried programatically deleting and replacing all queries. Have tried converting to Access 2003 and back again.
Is there any third party trace tool that I could use, or expertise that I could engage?
My London based client is losing patience and I am staring down the barrel of 4 weeks worth of work going unpaid.
Does anyone know if it is possible to create a macro (or whether there is another function) so that a database will automatically close after a period of inactivity.
There is only one form that users will see (or use) but if this form remains inactive for say 20-minutes the program shuts itself down.
My initial thought was to use Form>On Timer facility but I would need to be reset the timer after every update. This seems particularly longwinded and I'm not 100% sure it would work.
I've searched the forum for a sample code on how to automatically shutdown database at a given time of the day, but i can't find any. There are lots of codes pertaining to inactivity / idle users but none on scheduled time.
My idea is to kick-off all users every 12:00nn, Monday to Saturday and then compact / backup database after.
I recently got a corrupt backend with the standard "unexpectedly quit Microsoft Access" message. This type of corruption (backend) has never happened before so I'm a little worried. I think I've taken the standard preventitive steps, but I'm hoping I can do more.
I guess I have two questions but my main one is, what's the most graceful/ideal way to close an Access database as to reduce chances of corruption?
My other question is, does the size of the database have any bearing on it's corruptibility?
I am still learning access and have been helped alot by this forrum so I thought someone may be able to help me here. I am trying to experiment with security from a few different angles, privileges to folder, to database, inactivity shutdown, ect. I know that my office shuts down at 1630 hrs every day and noone comes back in till 0730 the next morning. Is it possible to ether load a script/macro on start up that will query the time every so often, and if the time is between 1700 - 0700, automatically close the program? If so could the inactivity timer sample supplied by petersoft be modified to accomplish this? If not possible, could a conditional statement be loaded on start and at a set interval after that to do something like (iif (time())<1,docmd.quit,"").
I download the database from this thread http://www.access-programmers.co.uk/forums/showthread.php?t=103278 and I copy the table, form, macro and module to my database but and error is appearing showing that missing shutdownform.
Is there a way to shutdown an particular db when multiple users are logged on from my pc? i.e. - When I need to get into design mode and can't because of other user's being logged on.
Or at least be able to send them a friendly message from within access to ask them to get out?
I have a table/form that has name, a specific date, and an email address. I would like that when the specified date matches the current date, it will automatically send an email to the address specified with a pre-built message. Is this possible? If so, how?
Hi all, We have a database here at work where we keep records of client marketing campaign materials, which lets us know when said materials have gone to print and such. The problem is that we've always had to type in the client info manually because none of us can seem to find a way to automatically update new client info in sequential order. We have to keep a list of the clients as well as the alphabetical code they've been assigned to, which has become very problematic, since everyone is not on the same page. I'll show you what I mean - below is an example of client names and the codes they've been assigned to:
(Existing client)Cleary - AFB
(New client) Greenville - AFC
(New client) UAW-DC - AFD
And so on....
If anyone could help me with this, I'd greatly appreciate it. Thanks for listening.
Hi, I am creating a table in 07 and I want my table to be able to calculate the difference between two amounts. I have the column "price" which shows the total amount, another one called "money paid" which shows how much of the total amount they have paid so far and the third is "money owed" which is the difference that i want to be calculated automatically. Do you know any way to do this??
I have an excel sheets with tables (Numbers). I have inserted this excel files into PPT. I have a button on my page. I have linked the PPT path to that buttom (using hyperlink). So, when I click the button the PPT which contains the excel charts is opening (this is good so far)The data in excel sheet is used by many people and they can change it.
When in Access the ppt is opened then it's showing the old data but not the new modified data. (We are right clicking on the ppt table and then updating the links)We just don't want to do that as we have lot of tables in PPT.when we open a ppt via access then it should automatically update itself in the backend and should open with the new values.
I have a table in Access with a field End Date with couple of other fields like Company Name and Description associated with the End Date as one record. In other words, one record has fields Company Name, Description and End Date.how could I get Access trigger an email automatically to a set of people let's say a month before the End Date is approaching. If the End Date is 30/4/2015, I would need Access to be triggering an email to the recipients on 30/3/2015.
I am working on an attendance file. I have created one MS access form and one excel sheet. On MS Access sheet I have Student ID, Date and Value. ON excel sheet I have Course, Student ID, NSN No and date.
I want data to be automatically appear on excel sheet from ms access form and after updating it or after transferring data i want these fields again empty and ready for next entry.
For example, If I type value .5 in ms access under 01-Jan-2014 for Student ID 1200001, value .5 should automatically appear in cell in ms excel sheet infront of same id (1200001) and under same date (01-jan-2014).
I need to import 15 csv files into access every month. I have location of all those files listed in a table in the same access DB but i'm not sure how to incorporate them in a macro I have written to import one of those files:
Function Macro_TransferCsvFileTo_RatesTradeData() On Error GoTo Macro_TransferCsvFileTo_RatesData_Err DoCmd.TransferText acImportDelim, "Import_Spec_tbl_RatesData", "tbl_RatesData", "c:Documents and SettingsaggauraDesktopWIPXMLDB_JOH_FI_2011123 0.csv", True, ""
[Code] ....
where c:Documents and SettingsaggauraDesktopWIPXMLDB_JOH_FI_2011123 0.csv is the file name I want to be replaced by each of the file listed by me in the other access table.
I created a Tracking System and would like to send an automatic reminder to the person the ticket has been assigned to, using the due date and the text message in the field "reminder message". Once the message send, I want the database to recognize and not send it again. I want the database to send a new message if the due date has changed.
I'm trying to use Access to send an automatic email reply upon receiving a request from a customer/employee, telling them that their request has been received and this is the tracking number and the due date of service completion. How can I do that? And I want it using Outlook because all the contacts are saved in Outlook and all emails sent and received through Outlook. And the version is Access 2010.
When I import a column from Excel into a new table in Access using the Docmd.transferspreadsheet function, Access automatically assigns a field name of "F1"; and if I try to import a range of columns (Eg A1:B10), then Access saves them into a table with 2 columns with field names "F1" and "F2". The table is created as part of the Docmd function, and so I don't have control over the field names.
Is this going to always be the case? Can I depend on Access to always use this naming convention? Because I am about to start writing more code that will depend on these field names.
I am in the process of development of a database and one of the functionality that I would like to achieve is a custom ID to become automatic on my 'ADD-CUSTOMER' form (e.g. CID0001 - CID0002) so on an so forth. From my research all I can see in access 2010 is a autonumber which cannot be altered (or at least i don't know how).
I am tying to create a setup application in access. The setup forms are incorporated in the database application.It has to split my database into a FE and BE so that the corresponding files can be placed in thier corresponding files folders automatically. Iam doing this because the database has to be exported to a number of remote locations every after two weeks.
Apart from using the Database Splitter, Could there be any Ideas on how i can split and link my database through code.
I am using DMax function for my custom autonumber I just realized that when using this in a multi user environment, I am getting duplications. This field is not the primary key, and I am using this as a group ID and cannot set it to “no duplications” My form also has a sub form, and when entering the sub form, the main record gets saved automatically. First I added the following procedure
Private Sub Form_AfterInsert() If IsNull(Me.OrderNo) Then Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1 End If
Private Sub cmdSave_Click() If IsNull(Me.OrderNo) Then Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1 End If
However, I then realized the after insert function will add the new autonumber to the form. However, it will not saved it to the table until the main record is saved again (which may not happen)
“DoCmd.RunCommand acCmdSaveRecord” doesn’t seems to be working after the “Form_AfterInsert”
Now I moved the code to the “Form_BeforeUpdate” (still testing)
Hi there,I know very little about Access but been asked to find out if this is possible:On a database we have a date field for when subscription is due, is there any way that if a DirectDebit method of payment has been chosen, when the date of renewal is, access will automatically update the year to the next one?Thank you very muchCathy
