473,326 Members | 2,196 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,326 software developers and data experts.

A97 - Date error in Runtime

I'm hoping someone can help me with the problem.

I have a database where the default value for a date field in a table is
=date()

This works perfectly in my table and on my form. But when I complile the
DB into a 97 Runtime, the date field displays and #error? in the runtime.
But if I open the runtime db on a system with Access 97, there is no error.
I have tried the runtime on mulitple systems (that dont have Access
installed) and I get the same error, and when I try it on multiple systems
that do have Access installed, it works perfectly.

Does anyone have any insight into this matter. Because after 3 days of
trying to get around this, I am stumped!!!

PS. I know how to use code to set the value, but I don't want to. I need it
the way it is for a few reasons.

Thanks
Paul
Nov 13 '05 #1
2 3544
The fact that this shows as #Error suggests a problem with the References on
the machine where the runtime is installed.

What libraries have you referenced under Tools | References (from a code
window)? If you have more than the standard 3 (VBA, Access, and DAO), does
the runtime package install the others? Do you have the licencing
permissions for this to work?

It is quite awkward to work around broken references programmatically, but
this article by michka may help:
http://www.trigeminal.com/usenet/usenet026.asp?1033

Basic info on references:
http://members.iinet.net.au/~allenbrowne/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.

"Paul" <pz****@rogers.com> wrote in message
news:6a********************@rogers.com...
I'm hoping someone can help me with the problem.

I have a database where the default value for a date field in a table is
=date()

This works perfectly in my table and on my form. But when I complile the
DB into a 97 Runtime, the date field displays and #error? in the runtime.
But if I open the runtime db on a system with Access 97, there is no
error. I have tried the runtime on mulitple systems (that dont have Access
installed) and I get the same error, and when I try it on multiple systems
that do have Access installed, it works perfectly.

Does anyone have any insight into this matter. Because after 3 days of
trying to get around this, I am stumped!!!

PS. I know how to use code to set the value, but I don't want to. I need
it the way it is for a few reasons.

Thanks
Paul

Nov 13 '05 #2
Paul wrote:
This works perfectly in my table and on my form. But when I complile the
DB into a 97 Runtime, the date field displays and #error? in the runtime.


I can't help you, but I know of a couple of machines in my organization
that are using an Access runtime application which completely fouls up
the references in A97 so that sone functions and date expressions using
the format funtion fail completely.

I always figured it was something the developer had done which badly
affected the A97 set ups we have.
--
Tim
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #3

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

Similar topics

1
by: Raskolnikow | last post by:
Hi! I have some beginner questions about C++, so please be gentle if the things I ask are trivial. What I want to do is a program that - changes the current (system) date, - calls an...
1
by: Shane | last post by:
I have a problem that I have spent an age on and can't resolve. Basically, I have a table that has a date field. I have created SP's to return values within a given date range. The problem...
0
by: Raj | last post by:
hi, How to pass a Two Date parameter to a report at runtime using VB .NET 1. How do we pass multiple values eg. Startdate, EndDate to crystal reports parameter. 2. I have a report to...
10
by: Jack | last post by:
Hi, I cannot get the date format correctly in dynamic sql statement, after trying various ways of handling it. I need some help with the date format in the following dynamic sql statement. Any...
1
by: MLH | last post by:
In an Access 97 form, I have a textbox control with the following code that runs AfterUpdate... Option Compare Database Option Explicit Private Sub UNIXdate_AfterUpdate() Me!RealDate =...
5
by: Donkey | last post by:
Hello, I want to find out how many digits does each date type have and how many bytes does it occupy in memory, so I wrote a program below: #include <stdio.h> const long double...
5
by: mabond | last post by:
Hi VB.NET 2005 Express edition Microsoft Access 2000 (SP-3) Having trouble writing an "insert into" command for a Microsoft table I'm accessing through oledb. I've tried to follow the same...
3
by: easter | last post by:
I have inherited an ASP site and am new to ASP. Part of the site allows the client to update event information about their centre. When they try to add a new event, the following error occurs: ...
5
by: iwasinnihon | last post by:
I have written the following SQL to take data off of a form and insert it into a table. sql = "INSERT INTO Water Values('" & Me.AccountNumber & "','" & Me.Department & "','" & Me.Delivery &...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.