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

    export checkbox and option button to word

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

    toolbar error every time i push a button, no consequences

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

    date function

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

    help file doesn't show pictures

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

    date function

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

    date function

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

    compare columns in excel

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

    compare columns in excel

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

    compare columns in excel

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

    compare columns in excel

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

    help: loop through colums

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

    rich text box in form

    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)...
  13. Timme1

    Writing Excel files from VB

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

    notation in table

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

    preprocessing raw access data

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

Part and Inventory Search

Back
Top