Search results for query: *

The .vbp file created on the windows 7 machine contains the 2.1 reference. The Windows 8.1 machine it seems is stuck on the 2.0. I will keep digging, thank you for the lead. Will post back after a short bit.

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

Aha. FULL OUTER JOIN That works...

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

Ick. Even worse than I thought. If I don't scroll the control, it clears quickly. If I scroll to the bottom it takes forever (3 sec or so) to clear even with my loop. I decided to make the control invisible, clear it, then make it visible again. It clears instantly now regardless of scroll...

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

Can I do the same thing with format(mydata,"000000") or does this do something bad? I have used this in the past.

data type = char data type = nvarchar What I have is a database with some data created in a legacy system, and some from the current system. Some of the data matches (old system, no padded zeros) while others do not (new system, padded zeros) I can't change the structure now. Once I have...

I am very sorry for the late replay. I went off to conquer the world with my new knowledge of JOINS and ran into a problem. 64-Bit SQL Server does not offer Jet as an option for linked servers. So I set off on the direction of upsizing my Access DB to SQL. I have since done this and now have...

Oh my. If only I would just listen instead of type. Sorry for the last 4 posts and I suppose the entire thread. The below works. Your help is certainly appreciated George, Andy! SELECT soitem.fsono, soitem.finumber FROM soitem LEFT JOIN tblSchedBkt ON (soitem.finumber = tblSchedBkt.ITEM)...

Ok. I am trying to simplify it a bit. I have the tables linked and the code is giving me all the records that both tables have in common. How do I get the rows that are in the table named soitem that are not in the table named tblSchedBkt? The WHERE Null isn't working> SELECT soitem.fsono...

I linked the tables in access and am trying to get the results I need. Will post back how it pans out.

After looking at this more, there is no reference to the second database gmmastros. I am working with an Access DB with the table tblSchedBkt and a SQL DB with multiple tables. I would need to reference the Access DB somewhere in this statement yes? My code, strCarverLoc, held the path to the...

This gives me an unclosed quote error. So I remove the ') before "As tblBktList ON..." Then it gives me an "incorrect syntax near "ON"?

I keep messing a bit while researching a bit. It doesn't seem to like the "IN" strSQL = "SELECT SOMAST.fsono,SOMAST.fcustno,SOMAST.Fcompany,SOMAST.fcustpono,SOMAST.fstatus,SOITEM.finumber,SOITEM.fenumber," & _...

Obviously my first try is a failure, but here is what I am working with. I pulled out my Where to simplify it a bit strSQL = "SELECT SOMAST.fsono,SOMAST.fcustno,SOMAST.Fcompany,SOMAST.fcustpono,SOMAST.fstatus,SOITEM.finumber,SOITEM.fenumber," & _...

Good catch on that. I was using variables for these in the past and the quotes carried over. Thanks,

Ok I will dig into those. Sorry for the delayed postings, you guys are way too fast.

I don't really have the first clue how to do this. I am looking into a join as mentioned above. My current statement that fills the list is below. strSQL = "SELECT SOMAST.fsono,SOMAST.fcustno,SOMAST.Fcompany,SOMAST.fcustpono,SOMAST.fstatus,SOITEM.finumber," & _...

The other DB is SQL. I am just getting into INNER joins in my programming life. I haven't used this before. I will dig into it and see if it is what I want. This would be great. Thanks,