Access Won't Quit
Hello again folks.
Having spent a week building my database and everything is working as expected - I set the 'startup' properties and now Access won't save or quit from the main form. In order to close I have to select 'form design' and then the 'X' will work. This goes for all the methods of closure including the menu and system buttons. I cannot access the cnt/Alt/Del with this system but that's immeterial. I'm using XP and Access 2000.
I have tried removing all the conditionally formatted controls.
Help please!!
Chalkie.
View Complete Forum Thread with Replies
Related Forum Messages:
Queries That Won’t Quit
Sorry to bug you guys (or Gals) for something as simple as this. I have several subforms and list boxes that references other subforms using queries and when I close the form using DoCmd.Close Some of the queries ask for parameter values. Is there a little snippet that will fix this? Thanks Everyone,
View Replies !
Employee Quit?
I have a form which has a drop down box which links to a table with Employee names. One employee quit and I want to delete her name from the table. But... if I do that, I will delete her entirely from all previous records. Is there a way to keep all previous records, but take her out of the drop down choices?
View Replies !
My Code To Quit The Application Has A Bug!
Hi I have succsefully used the code suggested on theis excellent forum to boot user from the db to repair it. It is FE/BE set up and the ONTIMER on the login form is used to chuck people off over the network. My ug is: I like to give people the waring before I chuck them off, but sometimes when they are using another application with the db running in the background they dont get the message, therefore dont click ok so my Code wont carry on and Quit application when I want it to. The code is trapped in MsgBox "Please finish what your doin, as the db will shut down", vbinformation Is there any way I can make my code bypass this if they user hasnt clicked ok? Many thanks in advance
View Replies !
Update Excel Before Quit....
Hi I'm trying to create a commandbutton that will update a Microsoft query in excel. My problem is that excel is quitting before the workbook is updated. Maybe I need a "wait" command or something... This is what i have: Private Sub cmdASP_Click() Dim XL Dim XLARK Set XL = CreateObject("excel.application") Set XLARK = GetObject("c: est.xls") XL.Visible = True XLARK.Parent.Windows(1).Visible = True XLARK.Activate XLARK.RefreshAll XLARK.Application.Cells(1, 1).Value = Now() XL.ActiveWorkbook.Close Savechanges:=True XL.Quit Set XL = Nothing Set XLARK = Nothing End Sub Can anyone help me out? eroness
View Replies !
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 Replies !
Error When "Quit"
Hello all, I need some help. I have a macro done in the menu macro, not on VB that imports some tables, run querys etc. The last step on the macro is "Quit", when the macro gets there I get the following error: You can't exit Microsoft Office Access now. If you're running a Visual Basic module that is using OLE or DDE, you may need to interrupt the module. Can somebody please help me? Thanks,
View Replies !
Automated Access Launch Causing Access Window To Fail To Hide
Hi, I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my main switchboard to hide the grey Access screen from being visible behind forms, reports, etc in this db. But when I started using a .vbs script file to launch the db, the Access window stopped being hidden. (The reason I use the script for launching is that it temporarily sets the db's security level to 1 which stops the macro security warning from coming up.) Apparently MS knows about this happening and released a technique to rectify the situation, but I don't understand their instructions. It looks like they expect one to have more understanding than I have. Could someone help me get this impliemented? Here is the article: http://support.microsoft.com/kb/167659/en-us Thanks!
View Replies !
Linking Excel Sheet To Access And Adjust Access Table Format.
I would like to use Access as a source for my pivot tables as i am trying to build a pivot table based on 10 different excel sheets. so I performed the following: 1. I linked the excel sheets into Access 2. created a Union Query between the two tables in access 3. created a pivot table in excel based on external data source a. clicked Pivot table wizard b. External data source c. Get data d. Tab: Databases, I clicked on <New Data Source> E. Named the query and selected a driver: "Driver do Microsoft Access (*.mdb) F. Then clicked on "Connect" in navigated to the Access data base then click OK then another OK G. in the tab "Databases" you'll find the new created data source highlighted it and click OK H. pick the Union query in the list and click on ">" then click OK 4. Now i have a pivot table in excel based on access as an external data source. the issue is when the excel sheet linked to access, the column including "No of products" formatted as number in execl in access automatically set to "Double" and it can't be edited as it is linked table. this causing the pivot table to treat as if its not a number so i can get a count but when i use "sum" in the pivot table I get "0" instead of summing the number of products. any ideas how can i fix this?
View Replies !
Using Access's User And Group Accounts Or Using A Login Form To Access Database?
Using Access's User and Group Accounts or Using a Login Form to access database? I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself. I also saw some sites where they give an example of a Login Form and how to create one. My question is do you need to create both. First create the users and groups to permit or deny access to certain forms and then have a login form? But would that mean that they'd have to login twice? Once when the database opens because it activates the db security that was created and then login again in the login form that was created? Also when the user logins in and clicks on the cmd button on the form which opens up another from, frmWorkLog, I have an Employee field. This field I want it to have the user's name entered automatically and "locked". So that info, employee name, is extracted from the user's login. So then the user can only see his or her records only and no one elses. How would I go about creating that. Hope I made my explanation clear. Thanks in advance.
View Replies !
Locking User Access To Database Objects (MS Access 2000 And 2003)
I have two database applications and they are: - the (A) application is for administration use. - the (B) application is for normal users use. the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...). the (B) application I have created for normal users who will have only to use forms to insert some data and display data only. but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data. The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys. I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.
View Replies !
|
TRACKER
