Convert numbers to text with VBA (ie 10 to be Ten)
Hi, The following is the link for converting numbers to text. It can handle decimals as well. http://www.meadinkent.co.uk/xlnumberstext.htm.

View Answer   |  March 31, 2009  6:04 AM
Convert numbers to text, String manipulation, VBA, Visual Basic for Applications

VBA – selecting middle portion of a string
Look for SUBSTRING and PATINDEX (I think VBA has both of those functions).

View Answer   |  March 31, 2009  3:55 AM
Excel 2003, Microsoft Excel 2003, String manipulation, VBA, Visual Basic for Applications

Convert Oracle code to Microsoft SQL code
Have a look at the <a href=”http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx”>SQL Server Migration Assistant (SSMA) for Oracle</a>. It might help you.

View Answer   |  March 30, 2009  9:51 PM
Database conversion, Oracle import/export, Oracle triggers, PL/SQL, SQL, T-SQL

Barcode scanner that dumps into text file
Symbol scanners are high quality and durable scanners, we still use several over 5 years old. Symbol was recently bought out by Motorola, but the DS6700 should be a good choice.

View Answer   |  March 30, 2009  8:17 PM
Barcode, Barcode Readers, Barcode scanners, Microsoft Access, VBA, Windows XP, Windows XP Professional

Programmatically load/eject CD drive in VB or Java
VB.Net code to eject or close the CD drive door. Sub OpenCDDoor() mciSendString “Set CDAudio Door Open Wait”, 0&, 0&, 0& End Sub Private Sub Command1_Click() mciSendString “Set CDAudio Door Open Wait”, 0&, 0&, 0& End Sub Private Sub Command2_Click() mciSendString “Set CDAudio Door Closed Wait”, 0&, 0&, 0& End Sub To use this code, [...]

View Answer   |  March 30, 2009  5:43 PM
Java, Visual Basic

OpenMsgStore API returns MAPI_E_FAILONEPROVIDER in different doamin with exchange server 2007
For MAPI to work you have to be logged onto the domain in which the Exchange server resides. You cannot do this from a different domain. You say this works with an Exchange 2003 server setup? That makes no sense. Are these trusted domains? If not, you can’t grant access rights to an account not [...]

View Answer   |  March 30, 2009  5:14 PM
Exchange 2003, Exchange 2007, MAPI, OpenMsgStore API

Integrated Windows Authentication prompts for username and password
Try <a href=”http://weblogs.asp.net/scottgu/archive/2006/07/12/Recipe_3A00_-Enabling-Windows-Authentication-within-an-Intranet-ASP.NET-Web-application.aspx”>this</a>. Just be careful as this could be maliciously exploited. May want to test the implementation or have someone else check it out if it’s for a sensitive/critical app.

View Answer   |  March 30, 2009  3:06 PM
ASP.NET, C#, IIS 6.0, Integrated Windows Authentication, Web development

What is the difference between software package in SQL and PL/SQL
PL/SQL is a <b>procedural extension of SQL</b>. It is a programming language. PL/SQL has variables and variable declarations, it includes conditional controls like IF. It also includes looping structures (LOOPs). PL/SQL uses SQL to get, manipulate and save data to/from the database. In PL/SQL you can build procedures, functions and packages. “SQL cannot be used [...]

View Answer   |  March 30, 2009  1:53 PM
Oracle SQL, PL/SQL, SQL, SQL development

Need someone to obtain ID and PW to website – Permission granted by owner
The hosting service needs to be able to identify that he is the owner of the site. If he pays the bill, he should have a customer number and an invoice number. If he uses a credit card to pay the bill, they can use that to identify him. If they also host his email, [...]

View Answer   |  March 30, 2009  6:41 AM
website access, Website accessibility, Website security

CGI Error
1) During initial login of the users: Error ocuured on the application web page: “Docuware Internet Server Error: Username passwrod is invalid . PLease check your entry. StatusCode 0×00400001 0xfffffff ” Procedure in stop/start services. Take offline / online DW5 Internet Services using cluster administration. 2. After refreshing the website second error will be CGI: [...]

