How do I use VB to create some code behind a button in one database
that will add a field to a table in another database that is not open
at the time?
The target database is C:\NewDB\statistics.mdb

I have a subform that has a command button to move to the next record.
If there are more records i would just like to move to the next
record, When the last record is reached I would like an action to take
place (havent decided what yet).

I preview a report and click the button to publish the report to
Word or Excel document. It works correctly until today. It
produced below error message.
Microsoft Office Access can't complete the Output operation.

I'm using the following code to retrieve some data from a seperate DB:
    Dim con As New ADODB.Connection
   con.Open _
       "Provider=Microsoft.jet.oledb.4.0; Data Source=\

Is there a way of adding more than the 8 items to a switchboard on
Access 97? If so how?
Colm

I have a database with one table (tblTest) which has two columns (id
(int) and ts (date/time)). In this table I want to select all records
between to times using the following query:
SELECT * FROM tblTest WHERE (ts >= #1/1/2007# And ts <= #12/31/2007

One of my clients is having a problem where users will be kicked out
of an Access program.  Six out of the seven users have an Access
runtime.  The seventh user has Access 2003.  The data lives on the
server in an Access database.  All users have XP machines.  Two of the

I currently have a button once clicked, invokes the following:
If Address_Select = -1 Then
     Forms!ProspectForm!Address = [Address]
     End If

I have a column in a table named "Hospice". I have a make table query
that pulls in this column but renames the column in the result to
"Hospice (Yes/No)". The column name in the resulting table is
"Hospice(Yes/No)", and the query design (after being saved) also shows

I have a application that links to several sql tables.  To improve
performance I want to have a seperate database with an autoexec macro
that when opened, connects to a ODBC data source and export three SQL
tables overwriting the previously exported tables.  Once that is

Any straightforward way to open a form with multiple subforms, where the
main form and all subforms are opened in readonly status?
If I run
    docmd.openform.......,acreadonly

Using Access 2003 SQL Server 8.0
I have a link to a View on a Sql Server.  The View does a sum of
inventory quantity --  sum(Quantity)  as Qty --
When I link this view to my databalse Qty shows up as Text with a

What is the correct way to code this?
I'd like to change the value of a field on the main form with the
value of a field on the subform using the click event of a command
button. I currently have the button on the subform.

I have 2 tables:
Table Users:
   ID
   Name

I would like to put a button on a form that will load up a website
the website bing
http://www.business-post.com/scripts/wsisa.dll/ws_refquickpod.html?lc_SearchValu
e=ORDERNUMBER
Where ORDERNUMBER is a field on the form