How do you programmatically obtain the workgroup path and workgroup name?
It isn't in the Application object, as I would expect it to be.

Is there a way in MS Access to input decimal degrees and have it convert to
degrees minutes seconds. Expression builder doesn't like any of the variation
I have tried. Can it be done in Expression builder, as a macro, or is there
another way to do it.

I have a form/button that issues VBA commands to run multiple queries, modify
some tables and finally open an Excel template.  The template is set to
refresh on open against one of the just created Access tables.  Now that I ma
confident everything is ok data-wise, I want MsAccess ...

I'm trying to have a command button look up based on 2 criteria based on
first & last names.  Works fine if I'm doing one or the other:
Dim FIRSTNAMEEXPR As Variant
Dim LASTNAMEEXPR As Variant

I hope someone can help me with this,I am trying to create a mail merge
from within my access database. The source of the data is a table which
I want to create mail merges based on a field name called Relationship
Manager. I want to open the word doc template and create the mail ...

I'm creating a tool in Access 2000 that will massage data (mainly adjusting
dates for weekends and holidays) from our corporate Oracle database so it can
be manually entered into someone else's website.  I have no control over the
Oracle database.  Here's the setup.  User enters ...

Do you know how to bypass the AutoExec macro of an MDB that you are opening
with the following code snip, just as if you held SHIFT down when you opened
it manually?
 Set App = New Access.Application

My between date is not working and I guessing my syntax is off.  Grrrr
syntax!  The cal1 and 2 is from two calendars on my form.  Thanks!
vSql = DCount("WORK_REQ_ID", "VIAWARE_WCS_TO_VIA_T", "DTIMEMOD Between #" &
cal1 & "# And #" & cal2 & "#")

Any body know of any downloads which will create the bare bones of a new
procedure in Access 2000 but which includes simple error handling. Like, for
example, when you insert an On-Click event from the properties form but with
user defined properties.

Is there a way to open and close the database window using Visual Basic?  My
database needs all outside users to not have access to anything but the form
displayed at startup.  I have accomplished this by turning off all the
startup options and disabling the shift bypass key. I ...

I am trying to do a trick on a continuous form (datasheet, tabular or
whatever). I am trying to mimic a Block Report or Pivot report. Since a
report is not as easy to interact with, I need a few features that forms
give. (Some reasons are resort on the fly, command buttons, ...

I need to use an if statment on two text box values. The problem is that one
of the textboxes is in a subform and I cant see the subform object in the
dropdown list and it does not pick up any syntex.
Any Ideas?

I am creating a VBA code that link a table from SQL to my Access file.
However, I am just a beginner so that if I want to update link whenever I
open Access file I have to run the VBA code.
Could any one help me to create a VBA code that whenever I open my Access

Can anyone tell me why the * wildcard does not work in the example below?
Rgds
Bruce
myDest = "C:\test\"      

From Access, I am running Word and doing a Mail Merge - automated with VBA.  
First time it runs fine.  Second time I get a 462 Error - "The automation
server is unavailable".  After that I close the Access app and all the Word
apps and start over. First try is good.  Each one ...