Hi, everybody. I'm new here. I would like to find someone out there who could
give a hand in a bunch of errors I'm getting.
I am using Access 2003. I have a 9-fielded table with two Currency data type
fields with their Validation Rule properties set to ">0". I have also set

I have a large table with three address fields.  Any of the fields can
contain an abbreviation which I want to change: "Blvd" to "Boulevard," for
example.  I have a smaller table with a list of abbreviations to change and
their preferred formats.  I would like my command button ...

From my Access 2000 application I am opening an Excel workbook which starts
with 10 worksheets (used for other purposes).  The second sheet is used to
display projects.  I am adding(appending) additional worksheets as needed
depending on the number of projects encountered in my ...

I have a form with an underlying table that I need to be able to delete
records from.  This is not a problem in itself, but there is a second table I
want to delete a record from which has the same primary key as the first
table.  The help screens on how to delete a record ...

I am trying to set a variable equal to the result of a sql query all within
VB (Access Form Code).  Here is an excerpt from my code:
Dim lsSQL As String
lsSQL = "SELECT [5_Deficiency_Item].[Magnitude] from [5_Deficiency_Item] " & _

I have submitted fields and assessed fields on a form.
I want to code such that if an assessed field is not equal to the submitted
field, I would like the assessed field to be bolded and red.
Q1: Which event would be best to put this code in?

I have a multiple user FE/BE database.
Depending department determins which FE they have.
One Departments FE has a main page with there own buttons ECT and, a SUBform
linked to a table displaying missing items that another department has

Can you please have a look at the code below and tell me where I have gone
wrong.
I need to be able to log the start and stop times of each job and use those
times to calculate costing of job and payroll figs.

MS Access 2K, Windows XP
=====================
Hi,
I have a simple form with the following code in the forms's On Load event:

I want to do some currency calulcations on fields on a form and handle any
nulls.
I have read the help and am having some troubles.
Formuals is:

I am using access 2000 and trying to create a database to record and track
time spent on jobs to eventually use in payroll.
I have 2 command buttons in the form - one for logon, the other logoff.
I need to be able to record the time on and off when these buttons are

I want to prevent characters other than the following from being entered into
a text box:
‘0’ to ‘9’
‘A’ to ‘Z’ (upper case only)

Good evening to you all. Im sorry if  this message gets too long, eheh , but
its as short as i can get it.
Well, I have a slight problem printing a product tree that is organized as
follows. Well, there is a product name field, a product number, and product

I have a form with a subform, and need to pull in calculations from
unrelated tables and queries.  In one case I use dlookup to pull in the sum
of all checks paid against a job.  In another I use it to pull in the
descriptions for job codes.  There are a couple other uses.  However, ...

I am having a problem with my ElseIf statement which is in my form event
(Before update) I have two fields one call AssignedOn, which is a date field
and the other is AssignedTo a text field.  My problem is I get a error
message -Run time error "424"  Object Required using the ...