Access 2007
i want to be able to ADD and EDIT existing records in a Subform.
When I click a button I want to pass the RefNo to Open a form that is
filtered with the value stored in a variable. The subform would also be

I have troubles finding the right method to populate a multiple column
listbox with VBA code. Can some one drop me a few lines of code showing the
trick to do so. Aswell how to clear the entire content of the same listbox
from all data.

I try to open a form.
The recordsource contains this code:
    t_hefte.gesamt_kuerzel="lsf100"
When I try to it with a form field like this, it is not working:

I wanted to have a function to get previous business date function.
Are there any available?
I can do that check weekday and - 2 if it is Monday.
Any way to take care of holiday?

I use a listview in one of my forms to load approx. 800 records.
Each row has 5 subitems, so six columns in all.
I load the records by walking through a dao recordset rst something like this
set lv = me.listview1.object

A client has installed new computers with Windows XP and Office 2003. Now
when a user has an Access application open, another user can't open the same
application using a shortcut key. But they can open the application if they
start Access and then go to File/Open.

I'm getting the operation canceled error when I run this DSum.  It must be
my Syntax!
Forms!frmCheckPayment!TxtDivideGrand =
Nz(DSum("iif(CDInclusive=-1,[CDQuantity]*[CDPrice]/1+[CDTaxRate],[CDQuantity]*[CDPrice]*[CDTaxRate])",

I have looked through the board to find the answer for the following
question, however, have been unable to find it ... my apologises if the
answer is already here.
I have a text box on form C (a subform of form B  which is a subform of form

I am trying to update a table using a sql string.  I am getting a runtime
error '3024'.  Using Access 2000. This is my code:
Private Sub Combo22_AfterUpdate()
Dim strCombo22 As String

Hi! I'm new at this vb programming and haven't written a code yet, read alot,
but no action.  Anyways, I used a wizard to set up an Option Frame; I wanted
to know if I can store the option value from a number into a text box
[AcctType] i.e "asset".

I am used to having a subform on a form and in the code associated with the
subform referencing a control on the main form using
"Forms![Main].Control.value
But if I have a subForm on a subForm all on a main form. From code

The code listed below is the "click" event on an "update" button." When I
click on the button in my form, it doesn't update my table.  However, it
doesn't give me an error message!!  HELP!!!  Why won't it update?
 CurrentDb.Execute "INSERT INTO tblSavedMTNs(MTN, AccountNo, ...

On a form with Default View = Continuous Forms and Scroll Bars = Vertical
only, when the table is displayed, and a record is added to the table that
will be positioned between two rows currently displayed, on doing a requery
to show the added row; the form redisplays scrolled up ...

Hello Access Nation,
I have a form that is used for interviewing prospective employees. It has a
checkbox pos_acpt. and a corresponding textbox reas_decl. If the pos_acpt
checkbox is checked the reas_decl textbox enabled is set to false. The code

The following code does not requery main menu.  Any help is
appreciated.
Private Sub Form_Close()
   If Me.Dirty Then