As you can tell I am new to Access.  
I have a query with a field called Value.  I would like to create an
expression field that would give me the following:
If, Value equals IPS or ECR, then IPS/ECR, otherwise use the Value.

Our IT department installed Outlook 2003 on my new laptop.
From that moment I cannon send mails via a macro in Access anymore.
It was working with Outlook 2000.
When I am in the Visual Basic screen and want to Debug, the next error

How does one test for 'no value', as in runtime error 2427 "You entered an
expression that has no value"?
Tried IsNull, IsMissing and IsEmpty, but processing just skips right by.
I am giving people the ability to move an entry from a subform list, but

A lot of what we do here requires a lot of 3 1/2 floppies.  It would be nice
if they could format a floppy disk in our software instaed of using windows
explorer.
Does anyone have the API call and code need to use the windows "format"

I have a form that calculates and writes/appends to a database.   It could
take up to an hour as the data could be very large.   I would like to display
what process is running so the user see's that the application has not locked
up.

I am working with two recordsets A and B.  Recordset A has a date field and
for a current record this is null.  I have some code that finds the first
occurrence of a null value date and then moves back n times to find a record,
it then takes the values of that record and creates ...

Is it possible to allow only selected items when a user opens up a database?  
For example, I would like the user to be able to use only "Save-As" under
"File".  It doesn;t matter if the other items are grayed out or not
displayed.  Can I create a custom menu?  If so, how do I do ...

I have a form that people use and sometimes they click the x in the upper
right hand corner of the form to close it.  I want to validate that certain
text boxes are not blank and if they are have a message box pop up and the
close action stopped.

My access db relies on information that first must be reformatted using
Excel.  On my Add New Record form, I want to link to this Excel spreadsheet
using a command button.  How do I specifiy the specific spreadsheet to be
called up?  I'm assuming I'll use an On Click procedure, ...

I think I may be in over my head on something here. I have a database which
contaings, among other things, a table with fields for email addresses and
expiration dates. I am trying to set up something that will email a notice
to subscribers when their subscriptions are about to ...

I have an MS Access Database with multiple forms that all update fields
in a single table because I can't fit all the required fields onto a
single screen. I have looked into converting these multiple forms into
a single form with subforms as tabs  but to date my attempts to do this

I get an error: "You can't use the GoToRecord action or method on an object
in Design view."  the error is generating on the GoToRecord line. Its a table
based form and it happens when i try to open an employee twice. The table PK
is autonumber (ID).

I have inherited the code below which basically looks at the date, creates a
series of queries dependant on that date and then combines the results from
these queries into one table for export to Excel.  The data is sourced from
two tables and compares the 'Fund' data with its ...

I'm unable to use the Mid function in VBA with Access97.  When
attempting to add the proper Visual Basic for Applications reference
(VBE6.DLL), I encounter an error, as it conflicts with the default VBA
reference, which cannot be removed.  Anything else I can do?

Which way of calling the common dialog box is more reliable?  Using the
Active X or the windows API?  When I use the Active X, it's not much coding
and simple to use.  I have never used the API, but every now and then, the
Active X acts up, and now my cmdl is dead?  Can anyone ...