I had a problem starting windows XP .. so I reinstalled Windows. Now I cant
open my Access97 database file. I get the following error message as
Access97 tries to open the switchboard:
"ActiveX component cant create object"

Using XP and Access2003:
I'm trying to track furnace downtime.
Operators will enter the downtime date and time manually but it could
be entered some time after the furnace goes down.

One more try.
After ransacking the Desktop AND Enterprise edition of Ken Getz Dev
Handbooks on Access 2002, I STILL don't know if it is or is not
possible to  link a client side MDE with a WEB server MDB table using

i want to create a form where the user can choose from a list of names
in table A
associated with this name is a telephone and address
on the form there will be a drop list for the name, fields for address

I am trying to create a function that is called on the Flex Grid's
MouseDown event.  However, this event is not listed in the properties
for this object.  I tried to manually create the prototype for this
event as:

i have made a small database for my logbook. i am being asked by my
colleagues that i should give them the file as they see it to be
helpful. now the problem is that when i use "user level security
wizard" and create a user with limited privilages and place it in say

                   I am Bhupi and I had a problem im M.Access. I have
created many-to-many relation between two tables vehicle and item_mast
with intermidate table between them.
In vehicle table i want field vno,date and time as a combine primary

Recently I found a really useful VBA program to compare two text
strings. It would determine how many changes, deletions or additions
would be necessary to change the test string to the reference string.
What I really liked about it was an ability to test for typographical

I have a database that I need to download tables into.  My ODBC source
takes way to long to report from, so I need to copy certain tables to
an Access database, then I run my reports off that.
What's the best way to do this?  Right now I'm using a macro that has

I'm using Access 2002.  I have a few memo fields on a form and have
just noticed that the memo field's vertical scroll bar disappears when
I change the left margin setting of the memo field - I changed it from
0cm to 0.1 cm.  The scroll bar reappears when I set the margin back to

Using MS Asccess 2000:
In a query I'm trying to create a new field with following expression:
FilmDate: Left([FilmNo],4)
The field "FilmNo" is another text field in the query.

I am a geologist, and over the years I've accumulated quite a number
of proffesional papers on the subject, in various publications. I
would like to make a database that would help me find the information
I want, based on keywords mentioned in the needed paper.

All,
   I have read the article on the MVP site regarding this topic
(http://www.mvps.org/access/forms/frm0028.htm) but I am having some problems
implementing it.

All:
I want to turn my hourglass around to indicate my program is still
running.  I am using VBA with Excel and MS Access 2000.
So far I use DoCmd.Hourglass true and false to turn on/off hour glass.

i created a table in Access 7.0 which contains a datetime field. when i
tried to write a querry in visual basic to compare this datetime field
with another date variable like select passportno from AppliedVisa
where ReceiveDate = " & curdate & " and status = " & "'" & "No" & "'"