Hey all, I have a form that is used on average by about 10 people on a daily
basis, who all like to see various sortings of the same information. Even
without saving somehow, soring gets 'hard coded' into the form itself (when
you go into design mode and go to form properties ...

Hello.
I have a listbox on a form, call it "form A" that is populated a table in my
database. Also on "form A", I have a button that opens "form B", and closes
"form A".

I am using Access 2003 running as 2000. My PC OS is Win XP Pro on a Windows
2003 network.
The following is two versions of the VBA code, to copy an object with the
database and then save it out to a serve, that I have on a Form, the first is

My form is unbound as are two controls. User inputs data into each control.
I wish to calculate the sum of the two and using VBA test for value, sucha as:
If (me.MyCntrl1 + me.MyCntrl2) > 2 then
  perform task

here's my code:
Option Compare Database
Option Explicit
Public Function sibbling1()

I am trying to use the following incomplete code to open a recordset based
on parameters. There are two parameters, each a field in the form from which
whose module this code comes from.
My question is how do I set the parameters for the code?. Obviously I can'

Table for box number. Box number autonumber, location text, description
text. Start numbering at 1. I want to build 1000 records. Is there a way to
do this without  filling in location and description? Like hitting the new
record button on the record selector 1000 times making 1000 ...

I'd like to make a class that would appear to be an recorset for the purpose
of binding it to a Access form, yet still be able to create custom
properties and methods.  Is there an interface exposed by ADO that would
allow me to do this?

I am using Access 2003 running as 2000. My PC OS is Win XP Pro on a Windows
2003 network.
The following is two versions of the VBA code I have on a Form the first is
on the local PC "C:\" drive and works the second is on a net work driv a

We have a bound form that opens by default to the first of several thousand
records.  We'd like the form to automatically open to a new blank record.
What code is necessary to do this?
Thanks in advance.

I have a subform that I am using for Data Entry however instead of adding a
new record, as my command button states, it writes over the record previously
entered.
If I use the subform on it's own it works fine, when this form is in the

I have a main form with a subform on it.  I copied all the fields including
the subform fields to a report so that I can print the records from the main
form.  The print screen function works fine, except that the subform fields
are blank on the printout.  

Is there a way to show the db name instead of "Microsoft Access" in the
title bar when I have the db minimized?

OK, well I need LOTS of help, but I'll start with this one......
I am attempting to use tony toews fe auto updater.  It works the first time
I launch it, creates the autoFEUpdater.INI file.
2nd time the StartMDB.exe file is launched, by me or anyone else, error of

Hope some one can help
I have a command button on a form with the following code on it
Private Sub Command81_Click()
On Error GoTo Err_Command81_Click