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

    IMPORT .TXT FILE SHOWS STRANGE CHARACTER???

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

    URGENT! How to re-order the priority number???

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

    How to import .sdf file to Access 2000

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

    How to check whether a query already exist

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

    How to check whether a query already exist

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

    URGENT!!! TRANPOSE OR ???

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

    .AddNew to create new record???

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

    Copy modules from one database to another via VBA

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

    Why "Not Enough Space on temporary disk"?

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

    Magic VBA to update a field in a table

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

    Can't Change data type

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

    SUBSTITUTE FUNCTION IN ACCESS 97

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

    Not supported Replace() function

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

    Replace function in Access97 or just in Access2000?

    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?
  15. jane30

    Modify query using VBA

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

    Modify query using VBA

    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]
  17. jane30

    An easy tabledef/querydef question

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

    USing VBA to Create tbl based on a parameter query

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

    USing VBA to Create tbl based on a parameter query

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

    PIVOT TABLE???

    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]

Part and Inventory Search

Back
Top