Does anyone know a way to change the size of the access window.  I am wanting
to change the size so it surrounds my form.  I can see this as the only way
to display only my form

I have a form that's data is supplied from an underlying query of a number of
tables.The form also has a number of subforms.
I have a VB procedure that runs when the user changes data in a subform. The
procedure deletes specific records from and then appends new records (in

I have a macro that checks fields on a form. The macro issues MsgBox
messages. It is triggered by the "OnCurrent" event of the form, as the doc
says this is the latest event that's triggered when a form is opened.
The problem is, the messages appear BEFORE the form is displayed, ...

I'm working in Access 2002.  I have a large form with about 6 subforms (all
embedded at the same level).  When I save the form in Design view, some of
the subforms suddenly have their Source Object property changed from the name
of the correct subform object to the name of one of ...

How can one filter a subform just for the current record on the main form?
That is, when you move to another record on the main form the filter is
"undone"? Thank you.

Its throwing me a runtime error on this line: Anyone have any clue why.
i think today is my off day. :-)
cboPromote.Recordset = "SELECT Client, PromoteGroup FROM
tblItemPromoteGroups WHERE Client = " & chr$(34) & cboPromoteClient &

I have a form in Access 2003 I use to display student records. I want to be
able to print the record that is currently displayed in the form so I created
a button that uses the PrintOut Method (DoCmd Printout acpages, 1 ,1).  It
prints a record but it's the first record in the ...

I am somewhat new to Access and I am having some problems setting up my
database.  My database is used to track emails that are sent outside the
country.  At times 1 email will be sent to multiple countries like Japan,
England and Denmark.

I have a datasheet form that displays a list of reports. In one column, I've
made provision to store hyperlink addresses to PDF version of each report
list. The hyperlink field in underlying table is set to the hyperlink data
type. The field in the datasheet has the hyperlink ...

I have a form in which I would like a text box to open only when OTHER is
selected from a previous list box.
Is there a code for this?

first off i was wondering if the line below is even valid. Its throwing
me an error on that saying that rowsource is not a valid data member.
compiler error. I thought you could do such a thing.. or would i be
better off using DAO recordset for this.

I have a combo box in my form that the user can select the name of a
department.  The user will be entering in multiple records under the same
department.  Is there anyway i can have the value in the combo box remain the
same until changed by the user?

Searched but couldn't find a thing on this.
When I build a form I usually put it together to appear as a paper form
would including a company logo.  The logo is sized correctly an begins as a
.jpg of 15kb size.  By copying and pasting I only get a box with the name of

I'm a new access user.  I created a simple table and then created a form.  
I've since gone back to my table and added lookup columns in some fields.  
How to I incorporate these new characteristics into the form I created?

I would like to create a macro TransferDatabase
where it takes ex. Atbl_2006 and creates Atbl_2007
I would like it to do it Atbl_"yyyy"(now)
create Atbl_"YYYY"(now()+1)