how can i set the dates in a fieldn in my tables in ms access to
handle only dates and no time?  in creating my table, i set its type
to 'date/time' with 'short date' format.  but when i entered values in
it, the data i get was '4/1/2004 4:28:12 PM'.  i only want this field

I am new to Access.  I have a form with a single record.  The keyed field is
PropID (number).  I want to run a query from the form that will have the
current value of  PropID be the variable in the criteria of the query.  The
intent being the query returns the values of the current  ...

I'm using A97.
What I'd like to do is to run a function (say F1) which name is stored in a
table, from within another function (F2) (not directly on the click of an
existing button). I would pass the F1 name as a parameter to F2. So, how

I have a table called Members (200 entries - member ID ) and one called
Photos (50 entries - Photo ID, Images)
How do I display all 200 members and the corresponding 50 entries so I get
something like below

Does anyone have any ideas on how to write self-destruct code?
I need to run a one-time procedure the next time a database opens. If the
procedure is successful, the procedure needs to be deleted and the code that
initiated the procedure needs to delete itself.

Even after changing Invoice_ID to Clng(Invoice_ID) and trying to link
to the Reference_2 field which is text it is giving me a type mismatch
error.
So I created a new query in access where I took the field Invoice_ID,

I thought I posted this yesterday, but can't find it. So if this ends
up showing up twice, please forgive me.
I am an Access developer and have done many Access databases in the
standard Front-end on the workstations, backend on the server

Hi, I am a first time poster here. I have been given an assignment to do
from college and it is ot create a student gradebook. I have planned all the
tables etc. to what I believe to be correct. I have also set the
relationships etc.

I am new on Access.
What would be the best solution for this?
We are getting access files from our suppliers in the following
format.

I created a simply database and I created a form to enter the data.  But I
will like to create a button that brings a window where it ask me what
specific record I'm looking for.
Does somebody knows what code should I used so I can search my record more

Here is another question:
I run a database in Access RT in a Virtual PC environment.
Every now and then I get an error: "Object Not set", which then freezes
everything.  Not even CTRL + ALT + DELETE can really help.

I need to programmatically create a link to a table in an MDB on a CD, so I
can read data from it.
Access objects that it can't create an LDB file in the same directory as the
MDB.

I am using a headform including a field  called "Location" (and some details
about the location) and a subform containing of  several fields including "
Location" and "Employee". The link between the headform and the subform is "
Location". In the subform a want to use a combobox to ...

I have a secured database that runs fine on the computer the database is
installed on.  I have several workstations with access runtime installed
that also need access to the database.  Access runtime runs fine when
accessing an unsecured version of the database.  However once the ...

I am trying to find difference between two time values in hours. I have
tried the following?
? dateDiff("h",  #23:00:00#, #23:00:00#) gives 0 as expected.
? dateDiff("h",  #00:00:00#, #23:00:00#) gives 23??? should it not be 1 as