I'm in the midst of a database project for a client: Big contract, so I
splurged
and bought a new machine, running Vista Business. I've installed both Office
2003 Pro and Office 2007 Pro. It seems to take the two versions fine,

I have created a data base for my company and now I would like to net work it
for thr33 work stations and a server.  Can it be done. If so, How do i do
this?

I'm sorry..I've never seen this newsgroup until now
why is this newsgroup called daovba.ado?

I am opening a second Access database from within an Access database.  The
problem I have is that I cannot get the second database to maximize.  It
opens at postage stamp size.  The code I am using is
   Set appAccess = New Access.Application

I want to run a query from a button on a form. It is a normal select query
and i want to display the output in datasheet form But I need to set the
Window or form in which it appears to maximized and dialog mode (i.e. popup
and modal both set).

I'm just dying on this one.  I know that there are other, perhaps better
options (RecordsetClone, Bookmark, Find, Seek), but I am getting stubborn at
this point and just want this SIMPLE method to work:
On a form I created in Access 2002, I type the word "Test" into the

Currently I have this expression in a query:  expression: ([expr]-[chrPFP])*
(0.3)*([SumOfdecProductionHours])
There is another field in the query that is [chrProgramShortName]
I would like my expression as it is above, however for the

Is there a way to create a relaationship between tables in my vba code?
I want a relationship from Table1!Field1 to Table2!Field2
via VBA...
Maybe you can't work with relationships in VBA, because I find nothing in

I have a chart on a report.  When the report is opened a query runs that
prompts the user for criteria.  The user has to type in a program name.  The
report data will reflect only that of this program.  I want there to be a
text field on the chart (preferrably as the chart title)  ...

I have a split database deployed to several different users on Windows Server
2003.  Some users link to many back ends in different file locations.
My problem is with a Hyperlink form.  When a hyperlink is created by "User
1"  from "User 1" location, the hyperlink works perfectly ...

I have problem writing the strCriteria declaration, the following is my code.
I guess my strCriteria declaration is incorrect, any help will be appreciated
Private Sub Form_Load()
Const strTableQueryName-“test_qry”

I am trying to compare a date within a recordset.  I have changed this code
around several different ways and my field ("DateSelected") in the recordset
is always null even though I know it's not.  Any help on this is
appreciated.....below is a chunk of my code:

I have been dabbling in writing VB for Access 2003 for a while now and a
question that has been bugging me is whether or not a SQL statement has to
end with a semi-colon. Any SQL I have looked at that Access generated (ie -
from a query) ends with a semi-colon. I have written a ...

A "ParentForm" has 2 sub-forms - "SubFormA" and "SubFormB". How do I call a
procedure on "SubFormB" from "SubFormA"?

I want to import (move, copy, or however/whatever I can do) a table from
db1.mdb to db2.mdb
The tables are the same structure.  I just want to programmatically 'put'
all the data from table1 in db1.mdb into table1 of db2.mdb