Enter your email address:

Delivered by FeedBurner



Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Saturday, November 26, 2011 – Permalink –

Forms and Slides

PowerPoint in Access


This download provides an Access database and a PowerPoint slide show.

"Create a PowerPoint slide presentation from scratch using Access data. In addition, display and control a slide show from within an Access form. Walk through the solution and explore ways to extend the sample for your own applications.

This article looks at two ways of interaction between Access and PowerPoint.

The first sample illustrates how to create a PowerPoint presentation from the data in an Access table using Automation.

The second sample shows how to display and manipulate an existing PowerPoint presentation inside of an Access form, also using Automation."

Here is an MSDN article:
Working with PowerPoint Presentations from Access Using Automation

If you have some knowledge of VBA, you can probably figure it out from the code on the Access Form.



Office 2003 Sample:
Working with PowerPoint 2003 Presentations from Access 2003 Using Automation


See all Topics

Labels: , , ,


<Doug Klippert@ 3:16 AM

Comments: Post a Comment


  Saturday, November 19, 2011 – Permalink –

Sample Queries, Forms, Reports

Examples to part out




This sample queries database contains examples of useful database queries, including the crosstab query, the union query , and the join query

Sample: query topics database

Here are some other sample databases. They are all for Access 2000, but the installed base is predominantly in that format. Access 2000 is also the default format for Access 2002 and 2003.
Sample Access databases that you can download and adapt

Database of Access 2000 sample forms
The sample forms in this database demonstrate a variety of form types and techniques, including how to manipulate data, use controls, and create undo and redo operations.

Some forms include:
  • Bring a subtotal from a subform to a main form
  • Create a running sum
  • Create a stopwatch form
  • Display line numbers on subform records
  • Fill current record with data from previous record automatically
  • Hide the combo box drop-down arrow
  • Simulate drag-and-drop capabilities
Database of Access 2000 sample reports
The sample reports in this database demonstrate a number of techniques, including how to shade every other row or every nth row in a report, how to create a table of contents or an index for a report, and how to create a top 10 report.



See all Topics

Labels: , , , , ,


<Doug Klippert@ 3:08 AM

Comments: Post a Comment


  Monday, November 07, 2011 – Permalink –

Cascading Combo Boxes

Everything's connected



"Cascading combo boxes are used to help aid the user in determining a choice when entering data into a form.
They help to breakdown the options available into selectable sub-groups such a State & City, Product Type & Product, Department & Employees.
The user can select, for example, Customer Services in a combo box and the second combo box's list will reflect this selection and only list those employees within Customer Services.
Switch to Finance and all the Finance employees become selectable, etc."


A cascading combo box solution:

Roger J. Carlson

CascadingComboBoxes.mdb (beginner)
CascadingComboInSubform.mdb (intermediate)


See all Topics

Labels: , , ,


<Doug Klippert@ 3:44 AM

Comments: Post a Comment


  Tuesday, November 01, 2011 – Permalink –

List box filter

Multiple selections



Filter a Report based on List Box
Fabalou.com:
"How to open a report based on a multiple selection in a list box. For example, you may have a list of makes of car and a report that shows various details for each make of car. You want to allow the users to select a range of cars and pull up the report according to that selection."


Microsoft KB:
How to Use a Multi-Select List Box to Filter a Form

Customize a list box, combo box, or drop-down list box



See all Topics

Labels: , , , , ,


<Doug Klippert@ 3:53 AM

Comments: Post a Comment