I find that reports sometimes get "stuck" with filters that are applied in
VB scripts - probably from irregular exits, or maybe working while in
development mode?  Dunno.  I would like to refresh the filters before
opening the reports.  How can I do that.

I am having trouble figuring out why numbers, stored in a general number field with two decimal places are being rounded to the nearest whole number. I have set the properties in the table and the form to General Number with two decimal places and cannot find where this rounding ...

This one strikes me as odd, so I thought I would drop a line to see if
anyone else has come across it?
I have a form with an underlying table that can be used to enter information
about computer systems. One of the fields is for the MAC Address. I want to

Dear Sir
 I have used the following cmmonds in query
1:-   " is not null"
2:- SELECT tblProducts.ProductName, tblProducts.Weight

1. Two reports
2. Macro to open and print the two reports
3. Command button to click to activate the macro
Question. I would like to print 2 copies each of the two reports. How can I

  Can't the IN operator be used in a form module with an IF.. THEN
statement?  Help shows an example in an SQL statement and an IFF statement.
  Left(StyleID,1) yields a single letter string value...
   If Left(StyleID, 1) In ("F","M","N","T") Then

From: <ria@discussions.microsoft.com>
Subject: form linking
Date: Wednesday, September 08, 2004 12:23 PM
I have a form in which I have a list box (lookup table)in

Need Help. Using a Macro to import a dbf file
and after import I want to delete the orginal dbf
file. I remember a runcommand that used KILL to delete a
file outside of the database. Any suggestions?

I'm importing raw data from a text file into access. So to make it user
friendly, I'm trying to write an SQL query that renames the imported fields
in each column to a more user friendly name. Here is one example:
SELECT Stats.Database, Count(Stats.Database) AS [Number of Times ...

I am new to access and am losing my mind.  I am trying to set up a simple
database that will keep track of PTO members and the committees they would
like to join.   I think I have the database set up correctly...in tables with
following fields:

We have an Access application (written by someone else who is no longer
here) for our Purchase Orders. The file was custom written in Access 2000
(not a template) and generally network users use the MDE file, which is
periodically replaced to prevent getting too large, etc.

Dear sir
I want to see only those fields in report, which are not  
empty.
 When I use "is not null" in the query below all the

please help me in this case i need a Balance entry by
entry in Reports
DebitAmt      CreditAmt           Balance
1,000.00           0.00           1,000.00

I'm kind of new at this-I'm trying to link an excel file
directly into a query.  This is my first programming
attempt.  Two things-when I run it I get a message:

Hi there - I am very much a pc novice.  What I need is a very very basic
database, just names, addresses etc.  I want someone else to be able to
access it remotely so have put it in my 'briefcase' - probably another way of
doing it but this seemed simplest.  What I need to know ...