How can I set an analogue clock in a Form ?
JDW
Belgium
Europe

I have a form with source of data on query "qrymultiselect"
On this form I have a multiselect list and a button "filter"
With click a button there is a procedure that is creating query
"qrymultiselect" with criteria from my multiselect.

Hallo all,
I want to retrieve a value from a Web page.
I have a web-based processor that measures temperatures from 8 different
sensors and displays it in a simple web page.

Folks,
I've got a text field that contains values such as 09/20/62,
03/13/68...  Is there a way that I can create a "real" date variable
from this mess - something that other software such as SAS, EXCEL and

How does Access determine how many data points it will use in a chart
and is there any way of forcing it to use more data points?  My Access
chart is only showing 7 data points of the 100+ that are available.  If
I dump the same data into Excel and chart it, the Excel chart shows ...

When I place the following in my query
ProductivityHours:
IIf([dbo_tblservice_activity]![activity_sysid]=85,actualtimeintounittime([units_activity_num]),IIf([dbo_tblservice_activity].[activity_sysid]=231,3,Sum(IIf([dbo_tblservice_activity]![activity_sysid]=33 ...

Is it faster to ...
format the data in the query -  then run the report
or
run the query - then format the data in the report

I thought that you could take a value created in a text box of
one form & make it available for use by other forms in the same
database as  until you closed that database.
If this is possible could someone post the code needed to do it.

I asked this question in Microsoft.Public.Word two days ago but I have
not received an answer. I believe there are Office Experts here who may
be able to help.
---------

Is there a way, from Access, to programmatically click the Send and
Receive button in Outlook?

I have a form that contains 8 textboxes "Textbox30, Textbox31,
Textbox32, Textbox33, Textbox34, Textbox35, Textbox36, Textbox37".
This form is designed to allow the user to input up to eight Department
Codes.  When they hit the submit button, it opens a report based off

Hi Gang
I have a simple single table that has many duplicate rows in them.  The
distinctrows only works on more than one table.  Is there a quick and
easy way to select only the distict rows from one table?

Hi, I did not find in Help the way for creating AutoNumber field in code.
I've tried to adapt these lines for that purpose
       Set fldClientID = .CreateField("ClientID", dbLong)
       .Fields.Append fldClientID

I build string sql in this way:
For Each varItem In Me!Lstclient.ItemsSelected
           strCriteria = strCriteria & "tbltable1.client = " & Chr(34)
_

Does anyone know how I could limit the number of rows allowed in a MS
Access table... want to limit it to 1.