Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Amy998

    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...
  2. Amy998

    Query

    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...
  3. Amy998

    Query

    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...
  4. Amy998

    This question is tough. Error: Ambiguous name detected: TmpDDE

    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...
  5. Amy998

    convert Access database from 2.0 to 97

    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...
  6. Amy998

    convert Access database from 2.0 to 97

    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...
  7. Amy998

    How to find disign view

    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
  8. Amy998

    How to find disign view

    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...

Part and Inventory Search

Back
Top