I'd like to put a link to an access database on our intranet.  Mostly
just for our users to have a quick link and not have to make a
shortcut for their desktop.  It is a simple database, no security .mdw
but it is a split database.  When a put a straight link to the .mdb,

Does anyone else find the Access 2007 Navigation Pane a pain?  Maybe
I've missed something but I've made the following frustrating
observations:
The Navigation Pane won't remember the last object used in a different

I have a subform that displays in datasheet view.  I have a notes
field on that form that I want to automatically text wrap and make the
line double height, is this possible?

Hi after adding a field to a table through VBA
How do I create a foreign key constraint/relationship between this
field and a field in another table - and enforce referential integrity
through VBA code.

I have 2 users who ran into a problem with a data entry program
(written in Access 2003).    One user was keying into one of the forms
when she got the message  "ACCESS Error Number: 3218 Could not update;
currently locked'.  About the same time, another user was keying

What is the difference between Visual Basic and Access XP VBA?
Thanks

What's the best way to launch MSPAINT c:\image.bmp
from a VBA procedure. Seeking the route with the least
number of complications. Hopefully there will be no more
complications than if I clicked START and typed in the

I am trying to calculate the two different time field. When I entered
in field like 7:00 and 15:00 the result is 8 hrs but when I entered
15:30 the result is also 8 hrs. I am using the following VBA code
Private Sub TimeToDay_AfterUpdate()

Forgive me for asking this question, I've trawled through nearly every
available post on this subject that I can find for a few weeks now but
nothing quite points me in the right direction.
I'm quite new to trying to mess around with VB and ADO within MS

I have an application which is written in Access 2003, with a SQL
server 2000 back end. The application uses a lot of VBA, as well as
quite a few macros.
We are about to upgrade to Office 2007. What are the main issues I

Hello together,
I want to calculate a sum in subform from a subsubform (sounds
complicated?) but I get an #error but... see below
My database:

Does anyone have an access report that will do dymo labels? It seems the
paper size would be similar to an envelope, since dymo's print landscape.
Looking for an access report that will print them well regardless of how
many you're printing at once.

Hi !!  I'm developing a small Financial Accounting Program & need to
enter & track the foll vouchers:
1) Purchase Vouchers ... prefix of PV
2) Journal Vouchers  ...   prefix of JV

I would need help to create a little ms access database adn wondering
if there would be someone ready to give me a hand on this.
thank you very much in advance

I am trying to change the forecolor of a field in a subform that is in
datasheet view.  I am using Access 2007.  I have tried everything I
can think of to do this but the text still appears in black.  I need
it to appear in red if the field has the word "YES" in it.  Is there