Nadz-Blog

To resolve this issue you can use below workaround. Open the Excel Click 'ALT +F1' to switch to the Visual Basic Editor Go to Tools -> References Click to clear the check box of the library which is marked as Missing and then click 'OK' Or Restore the referenced file in the path which is shown in the dialog box Or  If the referenced file is in a new location,clear the Missing reference and Create a new reference to that  file.   This link provides the more information about this issue :  http://support.microsoft.com/kb/282331

If you need to prevent the user from typing in the windows application combo box, property called ‘Dropdown Style’ should be changed from ‘Drop Down’ to ‘Dropdown List’. Normally, default value of the ‘Dropdown Style’ is ‘Drop Down’ and this allows user to type in the combo box.

This article describes how to deploy multiple pl/sql files (.api, .sql, .etc) at once using command prompt. First of all you have to store names of the plsql fiels in a text file in below way and save it in the folder where your plsql files are saved. Then open the command prompt and  change directory path to where your plsql files and text file is saved. Then type below commands in the command prompt and press enter. sqlplus/nolog conn username/password@service_name Then write @ sign and drag and drop the text file to command prompt or type the path of the text file. Press enter button. Do not forget to type @ sign before the path of the text file. Now all oracle files included in text files are deployed in your oracle database at once. If there are any compile errors in your db files, those are shown in the command prompt clearly. If There are more db files, it is difficult to type all file names in the text file. So you can create a script for this. Ope...

What is Conditional Compilation? PL/SQL source code is compiled selectively based on the compiler directives. Therefore, in the compile time code can be different according to conditions. Why do we need Conditional Compilation? Using conditional compilation features, we can include version specific features to our PLSQL source code. Therefore, In any production environments which use different versions,  Code is compiled and application is running properly without any issue. Assume, in development environments, we have developed multiple components such as component A for finance, component B for manufacturing, and component C for Sales. Now if we call methods written in component B for packages in component C, there is no issue when compiling and running particular code since all the components are properly deployed in the development environment. But, assume one of our customers install only component C in production environment, now when compiling the codes it gives e...

Google has provided its users to create a simple and powerful custom search engine. You can follow below simple steps to crate your own search engine Go to http://www.google.com/cse Give URL of the sites that you need to emphasize when searching, select the language and give a name to search engine.  Then you  will get your own search engine.  Then Start to search :)) This allows users to get uninterrupted browsing experiences with speed and simple search.

Would you like to know that your computer is a girl or boy? If so Try this :) Open your notepad Copy and paste CreateObject("SAPI.SpVoice").Speak"Hi Darling, How are you"  Save as computer_sex.vbs Run the file Now what you  hear? If you hear a male voice you have a boy computer, if it is a female voice, well, you have a girl computer. I have a boy computer :)). How is yours??  Also you can get the name of the voice owner by including below code. Set VObj = CreateObject("SAPI.SpVoice") For Each Voice In VObj.getvoices I = I + 1 VObj.Speak "Hello I am " & Voice.GetDescription & " and Nice to meet you" Next