I am trying to get a "Date entered" box to automatically fill when a
tick box = true, without success so its over to the experts for some
much needed help
Thanks in advance

I was just working on a project of creating a database for a relative that
have alots of clients. His company managed the shares portfolio of clients
and he requires the buy price of each stock in a particular client accounts
to be weighted averaged every time there is a purchase in ...

So I've got a table full of orders.  I have a query that counts the
orders, no problem.
Now I've also got a query that tells me if the order is due or not.
Its a little more complicated, but basically says

For the last 7 years we have been using a piece of software that's
based on Access 2000. About two years ago I created several MS Word
documents (merge files) that get data from this Access database and
today these documents are a crucial part of our business, they are

I am trying to instantiate an activex control directly from a
class module.
    My declaration is as follows:  Private WithEvents myPCCharge As
Charge.OCXCharge

I am trying to change the data in a text field in a table.  I can change this
field in other entries, but one specific one I receive this error:
The search key was not found in any record. (Error 3709)
This error occurs when an ISAM SEEK is being executed and there are no

To preface this post, I personally did not create the database in question.
It was created by someone working for our technical support provider.  That
person has since left the company and is not reachable.  Therefore, we should
bear in mind that I have no knowledge of how this ...

I am using the RTF2 control hat Stephen Lebans provides in one of my apps.
I am struggling with the issue how to check if the OCX is installed (properly)
==> I am distributing an mde.
When the OCX is not installed the app just errors in a way that is very unclear to some users.

We have a developer who created an initial database. He gave me access
to the database via the network by linking me into the main tables and
giving me access to add and modify.
I then designed reports and queries on my computer, which work fine on

Here's my code:
If Me![Gender] = "Male" Then
          Me.[B1].Visible = Me.[age] < 13
          Me.[B3].Visible = Me.[age] > 12

How can I make an array of command buttons (or toggle buttons) on a form and
have a text box on the same form display the index of the button clicked?  This
works very well in VB6, but I can't duplicate the action in Access.
Chuck

I need to get the right end of a field.  Really what i want is
everything after 7 characters in.
so if the field is 123456789
i would return 89

I have a main form with two subforms (both in datasheet view), neither
of which are linked to the main form.  The main form is based on a
query that uses the bound column of a combobox on the main form as the
criteria for the query. The combobox is based on a query that

All,
I've got a continuous form with one field on it, with a comob

I need to provide my users with a request form so they can provide as much
info as possible when they want me to build an application for them. If some
one has drafted one up and wouldn't mind sharing with me that would help a
lot. Thanks.