FoxPro Zone

    Microsoft ZONE

  • FoxPro

 
Article Author
Applies to: All versions of Access Level: Intermediate

Introduction:

One of the things all of us tend to loose sight of is that what we think of "Access", is really a couple of different components working closely together. Access is made up of a user interface and objects (forms, reports, and macros), JET, which is the default database engine, and Visual Basic for Applications (VBA), which provides a coding language. Because of this, there are certain things that you would expect to work somewhat the same, and yet are very different.
...
Article Author
Introduction

I often hear the opinion that "Access isn't fit for serious applications". Finance is of course very serious... and extremely serious in Switzerland; needless to say that I never expect much business from that particular branch. The main reasons are of course security and volume. You don't want numbered account information travelling on a laptop, and you won't handle a million daily transactions or fifty thousand cash distributors with Access. Let's be serious.

But there are also many small financial institutions like fund ...
Article Author
Introduction

Concatenation is always explained in a footnote, or as a section of something else. It is rarely explained as such, as a concept. I was making exactly that mistake in another article, when the section started to outgrow the core topic... I still needed some time to realise that concatenation is a topic.

This article is specifically written for expressions on reports (and forms). Everything said here holds true for queries (the syntax is slightly different) but not everything for Visual Basic. In particular, the handling of quotes and newlines is ...
Article Author
Introduction

Printing labels is one of those things that can be surprisingly fun or extremely tedious, depending on the program being used.

The first time I had to teach "labels", it was fun. The program was WordPerfect -- some antique DOS version without even a print preview feature -- and it was fun because it was easy, and it worked. Before the morning break, every student had printed a first sheet of "fake" labels, in reality photocopies of an original with hand-drawn rectangles.

...
 
 
Zone Advisors

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
 
WordPress 2.9

Have you upgraded to WordPress 2.9? Tell us what you like—or don't like—about blogging with this new version.

 
 
[x]
Neglected Question
Neglected questions are any questions that either have not yet been addressed by an expert, or a solution has not been awarded, and may be eligible for bonus points (see your profile page for details).
 
 
Loading Advertisement...
ADVERTISEMENT