i'm trying to do the following;
load a form with records, such that the recordset is disconnected from
the database. i can do this (open connection - then recordset and
assign it to form all via vb).

Good Day All,
 I have a command button to open my frminvoices in read only mode:
** Begin Code **
  DoCmd.OpenForm FormName:="frmInvoices", WindowMode:=acDialog,

I have created three multi-select list boxes with hidden list boxes to house
the selections.  I would like to sum each hidden list box and mutliply the
results from each and display the result after the user clicks "Calculate"

When trying to open a form in my DB, I get this error.
Everything worked fine, but then I pasted a form from another DB into the
current DB and now I get this error. This procedure used to work, but I have
just changed my computer - and on the new one I get this error. I am using

Hi,  I've asked this before, and I know its not the best thing to do,
but unfortunately, I have to be able to generate an auto number
sequence using the following format:
I have a form with a blank textbox [RMA Number].  I also have a button

I fixed a combo box to access the correct table of information (Accounts
payable code for Purchase orders). But now every time that I fill-out the
form to generate a new PO this combo box resets the account number for ALL
PO's. How can I make the entry for each PO permanent ...

I have a situation where a value from a combo box (named cboPayPeriod on a
Main form; source is form tblPayPeriods) needs to copy to a subform field
(named fkPerID).  The code is as follows (but does not save the value):
If IsNull (Me!fkPerID) Then

Got a Form called switchboard, I would like to open another form, Concern
Analysis, based upon a value that is present in a text box on the switchboard.
I already have the button on the switchboard to open the 2nd form that are
linked on the primarey key, Analysis Number.  

Hi Freinds,
I have a TextBox- txtNumDays which is associated with TestStartDate and
TestEndDate. If you put Number of Days and TestStartDate, it calculates
the TestEndDate. I also have VacationBeginDate and VacationEndDate on a

Right now I have a form that has the multiselect property set to 0 as default
(set on form design), but in certain cases I wanted to be able to use
extended to make multiple selections (the extended depends for what that form
is currently being used for, the form is used multiple ...

The control tip string entered in the control's property sheet (specifically
a command button on a form) does not show when the mouse pointer  is placed
on the control.  I am using Access 2003 with Windows 2000.  I would
appreciate any help.

My ControlTip doesn't work.  Does anyone have any suggestions?

larry.no...@gmail.com
    Dec 4, 3:05 pm   show options
Newsgroups: microsoft.public.access
From: larry.no...@gmail.com - Find messages by this author

I have a form which recently started taking an inordinate amount of time to
open. The source of the form  is:
SELECT tblLSGCode.*, [tblCauseCodes].[CauseCode] FROM tblLSGCode INNER JOIN
tblCauseCodes ON [tblLSGCode].[LCode]=[tblCauseCodes].[LSGCode] ORDER BY

I am creating a tooling quote db.  I want to have one table(form) with
specific project information which will be update for each new project.  I
have multiple vendors but will not have all vendors quote for all projects.
(2 for one project, 3 for another, etc.)  I am trying to ...