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

    Help with Query using wildcards

    Thank you Sunila7, this worked for me as I had the same problem.
  2. emeryp

    Output parameter problem

    I would like the answer to this as well!!
  3. emeryp

    Passing Parameters with ADO

    Hello Everyone, Could someone please look at my code and tell me why the first parameter is receiving the error: Parameter object is improperly design #3708? Private Sub Stored_Procedure(Value As String) Dim EMEDcnn As ADODB.Connection Dim cmdEMED As ADODB.Command Dim prmEMEDinput As...
  4. emeryp

    Linked Tables and updating

    Thank you cmmrfrds, Now am I correct in assuming that the tables will automatically update when I issue the refresh command? emery
  5. emeryp

    Save formatted text

    Sure! I would like to see that. It seems that otherwise, I need to SelLength and choose formatting that way. emery
  6. emeryp

    Updating Linked Tables

    Hello CClint, My tables are already linked in Access and I use the object code for the ActiveX component rather than building it from scratch. For instance: If (OldVar <> Environment) Then If Not (Environment = &quot;Search&quot;) Then If Not (Environment =...
  7. emeryp

    Printing Rich Text?

    vb5prgrmr, I too am having this problem. I am sending the text by editing a recordset: Public Sub Send_Msg() With FrmCHAT.AdoCHAT CmdType = adCmdTable If (RTInvite) Then StrSQL = &quot;TBL_INVITE&quot; Else StrSQL = &quot;CHAT_MSG&quot...
  8. emeryp

    Save formatted text

    Hello Everyone, I would like to save formatted text from either a textbox or label into a file, then pull that formatted text into another textbox. Can someone help? I have tried using RTF to no avail. Emery
  9. emeryp

    Updating Linked Tables

    Hi Everyone, Does anyone know how to automatically update linked tables from VB 6.0? I have manually used the linked table manager but would like to do it within an application. Emery
  10. emeryp

    Linked Tables and updating

    Hi Everyone, Has anyone automatically updated their linked tables? I have used the linked table manager to perform the update, but am looking for a way to perform this in my code in VB 6.0. Looking around, it looks like the DoCmd may help? Any ideas would be helpful. Emery
  11. emeryp

    ComboBox can't bind to field

    Hello everyone, I'm getting an error that the combobox can't bind to the datafield. I have an ADO that is the datasource for this combobox. I am not doing anything else to populate the box, is this the correct way to populate a combobox?
  12. emeryp

    MMControl works only once!

    Pete, Please see that the code is checking for the mode of the device and setting it back to .PREV if it has played. The problem is that the player only plays once, the reset doesn't seem to work.
  13. emeryp

    RichTextBox confusion!!!

    Can someone please check this code and tell me why it doesn't append to a file? See last message for code.
  14. emeryp

    RichTextBox confusion!!!

    The following code does not append to the file. I wonder if the LoadFile method of the RTB is locking the file and not allowing the append to take place? Any ideas?: Dim OutFile As String Private Sub Command1_Click() NewStr = RichTextBox2.TextRTF Open OutFile For Append As #3 Write...
  15. emeryp

    RichTextBox confusion!!!

    Let me try again to append to a file and get back to both of you. John, the filecopy method was used because my append try didn't work. I will use the TextRTF property this time.
  16. emeryp

    RichTextBox confusion!!!

    Here it is, I went back and looked and found that the real issue is appending to the file prior to loading it into the richtextbox: Private Sub Command1_Click() RichTextBox2.SaveFile &quot;C:\VB Projects\Test\RichTxtBox\InputFile.rtf&quot;, rtfRTF End Sub Private Sub Form_Load()...
  17. emeryp

    RichTextBox confusion!!!

    Hi everyone, I can use the RichTextBox.savefile and the RichTextBox.loadfile but the loadfile will not load the same file as the save file and I can't figure out how to copy the savefile to the loadfile for loading. Sounds stupid doesn't it? Can someone help?
  18. emeryp

    MMControl works only once!

    Thanks, Mode 526 actually checks to see if the control is still in 'play' mode. I have now changed the code to stop the player then move to the previous track which in this case will default to the beginning of this track: 'this code checks only the first time called to set up the 'control If...
  19. emeryp

    MMControl works only once!

    I have a MMControl (multi-media control) that will call a wave file, but it only works the first time it is called. Here is the code: With FrmCHAT.MMControl1 If (.Mode = 526) Then .Command = &quot;Close&quot; End If 'Set properties needed by MCI to open. .Notify =...
  20. emeryp

    Probelm with re-occuring error in Visual Basic 6.0. To frequent!!

    First of all, have you clicked the link to look at the error report? What is in it?

Part and Inventory Search

Back
Top