How do you make sure a form is fully displayed (no scroll bars, not maximized)?
I have several forms (unbound) which are used to display sorting options for
reports. Upon a button click, the form then opens the report with the
requested sort.

I have an Access2007 database (2000 as default). On a client's networked
machine I get a 'Return without GoSub' error message when moving between
records on a form.
There are no 'return' statements anywhere in the code.

I am trying to use the Report to PDF function by Stephen Leban. I've kind of
got it working but a few probs:
1. The system produces the PDF in the correct path and filename but it
crashes Access every time after creation. I use Access 2003, I assume this

This is a bit unusual but it is part of a table upgrade with a new release of
software.  One of the tables needs to be changed to delete the existing
primary key (the index, not the field itself), add a new field and make the
new field the primary key.  I can successfully add the ...

I have created a database in which the user will enter information into a
form and the record goes into a table. One of the fields on the form is Name.
As soon as the user enters a name, I would like for access to go to the table
of data that has been previously entered and ...

I create a recordset:
The recordset comes from view or sp.
dim cn as adodb.connection
dim rc as adodb.recordset

I want to open the Outlook application just as if I had clicked on the
Outlook icon on the desktop. I do NOT want to assign the Outllok app to a
variable say using CreateObject as this does open an instance of Outlook.exe
but it is not visible and when I leave the procedure and ...

I have a table with a "Location" field. The majority of the records in the
table have nothing in this field.
I have a query based on this table which includes the Location field. I
would like the query to display records where the Location field contains

I am running a query in VBA that uses parameters and multiple data sets.  
However, it is failing with a Operation Not Allowed When Object is Closed
error when I attempt to Open the RecordSet    Any ideas??  Thanks in advance
for your time - Mike

I have written a simple pay roll software in ms access.
master data is in access,
i am able to generate the report for only only month
ie i am unable to store the record of previous month!

Is there a way to create a custom menu in Access 2007?  In previous versions,
you could create a popup toolbar, link the buttons to VB code, and invoke it
from the mouse-down event (this gives you a right-click custom menu where
needed).

I've been able to successfully develop a program that pulls data from an MDB
file and exports it intoa VNC file for remotely accessing workstations at my
network.  The program works fine on the computer I designed it on.  However,
when I attempted to access the program from ...

Good Morning
I am using our custom area menu in my project.
I am changing the role(site group) of current user runtime according to which
the dynamic menu, I have created,displays the Areas according to the role

I have been using an access2k db for sometime to email text files to contacts
held in the database. I am trying to use the same approach to send an HTML
file.  All that arrives at the other end is the HTML code.  I am obviously
missing something! Here is the code I'm using (which ...

After read other posting and trying a few suggestions and getting no where I
was hoping that someone could help me out.
I am trying to do a DoCmd.Openquery but do not want the table to open.  I
have over a 50 different queries i.e. select, crosstab, make tables that are