Skip to main content

Posts

Showing posts from January, 2013

Tips to increase internet speed in pc

clear cache Clear cookees,history,cache,data trafic,serch history etc try google chrome to use google products like gmail,google,google plus etc. delete temporary files. Go to run->write temp->del all files->den go again in Run and type %Temp% and del all files here also!! Use Disc cleanup and defragment utility of disc properties. Clean desktop items. Delete unused user profiles from document and settings folders.

search subfolders and Add hyperlink for file from the top level folder in Excel

To search subfolders and Add hyperlink for file from the top level folder using Macro code in Excel. You can take help from code below. Private Files As Dictionary Private StrFile As String Public Function FindFolder(strpath As String) As String Dim fs, f1, f2, FleCollection Set fs = CreateObject("scripting.filesystemobject&quot ;) Set f1 = fs.getfolder(strpath) Set f2 = f1.subfolders Set FleCollection = f1.Files For Each subfld In f2 FindFolder subfld.Path Next For Each fle In FleCollection Files.Add fle.Name, fle.Path Next End Function 'add below code before adding hyperlink If (Files Is Nothing) Then Set Files = New Dictionary End If 'Filename should contain Extension like "test.pdf" If Not ((Files.Exists(Filename))) Then 'replace c:\ with root folder of the file,if you are no sure about Root folder, You need to call it with all possible drives like "C:\" "D:\" etc ...

Excellent Financial Investment Calculator

I got one good site which is Excellent Investment Calculator for diffierent purposes. You can visit following link. http://investmentyogi.com/Financialcalculators.aspx By this site you You can get following calculators Income Tax Calculator,Home Loan EMI,Double your money Calc,Systematic Investment Plan,Recurring Deposit Calc,Life Insurance Calculator,Fixed Deposit Calculator,SIP Investment calculator,Final return on monthly SIP,Annuity Calculator,Retirement Corpus,Save To Become Crorepati,CAGR Calculator,Insurance Calculator Future Value Calculator,Inflation Calculator,Interest Payable Calculator,Time To Become Crorepati Housing loan eligibility,Home Loan Refinance,Financial Health Calculator,Investment Planning Calculator etc.

Machines can never be as intelligent as human beings

Machines can never be as intelligent as human beings, although it is just a matter of perspective! By the term intelligence, if you refers only the modelling of human behavior [weak AI],it might b possible with the help of a large computational power. But if u want to built the real intelligence [strong AI], the task is going to b tough. In 1980, John Searle introduced a famous thought experiment called Chinese room experiment. He argued that intelligence can never be attained with the blind manipulation of symbols, as suggested by "The physical symbol system hypothesis"[by Newell and Simon, 1976].The thought experiment is explained bellow. "Consider an 'intelligent machine”, which answers to questions asked in Chinese, back in Chinese. Then, given the algorithm of the machine, one who doesn't speak Chinese can also answer the Chinese qns, executing the algorithm line by line. But that don’t makes him know Chinese. Like this, the "intelligent" ma...

Create a New Drive for your Favourite Folder

Use the SUBST command to substitute a drive letter for a path in order to treat a virtual drive (a reserved area rather than an actual disk drive) as a physical drive i.e create a new drive for your Favourite Folder in MS-DOS Prompt. For e.g if you want to create a drive named Z for your Program files folder then u need to enter the following in your DOS mode : - subst z: "c:\program files" This will create a drive named Z in your My Computer so that you can directly access your program files contents from this Drive. You can also create a Separate drive for your separate folder for accessing data easily. For e.g Separate drive for your music folder etc.

Reporting Services Error User cannot be found

In case of SSRS  in SharePoint Integrated mode. You may have report server in SharePoint integrated mode and the Reporting services running under domain account. which will be part of domain admin group as well.but when you try to connect to http:\\localhost\reportserver it may give following  error: Reporting Services Error -------------------------------------------------------------------------------- Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help User cannot be found. -------------------------------------------------------------------------------- SQL Server Reporting Services and in reporting service log it gives me following information w3wp!webserver!1!8/15/2007-13:40:01:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> Microsoft.SharePoint.SPException: User cannot be found. at Microsoft.SharePoint.S...

Proclarity Vs SSRS ,Features enhancement points in SSRS 2008

Proclarity - ease of use; Dashboard and KPI capability; chart types etc., are better than in Microsoft. Also, Proclarity is something even Business users can use (we can create libraries as starting points and the business users can deploy onto a PAS server) SSRS - offers greater control over formatting, which sometimes can actually be quite frustrating because expectations from an SSRS report is also higher in terms of formatting detail. But SSRS cannot be used by business users; Also no dashboard or KPI capability within SSRS. printing capabilities SSRS have which proclarity doesn't have. In fact formatting in SSRS might be difficult to achieve but anyway its is better than Proclarity. The point where Proclarity is better is KPI and Dashboard reports. Once configured even SSRS reports are used by business users. Proclarity as one of my friends said is more of an analytic tool. Even the Ad-hoc report functionality of SSRS involves Report Builder is meant to be sh...

Institutes in Hyderabad for Oracle Apps R12 Technical course

RAJ Connexion Technologies ERP Training Center(Chandra Institute ESI) Ilogic Institute Appworld Institute Oracle images SPAM Technologies VISHNU TECHNOLOGIES iWareLogic Vivid Technology Wilshire Gensys (Himayat Nagar). Comp-u-learn institute SR Nagar. Vennela Technologies Pvt. Ltd. srihitha technologies ANEESH Technologies 4Bss Solutions Inferdata Computer Education Peer's Technologies Pvt Ltd Anitech Software Solution’s Webnology Institute SRISYS, Inc Applsys Solutions Gandam technologies in s.r. nagar Naresh Technology Sql star

Visual basic Examples-Adding items from listbox to database,Validating user name and password ,Primary Key at Runtime

Adding items from listbox to database First you need to write code for connection and recordset opening then you can set following code in your program for i = 0 to list1.listcount -1 if list1.selected(i) = true then rs.addnew rs!fieldname = list1.list(i) rs.update next i Validating user name and password from the database using visual basic Set con = CreateObject("adodb.connection") con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Persist Security Info=False" con.Execute ("select Username, Password from table1 where Username='" & UID & "'") If Not con.Execute("select * from table1 where [username]='" & txtUsername.Text & _ "' AND [password]='" & txtPassword.Text & "'").EOF Then MsgBox "Login Successfull", vbInformation, "Success!" Else MsgBox "Login Failed-Enter UserID and Pas...