Recent content by OrbitMascot

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

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

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

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

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

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

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

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

Paul, We're good to go. OrbitMascot

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

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

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

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

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

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