I have the need to import logs into an Access table.
The first field is a date & time field, represented in this example:
05/15/2004 17:58:55.336
This is how the logs are reported. Date[SPACE]Time. The time is to 3

We're are about to develop an app in C# that will use a MS Access
database file for data storage.  The db structure will not be
modified.  The user will use the C# developed app to view and edit the
data (as well as add/delete records etc.).

Im trying to use thie combination but have not had success. Below is the
function
It tried the following
myriskLevel(2,2)

I have a table named CASES based used to store data for a small
insurance company used to keep track of all the different forms used
for a specific client.
Some field refers to a different forms and are named with the form

I am trying to find a way to normalise my database but am having
difficulty in ways to do this, as my table is over 100 fields.
A lot of the information is duplicated for previous years.  This is
the bit I think I can put in to another table.

Greetings all,
   As a newbie, using Access 2000, I would appreciate advice on the best
way to include pictures.
   I have developed a 'Home Inventory' database which can include jpeg

I have a table with saison_Id, saison_begin and saison_end in which i have 9
records or 9 saisons. in secodnd table i enter guest_id, guest_name,
guest_arrival and guest_departure.
now i need to calculates how many days did the guest stayed by saisons.

I have a form with 3 subforms (linked, the prevois to the next) which are
continuous forms, I wonder whether it is possible to move automathically the
cursor from one subform to the next when I finish entering the data instead
of using ctrl+tab.

How can I get the decimal part of a number? For example, the number is 4.25. How
do I get .25?
Thanks!
Mark

I'm working with Access 2K and seem to be getting some behavior that
contradicts the documentation. First, the help says:
"Note   The Activate event doesn't occur when a form receives focus back
from a dialog box, popup, or another form."

He everbody,
I came across a positng dated 2001 about the above.
I copied the code Hans De Schrijver posted at that time but I need more
help.

At the outset let me admit that I screwed up!
I have built a rather elaborate set of forms and sub forms starting with a client table,
and going down to PO and Line item. This works very well EXCEPT that when I started the
design I failed to consider that client records would be ...

Thanks for your help and reading my note!
I would like to display an image that would let the user know that
more information was stored in a comments field.  If the comments
field is empty I don't want to display the image.  If/when I get this

when or Where do you use a union query ?
how can I wright sql,
 tblPopulation,*  tblcustomer,*  one to one with  
all the appropriate attributes(field).

  I'm trying to do something that looks simple, but I can't make it
work right.
It's Access 2000 on a Win2000 computer.   I create a database with 5
columbs.  The data I need to import is text.  The way it's formatted