I use cascading combos which have rowsources driven by events.   In some
instances, the rowsource of the "parent combo" may have only a single value.
In such case, I use the following line to automatically select this value as
the default value:

I have a list box with a name and social security number in it. the social
security number is the bound column. i need a code to launch a form entitled
"New_Visit_Patient_Entry" that opens for the patient highlighted in teh list
box.  the patient is already entered into the form, ...

Hello, I've an interesting problem. I'm using access 2002 SP3
  I have a form which displays all the records in a table, with all sorts
of filtering options and sorting available for the user..There is one value
field which the user can update..however they must update this field ...

I'm sure this is simple, but I haven't been able to figure out how to
identify the second Sunday of the current month. I need to know if today (or
the most recent Sunday if today is not Sunday) is the second Sunday of the
month. I am trying to include this data on a form that my ...

I wonder if it is possible to filter a subform in Access 2002. In other
words, the selection criteria of the filter are defined by the fields of the
subform.
This doesn't seem to work. The only way I can make up to implement this, is

How to stop code from executing after the Shell function
is called

Hello,
I have a form that contains a subform. I have them both set to default
datasheet view so they look like a table with the little plus sign beside
each record to show the related records from another table. When I open this

Using the following code -
Dim path As String
Dim wShell As Object 'New wshShell
Set wShell = CreateObject("WScript.Shell")

I have a form that people enter into at least once a
month but never a set number of days.  Is it possible to
subtract one date from another to get amount of days
since last read date or similar?  I have a unique

I'd like to know how I can retrieve the value of a selected word (cursor
highlight) in a memo box. In other words, how can I filter my records
according to one/several words highlighted in a field.
Thx

Hello !!
I have made a time booking table with a record for each day with date and
weekday and it will work until year 2015.
Then i made a form with two buttons so I can move thrue the dates forwards

Hi I would like to use the TransferText command in the
OnClick event of my CommandButton to output my whole
database to a csv file and place it on the desktop.  Can
anyone help me to do this??  I only have very limited

I have a subform that uses the continious form mode.
Question?
I am wanting to use a label in the detail area to say "No Record Available"
when there are no records viewable, then when there are records, hide the

I hae a combo box that has 3 columns, I used a wizard to generate the combo
box and I am getting one of the values to the table feild I want but I also
need to get another value from the same combo box and send that info to the
same table.

I have a combo on a form that will allow me to choose a
site from the dropdown. This is based on a table and will
create a record when picked of a number relating to the
primary key in the combos source table.