Search results for query: *

Hi, I have made a VB Script but I want to write the application in VB6 so I can compile it to EXe. I have studied the FSO but I don't see the command to replace the Shell,Run and Sendkeys command in VB6. Any help is greatly appreciated. ------------ Below is my VB Script that worked but I...

Hi, I want to run a software install to all of the computers on our company. But I want to run it by invoking RUNAS (run as with Admin Rights) command and put it on the batch file. Is there a way that I can incorporate the password on the command line so it will just suppress the prompt for...

Hi, Invoking Foxpro command window is Ctrl+F2. However, why is it that when I execute a foxpro application and wants to Invoke the command window (by pressing Ctrl+F2) the command window does not show up. Is there any SET setting or command in foxpro that I am missing? Thanks for your help! Gene

Hi, We've got a (suspect ) right beside one of our databases and currently is not accessible. Is there any way to recover the database. What causes that makes it a suspect. If somebody could give a quick reply and advice, it is greatly appreciated. Thanks. Eugene

Is there a way to prompt a password so the user will be able to change their password in SQL 2005. We are using a software that uses SQL authentication instead of Windows authentication. Thanks! Gene

Hello! I have DatabaseA. I have made a backup of it (DatabaseA). I also have DatabaseB (empty but exact the same struture with DatabaseA). Can I restore DatabaseA into DatabaseB? What are the pitfalls if I do this. Thanks! Gene

Hello! Where can I find the Query Analyzer in SQL 2005 or the equivalent functionality ? Thanks! Gene

Hello! Can somebody help me get a SQL statement to get the size of a table and the whole database? I am using SQL 2005. Thanks. Gene

Hello! Can somebody help me get a SQL statement to get the size of a table and the whole database? I am using SQL 2005. Thanks. Gene

Hello there! I have 2 Excel 2000 spreadsheets. One is a parent and the other is a child (Parent-Child relationship). How can I upload the spreadsheets to MS access so I can make see/make the data link. Thanks. Gene

Hello! How can I concatenate 2 cells with a carriage return between them? Manually, I know that it can be done by ALT+Enter. However, I need to make a formula so I can save it on a single cell (new cell contains 1st cell + carriage return + 2nd cell). Thanks! Gene

I've been working on justifying LDAP authentication over database and Windows authentication. Could somebody explain to me in a nutshell the advantage(s) of LDAP over Database or Windows Authentication. Background: Currently, we are using Windows authentication. However, we are implementing an...

Hello! I have made this SQL Statement Select *, substring(name,1,3) as examplename into #TempoCustomer from Customer How can I copy(export) the #TempoCustomer into Excel? I really appreciate your help on this. Thanks! Gene

Hello everyone! I want to replace a field in SQL by removing all of the spaces. Ex. Field1 = ' Italy, France' Desired Result - 'Italy,France' Thanks. Gene

What is the string function in SQL if I want to start getting the string from the end. For example: Intended Result Hamilton, ON, CAN -> CAN Regina, SK, CAN -> CAN Thanks! Gene

Hello! I want to concatenate 2 fields in one field. However, when I save it on the target field I would like to separate the 2 fields (that I will save on the target field) with a carriage return. Thanks. Gene

Thanks a lot Mike!

I am doing a data cleansing and most likely I will be using an update statement. Tel_Field = 551-9000 Province_Field = Toronto, ON I want to update a telephone field (with an area code) if the province field is ON. What is the function I can use for this scenario. Thanks for your help! Gene

Thanks so much! Gene

Hello! I just would like to confirm if GRTBK is the Macola GL Account Master table. I greatly appreciate your help! Thanks. Gene