We have an application developed by one developer. He compiled the
database into an application and digitally signed the application. He
doesn't know if he used selfcert of makecert to make the key.
The problem is I am creating additional forms now for the database on

Hi I'm trying to Dcount *unique* records by comparing a date/time
field. I say *unique* because the field contains a date/time but I
need to ignore the timestamp and work off the date only.
I think the code below should work to count unique values in a normal

I am putting together a small Access 2003 DB to record details of our
motorvehicles. (this is more to teach myself some basics with Access)
The main form is holding data that is common to most vehicles.  Eg.
Registration date, expiry, VIN/Chassis, Make, Model, Year.

I'm having trouble with a query that should be returning one existing
record, but it's returning no records.
I created one new record, and left the program ID and Bug Type ID blank, so
the query below should pick up the record. Looking in the table of bugs, the

How can I get a list of the fields in an Access table into Word? I am
working on a very misdesigned database where one table has over 100 fields
and several others have over 50 fields. I am writing a report in Word and
want to include the list of fields in certain tables. I am ...

I have an option group called Issue_Type on my main form
F1_Member_Demographics_Main. When I select one of the 3 options on the
main form from the option group Issue_Type I want to limit the sub
form F2_Member_Issues records based on the combo box Issue_Code_T1.

I have created a LABEL, and placed it on top of a button.
When I press the button, the label disappears under the button.
Is there a way to get the LABEL to stay on top of the button,
or reappear after the button is clicked ?  I need the Label to remain

Hi, I have a database in access with the following columns:
Day
AgentID
ManagerID

I have a table (Table A). It has one field, a PK. It is in a 1:M with
another table (Table B). I am having trouble with a form/subform setup
to view the 1:M records.
On the parent form, there is a combo box with a Select query to select

Is it possible to prevent a row from being deleted in a table.  I want
to arrange a new table with an autonumbered primary key that will form
part of a set of sequential serial numbers. I want to protect the
integrity of the sequence so that an accidental deletion of a row can

In my business, I use Quickbooks extensively for billing and accounting and
a custom built Access DB for project management. I recently began using MS
Outlooks contacts quite extensively as well (recently bought a PDA to bring
to job sites!). I have been able to get things set up ...

How does one detect (in code) when the Delete key has been pressed.  The
KeyPress event doesn't respond to this keystroke.
Thanks,
Gord

So I have a form which shows all items available for sale, when it was
last sold, where it was last sold, and whether it is active or
inactive.
I would like to be able to edit the active/inactive field (its a yes/

for:
There was no reference to CDO in the References so selected CDO.
Code didn't work (CDONTS.email unrecognised).
read

I am trying to sum a population field that may have 140 records for
each Ward (example).
Any suggestions on the best way to do this.
I would like to have a unique record for each Ward with all the