Is there a preferred method for archiving redundant client records, without
actually deleting them, so that they are automatically excluded from
Queries/Reports etc, but the data remains on the main table & accessible for
future reference, if ever required.

I am looking for code that will allow the user to export a query to Excel,
however first receive a Save As prompt.  The DoCmd.TransferSpreadsheet
acExport code requires a file name to export to.  Is there code that will
export without having to specify a file name in the code, ...

I would like to write VBA code to hide any duplicated data. I start the code
with query the data from table.
For example:
      sqlcmd = "<query>"

I have a list in SharePoint that spuits out to MS Access and we
generate a report. simple. However, the one "summary" field displays
the SharePoint site's tags such as:
<div><font face=Arial size=2>, some &nbsps and some other things. It

I need the STARTTIME below formatted to display two separate fields in a
query.  Field1 will be NewDate and Field2 will be NewTime.  The STARTTIME is
from a GPS device in GMT.  I need the new date and time to display in current
time (GMT minus six hours or MST).  Also, when the ...

good morning
I have a report that shows a list of 97 'categories' pulled from a table
titled 'categories. I had performed a test to see if I could add new
'categories' to this list and then went back and deleted the entry. After

I have a table that stores very simple sales data by product by day as below
Sales Date  Product  Sales
05/01/08    Widgets    5
05/02/08    Widgets    7

Has any one come across a solution for the problem described below?
thanks for any help
JeanBC
Jack  Access 2007 will not paste data correctly.  When pasting data into a

Please help!
In the afterupdate event of a combo box I set an unbound control to the
value in column 2.
       Me.txtCRAmtAdjusted = Me.cboClient.Column(2)

I can not open a file.  Error message is : path is not valid, check spelling.
My backup files also do not open.  I have not changed anything.  Where
should I look to make any changes to file spellings?  
This problem seems to happen every few months although I never touch the

I have a subform in which I allow the user to enter a hyperlink to other
files (MS Word or PDF documents).  So obviously when a user clicks on the
hyperlink, the file will open.  Right now I have it set up so that my report
simply shows the hyperlink location.  What I would like ...

Hello    My folders are in a network drive, How can I password  protect all
folders?   Besides my self one other person may have access to my folders.  
Is this possible   thank you

I am trying to link pdf files to my form so that when the record source on
the form changes the say the primary key, the pdf file will change.  I have
named all of the pdf files to match the primary key.
for instance my path to the object is C:\windows\1111.pdf

I use the following reference on a subform and it works fine when I pull the
subform up on it's own but when I pull up the main form and access the field
in the subform, it pops up with a field indicator like it doesn't know what
is going on:

Just loaded Access 2007 and can't turn on automatic value incrementing of a
blank field. This was very handy in Access 2003, to enter a series of numbers
into a blank field just by holding the Enter key.
Is this feature gone now?