I added some code so that, on event end, the spell check was automatically
launched to check the text inpuuted in to the memo box. However, this
resulted in a bad loop where I kept getting confirmation that the spell check
was complete over and over again.

I have a main form with 3 command buttons that are used to open up other
forms (all associated with the same table).  When reviewing or editing a
record using a Lookup Form accessed by a command button, it opens up the main
form showing the correct ID, but the problem occurs when ...

In a multi-select (simple) listbox, how do I get the row selected, and how do
I know if it's an initial select or a re-select (i.e. clicking on an already
selected item this unselecting it?) Thanks.

Ok
I know this most be a recurrent doubt but I couldn't find anything that
would suite my needs.
I have a combo box that a user uses to enter a store name. The next field is

I am in frmSolLoc which is a subform on frmSolutions which is a
subform on frmBasic Data
I have used a Select Case statement to determine the RowSource for
cboSolLoc on frmSolLoc and am trying create a NotInList Event that

When I select "Other" in the Discovered How Field, and attempt to exit
form, I get the message box error.  I also get the No Current Record
message.  Any help is appreciated.
Access 2003 Windows XP

I have a listbox which shows a small subset of the columns in each record.
I'd like some way to allow the user to point to a row and see the whole
details in some kind of popup window which changes as I point to different
rows. If I could get the controltiptext to do it, that ...

Greeting folks.  I have a form, frmSearchEWO, that has an unbound text box
where users can type a note, then hit a button, and save it, which will also
save the primary key of the current record.  The on close event of the form
is as follows, and is to make people either save it, or ...

I have a crosstab query that is working great showing the data that is needed.
I have 3 row headers which are static. Then my Column Headers are dates, of
which there can be many.
I am only going to show 2 weeks (thus 14 boxes) of data at a time and give

I am using a Make Table query to build a table for reporting purposes. I've
tried with no success and I've read and been told that there is no way to
control what data type access chooses for each control. I need it to be a
number field but in the back end tables the data type is ...

Hello All, Im Trying to improve my Query serach's i have in my
database,
the query works like this,
I Have created a wizard type form with 3 combo boxes, which are un

This is more of a annoyance than anything else.
I have an access 2000 front end program that I develop in Access 2003 (before
compiling into MDE on an Access 2000 virtual machine). This has neven been a
problem.

I currently have the following code in my DB, so that if the user selects any
option other than "Closed", they are forced to enter a diary date.
How can I set the code so that they are not forced to enter a date when the
status is "Closed" OR "Rejected" please?

Can I Select and Insert From and Into the Same Table?  Such as...
SplitSQL = "INSERT INTO tblCheckDetaisTMP " & _
"SELECT * FROM tblCheckDetailsTMP " & _
"WHERE tblCheckDetailsTMP.CDCheckID = " &

I have a form called AddStudentForm in Access database. It has comboboxes in
it. There are two particular comboboxes i'm having troubled with.
Combobox 1 : Department
Combobox 2 : Course