Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tarena
  • Content: Threads
  • Order by date
  1. tarena

    Print to a selected printer and email screen shot

    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
  2. tarena

    Need query to show 6 largest items

    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...
  3. tarena

    Inserting Signatures

    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
  4. tarena

    Need to count records

    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...
  5. tarena

    Email response

    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...
  6. tarena

    Can I multiply by the number of records?

    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...
  7. tarena

    how to make a "login screen" force the users name

    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
  8. tarena

    Force the creation of a Form

    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
  9. tarena

    Force a users name with a cmd button

    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...
  10. tarena

    Running a report by selecting a date range from a calendar control

    I have a report that is generated from a query. I have a for with a calendar control to select a date range but I can not put the two together so that when you click the button to run the report it opens the calendar form first so that you can select the date range that the report should be...
  11. tarena

    Making a field not visible on one network computer

    I'm using Access 97. I have a form that has a subform that has one field that I need to make not visible to one computer on our network. Is there a way to do this with code or any other way? Thank you Tarena
  12. tarena

    Control Buttons

    I want one control button to enter the system time and date when clicked and the next time it is clicked to enter the same thing but as a new record. I am running Access 97. Can I do this? Thanks Tarena
  13. tarena

    Conditional Formatting a form

    I'm using Access 97 and need to format a field to be one color if the value is greater than the base number and another color if the value is less than the base number and just white if the value is = to the base number. I know how to format a report but doing it in a form is stumping me. Can...
  14. tarena

    Show date range on report

    I have a report that shows the date range that I selected to run the report...in the report properties, in the "control source" I put the following; ="Effeciency Report: " & Format([Forms]![frmGetDateRange]![dteStart],"mm/dd/yyyy") & " - " &...
  15. tarena

    Seperating data in a table

    I have a table with 2 to 4 lines of data per each employee. I need to pull this information from a vertical list of data in the table into a horizontal list in a query...per employee name. Can this be done and if so...how? Thank you
  16. tarena

    13 month date range

    I need to get data within a 13 month date range from the system date to 13 months back. I'm using access 97. How do I do this?
  17. tarena

    Calculations in queries

    I have a query with calculations that divide one field by another however, if one of the fields is a zero the result comes back as #error. The field needs to have a value or the total will not calculate. How can I get the #Error to show as either a blank or a zero? Thank you Tarena
  18. tarena

    Conditional Formatting on a report

    I have a report with 4 fields that if the % in the fields falls below 80% then I want the field or the front to become a different color than the default color. Do I do the formatting in the report or in the query? How do I do this? My report name is "rptEffeciency", it pulls from...
  19. tarena

    Importing from Excel

    I have a report run from one program and it lists times that employees clock in and out. It gives me all the info I need but it lists all of it in columns. I need to import this into a table and calculate it as follows. (TIME IN minus TIME OUT)minus (LUNCH IN minus LUNCH OUT). How can I do...
  20. tarena

    AutoNumbers

    I imported data from an excel spreadsheet into an access table, it contains clock numbers, employee names and their shifts. I made the clock numbers field the primary key and I want this field to automatically populate with the next number. Can you indicate the number that you want the...

Part and Inventory Search

Back
Top