Search results for query: *

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

I want to store the phone numbers into a single field: phone1;phone2;phone3;....; Today can be 0 to 3 numbers but next month may change. I can use three textboxes but I wonder if exist a ocx for multiple input.

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

The file contain data.The data is about sells and another transactions and is put in tables. Afterwards, the code creates statistics and reports. I want automatize the weekend work.

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