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!

Register Log in
  • Congratulations Chriss Miller 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
  • Order by date
  1. tarena

    Print to a selected printer and email screen shot

    Thank you very much for your assistance jrbarnett.
  2. 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
  3. tarena

    Need query to show 6 largest items

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

    Inserting Signatures

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

    Need to count records

    Alright, to do the simple query do I add any fields or just add the table and then just build the expression?
  7. 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
  8. 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...
  9. tarena

    Email response

    ...& String(2, vbCr) & strMainMessage & String(3, vbCr) & strAttachmentText & vbCr DoCmd.SendObject acSendReport, stDocName, "Snapshot Format (*.snp)", "Glenn Litchford, Rhonda Greene, John Jackson", , , strSubject, strMessageBody, True DoCmd.Close acReport, stDocName, acSaveNo...
  10. 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...
  11. tarena

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

    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?
  12. 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
  13. 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
  14. 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...
  15. tarena

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

    Is there any other way to select the bigging and ending dates using a calendar for a report parameter?
  16. 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...
  17. 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
  18. tarena

    Control Buttons

    I'm not sure how the faq was supposed to help with this issue but I tried your code in the Default Value of the textbox in the form and it did not create a new record when I clicked on my control button, not real sure as to what i'm doing wrong...
  19. tarena

    Control Buttons

    The code worked great TheAceMan1 but I can't get it to place the data into a new record each time...not the brightest I admit, real sorry.
  20. 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

Part and Inventory Search

Back
Top