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 derfloh 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: *

  1. OrbitMascot

    Outlook Oldest Email

    Thank you for the suggestions. The Get Last code worked perfectly.
  2. OrbitMascot

    Outlook Oldest Email

    I am working with a database in Access 97. The database currently extracts emails from Outlook and tracks the emails in Access. Everything in the database works fine. But the database randomly selects emails from Outlook. Is there a way for Access to extract the oldest email first? Any...
  3. OrbitMascot

    Access to Outlook Public Folder Calendar

    Thanks PHV, That worked great. I appreciate your help :-)
  4. OrbitMascot

    Access to Outlook Public Folder Calendar

    I have been working in Access 97 (I know its historic, but that is the version the company is using) trying to take information from Access and place it in a calendar located in a public folder in Outlook. The problem that I am having is that Access 97 does not recognize some of the commands...
  5. OrbitMascot

    New to this

    Paul, It is working great. I just had to change a couple of the wording, due to the tables I created were names slightly different from yours. But it is working great. Thanks so much for your help. You get a PURPLE star for all your help. Thanks again. Orbitmascot
  6. OrbitMascot

    New to this

    Paul, As for months we calculate just like regular months, so 10/30/06 the first points would be deducted on 12/30/06 then again on 1/30/07. As for Feb we would probably just go with the last day of the month be it the 28th or 29th. For example: if an occurance happens on 12/30/06 they would...
  7. OrbitMascot

    New to this

    Paul, I above structure is good. I already have a tblEmployee and a tblEmpHistory. I will set up a tblActions. Thanks again for your help. Thanks, OrbitMascot
  8. OrbitMascot

    New to this

    Paul, Thanks so much for your help, I am also getting ready to go home, so I will check back in on Monday. But to answer your question. Everything is based on three months. So when you get to the fourth month, you are actually back to month 1, so you wouldn't get any points deducted, but in...
  9. OrbitMascot

    New to this

    Paul, We're good to go. OrbitMascot
  10. OrbitMascot

    New to this

    Paul, Thanks for the response. Currently I am only keeping track of the points accumulated. I just created a query that combined the occurance table with the points table, to tell me how many points each occurance is worth. So if someone is 5 minutes late, the query lets me know they have 2...
  11. OrbitMascot

    New to this

    Melagan, I am working on a similar project. I have an attendance tracker table that keeps track of all occurances that an employee might receive. Ex. late more than 5 minutes, no/call, unexcuse absense, etc. Each occurances racks up a different amount of points 2, 4, or 8. Then if the...
  12. OrbitMascot

    Bring Report to Front

    In Access 97, there is no option for PopUp in the report properties. I have looked everywhere on the properties tabs. Is there another way to get the report to be a popup? Or is there something that I need to do to get the popup option in Access 97? Thanks for your all your help. Thanks...
  13. OrbitMascot

    Bring Report to Front

    Lamar, Thanks for your quick response. That would work perfectly. I am having a little trouble finding the popup in the report properties. Do I need to code it to popup, or should it be in the report properties? Thanks, OrbitMascot
  14. OrbitMascot

    Bring Report to Front

    I am working with a report that I would like to open in front of several popup forms. Is there a way to code this in Access 97? I tried make the forms visible = false, the problem I have is knowing which forms were open prior to opening the report, so I know which forms to make visible = true...
  15. OrbitMascot

    Main form to act as toolbar

    WOW! Thanks for all the replies. I am really interested in learning more about the the menu bar option and the unbound form option. I am not very good at being creative when creating forms. But I think that the menubar and the unbound form is what I am looking for. I am wanting the...
  16. OrbitMascot

    Main form to act as toolbar

    I have an idea for a form in Access, but I am not sure if it is possible. I would like to have a form that has a main form on the left hand side that will always stay open, but whatever topic you click on the main form, it will open up different subforms on the right hand side. Is it possible...
  17. OrbitMascot

    Run Event Prior to Screensaver

    Thank you both for your input, it has been very helpful. This will save me a lot of extra work.
  18. OrbitMascot

    Run Event Prior to Screensaver

    Is there a way to perform an event right before the screensaver starts everytime? I only ask because I am working with an automated system, and everytime the automated system goes down, the only way we can tell that the system is down is when the screensaver pops on. I just wanted to know if...
  19. OrbitMascot

    .HTMLBody Image question

    This is a question concerning inserting an image into an email that is sent from Access 97. Listed below is the current code that is used to produce the email. Everything works fine, except the email just shows a graphic box in the email not the actual graphic that is needed to be seen. I...
  20. OrbitMascot

    Array Index Out of Bounds

    I just wanted to thank you guys for all your help and let you know that the database is working great. Thank you for all your help. Orbitmascot

Part and Inventory Search

Back
Top