Mohamed Sathak Engg College  : http://alumni.msec.org.in/  

SQL Server 2005 -2008 Upgrade Process Plan

VB Run-time Errors

This blog is useful for VB Developer ErrorList

Designated trademarks are the property of their respective owners

http://www.racelinecentral.com/

Troubleshooting Tips and Tricks

Sometimes I am surprised by how the most basic troubleshooting steps can lead to resolving an issue. When I am mired in an issue, these are five of the steps I come back to time and time again.

1. Does this occur for all users? This can help to identify if it is a workstation issue or user issue. For this reason, it is always important to test for an issue as both 'sa' and as a normal user.
2. Does this occur for all companies? This can help identify if it is a data-related issue, or a system-wide issue.
3. Is it due to a third party product or customization? Disable it using Microsoft Dynamics GP menu-Tools-Customize-Customization Status (it will be disabled only for the current user, and only until they relaunch GP), and then attempt to recreate the issue.
4. When did the issue start? Identifying other activities around the same time (e.g., updates, system changes, etc) can help to pinpoint the cause or a contributing factor.
5. Witness the issue, follow it step by step. This can help to identify an issue that is the result of miscommunication or misunderstanding regarding system functionality. This step is often skipped, and yet it is critical to avoiding unnecessary back and forth to attempt to resolve the issue.

This list is definitely incomplete, but I thought I would share these five key steps. Please post your own as well :)

Christina Phillips is a Microsoft Certified Trainer and Dynamics GP Certified Professional. She is a supervising consultant with BKD Technologies, providing training, support, and project management services to new and existing Microsoft Dynamics customers. This blog represents her views only, not those of her employer.

Useful Shortcut

Common Tasks with Run

Below are a list of commands you can type into the Run dialog:

Run Calculator	calc
Run Command Prompt	cmd
Run Firefox (if installed)	firefox
Run Internet Explorer	iexplore
Run Microsoft Word (if installed)	winword
Run Microsoft Excel (if installed)	excel
Run Microsoft Outlook (if installed)	outlook
Run Notepad	notepad
Run Wordpad	wordpad
Open Control Panel	control panel
Open Program Files folder	%programfiles%
Shutdown Windows	shutdown
Restart Windows	shutdown -r
Log Off Windows	logoff
Registry Editor	regedit
Task Manager	taskmgr
Windows Update Launches	wupdmgr

Creating Your Own Run Commands

If you are like me, you will use a few programs very frequently. One way to make them start faster is to give them their own Run command:

1. Win+R to open the Run dialog
2. Enter %windir% to open the Windows directory
3. Alt+F W S to open the File menu, choose the New menu item, then the Shortcut menu item
4. Go through the wizard to create a shortcut to the desired program
5. The name you give the shortcut is what you type in the Run dialog to start the program

Infrequently Used Run Commands

Below are a list of commands you can type into the Run dialog, split into several categories: programs, control panels, computer administration tools, and special folders.

Programs

Character Map	charmap
Check Disk Utility	chkdsk
Clipboard Viewer	clipbrd
Free Cell	freecell
Hearts Card	mshearts
Microsoft Chat	winchat
Minesweeper	winmine
On Screen Keyboard	osk
Remote Desktop	mstsc
Spider Solitare	spider
Telnet Client	telnet
Windows Magnifier	magnify

Control Panels

Accessibility Controls	access.cpl
Add Hardware Wizard	hdwwiz.cpl
Add/Remove Programs	appwiz.cpl
Administrative Tools	control admintools
Automatic Updates	wuaucpl.cpl
Date and Time	timedate.cpl
Display Properties	desk.cpl
Folders Properties	control folders
Fonts	control fonts
Fonts Folder	fonts
Game Controllers	joy.cpl
Internet Properties	inetcpl.cpl
Keyboard Properties	control keyboard
Mouse Properties	control mouse
Network Connections	control netconnections
Network Setup Wizard	netsetup.cpl
ODBC Data Source Administrator	odbccp32.cpl
Password Properties	password.cpl
Phone and Modem Options	telephon.cpl
Power Configuration	powercfg.cpl
Printers and Faxes	control printers
Printers Folder	printers
Regional Settings	intl.cpl
Scanners and Cameras	sticpl.cpl
Security Center	wscui.cpl
Sounds and Audio	mmsys.cpl
User Account Management	nusrmgr.cpl
Windows Firewall	firewall.cpl

Computer Administration Tools

Computer Management	compmgmt.msc
Device Manager	devmgmt.msc
Disk Cleanup Utility	cleanmgr
Disk Defragment	dfrg.msc
Disk Management	diskmgmt.msc
Disk Partition Manager	diskpart
Dr. Watson System Troubleshooting	drwtsn32
Driver Verifier Utility	verifier
Event Viewer	eventvwr.msc
Group Policy Editor (XP Prof)	gpedit.msc
Local Security Settings	secpol.msc
Local Users and Groups	lusrmgr.msc
Performance Monitor	perfmon
Resultant Set of Policy	rsop.msc
Scheduled Tasks	control schedtasks
Services	services.msc
Shared Folders	fsmgmt.msc
System Configuration Editor	sysedit
System Configuration Utility	msconfig
Utility Manager	utilman
Windows System Security Tool	syskey

Computer Administration Tools

Application Data Folder	%appdata%
Home Directory Drive	%homedrive%
Home Directory	%homepath%
Shared Home Directory	%homeshare%
Temporary Folder	%temp%
Windows Root Drive	%systemdrive%
Windows Root Directory	%windir%

Download 002. GP_DEMO_RBI Setup.pdf for free - Ebookbrowse.com - Ebook Search & Free Ebook Downloads

Download 002. GP_DEMO_RBI Setup.pdf for free - Ebookbrowse.com - Ebook Search & Free Ebook Downloads

Excel 2007: "There was a problem sending the command to the program"

f you have ever tried to open an excel document and received the error that says "There was a problem sending the command to the program", you can fix it by doing the following:

1. Open Excel 2007
2. Open the Menu in the top left
3. Click the "Excel Options" button

   

4. Click the advanced tab on the left of the options screen
5. Under the general options uncheck the box "Ignore other application that use Dynamic Data Exchange (DDE)"

   

   
   

   Courtesy by : Josh Davis: Business Intelligence Consultant