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...
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...
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...
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...
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...
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...
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...
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]
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...
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...
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...
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...
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...
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...
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...
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...
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...
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"...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.