when i try to use the docmd line to print to screen a report in access, it
doesn't work unless access is open, even tho the connection and recordsets
work for everything else.  HELP

Hi, does any know how I can go about remove a set up unwanted characters from
the Account Description field below. I need to keep only the characters
before the ",,," commas.
Thanks,

After installing my app onto a users computer I get Activex component
Cannot Create Object. What swrong?
Please give me  a clue!!

I have developed and distributed a runtime version of a database using Access
2003 & developers toolkit. On all the PC's I have distributed the db to, I
get an error which appears to be related to a macro I have created to record
the time an entry was made. The macro is attached to ...

I've just started using the Office XP Packaging Wizard.  When I start it and
add a database file (Access 2002 format),  I get the following:
The file that you specified could not be opened.  Possible reasons for this
include:

Can anyone help me with a rounding error in a calculation?
I have a database that the user enters a whole number and this field iis
multiplied by a decimal number. I do not get what would be expected.
Here is one of the calculations

I have an "Inventory.mde" file which I am running with ART2003.  It does not
recognize or pickup the current date (Date()) in this mode.  If it is run in
standard Access 2003, everrything is fine.  I am date stamping my data
records and must have this functioning.  

I am getting towards the end of my MS Access 2003 database product, which I
wish to distribute.  I understand that  there is a visual tools for Access
Developers for packaging and installing a runtime Access, and that it doesn't
sometimes meet everyones requirements.  So, I have ...

Hi, all
   When I was developing with "SQL Server", I always used a utility tool
"Profiler" which is shipped with "SQL Server". This tool is used to trace
the trasactions and communications with a specified server.

All,
I have a database on a shared drive that three users shall be working with.  
Can I simply bundle up the files needed for runtime in an Installation
Package and get the users to install it?  Or do I need to have a database in

Is there a way to sort or group stored query names through some tool or
add-in?  Or perhaps a way to import the names to a table to be sorted from
there?  I have hundreds of queries that need to be cleaned up and documented
and I want to be able to search and sort them.

I've created a rather small application and I am having a slight problem with
one client who is using Runtime.  The MDE I'm using is created from an Access
2002 db, and the Runtime is 2002, so that shouldn't be the problem.
The problem is that I open up a few forms within the ...

Does anyone know how to obtain the location of the currently running Access
2002 .exe in a runtime environment? I need to create Icon sshortcuts during
an app install and configure and need to path to the msacess excutable to do
this.

Hi,
Do you have any idea how to workaround an runtime
error '3000' with a reserved error (-1517)
I´m using a recordsed to add records in a table with the

I have this code to enter values from a form into a table:
'Generate a revenue for this entry
Static db As Database, RevRec As Recordset, TempRec As Recordset, ChargeRec
As Recordset