Sunday am 9 am - 1 pm

  • Thread starter Thread starter Judge Rein
  • Start date Start date
J

Judge Rein

Am I permitted to employ someone answering this email.
I do need help and am more than willing to pay for your
time if that is permitted. Can do it Sunday 9 am -- 1
pm Eastern time.

407 - 333 4444
I will call you back so we will be on my phone time.

Here is the problem:

Would like to be talked through it by an Access guru.
I am fairly computer literate and will follow instructions
fast.


Access 2002 on desktop and notebook.
Same files on both computers
One has an error with a specific form while the other does
not. When copying file from computer which does fine to
the other, error reappears.
When copying file from computer with error to other, error
diappears.

Even reinstalled Access and of no help.

Problem: Simple form, simple table, -- about as easy
as basic as can be.

On form, Four(4)items are sums of various fields on the
form. On ONE computer and not on the other, the results
are "#Name$

Strange: When copying from working form on computer to
problem computer, the error appears as stated above.

Copying the same file back, the error disappears.
 
Judge,

There are no restrictions on employing people that volunteer their time
here, so long as they are willing to do so. You will find that many will
ask you to keep things here in the newsgroups so that all may benefit.

Two of the top Access people (Steele and Vinson) on these newsgroups both
came up with the same response for you. Unfortunately it didn't appear to
work. Give them a chance to think through another resolution...

And you've got mail....:-)

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm



Judge Rein said:
Am I permitted to employ someone answering this email.
I do need help and am more than willing to pay for your
time if that is permitted. Can do it Sunday 9 am -- 1
pm Eastern time.

407 - 333 4444
I will call you back so we will be on my phone time.

Here is the problem:

Would like to be talked through it by an Access guru.
I am fairly computer literate and will follow instructions
fast.


Access 2002 on desktop and notebook.
Same files on both computers
One has an error with a specific form while the other does
not. When copying file from computer which does fine to
the other, error reappears.
When copying file from computer with error to other, error
diappears.

Even reinstalled Access and of no help.

Problem: Simple form, simple table, -- about as easy
as basic as can be.

On form, Four(4)items are sums of various fields on the
form. On ONE computer and not on the other, the results
are "#Name$

Strange: When copying from working form on computer to
problem computer, the error appears as stated above.

Copying the same file back, the error disappears.
Other files also having "total" fields work well normally
on both computers.

All fileds on both computer obviously identical.

The formula with the problem is:
=nulltozero([amt1])+nulltozero([amt2])+nulltozero([amt3])
+nulltozero([amt4])+nulltozero([amt5])+nulltozero([amt6])
+nulltozero([amt7])

Please respond only to my email not to web site.
Thank you.

(e-mail address removed)
Click to expand...
Click to expand...
 
Have you tried re-compiling the database on the machine where the error
appears. Open the database by holding down the shift key; this will by pass
any startup operations. Enter into the VB Editior (code) window and select
compile. If any errors appear check under Tools | References and look for
any missing references. Locate the missing reference; it may be down below
or you may have to look under Windows/System or Windows/System32 to find the
missing file.

Problems with databases usually occur when moving from one computer to
another and one of the machines do not have or use the same references as
the other computer.


It may also be a need to download the latest MDAC for the machine with the
error.
Judge Rein said:
Am I permitted to employ someone answering this email.
I do need help and am more than willing to pay for your
time if that is permitted. Can do it Sunday 9 am -- 1
pm Eastern time.

407 - 333 4444
I will call you back so we will be on my phone time.

Here is the problem:

Would like to be talked through it by an Access guru.
I am fairly computer literate and will follow instructions
fast.


Access 2002 on desktop and notebook.
Same files on both computers
One has an error with a specific form while the other does
not. When copying file from computer which does fine to
the other, error reappears.
When copying file from computer with error to other, error
diappears.

Even reinstalled Access and of no help.

Problem: Simple form, simple table, -- about as easy
as basic as can be.

On form, Four(4)items are sums of various fields on the
form. On ONE computer and not on the other, the results
are "#Name$

Strange: When copying from working form on computer to
problem computer, the error appears as stated above.

Copying the same file back, the error disappears.
Other files also having "total" fields work well normally
on both computers.

All fileds on both computer obviously identical.

The formula with the problem is:
=nulltozero([amt1])+nulltozero([amt2])+nulltozero([amt3])
+nulltozero([amt4])+nulltozero([amt5])+nulltozero([amt6])
+nulltozero([amt7])

Please respond only to my email not to web site.
Thank you.

(e-mail address removed)
Click to expand...
Click to expand...
 
Solved.
Problem was corrupt confuguration file which
required "complete" uninstall including removing
all "ACCESS" entries from registry and reinstalling.

Thanks to all interested


-----Original Message-----
Am I permitted to employ someone answering this email.
I do need help and am more than willing to pay for your
time if that is permitted. Can do it Sunday 9 am -- 1
pm Eastern time.

407 - 333 4444
I will call you back so we will be on my phone time.

Here is the problem:

Would like to be talked through it by an Access guru.
I am fairly computer literate and will follow instructions
fast.


Access 2002 on desktop and notebook.
Same files on both computers
One has an error with a specific form while the other does
not. When copying file from computer which does fine to
the other, error reappears.
When copying file from computer with error to other, error
diappears.

Even reinstalled Access and of no help.

Problem: Simple form, simple table, -- about as easy
as basic as can be.

On form, Four(4)items are sums of various fields on the
form. On ONE computer and not on the other, the results
are "#Name$

Strange: When copying from working form on computer to
problem computer, the error appears as stated above.

Copying the same file back, the error disappears.
Other files also having "total" fields work well normally
on both computers.

All fileds on both computer obviously identical.

The formula with the problem is:
=nulltozero([amt1])+nulltozero([amt2])+nulltozero ([amt3])
+nulltozero([amt4])+nulltozero([amt5])+nulltozero ([amt6])
+nulltozero([amt7])

Please respond only to my email not to web site.
Thank you.

(e-mail address removed)
Click to expand...

.
Click to expand...
 
Back
Top