I have the following two tables:
(1) tblPharmacy has individual prescriptions from a pharmacy listed by
medical record number, date of prescription, and drug class (one of 2 defined
drug classes)

Why can't I open a picture in microsoft office picture manager?

I want to create a collection of forms that maintains the state of the form.
I plan to add the form to the collection, then close the form before I move
onto the next form selected by the user. I think I can do that. However, when
I want to return to a form at it's saved state in ...

I have a form that I use to review information about components.  Can I open
the same for for dataentry, by changing the DataEntry property in VBA when
the form opens?

I am accepting parameters from the user. then run a query to display all the
records.
Once i display all the record, i would like the user to click on the
particular record that he/she is interested in for edition or deletion.

Is there anything like a close database event.  I want to run some code just
before closing a database automatically.

For simplicity sake,
I need to take entered TEXT. i.e. "2 + 2"
and output the formula's solution. i.e. 4
The formula is saved in a text box and the output is diplayed in a seperate

There has been a lot of discussion that adp is currently not recommended for
use over mdb by Microsoft.  Can anyone verify is this is true?

I have an Access 97 fe/be database where the be data had a corruption. I
successfully repaired with Access and JetCompact but ever since there is one
fe report in particular that takes about 20 seconds to run compared to about
1 second before. Nothing has changed in the front end ...

Is there a way (within Access) to get a report to show up in the e-mail body
instead of as an HTML attachment?
Here is my SendObject statement:
DoCmd.SendObject acSendReport, "ReportName", acFormatHTML, "abc@xyz.com", ,

I'm trying to export a file with the current date and keep getting the
following error.  "The Microsoft Jet database engine could not find the
object 'NPS100907.txt'. Make sure the object exists and that you spell its
name and the path name correctly."  I could have swore this ...

Hi there, I'm trying to append a table using data from two tables that can be
joined in two places.
What I have is tblAuditDetails from which I want to pick the Audit ID. I
then have tblCMMISpecifics, from which I want to pick the PA ID (and

I would like to determine the age of an invoice being able to subtract the
[InvoiceDate] from the current date and display the information on a daily
report.  What is the best way to go about this?

I want a means to determine whether the perating system is Vista or not, upon
startup of an application.  It does not need to check for all possible
permutations of Windows operating systems - just Vista or not.
The problem, however, with using the typical GetVersionEx API is

Hi, i want to create different dataset by grouping records based on
condition. I want to break this data in different set of records run time for
calculation purpose, is it possible using some loop structure ?
My Table has field Month,Sales