Recent content by jane30

I tried to import a .txt file coming from AS/400 into Access 2000 database. The sample data on the import wizard showed ??? +++ and other strange characters. For test purpose, I FTPed another .txt from AS/400 and imported into Access 2000 databse, it worked fine. And I had no problem importing...

Hi, there! I have an Lotus Domino 5 database that tracks all the projects in our finance department. All the documents are entered through "Input Form". There is a field "Priority", which is numeric editable field that indicates the priority of each project. Currently the...

Hi, I need to import an .sdf (standard data format) file into my Access 2000 database on a routine basis. However, I couldn't find this file type when importing it. Any suggestions? Do I need a ODBC driver? The .sdf file comes from local area network. Thanks a bunch

exactly what i'm looking for. Thanks a lot.

Hi, in my Access 2000 database, I need to check whether a query already exist; If yes, delete; not, create a new one. Much thanks in advance.

Hi, in my Access 2000 database, I have a table summarized by name as followings: PersonName PGM1 PGM2 PGM3 PGM4 PGM5 John Smith 10(days) 5 3 Alice Young 2 1 John Test 7 8 10 6 Alice Test...

Hi,In my access97 table [Mater],there are [Month From](in "yyyymm" format) and [Month To] fields along with other fields. Currently, each record indicates a person receive certain amount of money during the period of [Month From] and [Month to]. Now, what I need to do is to create an...

Hi, in my Access 97 database, I have the following codes in module named "ModTest": Dim db As Database, mod1 As Module, appcurr As Application Set db = CurrentDb() Set appcurr = Access.Application For Each mod1 In appcurr.Modules If mod1.name Like "ModFAC*" Then...

Hi, in my Access 97 datase running on Windows XP, I ran a make-table query which joins 2 tables together. Both tables have over 1 million records each. I got an error message: Error 3183 Not Enough Space on Temporary Disk. From the Help provided with this error message, I read this error is...

Hi, I have a table in my Access97 database. It was created by the make-table query doing the one-to-many table join. The records are like this: Acct# StartDate EndDate Days ActivityDate Clinic 111111 11/24/99 11/30/99 7 11/24/99 xxxxxx 111111 11/24/99 11/30/99 7...

Hi, in my Access 97 database, I tried to change one field's data type, I got an error message, saying that "Microsoft Access can't change the data type. There is no enough disk space or memory." Sometimes I'm able to change the data type of a field in a table, sometimes I get the...

Hi, is there a function in Access 97 same as the Substitute function in Excel 97? The reason I need this is that I have more than 10 select queries. I need to modify the table name in them. So, I'm thinking about using "For each qdf in db.Querydfs" this statement to locate the table...

Hi, I tested the following code in debug window in Access 97: Mystring="Hello" ? replace(mystring, "No way") It returned me an error message: Run-time error: 438 Object doesn't support this property or method. My Access 97 was installed from Microsoft Office 97...

Hi, Is there Replace function in Access97? Why I don't see it in the Help topics? I have Microsoft DAO 3.5 Object Library reference. Do it matter?

Jeremy, thanks for the info. I'll talke to the boss about the utilities you recommended. By the way, I do have a question that're might be easy for you, a question about Access Pivot table: Can the recordsource of a Pivot table be changed? Here is the scenario: I have over 10 queries. I created...