Hello, I have a few text and combo boxes on my form that I want to have the
color change to red if there isnt any information selected in them. I was
going to use conditional formating but it only lets you use 3 Expresion is
and I have a few that need to cange red. I also wanted ...

I have an Accounts Receivable DB.  The information is fed to the DB by a
couple of text files that come from my companies internal system.  I have set
these files up as linked tables.  The linked table I am having problems with
right now is ARReport.  I have taken a look at the ...

I have used access 2003 to create a simple contacts db before but needs are
different now.  I want to create a db that will include a
calender/appointments linked to my teaching hours and lesson plans and
resources.  Is there a template that I can modify easily or should I start

I have an Accounts Receivable program that I am trying to write a find dups
query for.  
I am keying from the Ref # which can have multiple invoices under each.  I
am also pulling the amount of each invoice.  

I am trying to edit the Timing and Billing Database. I wanted to add a field
for "case number". I added the field and also edited the form and saved it. I
tried to open it and it says "there isn't enough memory to complete this
operation". What am I doing wrong?

Hello, I am trying to sum a control from a continious forms detail section.
The form is based on a query named qrySuperlog. the text box im trying to sum
is named txtfootage and its control source is named FOOTAGE. I created an
unbound textbox in the detail section and named it ...

I am trying to get an automated value assiged to a particular tag in access.
There are some different types of tags, where as i have to get an automated
value of the specific  tags.
For eg:

I work at a production facility. My main users are the floor
supervisors. Our current data collection is in Excel. The supervisors'
current habit is to input partial records throughout the day (e.g.,
Workstation, Part Number..) but not the Employee(s) name or

One of my main reports calculates the total number of hours worked by
180 employees across 3 shifts and 2 departments every day multiplied
by a constant stored value for each part produced. This would be
relatively easy if each employee actually worked 8 hours and each

I have a text file(.txt) that is has 20,000 plus records, and each record
contains about 30 columns of information.  I have 55 of these files.  The
problem with a simple import is that there is a couple lines of information
that belong together(ie there are two lines of ...

Hello, Im using a function in my switchboard with two text boxes that
requires me to select dates. Its working fine but I want to have another
section with a differnt area on the same switchboard that will allow me to
choose only one date from a seperate text box. How would I fix ...

Is it possible to create a command button on a form that will open a folder
on the network?
I can create a hyperlink to a file but not to a folder,
any help would be appreciated

I want to generate a query that calculates the work hours of all
employees based on adding/subtracting from an 80 hour work period.
TABLES (3):
EMPLOYEE:

I see from other postings that page headers don't show-up in sub-reports. I
need help implimenting this fix:
"One workaround is to create a group header in the subreport that is always
the same. In the Sorting And Grouping dialog, enter the field:

Hello, I want to be able to send an email with a message stating the persons
name and a date from a query in my DB. I wanted this to run in the background
with no pop up windows ect when the DB is opened. The query I made is named
qrySendEmail and it has 2 fields "EmployeeName" ...