I have an active formerly working just fine DB in Access 2000,  I recently
adjusted some simple forms and a few sub reports only to find that on opening
there is a message that It (access) can't find one of my forms.  It takes me
to my VBA where there were no changes to debug and ...

Is there a way to "dock" controls to a certain edge of the form so that when
the form is resized, they automatically move or resize as needed (you can do
this in visual studio)?  I don't think there is, but I thought I'd ask.
If not, how could I check the dimensions of the user's ...

I have a form built to allow users to filter the database using three
critieria.  I have an unbound lookup table for “Contract Type”,
“Discipline” and “Project Name”.  On the form I have three command buttons
for “View Report”, “Print Report” and “Exit”.  I can’t seem to figure out

I'm a new user of OLE objects in Access 2000. Thus, I need some help.
What I'm trying to do is open MS Word and paste a "message" out of a
text box into a temporary document. This is a fairly easy problem, but
my help has been subpar as of yet. Any help would be appreciated.

I have a form that queries by YEAR and a CODE. The YEAR is selected by ComboBox
and the CODE by a Check Box. I have 4 check boxes. Each with one of the
following values:
CS

I have various forms in my applciation that reference a specific icon
files in my application under the path of my MDE. My code works fine if
the location doesn't change (ie C:\appname). But if the user has to
place the "MDE" in some other location (S:\appname) my code will not

I’m trying to set a record set to my variables.  In doing so I get an error
when there is a null value in the table.  I’m trying to catch the null values
with the if then statement with no luck.  Here is some of my code:
Dim strNewBankerName As String

I have been trying to modify some code I picked up from
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/o
dc_ac_olauto.asp
I am uing Office 2003
I have modified most of it to run referencing my form but the attachment

in a reply to me in nov '04, stephan lebans went on to write:
".....
3). The MouseHook solution purposely allows Subforms to continue to be
scrolled via the MouseWheel. This was the behaviour requested by the

Dim ctl As Control
Dim blnEnabled As String
blnEnabled =  NULL
For Each ctl In Me

I have a front end that links to a slew of tables in a back end.  We use this
setup for many clients, but for contractual reasons, we MUST keep each
client's data separated, so I use a combo box to select a client, then loop
through a table containing the names of the tables I ...

I think I have the right idea but the wrong order.
I have an unbound form for the user to select or input information for
the report.
I would normally set the criteria for the record source on the report to

I try to assign a string variable the following value:
'Load subform recordset
   Dim sSQL As String
   sSQL = "EssayNote.NoteID, EssayNote.EssayID,  " _

The code pasted below was written by a now "not working with us"
developer to display a series of pictures in a multipage form. Some
background: The form is used to record information about ecological
surveys, which involve counting lots of trees. For each survey site, 3

Is it possible to have a button named for exemple "Select All" that will
select all the row in a listbox?
Thanks!
JS