This SQL UNION works...until I place the order by statement in the mix.  I
need the order by to sort Num-Alpha fields...Any help Appreciated.
Thaks
DS

I'm developing a simple program for a friend of mine. The scenario is that he
uses 2 email clients. Lotus Notes (Default) and Outlook 2007. The problem I
am facing is that he needs to be able to send an email through Outlook. I've
used the SendObject command which will ...

I have an application where users pull records from a common table which acts
as a queue. The problem I am having is that different users are pulling the
same record. I do have a locking mechanism which I have tested and it works
flawlessly. This locks other users out while ...

Using Access XP.
I have a "Menu" form containing 4 to 8 teachers names (depending on the
number of subjects taken by a student). The student clicks on a command
button associated with a teacher's name so the student can fill-in an

Here is the code, I have split the search criteria because it was just too
long and I have no idea how to work around that:
Private Sub Command212_Click()
Dim strWhere As String

The combo box is in the header section.
Control Source: (is blank)
Row Source Type: Value List
Row Source: "Option 1";"Option 2";""

AfterUpdating a control in my forms detail section, The
detail-field_AfterUpdate event is triggered and calls another function that
directly re-populates an unbound text box in the forms header section via a
DAO SELECT reading the detail-fields from the underlying table.  Even ...

I was wondering if it was possible to delay the autofill in a combo box?  
For example, if I was selecting color, I would type "R", but it could mean
either "Red" or "Royal Blue" - currently, if I was to type "R", RED would
show in the field, but I would only want RED to appear if ...

I am attempting to pass a large amount of text to a field when I close a
form, however, the text is being cut off, usually ending in weird ASCII
characters.  It is random of how many characters it captures, but it never
puts in the full amount of text that is in the field.  ...

I have an Employee Form and form it I have a command button to open the
subform time card.  It does open it but what it does not do is add the
employee # to the Time Card Table.
Here is the code I use to open the sub form.

After setting the format to a field in a subform, I always get the dialog box
to Save Changes when closing the form.  
I have used DoCmd.Close asForm, strFormName, asSaveNo. OnClick of the CLose
Form command button on the form.

I wanted to find out which factory shift, a particular time (Now()) falls
into
TblShift has
ShiftName,-ShiftStart(time), ShiftEnd(Time)

I have a form that I have been using to enter data into a table (or at least
I think I have).
The data source of the form is actually a query as I have several tables
represented on the form.  I know this has worked fine for everything I have

I've also posted in VBA Coding.
I attempted to assign the TransferSpreadsheet command to a
button, such that a person could click the button and have the resulting
query transferred to a spreadsheet. I used the following code:

How do we link a access .mbd file table to a pivot table in excel?
Also if anyone can post a simple user form for data entry in excess
table which I can begin with.