I have created two forms,  fStudent which data source is Student table with
a  primary key StudentID and fClass which data source is Class  table with a  
primary key ClassID; the StudentID is also a foreign key for Class table. If
a delete button on the f Student form is clicked ...

I'm trying to find a way to keep a form maximized no matter what users do.
I've tried MS's example of removing the restore button, and I've attempted
to maximize the form on resize, but I just can't get this figured out.  Does
anyone have any pointers or sites with examples?

I am trying to use SQL to update two tables based upon the user
updating a value in a form. One is working; when the user changes a
value, the value in the table changes appropriately. With the second
SQL statement, nothing seems to happen. The difference is that I am

I'm using some VBA code to open another form when you double click on a text
box in a continuous form.  I'm also trying to close the first form by using
the DoCmd.Close method at the beginning of the double click event .  While
this command usually works fine, in this particular ...

I have a subform containing a datasheet and I need to be able to modify
values in some columns of the datasheet based on entries the user makes to
other columns within the datasheet.
I figured out that I can access each column's control through the

There is a main form.  On the main form is a subform (frmVersion) and on the
subform is another subform (sfrmVersionTask).  The sfrmVersionTask is a
continuous form.  There is a combobox on the sfrm that has items listed.  At
the end of each record there is a button.  This button ...

I was testing my app and it errored out and it turned out the value of
Openargs was Null.
I set Openargs to either a record key (if modifying a record) or zero (if
adding a record) in the calling form. Nowhere do I set it to null. How could

Is it possible to have conditional formatting applied to a listbox?  Even if
that formatting has to be done through VBA.  I'm looking to have a row's text
change to a differnt color if a certain condition is met.  If it is possible,
can someone guide me to the proper sytax.  I'm ...

I have seen this question a few times but I can't seem to get mine to work
using any of those suggestions. I can't get it figured out based on my forms.
I have a form "PO" with a subform "PODetail". On the main form is a button
that opens the "Projects" Forms. What I want is for ...

I use conditional cell formatting in a datasheet to indicate items of
interest.  If there are many rows, it is time consuming to locate the next
row of interest.  I want to add logic to advance to the next highlighted row
using a PF key.  How do I determine if a row was ...

I'm trying to write a line of code that will update a date field (txtDate)
in a form to the current date whenever a value in another field is changed.
To that end, I've tried using the following:
Private Sub Activity_AfterUpdate()

I created a form, named fObras, in Access 2007 with a ListBox named
lbObras.
Then I created a Module to populate the lbObras with the column Name
taken form the table "Obras" in the database 'Fornecedores 2007.mdb".

I have a bound form that is used to modify existing records or add new
records. Records have a secondary index that is built from the data entered.
Records can also be active or inactive. Inactive records are never shown on
drop-down selection lists so users are unaware of them.

Hi,
I would like to delete a record based on a user entered string. Here are the
details. I have a txtFind textbox. A string is entered by the user. Based on
that string value it displays that one record in the fields in the

I have a subform, and i have 3 fields doing a DLookup.  They work, but in the
last row each one that i have the DLookup function it's displaying #error.
How do i get rid of this?
Thanks