hi. I work with laptop at home and desktop in office
and I use external h.d. to update from one machine
to other put i feel I'm loosing data here there whats
the best way to update ive searched the help in access

I'm trying to set up a search button on a form.  I went thru the
FindRecord macro wizards and it's not working correctly or maybe it is
and I just don't understand all the arguements I have to enter in. The
table to search for is Shops and the Field I want it to search for Shop

I have a database that is used by several people,
all who have access runtime on their machines.
They currently need to reconfigure the search
screen evertime they do a find, where I - who

Insert a LIST into each line of 2nd file - WILL PAY $$$!
Sorry if I am not technical enough in what I am about to describe...
I have 2 files. One of them has about 80,000 lines of data.
The 2nd file has 10,000 lines of data.

I have posted this problem a couple of times over the last few years
but have been unable to find a solution that works.  Sometimes charts
in reports will display showing the design data instead of the actual
query data the first time they are opened.  If the report is closed and

I am using the DetectIdleTime code from MS to shut down an app when not in use for a certain time.
http://support.microsoft.com/?kbid=210297
I use a hidden form FrmDetectIdeTime with a timer event running the code.
But with some reports after having a printpreview on screen the form ...

Has anyone else noticed this?
In A2K, I can write a query like this:
select tbl.* from (select * from tbl)
If given a chance, the A2k query designer will rewrite that into A97 syntax:

Hello ya'll ...  I've been searching through this forum and can't quite
find the answer to my question.  I have a form (vacation) with a
subform (a log that shows a summary of what was changed on the vacation
form).  The subform is in datasheet mode.  The subform is basically a

Is there a nice way to select every entry in a list box
without having to click and drag across every line
Thanks
John Fox

I have a unique situation that I'm not sure how to solve:
I have many fields but I only want to change one field.  For example.
Field 11
972.00^05001200^

I have an A97 database table (tblCorrespondence] in a database
installed at 2 sites. The table's key field [CorrespID] is not a
natural key - its an autonumber field. Here are the values at the
2 sites. First, site #1. Then, site #2. If you plot them, you'll see

I have a form with 20 fields.  When I place my form in EDIT mode, I
want all the
fields to have their BackColor set to Yellow.  Can this be done without
having

I have a form Form1 that displays surveys. This form has a subform1
which displays questions related to a particular survey. This subform
has a subsubform which displays subquestions for a particular question
for a particular survey.

Could anybody tell me how to display currency as £'s rather then $'s ???
Thank you !

Hello friends, I have a good question for you.
I have a form in Access with a check box named chk1.
On the same form I have a code that export my data to a template in MS
Word. I use bookmark to export my access data. No problem with regular