I have a database with customer information. I would like to add a
button
that will dynamically open a visio diagram of their network based on
the

Any advice on this would be most appreciated.
Using VBA code in Access 2003, is there a way to insert a fully
functional hyperlink inside of an Office Assistant help bubble?
Thanks folks,

I have a client with an Access 97 format switchboard based application.
This app is shared across several offices which are being upgraded in
sequence to Access XP.   Recently XP users started having the startup
switchboard halt before any items are displayed. Access 97 users still

What I would like to do is input a range of serial numbers in a form
and have that range populate in the table without me having to put them
in one at a time manually. The numbers do not exist yet, either. I'm
not sure how else to explain it.

i would like to navigate my form with arrow keys by jumping to the next
control or previous control when ever i hit the up,down, left or right
key.
this works fine as long as i do not click on the field with my mouse or

First thanks for your time to read and maybe respond to this question.
I have a new client with an ADO database on a server being used by
three users.  Not split, everyone uses the same one.  So I made a copy
of the database, changed the name on the original (as a backup) and set

I am importing two excel spreadsheets into access table 1 and table 2,
the two  spreadsheets have the same fields, i would like to join or
merge these tables giving table 3 so a user can write to the table via
a form,

Hello How can i add 1 to a string in a query, is there somethig like
char to int in sql?
thanks.

I need to package one of my access apps and send to clients. My app calls
outlook to send emails. The problem is that client pcs can each have a
different version of outlook (2000, xp, 2003 etc.). How can I package my app
that it will work with any version of outlook?

Am using a nested continuous bound subform to add multiple records to the
underlying table. One of the fields is based on a limit to list combo box.
Any suggestions on best way to progressively update the combo box query so
that for each new record being entered the combo box list ...

I use Terry Kreft's & Stephen Lebans colour dialog procedures for users
to pick colours for various control properties in certain apps.
Is there a way to take the colour code that is displayed in a
backcolor/forecolor/etc property and calculate the "reverse colour"?  In

I am doing so data validation, and need to check if a filed contains a
valid date in the format of "YYYY-MM-DD"
I would like to know if it is possible to convert this series of If's
to a Select Case. I am having trouble incorporating the various

Does anyone know a good site where I can find a MS Access forum so I
can get additional info about dB design with Access.

I have a form that calculates age when you enter the DOB. Everything I
enter on the form gets input in the table. However, the age doesn't get
input. How can I get it to input the age? I know I'm being vague, but I
don't know how else to explain it. Please help.

How do I import data from an excel sheet to an access database table
,excluding the columns that are hidden ?
Also this worksheet is among one of the three other worksheets in a
workbook,so how do I specify just this worksheet while importing?