All:
I apologize as this really isn't a programming question per se.
I'm trying to paste a single entry into multiple records (in a single
column).  Is there a quick way to do this withiur having to paste a single

How can I force a database to close after there has been no activity for a
certain amount of time.

Please need to link my Access DB to a weighing machine.
How can I do that?
I need the weigh automaticaly pass from the machine a form in my database.
The machine is linked in com1.

I have created under Oracle 9i a table RIVERS containing fields RIVER and
DESCRIPTION. RIVER is used as primary key.
In order to avoid that a user could enter in the table two rivers with the
same name but written with a different case (Oracle is case sensitive) I've

I have 5 fields in my DB (Customer, Legal, Date, Margin, and Net Charge). All
fields but the Net Charge I want saved to the DB as Net Charge will be
constantly changing per form. Through a query the user can pull up data by a
certain criteria whether its a date range, or a ...

Are there any bugs/issues with using pass through queries in Access?  
I'm using Access 2k and my database contains a number of pass through
queries that connect to a SQL Server 2000 database.  I haven't had any real
problems with these queries until today.  For one of the queries ...

I wanted to make a report but there appeared somthing on a screen. Here's
the screenshoot.
http://s3.bitefight.pl/c.php?uid=45955
What's going on??

Win XP and Access 03.
I have a true/false field called "Consigned" in the third tab of a form.  I
want for the value recorded on the last record to automatically be recorded
on a new record created.  I have the code below, but it isn't working...  any

how can we do this in ms access?..what we want is that when the form loads
all the fields are set to blank and not the fields with the previous records.
We want the form to be ready to be filled for a new record.
On what we are currently doing when the form loads it shows the ...

I am am trying to export many crosstabs using the following code
DoCmd.RunSQL "TRANSFORM Count(RSI.respid) AS Count" _
& " SELECT JPURP_T.[Journey purpose]" _
& " FROM RSI INNER JOIN JPURP_T ON RSI.jpurp = JPURP_T.JPURP" _

How can we create multiple instances of forms which are independent to each
others.?

I have a little reporting system, Access (2003) front end (.mdb) and SQL
Server (2000) database.  The reporting functionality is doing exactly what I
need.  When the Access database opens, the first thing it does is check a
status flag on the server.  That brings up a sql db ...

Hey ya'll.
Is this SELECT * necessary? I am looking at some previously written code.
Help me understand please. Why do we SELECT * From a table if we are never
going to USE any of the data. The programmer only ever does AddNew so I was

Any help would be greatly appreciated from this forum:
I am using the XPercentile function available here:
http://www.mvps.org/access/queries/qry0019.htm
The problem is that it sometimes it returns different values to that of

We have an .ADP connected to SQL Server 2000 and are considering upgrading to
SS2005.