I'm getting a subscript out of range error when trying to pass arguments via
OpenArgs.  This is my code in my first form.
Private Sub Job_Type_AfterUpdate()
   Dim MyOpenArgs As String

Hi everyone and Merry Christmas,
I have an interesting reference number that I'm trying to program that will
display on a form.  I hope I can explain this enough.  there are a total of
14 characters in this number.  The first 7 are static, the the next three are

I have created a button using a box and put label (text) on the box. I have
grouped these two controls and want to addresss the group as one so that I
can create the illusion of clicking a button. (down/up mouse). I know how to
create the Event Procedure, but how do I address the ...

I have tried a couple of methods to get these forms linked together.  I
finally got the subform to be updateable but I still can't seem to get it
linked to my main form via the Job_ID.  I have a presentation on this due
tomorrow. . . . God help me!!

I'm looking for a way to provide a user with the option of changing the sort
order of the query behind a form.  Any thoughts?

I implemented a wizard that dynamically updates the sub forms when Next is
clicked.  I would like to automatically select a certain item in a combo box
in one of the sub forms.  The combo box is filtered, so it only has one item.
Is there a way to select the first item ...

I have added the code below to a report.  When viewing the report in Print
Preview mode, the group footer totals are correct.  However, when the report
is actually printed, the group footer total values *double* in value.
Is this a bug in the Access Print Preview process (an extra ...

I want to be able to auto correct upper and lower case in feilds on a form in
access
i have tried 2 methods of strings found in help fields here however neither
option works.

Hello i'm trying to read data from a table in a loop and put it in a long
string so i have code that looks like this
data() = Records.GetRows(Records.Properties.Count)
   For i = 0 To Records.RecordCount

I found a great sample that I am currently using in a form. I have an
inventory listing shown as a data sheet in a subform on a main form. At
this time, the user chooses a location from a combo box on the form and
the code filters the subform resaults to only show the location in ...

I have a combo box that I use to select an associate and I want to email that
associate a message.
I've set the record source to:
SELECT ID, Name, EmailAddres ....

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
customer name.
For example if ABCCo has a visio diagram when you open the form with the

I am using a list box on a form to enter data. The list box is refreshed vie
requery when the user leave another control. I always show the choices in the
list box for the current record plus "other item" by having this as an
alternative in the query for the list box. I want to ...

When the user press a button on a form,
i want to send a mdb file by email
How can i do that?
The docmd.sendobject has no attachement option

I need to run this procedjure the number of times that TxtDisplay equals.
If TxtDisplay =1 the it runs once
If TxtDisplay =5 then its five
I think the the problrm is with the first line.  Any input appreciated.