Search results for query: *

Thanks HughLerwill. That was really helpfull. It solved my problem. Actually i did try this earlier but the i was putting a blank space between the Workbook and sheet name. Many Thanks once again.

Hi, I am dumping data in Excel Sheet which is then used by another application (Also using DDE). OLE Automations locks the Sheet for some time which causes both applications to hangup. My DDE Solution is working fine only that now new requirements from client need nformation to be placed on a...

I have a VB Application that communicates with Excel using DDE to pass data to excel. I use the code below and it works fine and outputs the data to Sheet1. Text1.LinkMode = 0 Text1.LinkTopic = "Excel|test.xls" Text1.LinkItem = "R1C2" Text1.LinkMode = 1 Now i want to out this to...

Thanks Stsuing.. i have just migrated to web development so i was thinking as i do it in desktop application.. Thanks for the tip...It solved my problem.... One more point to this...i declared an integer type variable at class level and initialized it in the page load...now when i was testing in...

Hi i have created a ASP page and declared a dataset at class level. I fill this datase at a push button1 code. After this i try to use the same dataset object at another push button2 event but it says that the dataset is empty (Nothing) Here is my code Public Class WebForm1 Inherits...

Hi every one i have win98 and winXP on my machine. I accidently ran an exe file which was infected with win95.cih virus. Now when i rebooted in Win XP my NAV 2002 gave me messages that the whole win98 partation is infected with this virus. It says that its unable to repair this virus. i cant...

Hi I am facing a problem with RDC componenet of CR9. I have created one Visual Basic form where i created a CRAXDRT report object ONCE and then on pressing a button on the form my code sets the Viewer control on the 2nd form and opens the report. I change the selection formula whenevr the button...

Hi I m new to my SQL. Ihave been using SQL Server and MS Access in the past. Can any one tell me if My SQL has a graphical interface like MS SQL server and MS Access. Whcih would allow me to visually manipulate database objects and also desighn queries/views visually. Thanks Asim

hi fechen have u found a solution to this problem yet?

I have an MDI application (MFC App Exe) which is linked with an MFC Extended Dll in which i am exporting some classes to be used by the application. Now what I want is, the bussiness logic is implemented in the dll and I call that method from the application. Now there is a progress control on...

hi i had created a query from a table that contains memo fields. now if i run simple query like SELECT DISTINCT memo_f1,memo_f2,memo_f3 from TblXYZ then the query executes perfectly fine on some Computers and fails to run on others and gives the following error message: " Cannot...

thnaks TomKane but i need a solution using a query i.e using a DDL statement. I already have solution from VB but mine is by using ADOX object. Below is the working for it. Which may be some help to u as well. Dim m_NewCat As New ADOX.Catalog Dim m_Command As New ADODB.Command...

Hello I want to create a Query in Access using a query. I mean just like a Create Table statement wt would be the statement for Creating a Query in Access db. I have used it in SQL server using the statement Create View but cant seem to figure out wt it would be in Access and the Access...

hello I have a question concerning Microsoft MSN messanger. Can any body tell me how can i get IP of the person i m chatting with without actually starting any file transfers or voice chat sessions. Once a person sent me my IP through messanger but i was unable to get how he did it. Can any...

which version is it. Any other solution apart from Gant Charts..

Hi I need to print a schedule in a format similar to Cross Tab report. But i dont require summarized fields. My data contains date values and time values and against this there exist some information fields tike name etc. Now i need to diplay this information in way that against each date and...

hi I still havent got the solution to the problem. Can any body plz help me out. [sadeyes]

i think you havent got wt i meant. wt should i set the App.Path of. I need to pass the database location to the report so that it takes data from the location. My report is based on pdbdao.dll database dll. And i cant use any DSN

Hi I have created report in Microsoft Acccess. Normally my report and database reside in the same folder. Now i have to change that by calling the same report based on same Database that resides in another folde. Now my problem is how do i tell the report in Visual Basic application where to...

Hi I have written a function in a module for access that returns a string value. Now when i call the function from a query written in ACCESS query editor then it works and executes perfectly. But when i pass the same SQLStatement from my VB project it gives me that the function is not defined...