I'm trying to find out what's the best (or good ways) to open and close a database (*.mdb) in ASP without
worrying about it staying open. The website stops running (page not displayed) after it has been visited several times
I think, or it's happening when I'm creating new scripts I made which crash several times during debugging. Not
sure what's causing it.
Here's how the db connections work. I'm basically using (includes) to do lots of this..
every web page that requires the DB, I do this format...
(includefile: open database)
(includefile: create constants/variables)
(includefile: load functions used)
- the html page, which access functions when needed -
(includefile: close database)
the includefile that holds all the function scripts does not open or close the db at all but only the recordsets
semi-example function
(function)
rs.open "", cn <--- the cn was opened in the database script
- blah = the stuff -
rs.close
(end function)
Is this a good way to work with the database? I'm using access. Yes, i know sql servers are better, but I was told that
since I have only access, I want to minimize the number of connections, so I open the database once during the page
being opened, and close at the end of the page.
Like I say, the problem is, the site works great for a while (no real visitors yet as it's new), but it suddenly says
"page not displayed" after a while. NORMALLY this happens when I'm making new functions/webpages and did the coding
wrong while the database is still open. I'm thinking it's crashing because there were too many errors during the database
being open.
PLEASE HELP!
BTW, is it possible to just run a script that finds ALL the open connections after a crash and close them?
Hello. Is it possible to close all open reports from one button on a form?
The form is a popup that appears if there are no records in a report. When the popup appears, and the user clicks OK, it is running a macro that closes the popup form and then the report. I would like to use this popup form for a number of reports, so obviously the macro cannot be used as it is only for one report.
Folks, i open my relationship window from a form and i after hide its visibility using the code below. DoCmd.RunCommand acCmdRelationships Forms![frmRelations].Visible = False I need to open the hidden form after clicking on the close(x) button of the relationship window. Are there any ideas please.
I need to find a way to close a file (spreadsheet) if it was left open by a user before my scheduled macros need to delete and remake that file to update it. Is there a way to do this in Access? I've been looking for scripts everywhere... Any help is greatly appreciated. Thanks, Rick.
Is there a command line argument to open AND close a db? I am running a schedule task to open a db which has an autoexec macro but I don't want the db to stay open after running the macro. Or is there a close db function in a macro? I see close form but not db.
I was wondering if someone could point me in the direction of how to have a form open to the record it was on when it was closed. I know I've seen how to do this before, but I've spent some time searching and I can't seem to find it again.
Is there a way to run code to see if a query is open? Then if the query is open, program the database to close it and re-run it?
I have a query that is based on a field on my form. It runs fine the first time. However, if the user leaves the query open and goes back to the form, makes a new selection, and clicks the button to open the query, the query doesn't refresh. The user either has to close the query and re-run it or press the Refresh All button. I need a way for the query to refresh automatically if it is open already or not. The only other alternative I can think of is to program the database to close the query and re-open it. I tried using QueryName.Requery and QueryName.Refresh but in both cases, it tells me that an object is required and I don't know what it wants. I also tried setting the query definitions using VB, but the query is apparently too long because no matter what I do, I can't get it on one line and Access doesn't seem to like it if the query takes up two lines.
I am tying to create a cmd btn called "Report" that when clicked opens a form [quick report] in dialog window. I have that done easy enough. But what I want is if that form [quick report] is open, and you click the same button "Report" for it to then close the form.
I am at my Login Screen, I want it to return to the Login Screen if you select "NO" and Close the DB if "YES"
Here is my current code:
Private Sub Form_Close() If MsgBox("Would you like to EXIT the Database?", vbYesNo, "Quiting Database") = vbYes Then Application.Quit Else ??? End If End Sub
I've been here for two months and answered over 400 questions. I'm seeing a pattern here, and I have decided to post the best ways to make sure you are never answered.10) Blood, sweat, and tears are for losers. Spend no time figuring things out on your own.9) Announce almost ceremoniously that you have no VBA experience.8) Fail to use the search functions of this forum.7) Try to put every example you're given into a macro.6) Believe that this is the only source for answers, because Access Help provides nothing. Nothing, I tell you!5) Have us write your homework for you and then complain when you don't understand it.4) Post in German.3) Have a belief that your particular problem is the most important issue ever, and post in every sub-forum possible. Then bump it.2) Be vague, and then be belligerent.1) Have no appreciation for the people that are answering your questions in the first place. I know this sounds cold and mean and otherwise uncaring, but we are here to answer questions, not give you fish, as it were. This is a place to say, "I've done most of the work, but I need help over this hump," not "I have this crazy project/idea and I want you to write it for me." I've written over a dozen example DBs for people, and I know that I know what I'm doing. But, myself along with perhaps the majority of others that answer the majority of the questions, I'm asking on their behalf to please take the time to figure some of this out. If you can't do VBA, you are using 25% maybe of Access. If you can't understand your own DB, then asking us to fix it is a solution, but not a learning opportunity for you. If you can't understand what I'm getting at, it's that so many posts are the same. Again, I'm not trying to be an ass, but if you want to be a decent Access programmer and a programmer in general, then please, take the time to learn it. There are plenty of books (look at the bottom of this forum) and there are plenty of resources. I don't think any of us are teachers by trade, but the best teacher for something like programming is always trial and error. Programming is a language, a passion, a "something you figure out" if you will. If you're spoon-fed the entire time, you don't learn. I will continue to answer as I always do and I apologize if anyone was offended, but jeez, make sure you've tried everything offline before asking for help. And don't forget to search first, both here and Google.Sorry for the long read. :)
Hello, I was hoping someone can help me how to put the following statement in right format. I have 4 fields idResult, QuestionNumber, Description and Result.
So If Question Number and Description have same idResult then Result is (results are defined in the table) there are 30 combinations.
I have set it up and now need to create an invoice section. An invoice needs to be issued every month and is worked out on a percentage of works complete. For example in one job there may be 10 items of work and for 8 of these iems 25% of the work is complete and the other 2 no work has started. Therefore my invoice needs to be able to calculate 25% of the value of the 8 items and work out a total price to be invoiced. Each time an invoice is created I need to be able to store the invoice value and the percent value of each item complete. Does any one have any ideas as to a good way of doing this. That is if you can undersatnd what I am asking for. Thanks for any help.
It is now possible that some of the products can also be a product group, and a product group would then consist of multiple products. (Note: if a product is a product group as well, both of them have the same names. therefore for consistency, if in future someone alters the product name, that should be reflected for the product group if that product happens to be a product group as well)
So, I started of by thinking that the products table should contain a binary filed like "Is_this_a_ProductGroup", where for any product that is also a product group, while creating or editing the product the user would flag this field "Yes" and "No" otherwise.
S, my revised products table is like:
PRODUCT ======== Prod_id Prod_name Is_it_a_ProductGroup Dept Type :
Based on some earlier suggestions in this forum, I tried to create a junction table like
and joined the Prod_id above to the Prod_idin PRODUCT table and created a copy of the PRODUCT table and joined the Prod_Group_id to Prod_id in the PRODUCT_Copy table.
I would like some help now on:
1. whether this design is really correct?
2. If so, how does one go about the process of data entry through forms for these tables?
I am currently building a db that will handle information on many events around the world. What I would like to do is set a check box that when people scroll through the different records they could check it and it (the current record they are viewing) will go into a compiled list wherein the iindividual record details of that list which the user created by their choices could be exported to an excell sheet (to automate a reporting need in the job) I have seen functions like this in large websites particularly the classified job sections in the seattle Times . where as you scroll through you see something you like you mark it continue scrolling mark another and then when you are all done you go to a page that has all and only your selections.
Can anyone tell me where to start on this one what am I Looking for Etc. This will be the next big step in this my first database. All help greatly appreciated
i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.
I've a custom menu bar from which I can choose any of my forms. However when you choose a new form the old form stays open, sloppy in my mind. Is there any way i can choose the new form from the menu bar & close the previous form? I've tried to close on deactivate, w/ no luck.
I have a report based on a query that has data for many dates. At the moment I have put a specific date in the criteria of the query so that I could build the report format. So it now displays all the data for the date i have in the criteria section. I will need to run this report several times per week so the specified date (and corresponding data in the report) will need to be changed to a new date when I open the report i.e. when I open my report I want to show data in the report only for a specified date.
Can I create a date parameter box open up when I open the report? Can I create a form with a button that when I click will open the report displaying data for that date? What would be the best way?I also need to display the specified date on the report.
:mad: I could really use some help here! Apparently, completing a mail merge automation process is much more complicated than I originally thought. I have it doing absolutly everything I need it to do (open merge document, merge data, print, and close all in the background) but I am missing one critical but probably simple step. I want to merge just the CURRENT record only, not the entire database. I've read all 500+ posts concerning merging, but I'm still lost.
-how do I specify just the current record's information? -do I need to create bookmarks, and how do I do this? -how do I properly use the WHERE statement?
This may be the last thing I need to do with my database, if I can get it working right. Currently, it's trying to print all 883 records and takes about 10 minutes to run the command (probably because it's trying to pull all of the records instead of just one.) I will post my code, if you like. I know this is simple, but I can't work it out on my own. Please help me!
If I start access and try to create a new database or view any database after a second or so this dialog box saying access needs to close appears. It has only happened after I closed the program and it asked if i wanted to save the current dbase. If I view the offending database (by copying it via a pen drive) on my other computer every thing works perfectly! I have tried the "repair program", same result. I have reinstalled the program, same result. I have totally uninstalled Office XP professional and reinstalled it SAME RESULT! As I am not a programmer I am at a loss!
I am using code in Access to run a merge in Word. I'll call the database containing the function (MergeWord) that runs the merge Database1. The table used in the merge is in a different database. I'll call the database that contains the table Database2. When the merge is run, another instance of Access is automatically opened with Database2 open. How do I close the second instance of Access (Database2)?
Here's my code so far: Function MergeWord() Dim ObjWord As Word.Document Set ObjWord = GetObject("H:SHAREDFORMSTest.doc", "Word.document") ObjWord.Application.Visible = True ObjWord.MailMerge.OpenDataSource NAME:="H:AccessDatabase2.mdb", Linktosource:=True, Connection:="TABLE NewFileExport" ObjWord.MailMerge.Destination = wdSendToNewDocument ObjWord.MailMerge.Execute ObjWord.Application.NormalTemplate.Saved = True ObjWord.Activate ObjWord.Close False
We have a couple Access 2000 database's that are updated from Oracle data each night. There is a routine that opens Access, updates, then closes. However, on numerous occations, when it closes, the ldb file is still there. I can not delete the file without rebooting the server which I do not want to do every day.
Also, I noticed that the ldb file date is changed when I exit Access not when the db is opened. I thought the opposite was suppose to happen.
i have close button on my form made thru the command button. But it does not show an error message when the form closes if information has not been entered in the reqired fields. it does not save the field though. how can i get the error messages to be shown before the form closes asking the suer to enter the missing data. thanks
When the user clicks to close the form the Before Update event runs, and has the following code to check that all the required fields are completed:
If IsNull(Me.ToxReceived) Then stdresponse = (MsgBox("You must enter the toxicology received date before continuing." & Chr(13) & Chr(10) & Chr(13) & Chr(10) & _ "Do you want to do that now? Click YES to return to complete the form, click NO to undo the record", vbYesNo, "Missing Data"))
If stdresponse = vbYes Then Me.ToxReceived.SetFocus
Else Cancel = True Me.Undo Exit Sub End If End If
If the user clicks no, and the record is undone, how do I get the close form event to still continue?