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!

  • Congratulations Mike Lewis 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. Genotix

    Excel Freezez when Formatting Text

    I've got the same problem here. I'm creating an Excel sheet from a Visual Basic application. The first time i boot and run excel there doesn't seem to be a problem. The second time there does. There is no CPU activity and only excel seems to "freeze" for about 25 seconds. From that moment on...
  2. Genotix

    Using a frame as an object

    Does that help me when I want a new, unique frame to be created every time I click a button? Linux IS userfriendly. It's only very selective about who it's friends are.
  3. Genotix

    Using a frame as an object

    Hi All, I would like to use the frame as an object. I'd like to create an instance of it. Something like : Public FRM1 As New Frame Public FRM2 As New Frame FRM1.Visible = True FRM2.Visible = True Can someone help me with this? Thanx!! Linux IS userfriendly. It's only very selective...
  4. Genotix

    Showing a single frame with multiple contents

    Ok, let me specify my question better. I want to use the frame as an object. I'd like to create an instance of it. Like : Public FRM1 As New Frame Public FRM2 As New Frame FRM1.Visible = True FRM2.Visible = True Linux IS userfriendly. It's only very selective about who it's friends are.
  5. Genotix

    Showing a single frame with multiple contents

    Hi All, I've got a problem which I hope you can help me out with. I'm trying to create an application that can open a frame that i've designed multiple times at once. (So there will be like three of the same frame with different content) (How) Is this possible? Thanx in advance! Eric Linux...
  6. Genotix

    Creating comment with color and bold in Excel Sheet

    Hi guys, I've got a small problem and I'm hoping you can help me out with it. I want to put comment into a specific cell. Inserting the comment into the cell isn't the problem. Making the comment partly BOLD and COLORING is though. Does anyone have a VBA script for me that fills a cell with...
  7. Genotix

    Access date compare datatype problem

    Thanx for the tip! Linux IS userfriendly. It's only very selective about who it's friends are.
  8. Genotix

    Access date compare datatype problem

    Hey guys, I've got a problem withe the WHERE clausule of my query. In my database records are stored and all have a field Start_Timestamp and Stop_Timestamp (both Date/Time format) When I execute a query like : SELECT * FROM table WHERE number = 1000 AND Start_Timestamp > '1-3-2005...
  9. Genotix

    Calculating with TIME problem

    I've seen the syntax and understood it immediately. Thanx anyway for the explanation :D Linux IS userfriendly. It's only very selective about who it's friends are.
  10. Genotix

    Calculating with TIME problem

    Exactly what I needed!! Thanx a million!! Linux IS userfriendly. It's only very selective about who it's friends are.
  11. Genotix

    Calculating with TIME problem

    Hi All, I've got a relatively small problem to which I can't seem to find an answer. In a production process employees can enter a time which they spent on a production. The start time is entered in the system and stored in the database in a date format. I would like to calculate the estimated...
  12. Genotix

    Locking Records using ADODB and ACCESS in VB6

    I suppose the CursorLocation must be set to adUseServer? Thanx! Linux IS userfriendly. It's only very selective about who it's friends are.
  13. Genotix

    Locking Records using ADODB and ACCESS in VB6

    Hi All, I've searched my @$$ of for sites that give me information about this subject and I hope some of you can help me out here. I've got a table in ACCESS with a records that I put in a recordset using ADODB. Cursortype = adOpenForwardOnly LockType = adLockPessimistic Now I'd like to lock...
  14. Genotix

    Quotes in database fields workaround

    @pkailas Thanx just wat I needed Linux IS userfriendly. It's only very selective about who it's friends are.
  15. Genotix

    Quotes in database fields workaround

    @Zemp It's not that easy to use the search function when you're not that good in English. I know how to phrase a question but find it very hard to use the right words in a search. Linux IS userfriendly. It's only very selective about who it's friends are.
  16. Genotix

    Quotes in database fields workaround

    Hi there, Is there a way to "escape" certain reserved characters when they're put into a string which I want to insert in a database field? The problem I have now is that VB6 gives me an error when i'm using a quote in the text field. Thanx for your replies! Eric Linux IS userfriendly. It's...
  17. Genotix

    Changing a celltype in Excel from VB6

    Thanx!! I've found the VB script is quite useful. Linux IS userfriendly. It's only very selective about who it's friends are.
  18. Genotix

    Changing a celltype in Excel from VB6

    Well, i've filled a cell with value 10.00 (A percentage) What excel does is putting a "€" sign in front of it, thinking it is a money value. I would very much like to remove that crappy € sign. Linux IS userfriendly. It's only very selective about who it's friends are.
  19. Genotix

    How to read and write Excel worksheet throught VB6

    Try to use this piece of code. It helped me out very well. http://www.freevbcode.com/code/VB2Excel.zip"]FREEVBCODE.COM[/url] This is from a site i use next to this site. In my opinion these two sites should be combined! Linux IS userfriendly. It's only very selective about who it's friends are.
  20. Genotix

    Changing a celltype in Excel from VB6

    Hi All, I'm trying to change the type of contents of one cell in Excel 2000. Can't seem to find the command for it though. Can anyone tell me how to do this and... Does anyone know a online source where I can retrieve more information about connecting VB6 to Excel and also creating charts...

Part and Inventory Search

Back
Top