In Acces 2003, I've designed a popup form that allows the user to specify
certain filter criteria. I do an ADO lookup based on those criteria, and if
records are found, I set the main form's "Me.Recordset" = the recordset I
found via lookup and close the popup. There is a subform ...

I have a few linked tables in my Access database (Incidentally, the linked
tables are linked via an odbc connection from out SMS server)
Everything is fine, the data is coming in as expected, however, what I am
trying to do is for each PC list the software installed, please see ...

I'm using an ActiveX listview control (MSComctlLib.ListViewCtrl) on an Access
2007 form.  I noticed that on records where the listview contents exceed the
height of the control, the vertical scrollbar does not appear as it should.  
I tried adding the line

Greetings all,
I am fairly new to Access and currently using Access 2003. I need some
assistance coding a subform(subfrmEmpHistory) that updates the main form
(frmEmpDemo). The problem I am having is how the handle the required subform

The application in question is designed with one mdb file contining all of
the forms and code, and a second mdb file with the data tables.  Each user
has the "front end" mdb installed locally.  Both mdb files are 2003 format.  
Recently one user noticed that the "status" field on ...

Is there a way to refresh a subform after the value in an unbound
textbox is changed?

I have a details form that contains the details of an individual with the
following fields:
firstname
lastname

Access 2003 & Access 2007
I want to code the "after update" event of a Yes/no box on a form.
if the answer is NO Is there an "After Update" just by tabbing past it?
if the answer is no I want to change the focus to a different tab on the

I'm curious to find out what other folks are doing with regard to sending
bulk email out from an Access table/query.
 Are they coding (vba) this themselves and sending out one email at a time
or are they extracting the data from Access and then using a 3rd party

I have a form with 17 checkbox options for the user to select. Once the user
selects the checkboxes  he then clicks a button that is suppose to run a
report. based on the options selected this report is to display  sql syntax
that goes with that particular option. This report is ...

I have the following code in my form (I included all of it just in case).
Under Division_AfterUpdate, the SeqNumber is supposed to automatically
increase by 1 each time a particular Division is selected, but it is only
going to 002 and then just keeps repeating 002 each time--it ...

I have a form (frmGuests) with a subform (sfrmGuestRentalHistory) that lists
property rentals for a particular guest.  Each record in the subform has a
unique identifier rentalID.
I have a second form (frmRentals) with a subform (sfrmTransactions) that

Once again REDACT() is a function pointing to the external database.
Is this syntax correct?
Thanks
DS

Is this correct?
CurrentDb.Execute "INSERT Into
tblChecksTMP(CheckID,ChkCustomerID,ChkServer,ChkTabID,ChkGuests, " & _
"ChkTypeID,ChkSepCheck,ChkDividedCheck,ChkDivideBy,ChkOldCheckID) IN '" &

Thanks for your help in my last question Rdub, worked a treat.
Hi
This is similar to my last question, I am creating an excel document using
info from some database fields (part of code below). In the phContactName