I'm a newbie here so please be gentle!  I have a main form with 5 subforms run off it.  I have copied Allen Browne's Audit Trail code (thanks to Allen Browne) and I have everything working fine, the only problem that I have is when I try to delete a record in one of my subforms ...

How do I get rid of the less then friendly "The value you entered
isn't valid for this field" message?
Validation Text = "Please Enter a Valid Date"
Validation Rule = "Is Null Or IsDate([dob])=True"

i have a form which have "material code" and "DOno". this two field are text.
in this form i want when click the button and it will open another form. but
it is link with this two two field. how i write the code in the
stLinkCriteria. I have try many times, but stil cant get the ...

I am trying to print a form that has a list. I have tried to drag a command
button, and then choose Print Form command. However, it only prints those
items that are shown in the list but not all of them (since you need to
scroll down to see all of the items). Is there a way where ...

1) I noticed that when I attempt to control the colors of forms ...
Me.Section(acDetail).BackColor = &SomeHex ... where &SomeHex is the exact
same value I copied from the forms back color property when I selected that
color do not work. Does anyone know if there is a list of 'hex ...

I have created a database for running a competition.
My Table is called        Entries
Some fields in table are
Entry #

I'm trying to use the following code to spell check a textbox (memo field
actually) - called from the AfterUpdate event.
I get an error message saying that  "The Macro or function set to the
BeforeUpdate or ValidationRule property for this field is preventing the DB

I'm trying to create a backoffice to a website.
I have a problem here. I need to copy the file from location on text1 to
location of text2 and update the  text of text3.
I have this on the textboxs:

I am adapting some code that will open an outside program when a command
button is pushed. I have sucessfully merged the code into my database. The
button works when I am using it on my computer but I get a path not found
when running it on another computer in the office. If ...

Starting from a hyperlink, would it be possible to save the destination file
without having to open the file?
That would be like a copy from a local path to another, but I understand
that the url doesn't work exactly like a hard drive path.

I have 2 tables, [adjustments] which has date, and price adjustments, and i
have [work done] which has all of the information that is calculated off of
the quantity entered and using the price adjustments related to the date
entered.

I have a query where it downloads information out of our database.
This database has volumes of items in weeks instead of days. so the
format would be 200801 for 2008 week 1, 200802, 200803, etc etc. Now I
want the last or most current week in the table, so I tried doing last

Having trouble with this one continuous form......i've tried many
alternatives on the load and open event without luck.
The fields/record are Category , Subcategory , Item , Checkbox
When the Subcategory is blank, i want the checkbox to not be visible for

Hello - there are 5 comboboxes in a subform from which users select
multiple staff involved in an incident.  When a user selects a staff
person for one of the comboboxes, I'd like the name to be excluded or
filtered out of the other comboboxes.  Or--and possibly better yet--

I am trying to use the screen.activecontrol command in the Form_current sub
in order to collect the name of the textbox the cursor was last in before the
record changed.
Everytime i try and use this command i get the error message 'Run-time error