Search results for query: *

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

...appcurr As Application Set db = CurrentDb() Set appcurr = Access.Application For Each mod1 In appcurr.Modules If mod1.name Like "ModFAC*" Then docmd.copyobject "d:\db1.mdb","",acModule,mod1.name else MsgBox mod1.name End If Next End Function It returned me a...

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

Hi, There are more than 10 queries in my Access97 database. All of them are based on the same master table. I want to change the table name. It's kind of tedious to change all the queries on by on. Can I use VBA code to do so? Many thanks in advance.[3eyes]

...to use VBA code---tabledef and querydef to create those select queries like this: For each tabledef in db.tabledefs if tdf.name like "c-1*" sql="select "&tdf.name&".f1,"&tdf.name&".f2 from "&tbl.name&" right join on tblMaster on...

Jeremy, are u suggesting me to use db.openrecordset to get the dept# in the Dept# table and pass this variable value to my sql statement in VBA? If so, how can I choose which dept to create? I don't intent to create the table for all the dept#. So, I need a mechnism to allow me to pick the...

Hi, I'm Access97 user. In my master database, I had query1(select query) and query2(a parameter query asking for Dept code) and query3 (make-table query join query1 and query2 to create a table in a dept database). I'm doing this manually now. That it, I changed the destination database name to...

Hi, I guess what I did wrong was I modified the RowSource, not the Record Source by copying and pasting the SQL statement to the RowSource. Now it worked fine after I change the Record Source. Thanks a lot. [thumbsup2]