I want to create a form that will show only incomplete records. Once the
record is complete, I'd like it to disappear from view. Any suggestions?

Although all settings required (Form properties) have setting to allow
Datasheet view only, when press the button (in my example - View open
tickets) to open list of all open tickets, I still see a Form View with a
single record, instead of a list of all open tickets. All fields ...

I have two combo boxes on a form and a command button that runs a report.  
The first combo box is called ComboCategory and the second if called
ComboProtocol.  They are each based on a query that lists the various
categories and protocols.  The report is based on a query that has ...

Using a Continuous View Form, I have a "Sum Field" which has a calculation
(quantity x price). In the footer I want a "Grand Total Field". I can not get
it to Sum more than one row. I can use =sum field and get the amount of the
first line but after that it is nothing. Any help ...

I have alist box with specific data to be displayed.  When I add a new record
I am able to view the list box and select one of the items in the list...but
when I save ther record it doesn't input the field informatin I sleected from
the listbox in the record.  What did I miss.

Hi, I know I am missing something simple, but I still haven't found the
answer after searching through the help files and newsgroup.
I have a 3 column combo box that is a value list populated automatically
from a table. The fields I am using are ID, ciprefix, and cinumber. My ...

I am new so sorry if this is basic. I am designing a larger database, but was
able to reproduce the problem with a smaller one. Here is the problem.
I have two tables, the first is Main which has four fields,
ID (autonumber), Date, Name and OrderID (number).

Newbie question here.  I am building a document tracking database wit
the following tables
DocumentPKe
DocumentTitl

on a forms text box i've entered the following validation rule
'>=1 and <=5'
with a message saying 'blah blah blah'
the message box was being shown earlier but now its not being shown but

I would like to be able to select an option box which would activate a combo
box, from which a selection can be made. Much like the Northwind Sales Dialog
Box. I am having a little trouble! Please Help.
Cheers People!

Strange thing is happening, I can design a form, create a new form but it
will not let me delete the form.
Any ideas as to why it will not delete the form.
Thanks,

I have a multi copy database with a BE and I want a particular form to be
open by one user only at a time.  Is there a way?

When using the Whercondition within the Openform,is it possible to access the
built predicate in the called form?
I need to extract a value from the Where clause built in a pop up form,
which then calls the form I am working on. The value in the where clause is

I have a database for a fitness club. I made a form with the member details
and then a subform with record of their monthly payments, annual payments
depending on their payment method. But i dont need to be able to see
thousands of records i only want to see the most recent 12 ...

When I try to start the Form Wizard in Acxcess 2003 I get an Error message
saying "activex component cannot create object". I have reduced Macro
Security to Low and the same happens, I have repaired installation and no
change but functionality seems OK as I can insert Cal Control ...