473,394 Members | 1,701 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Date problem with Access 97

Hi

I have a site using an access 97 application deployed with the runtime
version of access 97 i.e no development environment
on their PC's.

A few days ago their hardware people were on site and "something" was
changed on the PC. The result of the change
is as follows :

Any report that has a text box with the control source set to

=Date()

On the property sheet, no longer displays the date instead #NAME$ is
displayed.

The application has been running for over 2 years (without any problem) and
I can not simulate the problem on another PC.

Can anyone please assist

TIA
Steve
Nov 12 '05 #1
4 1314
There is a fairly good chance that something has messed up the references on
the errant PC.

Reinstalling your runtime may fix the problem. Using RegEdit to re-register
each library should also work.

If you are not familar with using RegEdit to fix references, see:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steve" <st****@ufrmsa1.uniforum.org.za> wrote in message
news:c8**********@ctb-nnrp2.saix.net...

I have a site using an access 97 application deployed with the runtime
version of access 97 i.e no development environment
on their PC's.

A few days ago their hardware people were on site and "something" was
changed on the PC. The result of the change
is as follows :

Any report that has a text box with the control source set to

=Date()

On the property sheet, no longer displays the date instead #NAME$ is
displayed.

The application has been running for over 2 years (without any problem) and I can not simulate the problem on another PC.

Nov 12 '05 #2
Thanks for the response, I have uninstalled and reinstalled the application,
but with no luck

Steve

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...
There is a fairly good chance that something has messed up the references on the errant PC.

Reinstalling your runtime may fix the problem. Using RegEdit to re-register each library should also work.

If you are not familar with using RegEdit to fix references, see:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steve" <st****@ufrmsa1.uniforum.org.za> wrote in message
news:c8**********@ctb-nnrp2.saix.net...

I have a site using an access 97 application deployed with the runtime
version of access 97 i.e no development environment
on their PC's.

A few days ago their hardware people were on site and "something" was
changed on the PC. The result of the change
is as follows :

Any report that has a text box with the control source set to

=Date()

On the property sheet, no longer displays the date instead #NAME$ is
displayed.

The application has been running for over 2 years (without any problem)

and
I can not simulate the problem on another PC.


Nov 12 '05 #3
Which references are you using (Tools | References from code window)?

Can you get your client to locate the files (dll/ocx/whatever) and
reregister them each with RegEdit on the problem machine?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steve" <st****@ufrmsa1.uniforum.org.za> wrote in message
news:c8**********@ctb-nnrp2.saix.net...
Thanks for the response, I have uninstalled and reinstalled the application, but with no luck

Steve

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...
There is a fairly good chance that something has messed up the
references on
the errant PC.

Reinstalling your runtime may fix the problem. Using RegEdit to

re-register
each library should also work.

If you are not familar with using RegEdit to fix references, see:
http://allenbrowne.com/ser-38.html

Nov 12 '05 #4
That is my next step.

Steve
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...
Which references are you using (Tools | References from code window)?

Can you get your client to locate the files (dll/ocx/whatever) and
reregister them each with RegEdit on the problem machine?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steve" <st****@ufrmsa1.uniforum.org.za> wrote in message
news:c8**********@ctb-nnrp2.saix.net...
Thanks for the response, I have uninstalled and reinstalled the

application,
but with no luck

Steve

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...
There is a fairly good chance that something has messed up the

references
on
the errant PC.

Reinstalling your runtime may fix the problem. Using RegEdit to

re-register
each library should also work.

If you are not familar with using RegEdit to fix references, see:
http://allenbrowne.com/ser-38.html


Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Shaiboy_UK | last post by:
Hi all, Hopefully something simple here. I have written a form that takes data from a text box and updates it into an Access database. However, I want to also pass the local user date and...
3
by: Dustin Wilson | last post by:
I have a problem with the following line of code. rstOutput! = FormatDateTime("January 1, 2004", vbLongDate) When I run this on my computer at home it runs without problem but when I run it at...
3
by: captain | last post by:
Below is the sql for data with same date need to extract + or - 5 days data of same date also. How to also get data of + and - days related to same date. SELECT IM.Area, IM.Location,...
12
by: Steve Elliott | last post by:
I have a query set up to gather together data between two specified dates. Shown in the query column as: Between #24/09/2004# And #01/10/2004# Is it possible to enter several different date...
11
by: Miikka Hamalainen | last post by:
Hi All, I'm making library db using SQL. I have date when book has been loaned (Date loaned) and date to return the book (Return date), which is 4 weeks. How can I get current date to show...
5
by: m_t_hill | last post by:
Running MS Access 2000 MS Windows XP Pro This has caused me a lot of hair loss in the last few days so would appreciate any help. I am running code to append/update a local access database...
9
by: Bob Achgill | last post by:
I would like to use the timestamp on files to manage the currency of support files for my VB windows application. In this case I would only put the timestamp of the file in the management database...
3
by: Jim in Arizona | last post by:
I have a gridview that's being populated from an access db query. The problem I'm having is that the date/time fields in access that are populating the gridview are showing both date and time, when...
2
by: hardik | last post by:
hi friends, i am really surprized the way access behaves in date fields i mean it's all ok when you have us time zone or us servers but if you have diffrent timezone like uk then access creates...
10
by: ARC | last post by:
Hello all, General question for back-end database that has numerous date fields where the database will be used in regions that put the month first, and regions that do not. Should I save a...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.