Search results for query: *

There are Starter and Developer editions of the updated Northwind database available. The templates use the new Modern Charts which may not render if you are running an older version of MS Access. There are lots of great coding examples and a huge amount of documentation. To download the...

A quick google search for "Cascading combo boxes" returns lots of hits including this youtube video. Duane Minnesota Hook'D on Access MS Access MVP 2001-2016

Does anyone understand the difference between CountS and CountL in Analysis ToolPak which seem to work the same unless there are ties? In case of a tie, CountL will duplicate and CountS won't. Is there some documentation for this (asking for a friend)? Duane Minnesota Hook'D on Access MS...

This is the word from the MS Access development team today regarding the query errors generated following a security update: Duane Minnesota Hook'D on Access MS Access MVP 2001-2016

This question is actually for a colleague (really!). Let's assume we have a worksheet [Sales Data] with sales data for all sales people and then one or more other sheets with pivot tables for analyzing the sales data. My colleague would like to: Filter the pivot tables for a particular...

Link to article. Duane Vevey, Switzerland Hook'D on Access MS Access MVP 2001-2016

Is there a syntax for using IN () with multiple columns? For instance: CREATE TABLE [ColorSizeQuantity]( [nchar](10) NOT NULL, [Size] [nchar](10) NOT NULL, [Quantity] [int] NOT NULL ) ON [PRIMARY] GO INSERT [ColorSizeQuantity] ([Color], [Size], [Quantity]) VALUES (N'Red ', N'L...

thread702-1756246 Duane Hook'D on Access MS Access MVP

As a Microsoft MVP I received this announcement that I thought might be of interest to fellow Access users who have some suggestions regarding the software and its features. Duane Hook'D on Access MS Access MVP

I expect there might be a better method for handling this. I have an Excel 2010 workbook with a worksheet named "Left Right Data". On another worksheet, I have a drop down in range("cbofacGrp") that allows the user to query the records/rows from Left Right Data. The filtered records display on...

I am tasked with running a SQL script that creates tables, views, stored procedures, etc for a corporate application. We are attempting our first installation using SQL 2012 and have run into an issue with RAISERROR. There are 26 instances of RAISERROR in the script similar to the following...

I'm attempting to create a query (probably cte with recursion) that would take a bill of materials (BOM) and identify all parts used in a finished product. I have searched the web and found a lot of recursion examples for org structures etc. but they don't seem to meet my needs. I have a table...

I do a small amount of programming/coding in SQL Server (mostly 2005). I have a table of scheduled events and would like to create a query/view of Jan 1 to Jan 31. I need a date to appear even if there are no events scheduled on that date (using a LEFT JOIN). There seem to be several...

PH has recently passed the 1,000 stars received in the Access Queries group. This is quite an accomplishment in any forum. PH has posted over 31,000 replies in all forums in Tek-Tips and been awarded over 5,300 stars. Great work! Duane MS Access MVP Ask a great question, get a great...

I just returned from the Microsoft MVP Summit in Redmond where the Senior Vice President of Office announced and provided a live demo of all Office 12 applications creating PDF format files. Don't expect to see Office 12 on the store shelves for about a year. MS is listening to its customers...