Check out http://blogs.technet.com/b/heyscriptingguy/archive/2010/05/19/expert-solutions-beginner-event-3-of-the-2010-scripting-games.aspx and http://blogs.technet.com/b/heyscriptingguy/archive/2010/05/19/expert-solutions-advanced-event-3-of-the-2010-scripting-games.aspx you will have to scroll down for the VBScript bits
View Answer | June 10, 2010 6:34 PM
QTP, VBScript, Visual Basic Script
Those pages need to be served by an <a href=”http://en.wikipedia.org/wiki/Internet_Information_Services”>IIS</a> with the proper .NET framework / ASP version installed.
View Answer | June 10, 2010 5:17 PM
Internet Explorer, Visual Basic, Visual Studio, Windows XP SP3
Twenty years is such a long time; my advice is that you take advantage of the vast experience that you have attained throughout that period. Just do software development as a side-dish. Since you are considering going in the direction of Microsoft, C# and VB.NET would be ideal for you.
View Answer | June 10, 2010 7:13 AM
Career change, IT career planning, IT careers, Software development
No – all records including the last record will have the same record termination code. You can change it for all records. Phil
View Answer | June 10, 2010 1:49 AM
AS/400, ASCII File, CPYTOSTMF, CRLF
Instead of the specific words, use this notation in the field criteria: <pre>[Forms]![YourFormName]![YourTextboxName]</pre>
View Answer | June 9, 2010 6:40 PM
Access 2007, Access 2007 functions, Query, TextBox
WOW – you want to search every column in every table looking for some piece of data? Yes, you can build some queries to do that. I have done it on a limited set of tables during one of the conversions I was involved in. (there were six characters that had to be found and [...]
View Answer | June 9, 2010 2:45 PM
Database query, SQL development
You didn’t provide any details about the programming language and the database being used. In general, you could perform such validation in your application, or with a database check constraint.
View Answer | June 9, 2010 1:49 PM
Database alerts, Form validations, trans
If you are running that as a query, you can run just one SQL statement at a time (anything after the first semicolon will generate an error).
View Answer | June 8, 2010 6:08 PM
Access errors, Microsoft Access, SQL, SQL Access
depending on the version of sql server there are a number of ways of finding this. Try looking at the systables view in your database to track down the table. You can then look at the columns in the table Alternatively use the sql server management tools to view the database structure
View Answer | June 8, 2010 5:47 PM
SQL Database, SQL Developer, SQL development, SQL Server Query
if it is over internet, you will need an IP, then you will need to have iis installed and also configure the FTP site…that is about it….
View Answer | June 8, 2010 6:51 AM
FTP, FTP Server, Software Requirements Specification
In that case it is a subject I can support . Unwanted web content is something that bugs me personally, and professionaly in the work space. To my knowledge, there is no easy way of doing this. I have used the off line browsing capability on my browser to automatically upload a single page, if [...]
View Answer | June 7, 2010 3:52 PM
Content management applications, Offline Backup, Website Testing
Have you gone to the Office update site to download the new format help files?
View Answer | June 5, 2010 11:46 PM
Excel 2003, Excel error messages, Excel macros
Typically put “EXIT” as the last line in the script.
View Answer | June 5, 2010 8:40 AM
batch queries, Batch Scripts
You could start using the <a href=”http://www.microsoft.com/express/downloads/”>express edition</a>, which is free.
View Answer | June 3, 2010 5:29 PM
.NET, Open source, SharePoint, SharePoint development, Visual Studio
Hi, Yes, just look to optional group 2 of Receive Data Queue (QRCVDTAQ) API <pre> Required Parameter Group: 1 Data queue name Input Char(10) 2 Library name Input Char(10) 3 Length of data Output Packed(5,0) 4 Data Output Char(*) 5 Wait time Input Packed(5,0) Optional Parameter Group 1: 6 Key order Input Char(2) 7 Length [...]
View Answer | June 2, 2010 5:56 PM
AS/400, AS/400 Data Queue, Data access, V5R4
This online documentation explains how to plan a web-based application hosted by Domino. <a href=”http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=/com.ibm.designer.domino.main.doc/H_PLANNING_A_WEB_APPLICATION_OVER.html”>Planning a traditional (Domino) web application</a> However, If by “Open in http link” you mean that you want Lotus Notes to start and open to this application from an web browser, then you need to write a link to the application [...]
View Answer | June 2, 2010 2:32 PM
.NSF files, HTTP, Lotus Domino Server 7.x, Lotus Notes Conversion
Sorted this now. I just changed the second MDI Child form to a normal form (MDI Child property = False). This allows the first MDI Child form that contains the flex grid to stay maximized while the second form is loaded at a set size.
View Answer | June 2, 2010 10:50 AM
MDI, MSHFlexGrid, VB6.0 MSHFlexGrid, Visual Basic 6.0
Hi, If, all you want is to hide the report viewer’s parameters pane, you can do it by writing code- MyReportViewer.ShowParameterPrompts = false; If you want to hide a single parameter, write the code - reportParameterCollection.Visible = false; Since you told your are new even to c#, here are the sample codes for you to [...]
View Answer | April 19, 2013 4:27 AM
C, C# .NET, Parameters, SSRS
This is SQL for DB2 for z/OS code that will do what you want. You may have to change the syntax if you are using SQL in some RDBMS other than DB2 for z/OS. Oracle, for example, uses DECODE instead of CASE. Also, you will need to repeat the CASE statement for how ever many [...]
View Answer | May 28, 2010 8:19 PM
Microsoft Excel, SQL
CALs aren’t per connected user, but per named users. If you already have the SQL Server CPU license then there is no additional cost. If you change the license there’s a cost and no savings.
View Answer | May 27, 2010 9:16 PM
SQL, SQL Server, SQL Server CAL licensing, SQL Server Enterprise Edition