When I have got Outlook 2003 maximized and then Open Word 2003, I click
Maximize and the window has a 1 inch gap at the top to allow me to see
Outlook behind.
I wasnt Word max'd to Full screen.

I have a syntax error problem with an update query.
Here is the piece of code:
   dim strSql as String
   dim res as variant

I have an application that looks up a number in a (backend) database and
then closes the connection.
Another database is actual if there has been any changes since last time it
was opened .

I'm using the following to populate my text box.  If the acctbal is a
negative number, it wraps it.  How can I stop this from happening and
keep the - with the number?
Code:

I am quite a new user to Access and require some assistance.
I have a form with two (2) levels of sub-forms. The main form and the first
level subforms are in Single Form format, while the  second level subform is
in Database format.

I have a form that displays a list of quotes and invoices from a
company.  I'm trying to set the record source of my form through code,
so I can use the same form.  I thought it would consist of a simple sql
statement that would match the fields with the controls, but it's not

I am designing my forms to fit 600 x 800 resolution.  I have more horizontal
real estate on the form than the screen size can show, therefore my user will
have to use the horizontal scroll bar to move left to right on the form.  My
problem is that I want the left most controls ...

How do i determine the number of records in the underlying table/query in an
open form and then force a particular field to be either visible (or not) if
the number of records is > 1
i am using the 'on current event' property to set this.

Older versions of Access required you to ctrl+Tab out of subforms when
jumping from a subform back to the main form.  
Later versions 2000?  Seem to allow you to do it automatically with a simple
tab.

Is it possible to check that a record on a form has been dirtied in a the
last lets say 60 seconds.  I have a form which usually sits on the same
record for most of the day. I want to check if a record has been changed
recently as opposed to being changed earlier in the day. I am ...

I have a main form containing a combo box.  Based on the combo box value, a
sub form displays data.  Everything is fine when I open the form or change
records.  If I change the value of my combo box, I need the sub form to
display the information based on the new value of the ...

I was just reading another post and it was recommended to keep from
getting duplicates in a field to set that field property Index to Yes,
no dups. If you enter a dup then and error is generated. Trap this error
and display a custom message.

I'm using this code to populate a bound textbox [PopulationBracket] that
yields a billing multiple based on population depending on which non-null
population is choosen (City or County but never both):
Private Sub PopulationBracket_BeforeUpdate(Cancel As Integer)

OK, I have tried almost all code and still can't figure this out:
I have a form in continous view, a button to select the record next to it.
This button I would like to open another form based on the selected record.
Code i have tried:

I have the following code to change the label to the company name after
clicking on the company name drop down.  The records are populating, but
will NOT update the label.  How do I get the company name to populate the
label based upon the company id?