I have a form, where I want to be able to print a drawing that is used in the
application volvo view. I do not need it to open it but print directly from
my access form. Do I just specify the location in the print command or how
would I go about doing that?

I really like a lot of the features of the new split form view; however...
I think there are a few properties and methods missing.  The problem is that
these are really 2 different forms pretending they are one.  The controls are
in two places, and there is no way to reference ...

I have a form with 3 ListBoxes.  Clicking on the first ListBox will populate
the second ListBox.  Clicking on the 2nd ListBox will populate the third on.
Here is my isse.  When I click on the 1st ListBox a second time (I've
already clicked on the second ListBox after I clicked on ...

Here is a bit of a head scratcher...
I have a combo box whose data source is an SQL statement I build in code.
Part of the SQL statement uses the Format function to make the data in the
list Yes or No.  The Syntax of the data source is:

Anyone know of any problem that might cause loss of access to the
immediate window in Ac2003.  It seems to have suddenly disappeared,
and I can't access it from menu bar or from Ctrl+G.
Thanks, Richard

Where is a good site to tell us what will be broken when we "upgrade"
to 2007?

I have the add-on to allow saving objects as xps & pdf. Could someone
post an access module/vba script that demonstrates how to export an
access report to pdf? Its easy enough to do manually, but I would like
to program my form to allow a user to save to pdf without any required

Apologies for the possibility of a misleading title, but I am struggling to
explain this in one short sentence, but I think this long standing problem is
affecting my sanity...
I have a continuous subform (linked to a master table of records) with a

i am looking to be able to format information returned in a query according
to the users desires. i was thinking about how in excel i can create a custom
format according to the string that i create to format it.
does anyone know of somewhere that might have code that i can adapt, ...

Here's the problem that I'm up against:
I have an append query.  When I run the append query, it says that it
can't add records due to a key violation.  I check indexes on the
table and review the data.  This set of data does not exist anywhere

I was wondering if you can help me it may be a very silly question but here goes:
I was asked to 'lock' one of my databases (I am used to creating databases not finishing them).  I have searched the internet and my access book and I really can't seem to be able to find how to ...

Hello.  I have hit a wall on this one.  There is a process that when a user
clicks the Submit button, there needs to be a check made in a directory on
the network to see if there are files located in the directory.  If there are
files with .txt or .Description extensions, these ...

I have an Access 2003 database from which I have automated the
emailing
of a report each Friday the first time the database is opened.
I run the following from the on Timer event when the DB is opened:

I need some option to call a procedure similar to msgbox, get info from the
user, and resume.  The info I need from the users is more complex than what's
offered through the msgbox function.  How can I go about writing a procedure
that would mimick msgbox but use my own custom ...

Hi every one, I have a combo box that looks up data in a form, I have 3
columns:
ID, WEEK ,ORDER
When I set up the combo to look for the firts column, ID it works fine but