I'm consolidating some data that my company has accumulated and many
of the peices of data carry over to the next entry many times over.
In other words, many entries may have duplicate peices of data, i.e.
location, country, building, etc...  I would like to make it so that I

Is showing one window maximized (like the switchboard) and another restored
(just some small form for data entry) at the same time possible?

I have a little problem I am hoping someome has experience in. I have
a subform that is formatted in datasheet view on my form that so that
a user can see the data that is being entered in through the form. I
need some buttons on my form so the user can go to the end of the

Thanks for taking the time to read my question
Dim CellID as Variant 'When the DLookup works I'll change this to Integer
Dim ThePhoneNumber as String
CellID = DLookup("CellNumber", "tblCellInfo", "CellNumber = 555-555-5555")

I have the follwing code for OnNotInList and AfterUpdate Events:
Private Sub Steward_s_Name_NotInList(NewData As String, Response As Integer)
If MsgBox("The Union Representative's name you entered was not found, do you
want to add the name you entered?", _

I would like a text box (and a combo box) on a form to remember the
last entry, but still be able to be changed if necessary.  Can someone
point me towards a method of doing this?
I thought I've seen this topic before, but can't seem to find it

I am looking for some help for my data entry form. In the form there
is a combo box, which is used to enter date ("cboLongDate"). The date
format is "Wednesday, June 13, 2007" . I need to confirm the day is
Wednesday or not before the user click on add data or close form. The

I have distributed the front-end of the database. However when one of the
users opens the forms, the contents of the form do not fit the screen. How to
I reduce the content size in a form?

Can the screen size be adjusted in access only as the form controls do not
fit the screen on another user's machine.
Thanks in advance.

Chaps,
I've got the following expression (in a form):
=DLookUp("[Count]","WeeklyWFReport","[ReportGroup]=5")
When there is nothing to return, rather than returning a zero, it returns

I use the TreeView control on several forms with Microsoft Access 2002 and
Microsoft Windows Common Control 5.0 (SP2).
Everything worked fine since a few months ago.
Since then the NodeClick event of all Treeview controls is not fired if the

Hi,i'm Mishu and I need to build a logon form, where users who logon can edit
the DataBase,and the ones who have no account can only view the content of DB.
The second thing is that I need a form where users logged on can upload and
download files to/from the DB. Sorry for my bad ...

This works fine if I select one or all, by clicking one by one.
I want that if nothing is selected then that means all are selected,
then the code runs for all records in the listbox.
Dim CashSQL As String

I want to set a button on a form that will filter and sort the records. The
filter works ok, but I can't get the sort to work. Forgive me, i'm
self-taught.
   DoCmd.ApplyFilter , "isnull(fldDateOff) = true"

I am using MS-Access 2003.
I have 1 mainform and 2 subforms, on the mainform.
I can tab perfectly from the mainform to the 1st subform, but cannot
continue to tab through the 2nd subform, then back to the mainform...