Recent content by tarena

Thank you very much for your assistance jrbarnett.

I am using Access 97. I want to set a control button to automatically print the selected form to pdf (the printer name is pdf995) and then email the pdf to certain users using outlook 2003. Can I do this and how? Thank you Tarena

I am obviously doing this wrong. It is not working. I have the query to count the number of serial numbers per part number and I only want to see the 6 part numbers with the largest number of serial numbers. Can I do this in the same query or do I need to create another query to do this...

I'm using Access 97 and I have a query with 2 fields "numPartRecNo" which is set to "group" in the Total field & "intSerialNo" which is set to "count" in the Total field. I want to set criteria under the "intSerialNo" field to display the 6 largest items in the field when I run the query. How...

Ok Remou, that worked great, thank you but...can I now use this imageform to select and input a secific image into an already existing form that I have?

Alright, to do the simple query do I add any fields or just add the table and then just build the expression?

I'm using Access 97. I have employees signatures as jpegs and wanted to insert them into a form using a drop down list. Can I do this? If so, how? Thank you Tarena

I am using Access 97 and I need to count the number of records by part number. Can this be done with one query? The Fields I have in my table are "PartNum" and "SerialNum". I need to count how many "SerialNum" entries are made for each "PartNum". I tried the DCount but it only added the...

I'm using Access 97. I have a Work Order form with a control button on it to email our the form to certain people. Once the problem is fixed and the Work Order is closed we want a control button to send a response only to the person who sent out the original Work Order. Is there a way to do...

I'm using Access 97. I have a tabel listing date, employees, part numbers, presses, number of parts, total hours. If multiple employees make the same part on the same day on the same press then I want to total the parts made and then divide by the number of employees that worked on them. Is...

ok. I'm not really that advanced. I created the module but the log in information is not being saved anywhere. Is this going to be a problem?

I am using Access 97. I have a database that has a login screen for users to access the forms within it. When a user logs in, I want the name they logged in under to force that name onto any form they use. Is there a way to do this? Thanks Tarena

I have a form that pulls from 4 different tables. How can I make a field from one of the tables create a form for this new field? Thank you Tarena

I am using access 97. I have a form with a command button on it that when I click it the current system date is forced into one field and the current system time is forced into another field. Can I make if force the current user name of the user who is logged into the computer at the time of...

Is there any other way to select the bigging and ending dates using a calendar for a report parameter?