TC thanks for the help so far but I am still not getting anywhere.
In regards to linking tables I cant do this because my Access database does
not have any tables at all.
Lets say this is what I want to do.

Anyone any ideas how to override the exit application X that seems to
be present in all Access databases?
I need to force people to exit the application through an exit app
button and not via the outer quit option?

I'm doing something stupid, but am too blind to see:
If Me.FP_PU_YEAR <> "L5" Or "F" then
Me.Frame56.visible = false
end if

Please have me. I'm stuck with one problem:
Let's say that I have form "frm_abc" bound to table "abc" with 3 textboxes
corresponding to fields: "word id" (auto increment), "sentence" (allowed
null) and "string" fields.

I'm using DoCmd.OpenForm to open a mainform and its subform using a WHERE
statement from a command button on another form:
DoCmd.OpenForm "frmMainForm", , , WHERE statement, acFormReadOnly
I want the user to only to be to read the record in the mainform without

I have a table i use solely for 'environment variables' i.e. image paths etc.
(i overwrite the one record all the time by setting isdirty flag to false
prior to each save..) -only problem now is when i try to 'use' the fields of
this table on a form that doesnt reference this table ...

We are currently in the process of trialling various Resize/Rescale
controls/code and have come across a number of issues with this approach.
We have an MS Access 2000 application designed at 800x600 screen resolution
and are wanting to use a resize control to allow forms to ...

Novice
I have a form (frmTable) with a large number of pages in tabs. Each page
contains a subform (fsubSelect, fsubText, fsubHousekeeping, etc.). All
(except one) of the subforms are based on the Main table and so DON'T have a

http://www.members.shaw.ca/AlbertKallal/Search/index.html
I would like to implement a search mechanism like Mr. Kallal shows in his
examples. I would like to place fields at the top and I understand the
wildcard searches, etc. however I really do not know where to start to get

i created .mde file for my database. i opened .mde file for testing... i
inserted new records for storing the data... record was inserted in the table
shown in .mde file.. but when i closed .mde file and reopened my .mdb file
then that inserted record was not shown in .mdb file... ...

I have three large (and seven small) text boxes in my Form, each of which
displays content dependent on which entry is selected in a list box on the
same form. The code that does this is below. (The three "Desc" text boxes are
the large ones; the others are much smaller (50 ...

In Access 2002 I use the following code to open the file dialog box which
allows the user to pick out a folder.
With Application.FileDialog(4)
   .AllowMultiSelect = True

       I have a basic sales order form that is only going to be used for
printing purposes. However, I made a column of Quantity fields where the
sales people can enter and ammount of product they are selling. These text
box fields are not bound to anything but what I want to do ...

I am missing something, probably simple. Can someone help with this?
Thanks in advance
stLinkCriteria = "[Unit1EventNumber]='" & Me.EventNumber & "'"_ Or
"[Unit2EventNumber]='" & Me.EventNumber & "'" Or "[Unit3EventNumber]='" &_

I have read throughout the forums that opening a form as "acDialog" will
cause your code to stop and wait for the form to finish or whatever.  It
doesn't seem to be working that way for me...
Here's what I'm doing: