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 Complete Forum Thread with Replies
Related Forum Messages:
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 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 !
Linking Make-table Queries /append Queries To A BE Database
Hi, I was wondering if anyone has dealt with linking queries to tables in the back end database. I split my database into a FE and BE database in Access (due to size issues). The tables in the FE Database have been linked to the BE Database. However, I would like to link all the make-table queries and append queries in the FE to the tables in the BE using the option 'Make New table'-> Another database(which will be the location of the BE) My question is -can I do this on multiple queries concurrently without having to go to every single query and manually link it to the BE tables. Thanks! rjoe
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 !
Update Queries Vs Append Queries, Indexes?
This is a very simple problem most likely for the masses, but I am new to access. I have employees who enter will enter information about specific tests on electronics components into separate tables by a form. I know my method is poor, but this is how it works. I got assigned this database at my internship this summer because they ran out of thigns for me to do.....I've never even used access before, so as long as it works, they're happy. I have a form which which writes to a first table with 20 fields. I then have separate update queries which take the data in the first table and put it in all the other tables. Trust me, i know this is pretty much the opposite of the whole point of a relational database, but I am and was limited by time, for the size of the database they want, there was no time to learn about normalization etc etc. Sorry this is wordy, but THE QUESTION is......if they run multiple tests wtih the same information for some of the fields I have fields named "Run#, Unit#, Date" etc, even if there is records wtih the same information, hwo do i get it all to show. Right now, it seems to be rewriting over the same records. If they run 3 tests on unit 10 on August 1st, how do i get it so all those show up. I think its somethign wtih in the table, for the primary keys, changing the Index: No, Yes(Duplicates) Yes(No Duplicates) but I could be way off. Thanks, if the question doesnt make sense i'll try to rephrase it, I apologize I'm running on about 45 min of sleep:confused:
View Replies !
Parameter Queries Vs Parametrized Queries
I have been asked to set up a parameterized query using 4 fields (ID Number, Surname, Christian Name and Treating Dr/s). When I search Microsoft On-line under parameterized queries it gives a tutorial which basically set out a simple query with "prompt" parameters in the Criteria field. When I search under the Access Help it gives me a totally different explanation - ie. setting up a cross-tab query first and then defining parameters. Is this a loose use of terminology or is there indeed a difference. Help please!
View Replies !
Creating A Form To Get Queries, Run Queries...etc
Hi All, I want to create a form with a Command button, when we click on the command button it needs to bring the Query from a particular mdb, the path for this mdb will vary so we should be able to provide the path info, after bringing the query it needs to be run, how do I do this by just clicking couple of Command buttons? Thanks
View Replies !
SQL Queries
Hi i wondered if anyone could help me. Im creating a large database and i have come accross a few problems which trying to create SQL queries. i wondered if anyone was an expert at them they could assist me. Thanks :o
View Replies !
Odd Queries
I have 2 queries with the same source tables, fields and relationships. The only difference between the two queries is that the criteria for one of the fields is - =9, in one and, <>9, in the other. The problem is that in the query with the criteria is =9 the results show the GroupBy totals correctly, i.e. they show each unique main field and the sum of the criteria field in one row, but the other query displays all of the rows that made up the sum and not the sum itself. But the only difference is the criteria...!!!! I copied the bad one from the good one and only altered the criteria. What am I doing wrong here? Any help would be gratefully received... Dave Eyley
View Replies !
Need Help In Queries
Hi, I am a teaching assistant at a local school where I am given the job to monitor the number of photocopy made by staff. I have successfully, I think, written the database using Access for the staff table. It has fields: dept, faculty, employment status (permanent/contract). I use a complex key as one staff can teach in more than one dept. There are also the dept table, faculty table and the photocopy unit table. Each staff is given a certain amount of copying units each month and each is different due class size. This photocopying unit table has fields like user id, financial year, financial month, units claimed as fields. I have made this a subtable in relation to the staff table. Now each dept., well, almost, but definitely each faculty will have a photocopier. Depending on the class size, the copiers are not the same model. So, for the copier, I have model table, copier table and copier reading table. The copier reading table is to record the reading of each copier each month so that the finance dept can tally the maintenance invoice by photocopier company. This table is devised as a subtable within the copier table. The copier table houses the serial number, physical location, Ip address (if it is on the network), MAC address. From this database, I need to creat monthly report of how many photocopying units claimed, per month, by each department; and report of each photocopier readings. I would be most grateful if someone can tell me how to creat queries for each month. I have entered 4 months of reading into the copier reading table. I have tried to write query to give me each month reading but it always return all 4 months' readings. In order words, the query result is a table of 4 of each copier. Your help is greatly appreciated. Copier records: XeroxID,Modeltype,SerialNo,Usagetype,cardreader,bu ilding,floor,room,IP,deptID,FacultyID,MAC,Notes. CopierReading records: XeroxID,Readingtype,FinancialYr,FinancialMonth,BW_ Meter_Copy,BW_Meter_total,Colour_Meter_1,Colour_Me ter_3,Colour_1+2. Modeltype related to Model type table which lists all different models. Usagetype has three choices from a combo box: printer, copier and printercopier. FinacialYr - field is entered by a pre-entered table,e.g. 2004-2005,2005-2006,etc. FinacialMonth - field is entered by a pre-entered table of the twelve calender months. I can write query to pick out the right usage type or model type. But I am not successful in selecting the desired month.
View Replies !
Queries
Hi Fairly new to access and some help required please. I have a database that records all my utility readings. What i want to do is subtract my previous meter reading from my present meter reading and then add the result to a field "units used" in my original table. I can create a query and using the expression, amount: [Present meter day]-[Previous meter day] and this shows me the units used, but how do i make this create another field in the same table?
View Replies !
HELP----With Queries
I am trying to figure out how to calculate the following: I have 2 columns in my table 1. Quantity on Hand 2. Reorder level I only want to see the products that need reorder - how do I do this??? Thxs
View Replies !
Help - AGAIN WITH QUERIES
I have 2 tables 1. Products id Product Number Product category Product Name Supplier Number Quantity On Hand Reorder Level 2. Supplier id Supplier Number Company name I need to do the following ----HOW???? prepare a report that lists each supplier, its products, quantity on hand, and associated reorder levels. The report should be sorted alphabetically by supplier. Within each supplier category, the product should be sorted alphabetically. Thanks
View Replies !
|
TRACKER
