Greetings forum members,
It would be greatly appreciated if someone could advise me how to add a pop
up calendar to a date field in a subform.
Basically, what I want to happen (...or something close to this) is:

hey all, I'm using a listbox that displays the number, organization, name and
date from a distribution table.  unfortunately, there is no key column (for
various reasons) so i've modified the underlying code for the AfterUpdate
action so it looks for the record matching all 4 ...

I have a main form, which contains mulitple subforms.  I have the end
users clicking on a command button to proceed to the next
section(subform).  I need the focus to be set to the firt text box in
the subform.  I seem to have the code right or so I think but it seems

hey all, here's my problem:  i have:
table: for distribution of disks
form: has a listbox that contains Number, Company, Name and Date from Distr.
table, and functions to open the selected record

On my form w/sub forms I have a button to enter a new item, and I want the ID
field to automatically pick the highest ID and add 1 to it, and display the
result. Actually, it doesn't have to display the result as long as the field
is updated in the tables. In this particular case ...

Hi I have a form which displays data as follows:
Country State City Location Population CrimeRate
 US      IL     Chicago LocA    20000        10
 US      IL     Chicago LocB    10000          4

I've saved a path and filename to a record. How do I read that record and
open the relevant document ie phil.doc as a word document or phil.xls as a
excel document,alter this document and save again?

I created a database last year and I am now attempting to do another
one.  I got help before with a Surname Search on a form which worked
fine, I have tried to copy this over to my new database and it
searches through the names, but when I select one I get the following

I have finally been able to create a form with a multi-select list box and a
command button where a click of the command button opens a query with the
selections in the multi-select list box as its criteria.  So far so good...
now I am wanting to use more than one multi-select list ...

I understand that each combobox and listbox on a form consumes a resource
type; a database connection I believe.
I also believe that this can be delayed if I open a form with combobox and
listbox rowsources empty and set them programmatically when required by the

I have an access 2003 application that contains a student timeclock.  The
student types in their student id number in a field, presses enter and the
code behind the form clocks the student in or out.  In the past, student ID
numbers could be no greater than 9999.  Now they can be ...

I have a database that contains several rows for one record. (I didn't set
this up)  Anyway, there is a header row that has one or more detailed row,
using the same ID number.  There are unique keys that are in sequential order
for each row.  I need to be able to bring up the ...

Dear Colleagues,
Please advise what may be wrong, access stopped to display items from
linked excel table?
In the same time, if I link access table it works properly.

Hi Groupies:
I have the following code in a combo box on a subform.
Private Sub CreatedBy_NotInList(NewData As String, Response As Integer)
Dim db As DAO.Database

Hi all, I have a form that shows student information (primary key =
student ID). I have buttons on this form to bring up other forms that
can be used to register student for certain events. The first form is
data from a student table, while the ones for registering the student