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 Chriss Miller 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: *

  • Users: Foada
  • Content: Threads
  • Order by date
  1. Foada

    Get record ID if exists, insert new if record doesn't exist

    I am new to MySQL and I just cannot seem to get the answer I am looking for. Basically I have a table that contains events so the table is comprised of an autoincrement id and name field. I need to add records to the table as events occur and log the details of the events in a different table...
  2. Foada

    Composite Key and Group By Issue

    Thanks in advance for any insight on this one. I have a composite key that is formed by a customer id and an address sequence number. Each time a address sequence is added to a customer a new Address id is added. If I perform a Max() on the sequence number and group by the customer id I get the...
  3. Foada

    General set up suggestions

    Hello everyone. I was hoping I could feed by brain with everyone elses knowledge. I am a programmer by trade so I am a little knew to server set up. Here is my situation. I am attempting to get a small network set up at home so that I can network my 7 development machines together. Basically I...
  4. Foada

    Date Time Picker - Strange Behavior

    Has anyone else seen this happen. If you drop a Date Time Picker control on a form along with a text box and then use this code: Private Sub DTPicker1_Change() Text1.Text = DTPicker1.Value End Sub Set the Date Time Picker Up Down property to true and the format to dtpTime, run the app and...
  5. Foada

    Syslink BEFSX41 Homepage Spoofed?

    I don't know if I can explain this well enough, but here goes. I have 3 computers on my network. I am using a LinkSys BEFSX41 firewall/router with firmware version 1.50.18 at the present time. I have tried every version of firmware that I could get my hands on. The machine in question is a dual...
  6. Foada

    Runtime Ado Connection Assignment for Multi-Table Report

    I did a quick check of the FAQs and a search but with no clear answer. I am a newb with CR and I am in a real time constrant so I appologize if this seems simple. Basically I am using VB6 w/ CR 8.5 on Win2K. (All current) I designed my report which is based from an Access2000 DB and obtains its...
  7. Foada

    Treeview Control and Node Items

    Has anyone ever noticed this before? If you add a treeview control and a command button to a new project and drop this code in the command buttons click event Private Sub Command1_Click() Dim nds As Nodes Dim str As String ' Set nds = TreeView1.Nodes str = "Set...
  8. Foada

    Toolbar Wizard Icons?

    Does anyone know what file the Toolbar Wizard selects its icons from? I want to extract a couple of them and make some modifications to them. Any Ideas? Thanks. [flip] If you choose to battle wits with the witless be prepared to lose. [cheers]
  9. Foada

    Record Sets vs. Collections

    I am wondering if anyone has an opinion either way on this. I have seen it coded both ways and have not seen a difference either way. Basically I am wondering if it is worth while to build a collection instead of using a static recordset to maintain small data items. For lack of a better example...
  10. Foada

    ActiveX wrapper for 3rd party dll using WM_User Message

    I have a 3rd party dll that generates a WM_USER message. What I am tring to do is wrap the dll with an ActiveX control so that it can be used in another app. I can't to get the WM_USER message to be handled by the control. I have tried both MFC and ATL ActiveX wizards but with no luck. I can...
  11. Foada

    Text position in a text box control...

    I have looked all over for this and have had no luck. I am writing a user control that mimics the textbox control. For several reasons I can not just place an intrinsic textbox on my user control. I have been able to duplicate everything that the textbox control does with the exception of the...
  12. Foada

    Option Explicit in VB Pro Edition Controls Project

    I was wondering if this happens to anyone else. I have my Require Variable Declaration option selected and the Option Explicit shows up for every project template except the VB Pro Edition Controls template. Has anyone else seen this or do I have a "buggy" installation? If you choose...
  13. Foada

    When is a Class overkill?

    Just because everyone seems to enjoy voicing opinions on Fridays, I will try to start a "Friday Discussion Post" today. When do you draw the line on a Class module? I have seen Classes for a simple "object" say ink which was really only a property of say "pen" but...
  14. Foada

    ADO 2.6 Cursor Problem with SQL Server 7.0 & 2000

    Hi everyone, Has anyone run across anything like this before. I have a basic ADO recordset that works fine with SQL Server 7 but fails with SQL Server 2000. Basically I use this code to retrieve the rs from within a function FYI rsEditEmp is global . . . 'Get a record set that contains all...
  15. Foada

    VB Serial Communications

    Hi everyone. [wavey2] I am looking for some input on a utility I am developing for serial communications. It started as a quick on the fly type app to do a quick couple of communication tests to a Omron PLC. After placing it at the mercy of some of our engineers it has moved on to the...
  16. Foada

    SQL Server Licenses w/ADO connections

    Does anyone have any links/info regarding how SQL server determines the license count required for ADO connections. Is it by client machine or by ADO connections. I am assuming that if I use NT Server authorization each client requires a single license and can have multiple ADO connections but I...
  17. Foada

    Drop ComboBox List from Code

    Hi Everyone. Here is what I am trying to do. I have an option button that enables a combo box. What I would like to do would be drop the combo box list at the same time I enable it. Has anyone done anything like this or do I need to make a mock combo box with a command button, textbox and a...
  18. Foada

    Syntax for DDL using ADODC and VB

    I am trying to write a utility that verifies an Access 2000 database. I am able to get the ALTER TABLE to add a column but not to rename it as follows: Private Sub MySub() On Error GoTo ErrHandler hDB.ConnectionString = sDBConnection & App.Path & "\TestDB.mdb&quot...
  19. Foada

    Verify Table Exist At Runtime Using ADO 2.6

    Hi Here is my problem. I am writing a utility that will verify that my database(Access2000) contains all the relavent tables, fields, data etc. I want to be able to check if a table exist and if it does not create it so here is what I have. Private hDB As New ADODB.Connection Private Sub...
  20. Foada

    DB2 Backup and Compact for a Never User

    I was pushed into trying to clean up someone elses mess and have no where to even start. The worst part is I just need to schedule a backup and purge/repair. I was able to run the 'Reorg' command from the command line counsel but I don't want the user getting in that deep. Is there some where in...

Part and Inventory Search

Back
Top