Im sure i found this option once, but i cant now.  When im designing a form
i stretch the window bigger than the actual form (only the window, not the
form size).  Im sure i found a function to set the window to the actual size
of the form so when i open the form from code it is ...

Here is what I am stuck with, any ideas on which way to go with this would be
greatly appreciated. (for all of these, SSN is Social Security Number)
table1.  I have a table with SSN, FirstName, LastName
table2.  I have a table with SSN, Position, etc...

how do i create a "clear" or "reset" button in a form???

I am distributing my application and it is important to me that the date the program is first opened on another computer is captured.  I want to store that date inside the application on the new user's computer for later use by on of the modules in the distributed application.  ...

I have a form that contains a check box to obsolete a
document.  Also associated with the document are several
individual toggle buttons which identify the binders these
documents are in.  If the button = yes then the document

Can anyone tell me how to bypass the Security Warning dialog that comes
up when I run an .mdb, created with Access 2000 or Access 2002, on a
machine with Access 2003 installed?
Thanks for your help.

I have a list box with names of cities.  I also have a field on the same form
that requires the name of the city.  I want to be able to click on the city
name from the list box and have it place the selected item in the "City"
field of the form.  How can I do this?  I am a ...

Good Morning,
I'm hoping someone can help me with the following problem. I have 8 people
who work for me , all use an Access97 database to perform inspections and
report results.

Help please, Need to create a command button on a form that will transfer the
record in it entirety to another table.

Can anyone tell me why I'm not getting an answer to this in a calculated
control
=DLookUp("[txtDomfacsoleqtr]","tblmaintabs","[txtMonthlabel]"="[txtqtr1]")
tblmaintabs is my table and txtDomfacsoleqtr and  txtMonthlabel are controls

I need to fix the size of my switchboard so that:
If:
1. minimized
2. maximized

Sorry if my question is elementary but I am a new user of Access:  
I have already created a table with my data as well as a form to enter new
data.  However, when the users open the db, I want something that asks them
whether they want to search the data that is already there or ...

This formula on main form
=[budgetfigure]-([MonthReqTotalForm].Form!TotalReqsAmount+[SplitMonthReqTotalForm].Form!TotalSplitReqsAmount)
works only if both subforms, MonthReqTotalForm and
SplitReqTotalForm, contain records. I tried NZ,and it does

I have a problem with a Combo box looking up a record.
I get a error message The OpenForm action was cancelled and the debugger
brings me to this line of code.
DoCmd.OpenForm "DeptUpdate", , , "DeptID = " & Me!Combo14

I'm trying to create some buttons on a form that duplicate the behaviour of
the navigation buttons at the bottom of a form using VBA. The form is
displaying selected fields from a table, which has a filter applied,
selecting A,B,C ... or all records from the table. I've added the ...