Basically, I want to do a Copy Down function, like in Excel.  How do I do
this in Access?

I collect reports weekly from an automated system.  I save the reports as
individual tables in Access.  All of the fields are identically names.  I
need a query that will look through the newest table and comparer it to the
prior table (I know that part may be manual) and show ...

I know there is a way to increase the amount of documents you see when you
open Access and see the Open menu with 4 forms.  Can someone tell me how to
increase that amount?  Thanks!

Using the Field List pane, I dragged the primary key field of my 'one' table
to the datasheet view of my 'many' table.  Then I went to the 'show
relationships' tab and double-clicked on the line between my two tables.  A
box popped up showing the one-to-many relationship where I ...

 I want to run append query if the screensaver appears,is it possible ?

I just spent several hours building a rather complex query. When I use Docmd.OpenQuery "LookupGeneralDiscount",acViewDesign in the
Debug window it opens the Query just fine. When I use print CurrentDb.QueryDefs("LookupGeneralDiscount").Name I receive the message
"Item not found ...

Greetings all,
I am not a programmer who would appreciate any assistance available.
I have a table with 2 fields I have made combo boxed.  Field 1 - staff
contact; Field 2 - local government.

I am setting up word templates for my work. I have inserted a full page
background image (45k) into the first page header of the template. The
"Different First Page" box is checked.
This image causes MAJOR slow down of word. The type lag is so bad it makes

MS Access2k: I have a column in a table that is "hyperlink column" and the
actual file name is in each record in that column. When I run a report, it
lists the filename on the report, when I export the report in HTML and pull
up the HTML file, the links are all "http://myfilename ...

In our database, we forgot to include a time stamp field to indiczate when a
record was created, so we are trying to determine if there is some internal
time stamp for record creation that exists and can be accessed so that we can
go back and determine when a record was created.  ...

I have a client who wishes to have 42 areas on the form in which he can enter
the number of calls verified per day.  His team is supposed to enter the
number of each area they have done on a given day.  He wishes to have all 42
shown all the time and the agent will enter 5 for ...

Using Access 2000 I have used the database splitter no problem. When I go
into my front end I get the menu I have put in place but when I hit the
database window button or F11 all I get is a blank screen, same thing if I
hold down the Shft key whilst opening so HOW do I find my ...

Hi every body,
I'd like to to capture a waypoint in a Access form in real time and I don't
know how to do.
I'll be in a boat to do water sampling. I want to plug my Garmin GPS to a

Using this method found on the boards below from Ofer Cohen to pre-fill some
fields onto a second form I get an error message "Type Mismatch":
You can pass the fields values using the OpenArgs, put a seperator between
them, like ($) Something that wont come up in the string

Hello. I have linked tables from As/400 and every time I use this tables I
must introduce my password for As/400. How could I avoid that?