Search results for query: *

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

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

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

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

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

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