Search results for query: *

Hi Dave, Thank you for the reply. I tried your formular, the results in Age field are "36864, 36636", I was wondering where are thoes numbers came from, I found out the Access 2.0 took the 6/25/00 as 6/25/1900. Now I am in trouble, I don't know if there is a possible to have Access 2.0...

Hi Georgews, Thank you for the reply. I tried the formular your provided, it gave me "36863, 36635" in Age(after query, there are only two records), the date for [Date Product/Form received] are "6/25/00, 2/8/01", so i don't know where these numbers came from, Do you know...

In my 2.0 Access database, there is an Aging Query, in this query, there is a formula like this, Age:CInt(Now()-[Date Product/Form Received]), [Date Product/Form Received] is a field name, it contains Null value, when I run the query, the "Age" field has all "#Error" value. I...

Hi, I just converted an Access database from 2.0 to 97, There is a problem I don't know how to solve, need somebody help me. I have a function like this: Function MergeModifyWord(FileName As String, ClaimNumber As String, LetterCode As String) On Error GoTo MergeModifyWord_Err Dim Channel As...

I tried, I already converted to 97, but the most of functions in 97 don't work, I changed user to user32 in Declare, I compiled all modules, changed some dim statements, like changed Dim tbl as Table to Dim tbl As recordset, Dim Dys as Dyneset to dim Dys as Recordset etc... but the system still...

I have an Access Database which is written in Access 2.0, it contains many functions, procedures and windows API Utilities etc... Right now, I am asked to convert it to 97. since there is a lot of difference from 2.0 to 97, Can somebody tell me what is easiest way to find those difference...

Hi Ken, Thank you for the reply. I already asked them to install this software on my computer, but they haven't done yet. I 'll ask them again. I don't know where the RPT file is. Thanks Amy

Hi, Our company has some reports which were written by somebody in Crystal Reports on the internet, the database is Oracle. Today, a user came to me that he found some errors which need me to fix, but I don't know how and where to get to design view for these reports, Can somebody help me here...