Search this site
Embedded Files
Skip to main content
Skip to navigation
ICB Consulting, Inc. Kbase
Knowledgebase Home
Epicor Prophet 21
Inventory with quantities on hand in more than one bin
Orders With A Disposition of B That We Should Be Able To Ship
SQL for sales summary report
SQL to import budget into Epicor p21
Transfer backorder report
Indusoft
ICB Consulting Home
ASP
ASP code to connect to a SQL Server Database
ASP Code to detect browser type
Connect to an Access database and run a query
Create a button that opens another web page using vbscript
Create a recordset from sql server stored procedure
Format a datetime field to show only the date value
Format current system date in asp so you can query sql datetime field
Pause or wait function in ASP
Posting data from one web page to another using asp
Syntax to query an Access database date field using asp
Update sql command errors out if text field has a single quote in it
Using a Chase Paymentech Hosted Pay Page
Using Google reCAPTCHA version 2.0 using classic asp
Crystal Reports
Commonly used Crystal Report formulas
How to do an "all" option with Crystal Reports parameters
Split a single name field into separate fields
Dynamics CRM
Activity Status Codes Explaination
Add a hyperlink to opportunity in a SSRS Report
Create a copy of your CRM Organization
Custom report built using report wizard on fresh CRM 2011 install doesn't run
Edit The Ribbon in CRM 2011
How Do I See All Activities Under An Account?
How To Make Someone a Microsoft CRM Deployment Manager Using SQL
How to modify default filter in Activities Associated View
Installing CRM 2011 on Windows 2008 Server - Must open port 1433
Introduction to Creating Custom Reports in CRM 2011
Javascript Library
Common Javascript Functions For CRM 2011
Javascript to Create A Contact In Microsoft CRM 2011
Javascript to create records in CRM
Javascript to default a date/time field with Today's date
Javascript to grab a field value and display in message box
Javascript to hide a section on a CRM form
Javascript to retrieve ID for current record and display in message box
Javascript to retrieve the value of the price list in a CRM quote
Javascript to set a text field in CRM 2011 to a certain value
Javascript won't update read-only CRM fields without special syntax
Javascript: Set value of a field equal to another field in MIcrosoft CRM
Phone number mask for Microsoft CRM 2011 using Javascript
Key Introductory Information About Microsoft CRM 2011
Map custom field on quote to custom field on sales order
Microsoft CRM Customizations and Add-Ons
Moving Microsoft CRM to a different server
Security permissions required to install Microsoft CRM
SQL Functions for Binary to Base64 conversion
SQL query to retrieve notes from Microsoft CRM database
SQL to insert a new account into CRM
SQL to insert new contact into Microsoft CRM
SQL to query tickets (service cases) in CRM
Step by Step Guide to Migrating CRM 4.0 to CRM 2011
Training materials on CRM
20 Tips You Have To Know About Microsoft CRM 2011
Customizing the Look and Feel of Microsoft CRM
General tips on making the most out of CRM 2011
How to improve the Microsoft CRM 2011 search box
Understanding CRM views
Using CRM marketing lists
Untested functionality - need to test
Updating a user's default organization using sql
Using A SiteMap Editor To Customize Look of CRM 2011
Where do custom entities get stored in the Microsoft CRM database?
Which contacts in Microsoft CRM get synched to my Outlook?
Dynamics GP
Assign 1 inventory item to every inventory site using eConnect
Create a customer record using econnect
Create a sale order in GP using econnect
Delete the reminder about customer service participation
Deleting open transactions in PDK
Dynamics GP Tools That Are Not Well Known
Error message when you copy live company to test company
FRx Login/Configuration Issues
Giving someone access to everything in Dynamics GP but payroll data
GP 2013 Web Client Features
GP Extended Pricing Database Tables
Grant Access to Smartlist Builder Object
Help Documentation on Dynamics GP canned reports
How to modify GP home page
How to query the Dynamics GP general ledger in SQL
How to see who is logged into GP
Management Reporter Data Mart missing Transactions
Management Reporter-Remove Report History
Microsoft's Sure Step Project Management Methodology
Payroll-Calculate Checks error
Publishing a custom SSRS to the Dynamics GP home page
Reset the Dynamics GP system password to blank
Setting a default selling unit of measure in Dynamics GP
SQL Query To Check For Inventory Items With Incorrect User Defined Category Field
SQL query to summarize pay stubs
Troubleshoot sales batches in Dynamics GP that won't post
Troubleshooting Dynamics GP role based security
Unable to change an inventory item to enable lot tracking
Using the Visual Studio Customization Tool For Dynamic GP
Adding a GP modified form to a VSTMenus VB.net project
GP Visual Studio Tools Installation
Using VBA with Dynamics GP
Basic Tips On Using VBA with Dynamics GP
Removing a specific field from VBA project
Web Client Login Error
Workflow 2.0 Adding additional tables to Workflow Conditions
How to to insert records in sql
HTML/Javascript/CSS
Basic Tips on Securing A Website From Hackers
Basics of using CSS
Basics of using Javascript
Confirmation popup message when someone clicks a button
CSS to overlay text on top of a background image
CSS to round corners on an image
Datatables options
Force a page break when printing a web site
Good web sites and tools to help with web development
Highlight values in an input box when someone puts mouse in it
HR html tag not printing when using CSS
HTML borders
HTML table border without the double lines
Internet explorer table widths don't display right
Javascript Calendar date picker that works
Javascript code to disable the right click menu in web browser
Javascript drop-down box for navigation
Javascript to automatically submit/post a form
Javascript to create a nice popup window from a hyperlink
Javascript to limit maximum length of textarea
Javascript to rotate images in a website
Javascript to set value of another field based on select choice
Javascript to stop form submit
Open a form post in a new window
Place an image behind a web page
Print a list of links using document links object
Print a web page automatically (IE Only)
Print A Web Page Automatically Using Firefox
Print button on a web page
Print button that prints only what's within a div tag
Print multiple pages at once using javascript
Print only a portion of a web page
Responsive HTML table that works on an IPAD
Tips for using Google sites
How to use CSS in Google sites
How to use Javascript in Google sites
Using custom Google Gadgets to enhance Google sites
Tips on using Jquery Mobile Framework
How To Do A Responsive 2 Column Grid in Jquery Mobile
Responsive Table using Jquery Mobile Framework
Linux
Common Linux commands you need to know to manage an Amazon EC2 Linux server
Configure Amazon Linux server to send SMTP emails using gmail
Getting LetsEncrypt SSL certificate to work on Amazon EC2 Linux server
How to install SSL on a Linux server
Miscellaneous
Brother DS600 scanner failed to calibrate
Configure remote printer on Windows Terminal Server
How to remove malware and viruses from your PC
Microsoft Online Services
Onedrive: how to rename folders to remove # from folder name
Schedule an Amazon AWS Snapshot Using WIndows Powershell
Send a text to someone's phone using email
Setting up a DNS record on a single server using HOSTS file
Step by step to configure an amazon cloud server to host a website
Troubleshoot SMTP error message Action delayed 4.4.7
MySQL
Basic maintenance commands
Differences between stored procedures in mySQL and MS SQL Server
MySQL compared to MS SQL Server
PHP
Common PHP Functions
Configuring PDO / SQL Server setup in PHP
Configuring PHP.ini to send emails using Exchange (Windows)
Converting from ASP to PHP
Custom Error Pages with PHP
Execute a SQL Server stored procedure with PHP and capture return parameter
Execute a stored procedure with parameters using PDO
Form Post to Amazon S3 Multiple File Upload At Once Using PHP
Form Post to Amazon S3 using PHP
How to fix rounding problems with PHP variable
Installing PHP on Windows IIS Server
Managing PHP sessions
PHP Recordsets Using PDO
Subtract 30 days from a date
Use PHP PDO to execute parameterized select statement
Use PHP to create an ADO recordset with SQL Server
Sharepoint
Sharepoint versions
VBA code to insert records into a Sharepoint database list
What is Sharepoint?
SQL Reporting Services
Run a SQL Server Reporting Services Report From a Web Page
SQL Server
Convert a datetime field to only show the date portion
Create Linked Server to MYSQL
Create text files from SQL Server data
Delete SQL Backups Older Than A Certain Date
Dropping a table in a SQL Server Stored Procedure
Example of pivot query
Generate a text file and FTP it using a SQL Stored Procedure
How to convert a date/time to midnight
How to create process to backup SQL Express Database
How to manually shrink a sql log file
Query an Access database from SQL Server
Search a SQL database for tables and fields that contain a string
Search SQL database for every table and field that contains a certain number
Send an email with sql code
SQL Function to Strip HTML from a field
SQL Server Administration Topics
Administering SQL Server Indexes
Data Collector in SQL Server
Data compression in a SQL Server database
Key SQL Server Security Concepts and Pre-Defined Roles
Managing concurrency in SQL Server
Managing SQL Server database schemas
Managing SQL Server database schemas
Monitor SQL Server locks
Moving SQL Server database files to a new location
Overview of high availability and replication options
Partitioning large tables in SQL Server Enterprise
Policy based management of SQL Server
Querying Other Databases From SQL Server
Resource Governor in SQL Server
SQL Server Agent
SQL Server Audit Tools
SQL Server Browser Service
SQL Server Bulk Copy Program (BCP)
SQL Server Data Encryption
SQL Server Data Import Methods
SQL Server Database backups
SQL Server Database Engine Tuning Advisor (DTA)
SQL Server Database Mail
SQL Server Database maintenance plans
SQL Server Database Snapshots
SQL Server DBCC maintenance commands
SQL Server error logs
SQL Server Full Text Indexes
Starting SQL Server from a command line
Transparent Data Encryption
Use DBCC to Clear the Process Cache
Using SQL Server Dynamic Management Views (DMV)
Using SQL Server Profiler
Using the EXECUTE AS statement to overcome security
Using the FILESTREAM data type in SQL Server 2008
Sql to analyze table sizes in a database
SQL to Determine if A Date Is A Month End Date
SQL to determine number of working days in a month
SSIS Script to move/rename/archive source files
Standard syntax to use a cursor in a stored procedure
Syntax to query a remote linked server
Unable to Connect to SQL Engine using Windows Authentication
Using the EncryptByPassPhrase Function in SQL Server
Using the RAISERROR command in stored procedure
VB.net
Retrieving selected item from a listview
VBA
"Refresh All" Command on Access Menu
ADO recordset against an access database
Another way to refresh all forms in Access database
Capture error messages in VBA
Create an Access form tied to a cross-tab query
Disable the shift key upon startup of an Access database
Error 2501 Outputto action cancelled
Extract Hyperlink from Excel cell
Get RDP Client Workstation
Merge 3 PDF files together into 1 PDF file using VBA
Move cursor to start of text field when clicked in Access database form
Open a file with VBA
Permission denied error message when using Sendkeys in Access
Refresh issue with an Access continuous form with new record
Reset all autonumbers in an Access database
Run Spell Check In Access On One Field In A Form
Scan multi-page documents into an Access database using single sheet scanner
Send an email from Access database using gmail
SQL insert command fails if your data has a dash ' in it
Update a subform's recordsource in an Access database
Update the row source of a combo box in a subform
VBA code for a yes/no message box
VBA code to create an ADO recordset in an Access database project file
VBA code to detect windows user id
VBA code to determine the week number during the year using a date
VBA to check if a file folder exists and if not create it
VBA to create an ADO recordset against a SQL Server database
VBA to determine the name of a user's default printer
VBA to find where a file is stored using the file name only
VBA to identify the name of a PDF file that a user has open
VBA to open a PDF file and print only certain pages
VBA to open Access report and print it to a PDF
VBA to print any file
VBA to turn duplex printing on or off from Access
VBScripting
Good tools to test a web service
Open a text file and edit line items
Query web service using form post (example 2)
Querying a web service using vbscript (virtual XML file)
Querying a web service with vbscript (Base64Encode password)
Querying a web service with vbscript (form post)
Querying a web service with vbscript (SOAP 1.1)
Using VBscript to send emails to Office 365 account
ICB Consulting, Inc. Kbase
SQL Server
Code samples and troubleshooting tips for SQL Server.
Report abuse
Page details
Page updated
Report abuse