Quit() Won't Work When User Has Certain Windows Open
I'm working on a program that Windows runs as a scheduled program at 5PM every day that closes MS Access so folks can go in do updates on databases. I've managed to get the program to exit- when there aren't any complicated windows open- using the following command:
App1.Quit(Access.AcQuitOption.acQuitSaveNone);
The problem is that when the user leaves the "New" window open (the window that comes up when you click File:New) or the "Open" window open, Access can't shut down. My thinking is that if I can just have the program close these windows, Access can shut down.
So, any suggestions?
Thanks for your help.
View Complete Forum Thread with Replies
Related Forum Messages:
Open With Windows/XP
Hey all I was wondering if there was anyway to open my program when windows opens, I have the XP sytem but I was also wondering if there would be a difference with windows 98... SO What i would like to accomplish is to open my access program without clicking on it when my windows, is loaded, can I open it when it loads automaticly. Does it matter that there are different users on my system or not. Thanks
View Replies !
Inserting Current Windows User Into Field
Hi Guys, my first post hereim making a database for work and need to figure out the followingi have two people that uses a ms access db, each entering data.i made a custom macro in the vb editor:Public Function cUsername() cUsername = Environ("USERNAME")End Functionwhat i want to do now is, everytime a new entry is added in the table, it should add that username to the "user" cell... it should only do this once, so for example, when i enter data it will show "albert" and if i was to close it, login as "steve" it should still show "albert" under the ones i added, and not steve...this needs to be in the table not a query or form...thanks for your timeAG
View Replies !
Open Windows Folder From Access ??
Please forgive my Newbieness and accept I am a keen ametuer running a small business and trying to use access as a tool. No doubt I will be back with many questions as you all seem so knowledgeable, thanks in advance. Can't really do code but get on OK with built in wizards etc. Wonder if someone might be able to help with this one: Is it possible to set a command into a form that opens up a windows folder elsewhere on the computer or network? For example, receive email from DIY multiple containing kitchen plan, installation costing etc, as attachments. File attachments in folder on server, manually enter detail into access database which generates "Customer ID Number", decides which fitter, surveyor etc. then need to email a report (have managed conversion to PDF and to launch outlook) but then wanted to copy and attach the original attachments to this new email, along with Access report for forwarding to various surveyors / fitters around the UK. Thus require if poss to open file on server, copy attachments and paste in new e mail, thought it would save time to do by one button press to open server file?? May seem easier to just forward original e mail but unfortunately some of the info in the mails from the DIY multiples is not for distribution and filtering isn't possible. Perhaps one simply can't do it but worth asking, thanks again. Paul
View Replies !
Can't Open Linked Tables After Upgrade To Windows XP
Hi. I have two databases, both originally created in Access 2000 on a Windows 2000 platform. database A has links to two tables in database B. Both databases are on a shared drive and are accessed daily by 10 concurrent users. Originally these links worked perfectly and it did not matter how many users had each database open the link still worked. Three months ago Access was upgraded to 2003 and still everything worked fine. Last month, however, the OS was upgraded to Windows XP Pro and now we have a problem. If both databases are open at the same time on the same machine the link won't work; it returns a message saying that tha database B is already open and it cannot connect to an already open file. However, if you close database B the link works fine. It doesn't matter if every other user has database B open at the same time the link will still work. Seems to be some sort of local machine file locking conflict brought on by XP. I know XP is much more security conscious than 2000 but both databases are set up as shared and work OK between multiple users. Our IT dept are not interested in supporting Access even though it is the only database that 85% of the workforce have access to. Only the chosen few get Oracle and support. For the rest of us it is "doctor heal thy self" I have already turned down all the security settings to minimumum to get macros to work but that has not helped this problem. Any suggestions welcome.
View Replies !
Button To Open Windows Explorer Window
Hello everybody, it's been a while since i wrote on the forums and yet again I am in the need to ask for the help of this wonderful community. I have a form on which is a button that I want when pressed to open a Windows Explorer window displaying the contents of a directory. The exact way that I want this thing to work is like this : The user is browsing a form of lets say client details and on the form lies the button that when pressed will take the client's name and apply it to the path in order to open that Windows Explorer window and create a path like C:program filesclient name and display the contents of that window. I would like if possible someone who can point me as to how I can construct this button to work cause I cant see to get it done. Many thanks for your time :)
View Replies !
Need User Logins To Work...
I am messing with the user logins and groups. I got it to work on my computer but...It only works on my computer and with every database I open. No other computers get a request for a login and password and the file just opens up. How can I get a nice login for people at our work?
View Replies !
From Work To Home Can't Open Access
Hi, I had copied my MS Access database that I made from work and tried to open it from my home to work. And it said it is only Read_Only. Why is that? Can I change this from my home PC or Can I work with this only from work? Another thing, then I tried to create another database and I could only do this by creating table from design view and entering data. But I was not able to create it using the table wizard. When I click on the table wizard, nothing happens. My work's MS Access is 2000 professional version I think, and my home MS Access is 2000l. Could someone give some advice??? thank you, Carboncopy
View Replies !
Table Exclusively Open By Another User Problem
i have a form that uses a text box to search through my bookings, and when the user double clicks on the record in the listbox it loads that record in my main booking form.. this works fine. the problem is this.. i will search and find a record using the text filter.. i will double click on the record and it loads in the booking form. i then close the booking form, and the search form is still open in the background.. if i then click on another record in the search form, i get this message.. runtime error 3008, the table bookings is already opened exclusively by another user... etc below is the code in my search form, is there anyway it can be edited to make sure this doesnt happen. Option Compare Database Option Explicit Private Sub QuickSearch_DblClick(Cancel As Integer) DoCmd.OpenForm "newBOOKINGS", , , "[bookingid] = " & Me![QuickSearch].Column(0) End Sub Private Sub Search_Change() Dim vSearchString As String vSearchString = Search.Text Search2.Value = vSearchString Me.QuickSearch.Requery End Sub Private Sub QuickSearch_AfterUpdate() DoCmd.Requery Me.RecordsetClone.FindFirst "[bookingid] = '" & Me![QuickSearch] & "'" If Not Me.RecordsetClone.NoMatch Then Me.Bookmark = Me.RecordsetClone.Bookmark Else MsgBox "Could not locate [" & Me![QuickSearch] & "]" End If End Sub
View Replies !
Works On Windows 2000 Not Windows 2003
I have a website that is asp (not .net) based with an Access DB and I am in the process of replacing an old windows 2000 server with a much faster windows 2003 server. Here lies the problem I have a script as part of the admin that exports data to a csv file. The query joins 4 tables together to get the data needed for the export. On the windows 2000 server it takes 1-5 seconds to execute and have the csv file ready for download. On the window 2003 server it times out. I striped it down to use 2 joins and it worked although it took more like 10-20 seconds to export. This exports a specific range of ID's and the range is normally only 40-50 rows. If I put time stamps in the code the problem is in the query of the database, so I know its not in the file write etc. I am going to rewrite it to use multible querys instead of one large query, but I have many other sites that I am moving to this server that would work better if I can figure out why it is so slow. The windows 2000 is a 900 mhz server the windows 2003 is a 2.8GHZ server both have 1 GIG of ram. The database file is on the local drive on both servers. I am guessing it is a difference in the Jet version, I just haven't been able to find a solution to the problem. This uses a DSN connection, configured the same on both servers. I have also tried it as a DSN-less connection with the same result. I have installed access on the server and to execute the command in access it is <2 sec. I am not an access expert I normally program in .net and php and use MySQL and MsSQL for databases, we just have these legacy sites that use Access DB's
View Replies !
User Database From Command To Open Word Document
In access database, Is there anyone know how use macro to open a word document on a share drive..(example S:safetyRegulation.doc)?. Here is what I did and it doesn't work.. Runapp command line: C:Program FilesMicrosoftOfficeOfficeWINWORD.EXE //S:safetyRegulation.doc. Is there any easier way to do this? Please advice..thanks Rob..
View Replies !
Access And Windows 98 To Windows 2000
Hi All, This is my problem - My customer has Access programs that work on their Windows 98 OS PC's, but when they try to use them on Windows 2000 OS PC's they will not work. The programs I believe were originally written in Access 97 and now they have Access 2000 on the PC's. By not working I mean the following - The Access program allows them to enter a document name and then the file opens in Word - BUT - when they use it in Windows 2000 it does not open the document at all. It says file not found in Windows 2000 and the file does exist. ** The reason they have Access opening files is that Access keeps track of them for auditing purposes. Now here is something that I want to mention. On PC's that were upgraded from Windows 98 to Windows 2000 the programs work. Can anyone here tell me what is missing from 98 to 2000 that would do this. Thank you very much for your time.
View Replies !
|
TRACKER
