Search results for query: *

Hi, I created 2 Classes. An Internal_Dict with items of type "double" and an external Dict with items of type Internal_Dict. Both classes have a Show procedure to print the data. I created a test procedure to verifies both classes. Internal_Dict it's Ok but External_Dict has an issue: when the...

Hi, I have a mysql database (v5.1) on xp. I run: a) pass through querys (from access) b) php scripts via window's scheduled tasks c) queries with the query browser The mysqld-nt process increases the ram usage but dont't release any memory when the queries or tasks have finished. I need to...

Hi, Somedays ago, I had a sql server table. My code were somthing like: set rst= db.openrecordset("SomeSqlServerTable") while not rst.eof if SomeCondition then rst.edit rst!SomeField="SomeValue" rst.update endif rst.movenext wend Today, the table is in mysql but...

Hi, In first place, sorry my bad English. Every morning between 3 and 4 am, some external process put a file in a remote server. I'm going to write a routine to connect via ftp, check if the file exist and read the file into a local machine. I have checked and the ftp read operation don't...

Hi, I have a vba code that open an access table. Then using a index (3 fields in the index), I can move record by record and perform change in some fields. This week I have migrate this table to a SQL SERVER Dataase and the vba code in the access database don't work anymore because the index...

Hi, I have at work, a mdb with some tables a queries. We are migrating the tables to an sql server enviroment and the mdb is now empty, with some queries and the new linked tables but... The queries don't work now. case 1: "Delete * From TableA" is not working Case 2: suppose TableB have...

Hi I wonder if there are some sort of algorithm to compare texts. I receive addresses (street xxx, buildind yyy, city zzz, ...) and I want compare the new addresses with the old ones in order to know if they may exists in the database and launch a warning. I need to catch new entries that have...

Hi, I want to know if I can delete a table in an external database I can delete a table in the current database by: docmd.DeleteObject actable,"MyTable" Thanks

Hi, I have this working code to replace Text in word documents: (objDoc is an object word) objDoc.Select With Selection.Find .Text = "Old text" .Replacement.Text = "New text" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = True...

I have a form with 3 textboxes for input phone numbers. Are ther controls for multiple inputs like a list???

Hi, I need to decompress some .tar.Z files whithin a vba access module. Is there an activex control that decompress this format???

I need to download from some servers a lot of files and process them. If the file is not in the server I want to wait X time. I think I need some timers controls. What can I do??

I write a module in excel that works perfectly in excel 2000. If I open the workbook in excel 97 I get the run-time error 1004: "Unable to set colorindex property of the font class. The instruction is: ActiveSheet.Cells(4, 3).Font.ColorIndex = 1 What's wrong in 97. BTW the workbook is...

When I use the docmd.TransferSpreadsheet method to export a tabla to an excell file I get an error If the path+filename is too long. How I can fix this if I don't want to change the path? Thx

I lost a module and I want to get the source code. Is There a way to get the code back?

I think that somebody is using my work computer and I want if there is a windows code or (TSR) that can intercept keyboard characters; put them in a file (like a log file).