I am wondering if access 2000 does allow you to work with Xml (meaning
retrieving, Importing data)??
Has someone managed to do that?
Where could I find out more how it is done??

I am good at Access but know little about Access Data Projects.
I have some queries I am converting using IIF statemenets.  What is the best
approch for using IIF in a SQL Server view ?

When customizing an Access application for various clients, I have an
occasional need to go through my application to find and replace all
occurrences of a string (e.g. Change all references to [User1] field to
[User2] because the structure of a referenced ODBC database has ...

Hi there, I'm pretty new to Access and VB so I'm still having problems
getting my head around various things.
I have a recordset on a continuous subform, representing a number of items
to be ordered (Purchase Order or PO). The SQL for the query is.

I am working with class modules and have dedicated several to particular
tables in this DB project.  I am calling some of the functions within the
class objects directly without creating a new instance of the class.  I am a
beginner when it comes to working with class modules.

I'm developing a report filter that chooses existing reports, applies a
filter (dates) to it and prints it out.
My report-selector is a comboBox that reads from tblReports where title is
the report string manually entered.

I have a form that is in modal mode and it prompts the user to pick the date
using the date time picker control.
I want to exit from this modal form and go back to the main form, but I cant
see to figure out how to pass the date that the user picked back to the main

Just updated a database from Access 97 to Access 2003.  I am trying to
generate a data table (in Fox) and send it to another computer.  I get an
error message telling me
Can not find an installable ISAM.  Haven't run into this before, what is it

In a query i have the following in a criteria box.
strnames()
The function should be something like this (although of course this doesn't
work)

For most tables, I can stop the action query warning message
via this code:
Application.SetOption "Confirm Action Queries", 0
But it does not work for ODBC linked tables to an IBM Informix database.

I am receiving type mismatch error 13 on execution of the DeleteFolder
method. It deletes the folder, but halts execution. I can use On Error Resume
Next, but I would really like to know how to avert the error 13.
This is the line causing the error (see my other post from today ...

Good morning,
I've made some progress on controlling Excel using Access, including opening
a workbook and saving it as a different name (made from entries in my
frmNewProject object).

I have two tables: Boxes & Imported
These tables have the same fields as each other.
Is it possible to check each value within Imported.F6 and compare it with
the values within Boxes.F6

I want to create a function that receives a week number and returns the date
of monday of that week.
For instance, if i send week number 34 to the function, the function should
return 16/Aug/2004.

How do you set the Query Description property?
I'm creating a query in VBA, and I'd like to set the description property
to keep things straight.
The User Help wasn't too helpful.  I'm trying the following code: