On one computer I am getting the message "This file may not be safe if
it contains code that was intended to harm your computer.  Open It?" and
on my computer I didn't get that message when I opened the same app.
This was due to me setting security level low on my computer but ...

Hey All,
I have a report that I would like to show a word on based on if a
field is checked in a form. For example. The form has a check box
called Fee. If that is checked, I want the word Paid to show up in the

Dear reader,
In a datasheet form you have the possibility to hide or unhide columns by
selecting the form "Unhide columns" in the border on the top of the form. In
a datasheet sub form I can't select the "Unhide Columns" form.

I distribute an application to about 10 clients. It is written in
Access 2003. I use Win XP but the clients use Vista and in some, but
not all cases, also have Access 2007 on their PCs. They are all using
Access 2003 to open the app. Recently the main form has starting

What is the simplest way to make a report where only the records
where a field matches a certain date are included, and the user first
selects that date (from form or popup)? (I can write the SQL to select
the records I want...)

I have used DCount() to determine the number of records in a recordset.
Silly me ... I just noticed that DCount returns an INTEGER, which can
hold a maximum value of 32,767.  What if the recordset recordcount
exceeds 32,767?  Is there a different function that returns a LONG

THis may be an obvious question and I'm just having a brain cramp. If so...
Otherwise, I want to reference data from an unopened table. I have a table
set up named CompanyConstants which contains information such as default
hourly rates, the company address, logo file etc. I want ...

I have a query which I have to export in a DAT format.All the fields
have been formatted except for one field.This field I need to add
leading and trailing zeros.
example; if a number is like 1234 I have to get it to be

Hello all, I had this e-mail today from a user, and would like to get some
ideas to pass along. Many thanks, all! Andy
" my program is very very slow when more than two people are using the
program.   The database is installed on a desktop, which  is about two years

I have a fairly static odbc connect string that should be visible in a text
box on a form for reference purposes. It seems excessive to me to keep a
table with 1 field and 1 record to record this string. Is it advisable to use
a tag instead? I'm thinking of keeping the string in the ...

Heya!
I feel I'm beating an old horse to death with this question but I
can't get around the problem.
I want to update a text field on a form with a string from a VB

I put the following
Count([Item]) From tblPHPDeveloperDoItems Where [Resolved] = True
in a report footer. It's OK at compile time. But when the report
runs - it gives me an error. Is there something I can do differently

Hi, I'm after what seems to be a simple formula.
For example:
If Now() >= 10am then
    do this

Hi folks....I have been checking out this group and have found help
and solutions to everything I have needed up to this point.  I have
created a report based on a Query to show me certain activity during a
specific period.  When I run the report a prompt asks me for the start

I have a routine which checks idle time and opens a pop up screen to advise
users before shutting them down. The pop up has an option for the user to
keep the application open, in which case the timer is reset for another
period.