Basically I want to do something like this..
If Record X Exists The
  Run SQL Update Quer
Els

Can anyone tell me to have a marquee effect on a button displayes in a form,
it would be even fine on a label or a text box.
Any help is highly appreciated
Thank you.

I have a form that has demographics in it. The demographics are attached to
MedicalRecord which is my tables Primary Key.
Is it possible to have the user enter the medicalrecord they are searching
for in the Medicalrecord text box on my form and if that medical record is in

I want an error check on a SQL table that looks to make sure not to put a
duplicate record in for the primary keys I set.  Access automatically pops up
a message saying that there is a duplicate key record.  Is it possible to
pop-up a custom error message rather than the generic ...

Using access 2003, I have a form which displays Student Data, for a
single student, from StudentTbl and Exam Data, for the same student,
from ExamTbl.
Student Data is displayed in Single Form view and Exam Data is

i'm a using a vb code for data duplication in the afterupdate event and i'm
getting an error message when it gets to "elseif"
Private Sub CustomerID_AfterUpdate()
   Dim strwhere As String

I need a form for Access 97 to calculate a CountDown from h:m:s:ms.
i found similar argument in this forum, i did try to crate form and module
but it does'nt work. I need help, and please be clear (explications for
dummmies :-)

  Access Newbie here with I'm sure is an easily answered question.  I have
a form that has a tab control with a listbox called lstVacations.  What iam
attempting to do is click a record in my listbox that navigates to the
selected record on my mainform. Below is the code that I am ...

Greetings,
I'm trying to find a resource that will tell me how to pull the field/column
names from existing queries to use in a form that will build ad hoc reports.  
I'll use the names in a For Each Loop that will assign them to check boxes

I posted this in the General Questions and received good, helpful answers,
but I'm still having a problem.  I want to make 2 combo boxes, Groups and
Names, hidden until I choose the option/value Rules in another Combo box,
ChangeMade.  I used this code in the AfterUpdate event of ...

Okay, so I built a form in design view.  I am wanting to use this form to
enter data. For some reason I can't add new records.  It doesn't give me the
last button that I normally use to add them.  Any ideas on how I can get it
fixed?

Is it possible to get by code the value entered in an Access Table object?
(The value you enter by right clicking on a table and then on Properties)
I tried this but with no success:
MsgBox CurrentData.AllTables("myTable").Properties

How can I use an IIf function if I wan't to have 3 diffrent answers.
I'll will try to explain whet I mean.
If the value is neither True or False then I want to give the value of Ord
back.

I have an MS Access form with the following objects
ListBox with visible set to false, populated by a query and on timer event
set to requery at 5000 milliseconds.
A button which makes the ListBox visible and deselects any selected items

My Google searches have come up dry...
I am am toying with a text box with the control source of...
=DateDiff( "h", Me!cboUCT , Now() )
Where Me!cboUCT is a lookup combo box that returns the Unified Coordinated