Unofficial Access Stuff

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

Host your Web site with PureHost!

Sunday, July 26, 2009 – Permalink –

Fiscal Year in Access

Make up your own year

You can show a custom Fiscal Year starting June, 1 and ending May 31.

BeginFiscalYr = DateSerial(Year(Date), 6, 1)

EndFiscalYr = DateSerial(Year(Date) + 1, 6, 1) - 1

Also:
Calculating a future or past date in Access

See all Topics

access
Labels: Functions, Tips

<Doug Klippert@ 3:29 AM

Comments: Post a Comment

Saturday, July 18, 2009 – Permalink –

Auto Form

Just add Data

Highlight a Table in the Objects Table view.

Go to the main menu bar and click on Insert.

Towards the bottom of the menu, you'll find an entry for
"AutoForm"

Click on it and Access will create a data entry form based on the selected table.

When you close the AutoForm, you will be asked if you want to save changes.
Click Yes.

(In 2007 go to Create>Form)

The default name will be the name of the table. If you are using Hungarian notation, change the name from

"tblCustomers" to "frmCustomers"

and click OK.

Also see:
Hungarian Notation

See all Topics

access
Labels: Forms, Tips

<Doug Klippert@ 3:48 AM

Comments: Post a Comment

Thursday, July 16, 2009 – Permalink –

Access-Excel-XML-HTML

Transfer data

XML makes data transferable between applications.
Here is a tutorial with downloadable files.

Some simple guidance of how to transfer data from Excel or Access into HTML web pages using XML data files. VBA programs can be used to export data tables from Excel or Access into simple XML files. There are several examples of using different methods to display the XML and XSL files on web pages in order to quickly share your data with others.

An introduction to Excel and XML data files

Also:
Some nice photos and calendar layout:
Monthly calendar with photos

See all Topics

access
Labels: Tables, Tutorials

<Doug Klippert@ 3:55 AM

Comments: Post a Comment

Wednesday, July 15, 2009 – Permalink –

Restore Defaults

Office 2003 redo

To reset the original settings in Office 2003, follow these steps.
Make sure that you back up your files before you follow these steps.

1. Start any Office 2003 program.

On Help menu, click Detect and Repair.

Click to select the Discard my customized settings and restore default settings check box, and then click Start.

Quit the application, and then click Ignore.

Click OK when you receive the following message:
Reset of setting to default succeed.

Microsoft Office Diagnostics in 2007 replaces Diagnose and Repair:

Howtogeek.com

See all Topics

access
Labels: Tips, Troubleshoot

<Doug Klippert@ 3:30 AM

Comments: Post a Comment

Sunday, July 12, 2009 – Permalink –

Plain Numbers

I'd Like to Make It Clear

Plain Figures is a method of transforming statistical and financial data into figures, tables and graphs that people readily understand.

Have you ever:

squinted your eyes trying to see the numbers in a PowerPoint presentation?

scratched your head at a charity leaflet with an indecipherable pie chart titled 'Where your donation goes' ... and set it aside?

missed discussion at a meeting because you were busy trying to figure out the figures?

put aside a graph or table, thinking "I'm not good with numbers."?

Then you know how important the clear display of numerical information can be. Common problems People have trouble using numerical information for many reasons. Most commonly, authors don't know:
what to include: when unsure what numbers are important, people frequently display them all, overpowering the reader with irrelevance.

which format to use: the choice between text and table, table and chart, bar and pie.

how to use the technology effectively: computer software generates graphs easily, but the results hide your point behind incomprehensible chartjunk.

how to explain the information: selecting the right words for titles, columns and captions.

Plain Figures is a partnership between Sally Bigwood, located in Wakefield, Yorkshire, UK, and Melissa Spore, who divides her time between Toronto and Saskatoon, Canada. Sally and Melissa are sisters and both have dual citizenship in the United States. PlainFigures.com See all Topics access
Labels: General, Tips

<Doug Klippert@ 3:01 AM

Comments: Post a Comment

Saturday, July 11, 2009 – Permalink –

A Hoard of Tips

Good for all levels of user

Allen Browne's tips for Access users

Here is a list of the sections on this site; something for everyone.

Casual Users - basic tips and explanations;

Serious Users - ideas for forms, combos, reports, and code;

Flaws in Access - unfixed bugs that will bite you;

Traps to avoid - problems that may not be obvious;

Specific Applications - a couple of examples where people get stuck;

Tips for xBase developers - for people who used the old dBase;

Functions you can use - code to copy;

Upgrading - issues when changing versions;

Other sites - links to other sites with free Access tips.

See all Topics access
Labels: General, Tips

<Doug Klippert@ 3:19 AM

Comments: Post a Comment

Wednesday, July 08, 2009 – Permalink –

Polyglot Polynomials

ToolPak Translator

I was disappointed recently when I tried to look up Eric Desart's ToolPak translator. I found his site "niet beschikbaar."

I won't use the boy and wet thumb story, but Ron de Bruin did spring up to save the day and make the download available.

"Ever wanted an oversight of the Analysis-ToolPak Add-In functions, their descriptions, their arguments, their VBA and Procedure names, and all of this in your LOCAL language including translations versus the corresponding English names?

This utility extracts this data from your LOCAL MS Excel edition.

As such this table can be generated for ANY LANGUAGE EDITION of MS Excel, even when this language is not yet integrated in the utility."

Analysis ToolPak Translator

See all Topics

access
Labels: Add-in

<Doug Klippert@ 3:02 AM

Comments: Post a Comment