If I change the source object of a subform control can someone give me the
list of events that fire??  If I minimize the App then restore it is the
event list different??
Ernst.

I have this code that filtered from query to view the word list I write on a
field on a form,
so with every key I press on the field the word list it be closer.
This code it work on Access 2000 and not work on Access 2007.

Are there any functions to return the first and last day of week and month?
I am looking for a function to pass now and get the first and last date of
week and month.
Does it exist?

This code raises error 424. How do I copy a row from a two-column combo box
into a two-column list box.
The combobox, cbox gets its rows from a query
Option Compare Database

I have a form where the user needs to select from an existing list of Parts.
There are 2 combo boxes on my form.  Both return the Primary key from a main
Parts table.  One combo box allows the user to select by Part No. the other
by Description.  Both combo boxes have the same ...

I am trying to capture the value of the second column of the subform
identified as CaseListSubform, the name of the subform itself (ie, the
source object) is CaseList.  The event is when I click on the first column
I must identify THE SECOND COLUMN.  What is the reference path?

Good morning all,
I have a quick Question.  I need to send a table out in Excel, I have the
code set up but I need to filter it out to equal what is on the table.
I am recycling some old code that uses a report but the format is not what

I'm trying to create a form that would allow my Co-workers to run a query
after cherry picking some parameters. The problem is that if i leave any of
the parameters blank it returns no records. I'm thinking of a workaround for
this problem but I can't make it work. Does anyone ...

How can I check if a combobox has any option choosed.
What I'm looking for iis something like:
if combo1.text = "" then
msgbox "Error"

I use the following code to populate a listbox  with report names on an
Access 2007 form.
   Dim objReport As Object
   For Each objReport In CurrentProject.AllReports

I have a bound form and am wanting to display a field from a query on the
form. I think I could use dlookup for a table but could someone tell me what
method would be best to use (or if it's possible) to look up a value in a
query?

I am trying to programatically open pdf files that are password protected.  I
can't seem to figure out how to pass the password when opening the file.  
Any assistance would be greatly appreciated.
Thanks,

I have a recordset as follows
The user is able to manually go in enter amend new records.
On form close I need to check to find that each tee and teetime has a P1,
P2, P3 and P4 record, and if one is missing do message to get user to fix and

I am trying to create a membership database and would like to have a Fee's
collected box that would update a membership field to one year out.  Thank
you for any help.

I am using the function NIL below in several cboBoxes and I am calling it in
the Forms module using: Response = NIL(NewData).  My question is, can I call
the function NIL from the Properties window instead of the Form module and if
so how would I enter it?