helloloo
I'm get used to the sound 'beep', and need some other sounds than it like to
have a sound of 'bomb'.
Thanks thanks,

I have a table that contains 4 fields for completion in a form.
I do not want users creating entries via the form where 2 of the fields
contain the same data as another record. I cannot set the table to disallow
duplicates on the fields individually as they are allowed and are ...

I have a form with several fields on it which calculate or lookup data based
on the input from other areas of the form.  The problem that I have is that
the calculated or looked up data doesn't seem to update in the underlying
table.  And in some cases, when I advance to the next ...

My database has a module in which I keep several global variables and I have
no problem referring to them in any of the forms or reports.  But there's
one that I now find I would like to refer to in a query and cannot determine
the right protocol (or even if it's permitted).  The ...

I have a char field which I check the "allow null" property and when I tried
to input an empty string that field, it always give me the following msg:
"You tried to assign Null value to a variable that isn't a Variant data
type"

Hello, all.  Thanks in advance for any assistance you might offer.
As instructed by the various articles and posts regarding how to add a
'<All>' item to the top of combo box, I am utilizing the following union
query as the rowsource for my box:

I created a form using the wizard.  Some of the fields require more than one
line.  In some instances, I must return to get to the second line in the
same "box".  In others, I use Control/Return to get to second line.
How do I make this uniform throughout my forms/

I’m trying to use Leszynski/Reddick naming conventions for all objects but
have come unstuck on the following:
1) Naming the different sections of a form (frmTestReports):
What prefix should I use for these names?

I'm trying to use conditional formatting in a listbox but the option is
greyed out. I'm using Access 2003. What I have is a listbox containing many
dates. Some of the dates are required and some are optional. I'd like to make
the required ones red and the optional ones black. Is ...

When I set the subform's Allow Additions = No, the subform is not visible
unless there a records.  Is it possible to set a subform to NOT allow
changes, additions, and data entry but have the sub-form visible at all time
and allow navigation buttons? thanks in advance.  

I have a membership form based on two queries.
The membership query provides the fixed information about the member
and the history query provides the history of joining and terminating
at various clubs in the league.

my forms on tab control are not requerying using the following code on the
change tab event, can some one please help.
Private Sub TabCtl5_Change()
Select Case Me.TabCtl5.Value

I have a batch file called transfer.bat which zips a few files together to
create one zip file.
How can I launch transfer.bat from within Access VBA?
-rick

I am new to access and I cannot figure this out on my own.  I first created a
table, then used autoform to create a form bound to that table.  I have been
using the form for about 2 months to input data into the table.  I recently
decided that I want to add a new field to my ...

I'm using a form very similar to Northwind's Order form. When I try to select
the product on the subform I get  "Compile error: Sub or Function not defined"
I'm not seeing where the problem could be. The function is from the
ProductIDcbo