Search results for query: *

Hello, I am trying to create a checkbox and an optionbutton in a word 2000 or XP document with vb6. Is there a special code or formula to represent these symbols? If this works, how can I group my option buttons, since they are grouped is sets of 4 or 5. (with one possible answer) Can...

Hello, Evere time I push a buttun on my toolbar , which is on a mdiform, I get the following error: Line 13: Property Left in Toolbar1 could not be set. Line 13: Property Width in Toolbar1 could not be set. and then the code behind the button is carried out like i want it. So only the error...

I just used the file with the code, thus the projectfile, of my friend. We use the same disk to work on. Suddenly , it doesn't know the date function anymore Thank you in advance, Timme

Hello, I have a big problem at which I have spent hours of searching on. But I can't find the problem. I created a html file in word, including png and jpeg pictures then I created a helpfile with html help 1.3 and put it in my visual basic (6) application like it is told in...

hello, The error says :can't find object or library. The function places the current date in the label. It's very strange, since it works on one pc, but not on the other. Thank you in advance, Timme

Hello everyone I use the rule: label1 = date It works on one pc, but not on another, and I use the same program? What would be the reason? Thanks in advance, Timme

Hello, Thank you Dale for the file you have sent me. I'm really surprised by the speed of the calculations using database properties in excel. Otherwise, it is really too slow. I think many people will be interested and surprised by the file you made. None of my friend even knew that this is...

Hello, Thank you for all the information you gave me. The nonmatchcount function works very well. But I have 100000 records en 256 columns. This fuction is then really too slow (even more than an hour), certainly when I have to use it many times again. (of the loop I think) Is it possible to...

Hi, The columns I have to compare are of equal size and they have to be exactly the same to match.(smith <> smyth) eg 150 names and 65 are the same, then 43 % are the same and 57 % is different Timme

Hello, I'm looking for a solution for the following problem: I have two columns with names. I want to insert a funtion in a cell that compares these two columns and gives me the % difference (of the names which aren't present in both columns). Is there an existing function for this? or how...

Hello, I created a While loop where I go through colums. in the beginning of the sub: k = 1 in the loop is a command: columns(k).select and at the end of the loop: k = k+1 Now there is a big problem: when the column is at the &quot;Z&quot;-column, he goes back to the A-column with with...

Hi, I have vb 6 and want to export data to ms excel xp in a sheet that I made before, thus a template I made. Then I want to view this sheet in a vb form. Important is that the user of the program cannot see that excel is open at that moment. With a button in the form (with the ole excel link)...

Hello, I have put the code proposed by icet (first in thread) in a module and i call it when a button is pressed in a form. I get the message that the method FileExists(...) isn't known. Does anyone know the reason for this? thanks in advance Tim

Hello, I wondered how I can put the name of a column followed by '=' in front of all the entries in a certain column. E.g. If the name of the column is 'color' and an entry is 'red', then 'color=red' should appear in the cell. Afterwards I want to export the table to a text file and I hoped to...

Hello, I have a access database with uncomplete data. I need to do some work first with the table. e.g. I need to apply expressions on the data, like giving a certain value IF ..., change values of fields with inconsistent data, new fields with sum of two other field etc... I want to change the...