If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Quick question
I'm working on a database that stores a series of company audits that are
done every year. I was handed a database that was supposed to be near completion (only a simple error or two) and I was asked to complete it. I'm relatively new to Access (used it before in college but it's been a couple of years now), and my question might be rather vague. I've made sure that all of my information is correct, there are 3 tables and all keys are clearly defined, correct, and relationships have been formed between the 3 tables. I've gone over this database with two other associates who have more experience than I do. We all agree that the database looks fine and should work. However, whenever we start up the database it allows us to enter in the name of the person who is doing the audit (which puts that person's name on all audits they enter. But just after that point, the Access freezes. I have no idea why and I was wondering if there might be some common bugs or certain areas one should typically look first to find a solution. Any suggestions would be VERY much appreciated. Thank you all very much |
#2
|
|||
|
|||
Quick question
First, what version of Access was the original database written it?
Are you using the same version or a newer one? If it was written in an older version, have you converted it? If that is not the problem, open the form you are using to enter the person's name and see if there is any VBA code associated with the form and specifically with the control where you enter the name. I would first look to see if there is a before update or after update event for the control. If so, put a break point on the first line of code, swith to form view, enter the name and trace the code until it fails. See what happens and post back. "One confused underwriter" wrote: I'm working on a database that stores a series of company audits that are done every year. I was handed a database that was supposed to be near completion (only a simple error or two) and I was asked to complete it. I'm relatively new to Access (used it before in college but it's been a couple of years now), and my question might be rather vague. I've made sure that all of my information is correct, there are 3 tables and all keys are clearly defined, correct, and relationships have been formed between the 3 tables. I've gone over this database with two other associates who have more experience than I do. We all agree that the database looks fine and should work. However, whenever we start up the database it allows us to enter in the name of the person who is doing the audit (which puts that person's name on all audits they enter. But just after that point, the Access freezes. I have no idea why and I was wondering if there might be some common bugs or certain areas one should typically look first to find a solution. Any suggestions would be VERY much appreciated. Thank you all very much |
#3
|
|||
|
|||
Quick question
|
#5
|
|||
|
|||
Quick question
That's pretty much where I'm at right now. The last consultant was fired and
I'm picking up the slack, and learning all about Access along the way. Not a bad way to do so if I may say myself. When I open the program, there's a drop-down menu that allows you to chose a reviewers name. I select the name, hit ok, and it closes the form, and freezes. I'm entering data into a form, but can't even get to that point. It looks painfully simple and neatly laid out, the next problem lies therein. The database is on a server on the other side of the country. Therefore, there may be a problem with memory that is causing the crash, it's my job to make sure there are no other possible problems before a memory issues is addressed. Thank you to both of you who posted, I'm looking over the possible errors suggested by you right now. I'll post again if this fixes my problem. Jim Francis "Klatuu" wrote: LOL, Did one of those a few years back. "It is Almost Done, it just has a few errors to clean up, but we had to fire our previous consultant" One year and $75,000 later, it worked. I knew it was going to be good when they said they fired the other guy "John Vinson" wrote: On Wed, 19 Apr 2006 12:33:01 -0700, One confused underwriter One confused wrote: I'm working on a database that stores a series of company audits that are done every year. I was handed a database that was supposed to be near completion (only a simple error or two) and I was asked to complete it. owwww.... I hate to tell you how many times I've heard THAT line. The only good thing about it from my perspective is that (as a consultant) it usually means "Billable Hours" - *lots* of them, typically. I'm relatively new to Access (used it before in college but it's been a couple of years now), and my question might be rather vague. I've made sure that all of my information is correct, there are 3 tables and all keys are clearly defined, correct, and relationships have been formed between the 3 tables. That's better than most. I've gone over this database with two other associates who have more experience than I do. We all agree that the database looks fine and should work. However, whenever we start up the database it allows us to enter in the name of the person who is doing the audit (which puts that person's name on all audits they enter. But just after that point, the Access freezes. I have no idea why and I was wondering if there might be some common bugs or certain areas one should typically look first to find a solution. Any suggestions would be VERY much appreciated. Please post a bit more information. Are you entering this data on a Form (good) or directly into tables (not the best idea)? WHere are you entering the name? Do you get any error messages? What "freezes" - do you need to Ctrl-Alt-Del and shut down Access, or what? John W. Vinson[MVP] |
#6
|
|||
|
|||
Quick question
Also, I am using Access 2003. There's no need for me to convert. So I'm all
set on that front. "Klatuu" wrote: First, what version of Access was the original database written it? Are you using the same version or a newer one? If it was written in an older version, have you converted it? If that is not the problem, open the form you are using to enter the person's name and see if there is any VBA code associated with the form and specifically with the control where you enter the name. I would first look to see if there is a before update or after update event for the control. If so, put a break point on the first line of code, swith to form view, enter the name and trace the code until it fails. See what happens and post back. "One confused underwriter" wrote: I'm working on a database that stores a series of company audits that are done every year. I was handed a database that was supposed to be near completion (only a simple error or two) and I was asked to complete it. I'm relatively new to Access (used it before in college but it's been a couple of years now), and my question might be rather vague. I've made sure that all of my information is correct, there are 3 tables and all keys are clearly defined, correct, and relationships have been formed between the 3 tables. I've gone over this database with two other associates who have more experience than I do. We all agree that the database looks fine and should work. However, whenever we start up the database it allows us to enter in the name of the person who is doing the audit (which puts that person's name on all audits they enter. But just after that point, the Access freezes. I have no idea why and I was wondering if there might be some common bugs or certain areas one should typically look first to find a solution. Any suggestions would be VERY much appreciated. Thank you all very much |
#7
|
|||
|
|||
Quick question
Access locks up after I select the reviewer, and I have to hit ctrl-alt-del
and close access. "John Vinson" wrote: On Wed, 19 Apr 2006 12:33:01 -0700, One confused underwriter One confused wrote: I'm working on a database that stores a series of company audits that are done every year. I was handed a database that was supposed to be near completion (only a simple error or two) and I was asked to complete it. owwww.... I hate to tell you how many times I've heard THAT line. The only good thing about it from my perspective is that (as a consultant) it usually means "Billable Hours" - *lots* of them, typically. I'm relatively new to Access (used it before in college but it's been a couple of years now), and my question might be rather vague. I've made sure that all of my information is correct, there are 3 tables and all keys are clearly defined, correct, and relationships have been formed between the 3 tables. That's better than most. I've gone over this database with two other associates who have more experience than I do. We all agree that the database looks fine and should work. However, whenever we start up the database it allows us to enter in the name of the person who is doing the audit (which puts that person's name on all audits they enter. But just after that point, the Access freezes. I have no idea why and I was wondering if there might be some common bugs or certain areas one should typically look first to find a solution. Any suggestions would be VERY much appreciated. Please post a bit more information. Are you entering this data on a Form (good) or directly into tables (not the best idea)? WHere are you entering the name? Do you get any error messages? What "freezes" - do you need to Ctrl-Alt-Del and shut down Access, or what? John W. Vinson[MVP] |
#8
|
|||
|
|||
Quick question
Update:
I have just got passed the freezing aspect of my issue. Turns out that the code that was bringing in the name of the reviewer was looking in the wrong column of the datasheet, once fixed, it opens. Now I have one more dilemma. We are entering the information into a form that is supposed to have a click even to add the new records to the main table. The delete even works, as does the save (for saving changes), but the adding records does not. Where can I find some basic code that would allow this click event to add the new information to the main table?? Thanks guys Jim "John Vinson" wrote: On Wed, 19 Apr 2006 12:33:01 -0700, One confused underwriter One confused wrote: I'm working on a database that stores a series of company audits that are done every year. I was handed a database that was supposed to be near completion (only a simple error or two) and I was asked to complete it. owwww.... I hate to tell you how many times I've heard THAT line. The only good thing about it from my perspective is that (as a consultant) it usually means "Billable Hours" - *lots* of them, typically. I'm relatively new to Access (used it before in college but it's been a couple of years now), and my question might be rather vague. I've made sure that all of my information is correct, there are 3 tables and all keys are clearly defined, correct, and relationships have been formed between the 3 tables. That's better than most. I've gone over this database with two other associates who have more experience than I do. We all agree that the database looks fine and should work. However, whenever we start up the database it allows us to enter in the name of the person who is doing the audit (which puts that person's name on all audits they enter. But just after that point, the Access freezes. I have no idea why and I was wondering if there might be some common bugs or certain areas one should typically look first to find a solution. Any suggestions would be VERY much appreciated. Please post a bit more information. Are you entering this data on a Form (good) or directly into tables (not the best idea)? WHere are you entering the name? Do you get any error messages? What "freezes" - do you need to Ctrl-Alt-Del and shut down Access, or what? John W. Vinson[MVP] |
#9
|
|||
|
|||
Quick question
Almost forgot, here's what the Add Click event looks like now:
Private Sub cmdAdd_Click() On Error GoTo Err_cmdAdd_Click DoCmd.GoToRecord , , acNewRec **Do you know what's missing? |
#10
|
|||
|
|||
Quick question
Personally, I use ADO to do my database work. While it doesn't take advantage
of Access' automated abilities (gag), it allows me complete control, and I know EXACTLY what's happening... "One confused underwriter" wrote: Almost forgot, here's what the Add Click event looks like now: Private Sub cmdAdd_Click() On Error GoTo Err_cmdAdd_Click DoCmd.GoToRecord , , acNewRec **Do you know what's missing? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Quick Excel formula question before I go on holiday tomorrow! | Pheasant Plucker® | General Discussion | 2 | October 5th, 2005 06:34 PM |
Have a quick question about borders and images help please | joedrifter1 | New Users | 2 | September 9th, 2005 09:41 PM |
Quick Little Formula Question | Naoki | General Discussion | 7 | August 16th, 2004 07:39 PM |
Quick question | General Discussions | 1 | August 5th, 2004 05:14 PM | |
quick question about PivotTables | Dominique Feteau | Worksheet Functions | 1 | June 14th, 2004 09:55 PM |