Recent content by jcarneir

Solved. Solved. The code it's right!!! Vba dictionary has an issue when accessing and item that not exists: vba creates an empty item with an empty key. The code never evaluate a not existing element but in the watch window I have an expression that was viewing an external variable of...

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

Question: If the index is unique, can I omit the rst.Index="UniqueIndex"?

I think this approach have some problems: 1) I need time to order a table that have an Index yet. 2) The openrecordset creates a photo of the table. I need apply the changes in the records. thx

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

I finding something like this: "Length of LCS (Longest Common Subsequence) is a good measure of the similarity of two strings" I got this link: "http://64.233.161.104/search?q=cache:k6hZJ7PuQJMJ:www.dcs.gla.ac.uk/~rwi/Algs4_Lecture_8.ppt+%22comparing+texts%22+algorithm+plagiarism&hl=es" but I...

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

I found the solution. It's a bug with Office. Here is the link: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q292/7/44.asp&NoWebContent=1&NoWebContent=1 There are two possible solutions: 1) Use late binding with word objects (This solutions...

hi, try this Private Sub Test() Dim vProd1 Dim rst as Recordset set rst=CurrentDb.openRecordset("SELECT TOP 1 [Prod1] " _ & "FROM tbl_Client_Employee_Contrib ORDER BY [Prod1];") if not rst.EOF then vProd1 = rst!Prod1 else 'put here your error...

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