Hiya,
I am kind of a novice at this and I think there might be a very easy
solution to this that I am missing...
I have a form that we fill out for a patient's medication use.  The

Access 2003
Several days ago, I deleted a field from a table, which was no longer
required.  Additionally, all associated elements for this field were also
removed from the database, i.e. from Forms, Queries, Reports.

How do you unlink tables in a split database.  Or change the link?
Thanks
DS

DoCmd.RunCommand acCmdDeleteRecord
raises error:  2046 The command or action 'DeleteRecord' isn't available
now.
Why could it be?

We are doing data entry into an Access database form. A lot of the
names are the same but other data changes (date, address, client ...)
What I'm wondering is ... is there a function key that allows you - in
form view - to automatically copy the data entered in the preceeding

I have a simple form that will gather it's information from a card
reader.  The form has 3 fields SSN which is gathered from the card
swipe.  Can I make access automaticly hit enter when it hits the last
digit in this field, it will always be 11 digits (000-00-0000)?  I wold

I have a table with a field that has ( a sample )
13767;38355;520270-1;
44795;38355;110818;
13981;38355;563550;

I'm trying to display an OLE object (.jpg) linked to a database record on a
form.  When the form is displayed, the .jpg image doesn't appear.  What
appears are the characters |3| in the space on the form that I designed to
display the image.  Anyone have any ideas what this means?

I have a wedge mag stripe reader that I swipe when ask to input
information in a query.
How do I filter the unwanted characters.
Apparently there are two mag stripes that are read every time I swipe

All,
In Microsoft Access when creating a query how do you enter a timeframe
for access to search between, as we need to search records by the week
on month, but we can only figure out how to search information on a

I have a problem with some of my command buttons, in design view I set
their properties to not visible. When I load up the form they appear
(visible).  I can create another button to set them to not visible, this
works.. I tried setting them to not visible in the forms onCurrent

A2003, Xp Pro.
I've designed a form which contains 6 of combos.  Three on the left are
set up to select fields from a query, three on the right are set up to
select values from the corresponding field selected on the left.

I have a form that brings in the customer address info.  On this form I
would like to put a sub-form that displays the Peachtree ID for this
customer.  This works fine.  However, when I create a new customer
record, and then in the sub-form a new Peachtree record, the customer

All,
When you sell a product we require access to remove that information
from the stock table, so the product is sold througha  comobo box named
"Combo4" under the prodcuts sold form which is a sub-form of the form

        I currently have a database in Access 2002 with several
forms. I would like to restrict access to one form in perticular until
November 1st every year. My current method (attempted method) is a
heavy handed, no nonsense, direct date comparison using VBA.