View Answer   |  March 30, 2009  5:37 AM
CGI, DocuWare, Perl, Perl error handling, Web development

IE 8 JavaScript eval() Problem. Alternative?
eval was not the issue, sorry bad code. couldn’t figure out how to delete this question.

View Answer   |  March 29, 2009  2:01 PM
EVAL function, IE7, IE8, Internet Explorer 8, JavaScript, Web development

Error while making VB 6 installation setup file
A couple of thoughts: - Make sure the files/programs you are including are not in use at the moment of the package creation. - Review the path of each file you are including in the package, and make sure you have the appropriate access permissions to the folders in which they reside.

View Answer   |  March 27, 2009  5:46 PM
Error 70, Package and Deployment wizard, VB 6, Visual Basic, Visual Basic 6

I want to input operater like “* / -”
Please describe the specific problems/doubts you are having, so we can provide bettter help. In general, you will need a scanner to scan/parse the input string, and you will probably need to use postfix notation which will require the use of some LIFO (stack) structures.

View Answer   |  March 27, 2009  5:30 PM
C++, C++ Operators

STRDFU utility
Hi, You could start journalling for your files, this can keep before and after images of your data. SQL itself doesn’t have a before and after print feature like DFU. Regards, Martin Gilbert. ////////////////////////////////////////////////////////////////////////////////////// Martin is right – as always – first answer Journalling and report from TAATOOL’s journal tools. You can “simulate” the DFU [...]

View Answer   |  March 27, 2009  3:12 PM
Data File Utility, SQL, Start DFU, STRDFU

Generating ASPX pages from a MYSQL table
As a work around you can use the Visual Studio solution and change the code for MYSQL. All you would really need to change are the data connectors. anyone have anything better?

View Answer   |  March 27, 2009  2:43 PM
ASPX, MySQL, VB.NET, Visual Studio

Visual Basic code
Create a global variable outside of the Sub Main, then assign this variable the value you need and use it in another form.

View Answer   |  March 27, 2009  2:39 PM
VBA, Visual Basic, Visual Basic for Applications

(2008 Visual Basic) I need help with an error in my code
It looks like Link.Innertext might be “Null” when you assign it to strText in one of the loops in the for/each. You might try running the code in Visual Studio with a break point before and after the error and the assignment so you can watch the values. This error is often because the code [...]

View Answer   |  March 27, 2009  2:36 PM
Debugging, innerText, System.NullReferenceException, Visual Basic, Visual Basic 2008, Visual Basic 2008 debugging, Web development

How to make a welcome screen in Visual Basic 2008 app
Hello Dear sir, it,s easy to create. Design your welcome message in new form, then double click on ‘ My Project ‘ from Solution Explorer, then find SPLASH SCREEN, and set your welcome form as a Splash screen, when you start your project, load the form that is your welcome message view and issue the [...]

View Answer   |  March 27, 2009  2:23 PM
Interface design, Software development, TIMER, Visual Basic, Visual Basic 2008, Welcome Screen

JOB Schedule
We use the job description attached to the scheduled job: The SBMJOB command has INLLIBL as a parameter: Command: SBMJOB CMD(call pgm(mylib/myprog)) JOB(myjob) JOBD(QGPL/myjobd) JOBQ(QGPL/QBATCH) INLLIBL(*JOBD) – or whatever you want Good Luck! K ————————————————————————————————————————————————– The Add Job Schedule Entry command has JOBD and USER parameters. The JOBD parameter defaults to the user and the [...]

View Answer   |  March 26, 2009  8:10 PM
AS/400 Library, Job scheduling, WRKJOBSCDE

Connectionstring for paradox db password protected
Take a look at the following Microsoft Article, to see if it helps. It shows how to do it using DAO. <a href=”http://support.microsoft.com/kb/217213/en-us”>How To Open a Password-Protected Paradox Table Using DAO</a>

View Answer   |  March 26, 2009  7:55 PM
ASP, SQL Database, SQL Database Security, SQL Query