I have a table for months. When I enter the months name starting of Jan, Feb,
March, April……., Dec the order of the months change to be random. For
example: April, Aug. Dec. Jan…….
How can I make the data stay as typed?

Good morning!
I just found out that I cannot edit a Access MDE database (great!!).
I found the MDB file, so I will be able to do all the changes I
require.

I have a form with 5 fields on it and these fields are 'Required' before the
form can be saved. A message pops up to advise that all fields need to be
filled in if you try and save the form. One field is a drop down box choice
of 'Pass' or 'Fail' and I would like to add another ...

I have a form which has several sub forms. I need to check when anything on
a form is changed including on any of the sub forms. Would it be enough to
check the AfetrUpdate of the main form or do I need to check AfterUpdate of
each sub form too, or do something else?

Apparently a subquery and an iif statement have
overlapping functionality.  Which one is better
to use in which situations?

I would like to have an item on a pop-up menu
that brings up another user created pop-up when
the mouse moves to that item.
I created a 2nd pop-up and tried to "connect" it to

I am stumped - and it's probably an easy solution.
I've designed a report that should, in most cases, fit on one side of the
page.  If that's the case, the page footer should print on the bottom of the
page.

USE AUTONUMBER IN A CUSTOMISED NUMBER STRING WHICH WILL RESET BACK TO 1 AT
THE START OF A NEW YEAR.   EG   ABC/462/2006 CHANGES
TO ABC/1/2007 AT TURN OF YEAR

I want to to change all the links in the linked tables in an mdb file to
point to sql server database.
If there's a way to do this by writing some kind of script (vba or even
.net) or any other way (using the Linked Table manager I can only change the

I'm trying to create a form to simplify a somewhat complex scheduling
task.
I have individuals attending tests that take place at a given date and
session (AM or PM).  For each individual/test, I have to assign both a

I've created a few popup menus that show up
okay under the "Shortcut Menus" -> "Custom" .
How do I delete un-wanted pop-up menus?
I've tried everything I can think of to reveal an

I am running a stock inventory database set up to calculate stock receipts
and issues. I am able to run queries and forms with no problems but the
dammed program flatly refuses to generate any reports. I have tried using
both wizard and design view with no luck. The only result I ...

This is what I am trying to do:
INSERT INTO TTEMP_CampaignRun05 SELECT TM_CompContact.FK_CompID,
TM_CompContact.PK_Contact, TM_CompContact.Group,
TM_CompContact.SubGroup, TM_CompContact.LCO, TM_CompContact.Source,

I have a situation where I have build a database in Access 2002.  I
save it as a MDE file and distribute it to three users at different
locations.  All three users have Access 2003.  I'm not sure who
installed Access on their computers.

I have been developing on a database for a few months now (off and on) and
all of a sudden I am experiencing the following error when I try to refresh
data on a form:
"Microsoft Access has encountered a problem and needs to close."