I need to add records to a table under controlled conditions, apart from
using validations anf format checks with the unbound controls - I would also
like to have the controls across the page and have the form as a continuous
form so that users have the abolity to input a numbers ...

I need a from to enter new records only.  No previous records show.  I also
need a form to edit old records.  I have users that cannot grasp the "do not
change old records" idea.  So I make it hard toget to them.  Right now I
have 2 identical forms one with Data Entry set to No and ...

Hi. I posted this yesterday but have had no replies. Sorry to be impatient.
What I want to do is limit the records shown in a combo dropdown, based on
field values shown in a main and subform. I would have thought this had been
done before. Can anyone help please? If its ...

Hey
I am trying to build a quiz in Access but have had problems wit
setting up the multiple choice. If any one has any thoughts or has som
links to other pages that would be great.

I would like to get the File | Database Properites | Author property for my
access application in code.  Moreover, i would like to get the value for a
custom property named Version as well.
The Application.CurrentProject.Properties collection is empty.  I suspect

Can anyone tell me why the following SQL code is only giving me 1 record?  
There are supposed to be 2 records when I use MsAccess' QBE.
'assy is predefined
Dim db As Database

Greetings fellow developers.
I would like some opinions on the methods I have used to achieve an 'outlook
imitation', using ms access.  I have built an Access form that contains a
treeview and a listview, that imitate Outlooks folders and email items

At present, I can't see any way to zoom into the picture on an image control
and scroll around the enlarged image. Can anyone offer a possible solution?

Could someone please tell me what is wrong with my code:
----------------------------------------------------------------------------------
Private Sub btnApply_Click()
Dim Weight As Double

I have a combo box titled "Text0" which looks up to my list of patients. when
i type the patients lastname, the list of patients with the matching last
name are returned to a list box called "List2"
how do i have the first patient in the list automatically selected in

I have a splash screen (form) bounds to a tblLogin. The form has a txtbox
for userid (automatically captured network id) and currentdate (default value
=now()). I want to update my tblLogin everytime the Form loads. Thanks.
Allan

I am hitting an unexpected problem with the following code in a subform. It
works fine for some main form records but the storing of the bookmark causes
Error 3021 (No current record) for other records.
Set rst = Me.RecordsetClone

Guys and Gals,
I keep getting two records saved in my main table when only one record
should be saved.
Here's the controls on the form:

I am using Access 2002. I want to create a search bar in my form using a text
box. I plan to split out each word the user enters in the text box and then
build a query that filters these words.
I'm getting a "Type Mismatch" error at the moment, and I'm unsure why.

I use the following code behind a control on a form to  delete a record and
then call up the previous record. There can be multiple Inv's per FileNo. It
seems to find the match, rst.NoMatch is returned as false, but the previous
record is not displayed. The first record in the ...