Search results for query: *

I, like many of you, have been holding on to VB6. I have a Win7 environment with MSCOMCTL.ocx in the System32 directory and a Windows 8.1 machine with MSCOMCTL.ocx in the sysWOW directory. Both machines have VB6 installed and working well. The dependency works fine when a project is started...

I have: A table of employees - tblEmp A table of things - tblthings A table that associates the two - tblAssoc I would like to see those employees not associated with things in the association table. Should be something like below. Select * from tblEmp LEFT JOIN tblAssoc on...

I am not seeing this as a discussion topic which leads me to believe I am the only one who has this problem. When using a Treeview control, you clear it using the .Nodes.Clear Method. For some reason when I use this method with a latge amount of data in the control, the control hangs for a...

There has got to be a faster way of doing this. At first I was using code to open and close the recordset, this is way too slow. For i = lstvwBreakdown.ListItems.Count To 1 Step -1 strSQL = "SELECT SONO,ITEM FROM tblSchedBkt WHERE SONO = '" & lstvwBreakdown.ListItems(i).Text &...

This one gives me the error "data mismatch in criteria expression" strSQL = "SELECT * FROM tblSched WHERE (APPROVED=0) AND (sDate BETWEEN '" & dteDate & "' AND '" & dteDate2 & "')" This one does not strSQL = "SELECT * FROM tblSched WHERE (sdate BETWEEN '" & strTemp & "' AND '" & DateAdd("d"...

I am struggling to see what is wrong with this SQL statement. By the errors it seems to have an issue with the pareths, although I am not sure what alternative I have. the errors are: Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '>'. Msg 102, Level 15, State 1, Line 4 Incorrect...

Someone please tell me that I am not dreaming and I can use VB6 to connect to a web hosted (Remote) SQL database. This seems to be such a simple thing and yet everything I am reading is indicating the db must reside on the local network? I try to connect using the following string (with server...

I have been up a while working on this and just can't see my mistake. I am ultra new to using innerjoin, but I feel my sql statement is ok. I need to pull a bunch of fields together and it just so happens there are two different dates (SOMAST.fduedate) and (SOITEM.fduedate). I now need to...

I just recently installed SQL Server 2008 Express. I set up the accounts and tried to connect to the server from another computer in the workgroup. I can only connect if I have the windows firewall off. I am using Mixed mode. Logging in as sa with the appropriate password. I changed the TCP...

I am having a bit of trouble navigating ADOX with multiple catalogs in SQL. The following code will pull the tables into one list and the fields into another. The problem is the SQL server has 5 different databases in it and this is pulling them all. Can I get this broken down by each DB in...

I am having a bit of trouble colorizing a listview sorted with strongm's API sorting of a listview used in thread222-578008. The colorizing code turns negative numbers red and positive numbers green. It works swimmingly for standard alphabetic sorting, but when the API sorting is used, it...

I have a page that uses SMTP to send mail. My host upgraded from .NET 2.0 from 1.1 and both pages of ASP code no longer work. This has to be a simple thing, but I just don't get what needs to change. Any thoughts? <p> <%@...

Good day, I am near my breaking point here. I installed MSSQL Server 2008 Enterprise Evaluation on my "server" yesterday. Made sure I had get a clean install with no issues. The "server" is a Win XP SP3 machine not connected to a domain. All services run fine on the server side. I enabled...

I am missing something simple here. If you can assist, it would be appreciated. Connecting to a SQL database that stores well over a bajillion records. Trying to narrow the scope of my search a titch. I am trying the following SQL statements. #1 returns all records but there are ton of them...

Good Day. I have limited experience with SQL and quite a bit of experience with Access. I have been connecting to Access with ADO for some time now. I recently ran into trouble when connected to a SQL database and attempting a write. What works against an access database isn't working here...

Hello all, I have searched up and down several of the Tek-Tips forums and still have a few unanswered questions about my connection to a foxpro database. Hopefully I can hammer this out in the VB6 forum. Our system (Made2Manage) uses a Foxpro database to store company data. I am looking to...

I am using the following code to change the icon to a custom icon. Private Sub Form_Load() Form1.MouseIcon = ImageList1.ListImages(1).Picture Form1.MousePointer = 99 End Sub However, it doesn't show the icon at actual size. It resizes it. I thought the size limitations were only...

Is it possible to replace a sheet name with a value from a cell in the following formula? 'What Works =IF(J4="x",SUM('WITTYSHEETNAME'!L5:L13),0) Replace WITTYSHEETNAME with the value of Cell B6 'Pseudo Code that doesn't work =IF(J4="x",SUM('B6'!L5:L13),0) Thanks in advance, Matt

Hello to all, I am creating an ActiveX control. I have created custom properties using Get/Let. When I add the compiled control to a new project (.exe project) I can use my nifty little properties but there is one little hang up. They don't have any comments attached. I would think someone...

I am writing an ActiveX control. Very new to these. When I compile and decide to load it onto a form in an exe project the True/False selection in the properties window is locked (Can't switch between the two values). Can't seem to figure this one out. (please don't add the property bag...