Lotus Notes 8.5.1 error message
The reqular Notes client package has an option to install for “Just this user” or “For all users of the workstation.” The Admin/Design client only supports “Just this user”. When you un-installed the old client it may have failed to completely clean up the Lotus software key in the Windows registry. Thus, when you tried [...]
View Answer
| December 16, 2010 6:58 PM
Lotus Notes, Lotus Notes 8.5.1, Lotus Notes error messages, Lotus Notes Upgrades, Multiuser application
The reqular Notes client package has an option to install for “Just this user” or “For all users of the workstation.” The Admin/Design client only supports “Just this user”. When you un-installed the old client it may have failed to completely clean up the Lotus software key in the Windows registry. Thus, when you tried [...]
View Answer
| December 16, 2010 6:58 PM
Lotus Notes, Lotus Notes 8.5.1, Lotus Notes error messages, Lotus Notes Upgrades, Multiuser application
Date conversion (to_char) behavior
In case someone else finds a similar situation, the problem was that the Oracle client software was installed in Spanish. Some of the options to fix it were: -create a logon trigger to change the nls session parameters if needed -modify the machine’s registry -reinstall Oracle client software We opted by the third one.
View Answer
| December 15, 2010 11:20 PM
Oracle, SQL, Windows
In case someone else finds a similar situation, the problem was that the Oracle client software was installed in Spanish. Some of the options to fix it were: -create a logon trigger to change the nls session parameters if needed -modify the machine’s registry -reinstall Oracle client software We opted by the third one.
View Answer
| December 15, 2010 11:20 PM
Oracle, SQL, Windows
Fill Char-elements w For Loop in Array
. The key was to use the “Chr” function: <pre> Dim array(15) As Char Dim i As Integer For i = 1 To array.Length – 1 array(i) = Chr(64 + i) Next </pre>
View Answer
| May 14, 2013 11:17 PM
Arrays (programming), VB.NET, Visual Studio, Visual Studio 2008
. The key was to use the “Chr” function: <pre> Dim array(15) As Char Dim i As Integer For i = 1 To array.Length – 1 array(i) = Chr(64 + i) Next </pre>
View Answer
| May 14, 2013 11:17 PM
Arrays (programming), VB.NET, Visual Studio, Visual Studio 2008
Formatting VB Script
You should do your formatting only during output just incase you wanted to do a computation on the variable there is nothing stopping from doing this prior to output. But as per MSDN documentation: http://msdn.microsoft.com/en-us/library/0c899ak8.aspx —————– If the paydate is stored in the database as a date and the checkamt as numeric (and not as [...]
View Answer
| December 15, 2010 11:15 PM
ASP.NET, VB.NET, VBScript, Visual Studio
You should do your formatting only during output just incase you wanted to do a computation on the variable there is nothing stopping from doing this prior to output. But as per MSDN documentation: http://msdn.microsoft.com/en-us/library/0c899ak8.aspx —————– If the paydate is stored in the database as a date and the checkamt as numeric (and not as [...]
View Answer
| December 15, 2010 11:15 PM
ASP.NET, VB.NET, VBScript, Visual Studio
Can we change opacity of an MDI child window in VB.NET?
Yes, that is pretty easy: <pre> Dim myForm As New Form2 myForm.Show() myForm.Opacity = 0.5 </pre>
View Answer
| December 15, 2010 11:13 PM
MDI, MDI child window, Multiple Document Interface, VB.NET, Visual Basic .NET
Yes, that is pretty easy: <pre> Dim myForm As New Form2 myForm.Show() myForm.Opacity = 0.5 </pre>
View Answer
| December 15, 2010 11:13 PM
MDI, MDI child window, Multiple Document Interface, VB.NET, Visual Basic .NET
VB.NET MouseUp and MouseDown events
Here is an article describing how to do it: <a href=”http://forum.codecall.net/blogs/xav/163-simple-painting-program-visual-basic-net.html”>Simple Painting Program in VB.NET</a>
View Answer
| December 15, 2010 11:12 PM
MouseDown Event, MouseUp Event, VB.NET, Visual Basic .NET, Visual Basic drawing coordinates, Visual Basic graphics
Here is an article describing how to do it: <a href=”http://forum.codecall.net/blogs/xav/163-simple-painting-program-visual-basic-net.html”>Simple Painting Program in VB.NET</a>
View Answer
| December 15, 2010 11:12 PM
MouseDown Event, MouseUp Event, VB.NET, Visual Basic .NET, Visual Basic drawing coordinates, Visual Basic graphics
Problem with ++ string operator in VB.NET
We didn’t get an answer to the details request, but for anyone having similar problems, the recommendation would be: “For security reasons DO NOT construct your SQL statements dinamically unless it is strictly necessary”. You should parameterize the statements instead. Something like this: <pre> command3 = New Data.SqlClient.SqlCommand(“UPDATE Products SET Stock = :psTock WHERE ProductName [...]
View Answer
| December 15, 2010 11:11 PM
Integer, SQL, VB .NET, Visual Basic .NET
We didn’t get an answer to the details request, but for anyone having similar problems, the recommendation would be: “For security reasons DO NOT construct your SQL statements dinamically unless it is strictly necessary”. You should parameterize the statements instead. Something like this: <pre> command3 = New Data.SqlClient.SqlCommand(“UPDATE Products SET Stock = :psTock WHERE ProductName [...]
View Answer
| December 15, 2010 11:11 PM
Integer, SQL, VB .NET, Visual Basic .NET
about visual basic.net
What is the error message ? Are you sure your table name is “tblCustome” and not “tblCustome<b>r</b>” Also, if you used the ampersand (&) to indicate that intCustomerID is a parameter, you should do it this way (assuming that SqlClient was being used) : <pre> command.CommandText = “select * from tblCustomer where CustomerID = :pCustomerId” [...]
View Answer
| December 15, 2010 11:10 PM
Database connectivity, SQL, VB.NET, VB.NET 2003, Visual Basic .NET
What is the error message ? Are you sure your table name is “tblCustome” and not “tblCustome<b>r</b>” Also, if you used the ampersand (&) to indicate that intCustomerID is a parameter, you should do it this way (assuming that SqlClient was being used) : <pre> command.CommandText = “select * from tblCustomer where CustomerID = :pCustomerId” [...]
View Answer
| December 15, 2010 11:10 PM
Database connectivity, SQL, VB.NET, VB.NET 2003, Visual Basic .NET
cannot connect vb program with sql server 2005 in local machine
The problem is most likely that Sql server has been configured to work in Windows Authentication Mode so it doesn’t allow using sql accounts. If that is the case, changing it to work in Mixed Mode should solve the problem. Take a look at this Microsoft article: <a href=”http://support.microsoft.com/kb/555332″>Login failed for user ‘username’. The user [...]
View Answer
| December 15, 2010 11:08 PM
SQL Server, SQL Server 2005, SQL Server Management Studio 2005, VB.NET 2008, Visual Basic, Visual Basic .NET, Visual Basic 2008
The problem is most likely that Sql server has been configured to work in Windows Authentication Mode so it doesn’t allow using sql accounts. If that is the case, changing it to work in Mixed Mode should solve the problem. Take a look at this Microsoft article: <a href=”http://support.microsoft.com/kb/555332″>Login failed for user ‘username’. The user [...]
View Answer
| December 15, 2010 11:08 PM
SQL Server, SQL Server 2005, SQL Server Management Studio 2005, VB.NET 2008, Visual Basic, Visual Basic .NET, Visual Basic 2008
updating, deleting in access with asp.net using Visual basic
You would update or delete records almost the same way as executing the query to populate your grid, but you would use the ExecuteNonQuery method: <pre> query = “DELETE FROM advertiser WHERE <some_column> = <something>” UpdateOrDeleteCommand = New OleDbCommand(query, msaccessconnect) UpdateOrDeleteCommand.ExecuteNonQuery() </pre>
View Answer
| December 15, 2010 11:07 PM
Access 2003, ASP.NET, Visual Basic, Visual Basic .NET
You would update or delete records almost the same way as executing the query to populate your grid, but you would use the ExecuteNonQuery method: <pre> query = “DELETE FROM advertiser WHERE <some_column> = <something>” UpdateOrDeleteCommand = New OleDbCommand(query, msaccessconnect) UpdateOrDeleteCommand.ExecuteNonQuery() </pre>
View Answer
| December 15, 2010 11:07 PM
Access 2003, ASP.NET, Visual Basic, Visual Basic .NET
FINRA Guide to IT Compliance
FINRA published <a href=”http://www.finra.org/web/groups/industry/@ip/@reg/@notice/documents/notices/p120779.pdf”>Regulatory Notice 10-06</a> in January 2010, which spells out specific guidelines for social media. It essentially covers all the applicable rules and regulations that firms need to adhere to in order to remain compliant with this regulatory notice. FaceTime Communications has published a <a href=”http://www.facetime.com/forms/wp_request.aspx?wpsource=lit&wpcode=finramap”>reference sheet</a> that helps organizations understand how the [...]
View Answer
| December 14, 2010 7:47 PM
Compliance, FINRA compliance, Infrastructure management, Infrastructure services, Network infrastructure
FINRA published <a href=”http://www.finra.org/web/groups/industry/@ip/@reg/@notice/documents/notices/p120779.pdf”>Regulatory Notice 10-06</a> in January 2010, which spells out specific guidelines for social media. It essentially covers all the applicable rules and regulations that firms need to adhere to in order to remain compliant with this regulatory notice. FaceTime Communications has published a <a href=”http://www.facetime.com/forms/wp_request.aspx?wpsource=lit&wpcode=finramap”>reference sheet</a> that helps organizations understand how the [...]
View Answer
| December 14, 2010 7:47 PM
Compliance, FINRA compliance, Infrastructure management, Infrastructure services, Network infrastructure
Lotus Notes Application Testing Automation
There is a tool called “Rational product for testing Lotus Notes applications” at IBM website Please visit <a href=”http://www-142.ibm.com/software/products/us/en/category/rational/SW730″>Here</a> For full concept and how to, please link <a href=”http://smart-toucan.com/web_movie/Automated_Application_Tests_for_Lotus_Notes_UKLUG_2009.pdf”>Here</a>
View Answer
| December 14, 2010 12:33 PM
Automation, Lotus Notes, Lotus Notes 8.x, Lotus Notes Application
There is a tool called “Rational product for testing Lotus Notes applications” at IBM website Please visit <a href=”http://www-142.ibm.com/software/products/us/en/category/rational/SW730″>Here</a> For full concept and how to, please link <a href=”http://smart-toucan.com/web_movie/Automated_Application_Tests_for_Lotus_Notes_UKLUG_2009.pdf”>Here</a>
View Answer
| December 14, 2010 12:33 PM
Automation, Lotus Notes, Lotus Notes 8.x, Lotus Notes Application
Software application to build database
Well it would really depend on how much data you are looking to store. If the data is small you can use Access for the front and back end. If it is slightly bigger you can use Access for the front end and SQL or MySQL for the back end. And finally if the scope [...]
View Answer
| December 14, 2010 12:28 AM
.NET, Access, Database, Database frontend, Java, Visual Basic, Web development, Web development tools
Well it would really depend on how much data you are looking to store. If the data is small you can use Access for the front and back end. If it is slightly bigger you can use Access for the front end and SQL or MySQL for the back end. And finally if the scope [...]
View Answer
| December 14, 2010 12:28 AM
.NET, Access, Database, Database frontend, Java, Visual Basic, Web development, Web development tools
Find missing numbers with SQL
I’m not sure if this syntax will work on your platform: <pre>SELECT invno – 1 FROM invoices i WHERE NOT EXISTS ( SELECT 1 FROM invoices WHERE invno = i.invno – 1);</pre> Notes: -The result will include a fictitious invoice number smaller than the lowest one. -This query would perform better if an index exists [...]
View Answer
| December 13, 2010 4:23 PM
AS/400 SQL, SQL, SQL Server, V6R1
I’m not sure if this syntax will work on your platform: <pre>SELECT invno – 1 FROM invoices i WHERE NOT EXISTS ( SELECT 1 FROM invoices WHERE invno = i.invno – 1);</pre> Notes: -The result will include a fictitious invoice number smaller than the lowest one. -This query would perform better if an index exists [...]
View Answer
| December 13, 2010 4:23 PM
AS/400 SQL, SQL, SQL Server, V6R1
How to collapse data in a Pivot Table in Excel 2007?
1. Right-click the category label or the data series 2. On item in the column label of a PivotTable report or series in a PivotChart report, do one of the following: Click the expand / collapse Right-click item, select Expand/Collapse, and then do one of the following: To collapse details for the current item, click [...]
View Answer
| December 13, 2010 12:11 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel Forms, Excel functions, PivotTable
1. Right-click the category label or the data series 2. On item in the column label of a PivotTable report or series in a PivotChart report, do one of the following: Click the expand / collapse Right-click item, select Expand/Collapse, and then do one of the following: To collapse details for the current item, click [...]
View Answer
| December 13, 2010 12:11 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel Forms, Excel functions, PivotTable
Starting a session in MySQL
Here the Q is not clear properly. More details r required. i.e. what os and what is the web and other related SW. If possible supply actual scenario, that helps to provide more correct answers. Though I am trying to provide some information, that may help u. Session is related with any web application. Session [...]
View Answer
| December 13, 2010 11:16 AM
MySQL, MySQL functions, MySQL query
Here the Q is not clear properly. More details r required. i.e. what os and what is the web and other related SW. If possible supply actual scenario, that helps to provide more correct answers. Though I am trying to provide some information, that may help u. Session is related with any web application. Session [...]
View Answer
| December 13, 2010 11:16 AM
MySQL, MySQL functions, MySQL query
Outlook 2003 cannot connect to the server via HTTP any longer
Try out this…. Start > Run > regedit and locate the following HKEY_CURRENT_USERSoftwareMicrosoftOffice<version no>OutlookRPC Edit menu > New & add a DWORD Value Type DefConnectOpts, & press enter. Now right-click DefConnectOpts, select Modify type 0 in In Value data box, & OK Close and reboot. CAUTION: Before editing registry, it is good practice to take [...]
View Answer
| December 13, 2010 7:10 AM
Exchange 2003, HTTP, HTTP access, Outlook 2003, Small Business Server 2003
Try out this…. Start > Run > regedit and locate the following HKEY_CURRENT_USERSoftwareMicrosoftOffice<version no>OutlookRPC Edit menu > New & add a DWORD Value Type DefConnectOpts, & press enter. Now right-click DefConnectOpts, select Modify type 0 in In Value data box, & OK Close and reboot. CAUTION: Before editing registry, it is good practice to take [...]
View Answer
| December 13, 2010 7:10 AM
Exchange 2003, HTTP, HTTP access, Outlook 2003, Small Business Server 2003
How do I retrieve data from Visual Basic 6.0 with SQL?
Since u didn’t mention here sql means, what sql server version, There r several ways to connect from each version to each version of SQL Server (ODBC, ADODB, DSN-less, and so on. Though here is a one line code for connection, be care about syntax…. Provider=SQLOLEDB.1;User ID=<userid>;Password=<password>;Initial Catalog=<db….name>;Data Source=<computernameinstancename>;Persist Security Info=True; For total info and [...]
View Answer
| December 11, 2010 6:32 AM
Retrieve Data Area, SQL, SQL Server, VB 6.0, Visual Basic 6.0
Since u didn’t mention here sql means, what sql server version, There r several ways to connect from each version to each version of SQL Server (ODBC, ADODB, DSN-less, and so on. Though here is a one line code for connection, be care about syntax…. Provider=SQLOLEDB.1;User ID=<userid>;Password=<password>;Initial Catalog=<db….name>;Data Source=<computernameinstancename>;Persist Security Info=True; For total info and [...]
View Answer
| December 11, 2010 6:32 AM
Retrieve Data Area, SQL, SQL Server, VB 6.0, Visual Basic 6.0
blocking permission inhertiance in Windows Server 2003
On the security tab of an account properties click the advanced button. You can uncheck “inherit from the parent the permission entries that apply child objects”. Is that what you are trying to acheive?
View Answer
| December 10, 2010 6:34 PM
Active Directory, Inheritance, Windows Server 2003, Windows Server Permissions
On the security tab of an account properties click the advanced button. You can uncheck “inherit from the parent the permission entries that apply child objects”. Is that what you are trying to acheive?
View Answer
| December 10, 2010 6:34 PM
Active Directory, Inheritance, Windows Server 2003, Windows Server Permissions
Crystal Reports 8.5 compatibility with SQL 2005
Yes.
View Answer
| December 9, 2010 10:54 PM
Crystal Reports 8.5, SQL, SQL Server, SQL Server 2005
Yes.
View Answer
| December 9, 2010 10:54 PM
Crystal Reports 8.5, SQL, SQL Server, SQL Server 2005
