DataGrid in Visual Basic 6
I am developing an application in VB6 using a bound data grid with a data control, and am struggling with the following: 1. How do I force an update of the data grid to the data control by pressing the Enter Key, regardless of which cell of the data grid is current. 2. When updating [...]
Answer Question
| March 3, 2009 12:48 AM
Database programming, DataGrid, VB 6, Visual Basic 6
I am developing an application in VB6 using a bound data grid with a data control, and am struggling with the following: 1. How do I force an update of the data grid to the data control by pressing the Enter Key, regardless of which cell of the data grid is current. 2. When updating [...]
Answer Question
| March 3, 2009 12:48 AM
Database programming, DataGrid, VB 6, Visual Basic 6
How to convert VBA decimal DataTypes
I need to figure out how (if possible) to remove decimals from numerical data, and add zeroes to the front/back end of data so that I can concatenate several cells into a single strain. Ex: Actual value = 14.37, needs to be converted to 14370 Actual Value = 4.3, needs to be converted to 04300 [...]
Answer Question
| March 4, 2009 10:02 PM
Concatenate, DataType, VBA, VBA DataType
I need to figure out how (if possible) to remove decimals from numerical data, and add zeroes to the front/back end of data so that I can concatenate several cells into a single strain. Ex: Actual value = 14.37, needs to be converted to 14370 Actual Value = 4.3, needs to be converted to 04300 [...]
Answer Question
| March 4, 2009 10:02 PM
Concatenate, DataType, VBA, VBA DataType
Access 2003 using IIf statement on a form
I am building a database to help my daughter with keeping a record of pupil progress. I have a form in which I have a field for ‘current grade’ and a field for ‘target grade’. I also have a field ‘progress’ in which I am using an ‘IIf statement’ to compare the two fields (to [...]
Answer Question
| March 5, 2009 9:32 PM
Access 2003, Access 2003 forms, Access forms, IIF function, Microsoft Access
I am building a database to help my daughter with keeping a record of pupil progress. I have a form in which I have a field for ‘current grade’ and a field for ‘target grade’. I also have a field ‘progress’ in which I am using an ‘IIf statement’ to compare the two fields (to [...]
Answer Question
| March 5, 2009 9:32 PM
Access 2003, Access 2003 forms, Access forms, IIF function, Microsoft Access
vbscript email message lenght limits?
Is there a “total message length” limitation for Excel Macro Emails? I’m new to vbscripting and thought I had successfully created code to email Excel data via a macro. I have written the macro to send up to 30 lines of information, but have discovered that the number of lines I can actually send depends [...]
Answer Question
| March 2, 2009 5:07 PM
VBScript, VBScript Email, VBScript Email Message Length
Is there a “total message length” limitation for Excel Macro Emails? I’m new to vbscripting and thought I had successfully created code to email Excel data via a macro. I have written the macro to send up to 30 lines of information, but have discovered that the number of lines I can actually send depends [...]
Answer Question
| March 2, 2009 5:07 PM
VBScript, VBScript Email, VBScript Email Message Length
Legacy MS-DOS Licensing
I’m setting up a virtual machine that is going to run a legacy application that runs in MS-DOS 6.22. The client asked about the legality of copying the MS-DOS software. (He does have the license on the original machine as well as the original 3.5 install disks, so I suppose I would be “transferring it” [...]
Answer Question
| March 10, 2009 3:55 PM
Legacy software, Licensing, Microsoft, Microsoft licensing, MSDOS
I’m setting up a virtual machine that is going to run a legacy application that runs in MS-DOS 6.22. The client asked about the legality of copying the MS-DOS software. (He does have the license on the original machine as well as the original 3.5 install disks, so I suppose I would be “transferring it” [...]
Answer Question
| March 10, 2009 3:55 PM
Legacy software, Licensing, Microsoft, Microsoft licensing, MSDOS
Error message: DLL undefined
Please help me correct. Error message: DLL is undefined and BN is undefined.
Answer Question
| March 2, 2009 3:48 PM
DLL, DLL management
Please help me correct. Error message: DLL is undefined and BN is undefined.
Answer Question
| March 2, 2009 3:48 PM
DLL, DLL management
Processing XML files with SQL Server functions
Hi I read through your tip on Processing XML files with SQL Server functions. It’s great but what happens when the XML file exceeds 4000 charcters? I’m using SQL Server 2005 and the XML file that I try and import is too big. Do you have any ideas to how I can use SQL to [...]
Answer Question
| March 2, 2009 1:43 PM
SQL Server 2005, SQL SERVER 2005 XML, SQL Server Functions, XML, XML Files in SQL Server 2005
Hi I read through your tip on Processing XML files with SQL Server functions. It’s great but what happens when the XML file exceeds 4000 charcters? I’m using SQL Server 2005 and the XML file that I try and import is too big. Do you have any ideas to how I can use SQL to [...]
Answer Question
| March 2, 2009 1:43 PM
SQL Server 2005, SQL SERVER 2005 XML, SQL Server Functions, XML, XML Files in SQL Server 2005
Prospects for Java developers?
Now ,I am studying Java programming J2SE. How do u think of this language? Should I continue to study? Can I stand as Java Professional. Most people says that Java is difficult and there is few jobs . And another question is How can I run Java RMI.
Answer Question
| March 9, 2009 12:28 PM
IT careers, IT Job Market, J2SE, Java developers, Java Remote Method Invocation, Java RMI
Now ,I am studying Java programming J2SE. How do u think of this language? Should I continue to study? Can I stand as Java Professional. Most people says that Java is difficult and there is few jobs . And another question is How can I run Java RMI.
Answer Question
| March 9, 2009 12:28 PM
IT careers, IT Job Market, J2SE, Java developers, Java Remote Method Invocation, Java RMI
POST is not displayed on my LCD screen through DVI-I
POST is not displayed on my new LCD screen when its connected through DVI-I and it proceeds straight to the XP boot screen. On VGA either on the new screen or the old CRT POST is displayed normally. While on dual display I get POST on my CRT but not on my LCD. Any way [...]
Answer Question
| March 9, 2009 4:52 AM
ATI Radeon 9200, Digital Visual Interface, Dual monitors, DVI connector, DVI-I, LCD display, LCD Monitor, POST, Power-On Self Test, Windows XP
POST is not displayed on my new LCD screen when its connected through DVI-I and it proceeds straight to the XP boot screen. On VGA either on the new screen or the old CRT POST is displayed normally. While on dual display I get POST on my CRT but not on my LCD. Any way [...]
Answer Question
| March 9, 2009 4:52 AM
ATI Radeon 9200, Digital Visual Interface, Dual monitors, DVI connector, DVI-I, LCD display, LCD Monitor, POST, Power-On Self Test, Windows XP
Macromedia Dreamweaver Dataset problem
Hi, I’m new to web development and I’m working my way through the Dreamweaver manual (also in the PDF). It was going well well until I hit the wall in “Chapter 5 Developing a Web Application” (Page 69-82). My problem…. I can’t seem to get “Live Data View” to work (bottom of P.66 in the [...]
Answer Question
| March 2, 2009 2:44 AM
.NET Framework 1.1, Database connectivity, Dataset, Dreamweaver, Dreamweaver MX 6.1, Macromedia, Macromedia Dreamweaver, Web development, Windows XP
Hi, I’m new to web development and I’m working my way through the Dreamweaver manual (also in the PDF). It was going well well until I hit the wall in “Chapter 5 Developing a Web Application” (Page 69-82). My problem…. I can’t seem to get “Live Data View” to work (bottom of P.66 in the [...]
Answer Question
| March 2, 2009 2:44 AM
.NET Framework 1.1, Database connectivity, Dataset, Dreamweaver, Dreamweaver MX 6.1, Macromedia, Macromedia Dreamweaver, Web development, Windows XP
Integrating IT operations/developers from acquisition
My firm has just purchased another company, and I have been placed in charge of the process of absorbing the IT operations into the other company. While my company has largely standardized on a .NET platform, the new purchase uses a mix of COM/COM+, Java Beans, and older Visual Basic 6 applications. The staff of [...]
Answer Question
| March 2, 2009 1:05 AM
.NET development, Acquisitions, COM/COM+, IT operations, JavaBeans, VB 6, Visual Basic 6
My firm has just purchased another company, and I have been placed in charge of the process of absorbing the IT operations into the other company. While my company has largely standardized on a .NET platform, the new purchase uses a mix of COM/COM+, Java Beans, and older Visual Basic 6 applications. The staff of [...]
Answer Question
| March 2, 2009 1:05 AM
.NET development, Acquisitions, COM/COM+, IT operations, JavaBeans, VB 6, Visual Basic 6
Dynamic/Data-driven page creation and content
Hello! Sort of a “newbie”, so please forgive the ignorance. I want to be able to build a page (and edit screen) dynamically, based on some mechanism of persistable per-control screen location/formatting/field masking information – storeable/retrievable as a “unit”, representing a particular “view” of a model/data in a database. For example, I have a database [...]
Answer Question
| March 2, 2009 9:00 PM
Ajax, ASP, CSS, Data-driven, Database connectivity, Database-driven website, DHTML, Dynamic content, dynamic controls, Dynamic HTML, Silverlight, Web development, Windows Forms
Hello! Sort of a “newbie”, so please forgive the ignorance. I want to be able to build a page (and edit screen) dynamically, based on some mechanism of persistable per-control screen location/formatting/field masking information – storeable/retrievable as a “unit”, representing a particular “view” of a model/data in a database. For example, I have a database [...]
Answer Question
| March 2, 2009 9:00 PM
Ajax, ASP, CSS, Data-driven, Database connectivity, Database-driven website, DHTML, Dynamic content, dynamic controls, Dynamic HTML, Silverlight, Web development, Windows Forms
Create dynamic video archive
This is the code from my watershed (paid portion of ustream.tv) site that I’m trying to get to work on my own website. (I’ve got an account with Watershed, and have the right to do this, but Watershed does not have a tech support team to show me how to implement the dynamic archive I [...]
Answer Question
| November 9, 2011 7:37 PM
JavaScript, Video streaming, Web development
This is the code from my watershed (paid portion of ustream.tv) site that I’m trying to get to work on my own website. (I’ve got an account with Watershed, and have the right to do this, but Watershed does not have a tech support team to show me how to implement the dynamic archive I [...]
Answer Question
| November 9, 2011 7:37 PM
JavaScript, Video streaming, Web development
How to compare fingerprint images in VB.NET
i am working on FINGERPRINT RECOGNITION SYSTEM, i am using vb.net as front end and sql server 2000 as back end, i had saved fingerprint images in sql server using image datatype, now i need suggestion how to compare fingerprint images.
Answer Question
| April 2, 2010 7:36 PM
.NET development, Authentication, Biometric authentication, Biometrics, Fingerprint authentication, Fingerprint scanning, SQL Server 2000, VB.NET, Visual Basic .NET
i am working on FINGERPRINT RECOGNITION SYSTEM, i am using vb.net as front end and sql server 2000 as back end, i had saved fingerprint images in sql server using image datatype, now i need suggestion how to compare fingerprint images.
Answer Question
| April 2, 2010 7:36 PM
.NET development, Authentication, Biometric authentication, Biometrics, Fingerprint authentication, Fingerprint scanning, SQL Server 2000, VB.NET, Visual Basic .NET
Looping Queries in Oracle using data from SQL Server
I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = ’0′ CONNECT BY PRIOR a.parentid = a.sid’ Where I have ’0′ in the query above, should take all the values from PID. Is there a easy way [...]
Answer Question
| March 2, 2009 4:05 PM
Oracle development, Oracle queries, SQL, SQL queries, SQL Server connectivity
I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = ’0′ CONNECT BY PRIOR a.parentid = a.sid’ Where I have ’0′ in the query above, should take all the values from PID. Is there a easy way [...]
Answer Question
| March 2, 2009 4:05 PM
Oracle development, Oracle queries, SQL, SQL queries, SQL Server connectivity
Excel 2003 VBA drop down list and discontinuous ranges
I am attempting to populate a drop down list in excel using data validation and data contained in two discontinuous ranges. I have used the Union command in vba to create a named list which seems to correctly concatenate the two data ranges but when I validate the cell which is to contain the drop [...]
Answer Question
| February 27, 2009 3:43 PM
Excel 2003, Excel 2007, Microsoft Excel, VBA, VBA EXCEL 2003
I am attempting to populate a drop down list in excel using data validation and data contained in two discontinuous ranges. I have used the Union command in vba to create a named list which seems to correctly concatenate the two data ranges but when I validate the cell which is to contain the drop [...]
Answer Question
| February 27, 2009 3:43 PM
Excel 2003, Excel 2007, Microsoft Excel, VBA, VBA EXCEL 2003
Java API For Domino Scheduling & Caledaring feature
I’m trying to access domino’s caledaring & scheduling fetaure through java application using lotus.domino API to make some reservations/appointments , just wanted to check Is there any other specific java API for dominos calendering & scheduling feature , exposing the makeReservation , checkAvalability kind of functionality ??
Answer Question
| February 27, 2009 1:59 PM
Domino Calendar, Domino Java API, Java, Lotus Notes
I’m trying to access domino’s caledaring & scheduling fetaure through java application using lotus.domino API to make some reservations/appointments , just wanted to check Is there any other specific java API for dominos calendering & scheduling feature , exposing the makeReservation , checkAvalability kind of functionality ??
Answer Question
| February 27, 2009 1:59 PM
Domino Calendar, Domino Java API, Java, Lotus Notes
PK allows null values in progress DB does this reduce performance of sql statements?
Hello Primary Key allows null values in progress DataBase, does this reduce performance of sql statements??
Answer Question
| February 27, 2009 1:50 PM
NULL values in PK, SQL performance, SQL statements
Hello Primary Key allows null values in progress DataBase, does this reduce performance of sql statements??
Answer Question
| February 27, 2009 1:50 PM
NULL values in PK, SQL performance, SQL statements
Hiding query string in ASP.NET 3.5 application
Hi.. Can any one tell me how can i hide query string from address bar of web browsers, due to secourity reasions…. I know i can pass data from one page to another page thruogh sessions but this time i need to do this through query string.. so please tell me how i can do [...]
Answer Question
| April 14, 2009 10:21 AM
ASP.NET, ASP.NET 3.5, ASP.NET Web applications, Session value, URL parameters, Web development
Hi.. Can any one tell me how can i hide query string from address bar of web browsers, due to secourity reasions…. I know i can pass data from one page to another page thruogh sessions but this time i need to do this through query string.. so please tell me how i can do [...]
Answer Question
| April 14, 2009 10:21 AM
ASP.NET, ASP.NET 3.5, ASP.NET Web applications, Session value, URL parameters, Web development
Memory leaks in IIS 6.0
Hi, I am working on an application that uses .NET remoting features. There are multiple instances of a process running on different set of data. Every instance of the process has its own unique transaction number. Now the problem is that we had one instance that had used correct transaction number for half of its [...]
Answer Question
| February 27, 2009 9:50 AM
.NET applications, .NET development, .NET remoting, Class-level variable, IIS 6.0, Memory leak
Hi, I am working on an application that uses .NET remoting features. There are multiple instances of a process running on different set of data. Every instance of the process has its own unique transaction number. Now the problem is that we had one instance that had used correct transaction number for half of its [...]
Answer Question
| February 27, 2009 9:50 AM
.NET applications, .NET development, .NET remoting, Class-level variable, IIS 6.0, Memory leak
