A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Quick question



 
 
Thread Tools Display Modes
  #1  
Old April 19th, 2006, 08:33 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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  
Old April 19th, 2006, 10:33 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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  
Old April 19th, 2006, 10:51 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Quick question

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]
  #4  
Old April 19th, 2006, 10:59 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Quick question

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]

  #5  
Old April 20th, 2006, 04:07 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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  
Old April 20th, 2006, 04:26 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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  
Old April 20th, 2006, 04:38 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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  
Old April 20th, 2006, 05:17 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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  
Old April 20th, 2006, 05:25 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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  
Old April 20th, 2006, 06:09 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.