I built a Database application that used Access as its DB backend for a
library. Initially, the application was meant to support only routine tasks
of the library staff, and was not available to the public. However, it has
been so successful that the library has decided to allow ...

Through the years, I learned to develop a number of Access/VBA
applications. Just by using the help-functions, and the utmost valuable
discussions on many forums, I gained quite some knowledge in this field.
At one point, I'm totally a newby: the documentation of my applications.

I tried to uninstall the program "logmein" but I am unable to do it neither
from add/remove programs in control panel, nor by manually removing all
folders after a search.  I get a message "access denied" and "another
version of the pogram is running" while there is no other ...

when opening any excel file on nework, excel opens the same worksheet on
network everytime, even if I just open blank worksheet

Dear Sirs
I have a Form with a command button. The command button should have the
purpose to print the report to a file in PDF format.
The report has all end-of-month information from each customer.

I'm inserting into a database and need to know the number of records that
where entered and the number of errors, using this
    With CurrentDb
       .Execute strSQL_insert

In our office we struggle with the 2007 user interface. Personally I am
deal with the ACCESS the most. Here's what I say:
Previous version of ACCESS allow user to sort objects in modify date,
create date and even the description property. The 2007 version seems

I have a with field with yes/no values and need to count the number of "Y"
(yes)responses on a report.  What syntax/code can I use to count only the Y
values?

Is it possible to use a wildcard in the expression of a conditional
formating in a form.
I want to highlight the datafield (backgroundcolor) if the datafield
contains, for example,

Using Access 97 (and strongly considering SQL Server Express)
I have a data warehouse project that requires daily import of large
Excel files.  The files come normalized.  My issue is that i'm not
sure how to take the excel file and parse it into all the sub-tables

Phone field is text without input mask.
I want to enter 7 digits and have it appear as (   ) xxx-xxxx
I want to enter 10 digits and have it appear as (xxx) xxx-xxxx

Hallo zusammen,
wie kann ich in Access per VBA oder SQL (oder auf iiirgendeinem
anderen Weg) in eine bestehende Tabelle eine neue Spalte mit einer Art
AutoWert einzufügen.... also eine Spalte, welche die Datensätze von 1

You've been a great help to me in the past. I hope someone can here
too.
I have a database to which I would like to import data from a csv
file. Each csv file has about 30 different fields separated by commas.

On a sub report I have a field datetot which is the sum of two fields those
two fields are in turn coming from two further sub reports of the sub
report. How can I take the sum of datetot field to the main report?
Thanks

The 2007 Midwest Excel / Access User Conference will be held on October
24-26 in St. Louis, Missouri. Regular registration will close on September
30th. This event will be featuring Mike Alexander, Damon Longworth, Jon
Peltier and Bob Umlas.