Search results for query: *

It has been a very long time since I worked with the DBGrid control and I could use some help. I need to use the control in the unbound mode. Does any one happen to remember how to address a given cell. Ie: set column 0 row 3 = somevalue. Thanks Terry (cyberbiker)

I really suspect this is not the best forum for this question, but I really do not know where to post this question. I need to covert some binary values to a 32 bit integer by any means possible. These values, once converted to a 32 bit integer will be a constant this is an example of the...

I am attempting to create a stored procedure that duns a DTS package according to an agument passed in. This works fine EXEC @hr = sp_OAMethod @oPKG, 'LoadFromSQLServer ("(local)", "", "", 256, , , , "DTS_Import")', null This gives me a syntax error at + 'LoadFromSQLServer ("(local)"...

I seem to be locating everything but what I need to find out so please bear with me if this subject has been discussed to death but... When I attempt to run the debugger I receive an error stating: "SP debugging may not work properly if you log on as a 'Local system account' while SQL Server is...

I am into something new and need some advice I have an Access 2000 mdb that uses pass through queries to a DB2 database on an AS400. I know very little about what is happening (I just received the MDB by Fed Ex a few minutes ago), but the MDB contains pass through queries, linked tables and...

I do not fully understand the definitions of protected and friend keywords in the help menu. I sounds like "protected" would be "Public" if called from a class derived from the class where it was declared and private any other time. "Friend" sounds almost identical to "public" in that you can...

New to VB.net and am becoming confused with event handlers. I have looked through the posts for a bit and realize that control arrays do not exist in VB.net. The question I have is that I do not seem to quite understand how to use the event handler to handle something like this (from VB6)...

I am a bit confused re MSDE so please bear with me. It seems the more I read, more confused I am become. Note: Once I get past this initial confusion I might be able to phrase a more sensible question, but right now I do not even know exactly what to ask. I have had a desk top version of SQL...

I am attempting to improve my skills and find that I am often missing a basic concept.I know some things work and use those techniques as I was taught but as I can more skill, I begin to question the logic. This question is very basic. I know that if I am updating 2 recordsets and I want...

Before I go off with some goofy code to fix this, perhaps someone knows a better way. I have a a fair number of date time fields (smalldatetime data type) in my SQL Server database. Null values are permitted. On one form in my app I have 2 bound text boxes that are assigned the value of the...

I think I am missing something very basic in my understanding of stored procedures. So I need clarification on a (or some) basic points that I either cannot find in BOL or do not understand when I read it there. The current problem (as one example) is that I want to have a stored procedure...

I do not quite understand what I am reading between BOL and searching the forums. I need to export certain data into a comma delimited text file. I have created a DTS package using enterprise manager and it works pefectly from enterprise manager. I need to run the package from VB code. At...

I do not know this is not the proper forum for this, but this is my best guess as to where to start so please aim me the right direction if I am wrong about where to post. (I an cross posting in the API ,VB6 and VB.Net forums alsso) I need to write what would IN EFFECT be a mouse driver for a...

I do not know this is not the proper forum for this, but this is my best guess as to where to start so please aim me the right direction if I am wrong about where to post. (I an cross posting in the VB6 and VB.Net forums alsso) I need to write what would IN EFFECT be a mouse driver for a USB...

I do not know this is not the proper forum for this, but this is my best guess as to where to start so please aim me the right direction if I am wrong about where to post. (I an cross posting in the API,VB6 and VB.Net forums also) I need to write what would IN EFFECT be a mouse driver for a...

I do not know this is not the proper forum for this, but this is my best guess as to where to start so please aim me the right direction if I am wrong about where to post. (I an cross posting in the VB6 and VB.Net forums alsso) I need to write what would IN EFFECT be a mouse driver for a USB...

I have never worked with the data enviroment before nor the Data Report Designer. I really just need somebody to confirm I am on the right track before I get in too deep since it just looks too simple. I need to creates some very simple reports that will need the datasource set "on the...

I am struggling with the syntax for stored procedures and triggers. Most of the books I have are pretty simplistic and I am wondering if anybody knows a good place for me to find sample code to study? One that I am trying to write at this time would be something like: CREATE TRIGGER...

I have a form with various text boxes and a single DBcombo bound to a recordset. If I update the recordset by modifying any of the data contained in any of the text boxes as well as the dbcombo box the recordset updates properly. If I change the value in the dbcombo box without changing any...

I am using VB6 ADO and SQL Server 7 Most of my tables are set up pretty much the same with with columns like ID,name , address, etc. ID is an intendity field Then I have tables where the rows are like ID,notes or similar. I am creating recordsets with select statements similar to Select tblA...