I have a subform that lists the names of samples that are related to the
sample on the main form. On the subform I have a hyperlink to one of two
forms which are supposed to open up filtered to the name on the subform.
Ie:

I have a form where a user can select to take responsibility for a
ticket.  At that point, the user will be able to view the record and
all other data pertaining to it, but no one else will.  I want to set
a safeguard in the event the user forgets about the ticket or goes on

Hi -
I have a form open with temp table as record source contain fields Lastname
and Firstname.
- How I search lastname and Firstname in two (2) another tables have same

I am using 'OutputTo' to generate a report in snapshot format.
It works perfectly when I bypass the StartUp form with the shift key, so
that it goes into edit mode. But when I start the database as a user would
do, and get to the snapshot generation code, I get the error message ...

I have a database that is Access FE and SQL Server BE.
Once the user has input all the relevant data into the Combo & TextBox's I
have a submit cmdButton which will then update the relevant recordset in the
table. My problem is that once this has been done and the User clicks Add ...

I accidentally posted this as a reply to my own question on Nov. 5.  I have
copied that "reply" and posted it as new:
I posted this question before (in this group on Nov. 5) with quite a bit of
detail that was intended in part to show I had tried everything I could

I am trying to send multiple emails with attached files at once.
The code should take each record and populate to the report then attached
that report to email and send it. The email address has in each record in the
table.

I have a Main Screen obtain the records from a temp table. User will click a
button to search for Lastname and Firstname in 2 separate table Customer and
table Service.
If found in those 2 tables then

I'll begin by saying I am still new to Access, with less than a year since I
was told to pick it up and learn as I went, and have only been digging into
the SQL for about a month. What I would like to know is if I am on the right
track for a project I am working on.

Hi All,
Do you know of a program from SUN that can run MDB/MDE?
Thanks,
Tracktraining

I have a database that is Access FE and SQL Server BE.
Once the user has input all the relevant data into the Combo & TextBox's I
have a submit cmdButton which will then update the relevant recordset in the
table. My problem is that once this has been done and the User clicks Add ...

Hi,  I have the following data structure.  One sr contains 20 different nums
in nums field. Instead writing sr (here 1) again and again 20 times, what I
should do to generate sr.no. twenty times automatically and after entering 20
nums it should increment by sr+1.

I just wonder are there any function that can use for auto distribute
weight factor.
I have a request that for 7 weight factor which should be 100% total.
Is it possible to have user modify weight factor and distribute the

I have 200 records in my table ‘tblLetters’ (ContactName, ShippedDate and
ContactEmail columns) and I have one report ‘rptLetter’.  The ContactName and
ShippedDate columns populates in the report.
Sense I have 200 records. I need to create 200 SNP files and OutputTo to c:\

I have bound subform "frm_Summary" that links to my master data table
"tbl_Contractor." At the top of this form I have two combo boxes "cmb1",
"cmb2"
- Cmb1: queries tbl_Contractor and brings back the Invoice number, I am