I have a routine that emails a person when an issue is assigned to them.
Is there a way to include "in the body of the email" a link to open the
Access database on the network?
Below is my code.  It makes the link clickable, but it just brings up a

I have been struggling with trying to make the value selected in a combo box
of my form become the default value for combo boxes in subforms. On the main
form, my combo box allows me to choose the primary wood used in a room. On
the sub-forms I will choose the wood used in ...

I have isolated the records that I need in a recordset in vb I now want to
insert those records into the subform to give the users a head start on
entering the data that we need to store. What I would like to know is this:
Is an SQL "INSERT INTO" statement the easiest way to go - ...

Hello all,
I have designed a phone log database with a simple front end for callers to
pull up a screen that displays a persons name, address, and other personal
information along with options to select, depending on whether or not the

I am trying to edit a value the user is placing in a text box on the form.  
The value needs to be unbound, numeric, 1 character long between 0 and 5
inclusive.  When I use the KeyDown event, I can edit if the user presses the
number above the letters, but if the user presses from ...

I don't understand what is going on with the math and why this dosen'
work.
I have two fields:[MAX I Design] and [MAX I Calculated] and one calle
[Delta] that has the following as it source:

The Startup dialog box allows browsing and setting the location for an icon
Is there a way to set the ico path programatically - say when the
application opens?
Since users install the mdb in different locations

Hi all (again),
I am trying to add records to the subform based upon a selection in the
mainform. I am using the following code to try and get to the records that I
want:

I have a text field that I need to calculate the difference of two other
fields.  Here is my code:
In the source code field of "diff in hours" I coded
=[hours]-[paid_hours]

I installed the API: Manipulate Access Window from the Access Web, and it
was working fine.  I disabled it while I was developing my application, and
tried it yesterday, and now the Form I am calling the program from is also
being hid.  I can't imagine why this is occuring.  I am ...

I had replied to a previous post and haven't had any new answers.  Can anyone
help?  Here is the previous post.
It is working now.  I changed my data type to "Long Integer" and edited the
public statement to "as Long".    However, I need my box numbers to have a 0

I have several databases that I would like the User to be able to open up one
application, and have access to all the other access applications. (instead
of searching the network for the different one-offs application like they are
doing now)

I want to use code to import an Excel spreadsheet into an Access table.  I
can currently import the file manually (clicking) into an existing table or
into a new table with no errors.
But when I use this code:

I have Access 2003 at work, but Access 2000 at home.  When I zip up Access
2003 to work on it from home, I can't open it from home.
Is there a way that I can maybe convert the Access 2003 to 2000 and then when
I'm finished working on it from home I can convert it back to 2003?

I have a list box that uses the first name and last name fields. The first
name is displayed in the list box and the last name is hidden. The plan is
that when I click on the name in the list box and click the "show record"
button, it opens up the form to that record so that I ...