Search results

Hi, I would like to find out if there is anyway that VBA is able to extract / edit mail details. Details such as time stamp from "Received" column The name of the person who sent the mail Is it also possible to edit the field under the "Categories" column

Hi DCrake, Thanks a lot for your help. I will take a look. You are really a saviour... and I dislike my management...kekeke

Hi, If there anyway where we get use system time to calculate country time? E.g. I have a form and a text box. I enter the country's name or code (JP) into the text box and access will display the current time in that country. I read about GetTimeZoneInformation in MSDN but do not think...

Yup, This is one of the option that is feasible when all the computers are in my office. But I need Access to do it instead as this Access file will be circulated out of my country and i do not want each user to start configuring their computer when they know little about window schedule task.

Hi guys, Is there any way to create a VBA module that runs certain shell command when user startup / shut down / log on / log off windows? Thanks!!

the reason why I think system idle time will be more applicable to me is that if user left the office for lunch and comes back, my team lead will be able to know it as ms access will change his status to green. (all messaging system in banned in my office)

if I want to detect idle time not only for access but system idle time, can I use getlastinputinfo function in access 2000/2003?

WOW!!! Thanks!!! I was also reading other forums, some of them us the getlastinfo function from user32.dll. What is the difference?

So how does the timeout feature works? Keying in data into my database or mouse movement? key stroke? I am having problem with my users running off for meeting without closing my database!!

hahaha, I guess as much that you will say that. but in our nature of business, it is not spyware. It is like taxation, we need to bill our customer by the number of hours we work on the project. The problem is that the number of hours works for certain products are not finalised yet and we...

I intend to create using VBA in MS Access 2003. I am ask to created it to find out the time taken for a job to be taken, amount of idle time on the computer (user leaving the desk for extended lunch break), to find out if outlook is open so that I can launch my email function in access. Stuff...

Hi everyone, I would like to know if VBA is able to track user activity on the computer? Things like Idle time (similar to "away" or "Idle" in MSN), or to know if outlook, excel or word is open on their computer. If so, how do you do it?

Yup, I tried that. I even tried the same application (i copied the access database to a thumb drive) on three other computers and it worked like a charm. Only that particular computer does not seem to recognise f.path or the actual path.

This is the first time that I encounter this problem and I do not know the source of it, I hope someone can shed some light on it. I was using .lookin for a file search With Application.FileSearch .NewSearch .LookIn = f.path .SearchSubFolders = False .filename = "*.txt" .MatchTextExactly =...

This is just what I need! You are the man!!!

Nope, not the cool search tool. I think my problem is me unable to make subform B to requery from subform A "forms!mainform!subformB.form.requery" does not work from subform A

i understand, but someone did a sample database that was so beautifully made and I am still unable to find it in this forum. :(

maxmangion, Thanks for your link. Very good reference source. My subform 1 and 2 are both on the main form. A bit different from what the example was teaching.

Both data in subform A and B are queries and are totally not related. When user click on a row, Subform A takes a value from the row, place it into a textbox and requery subform B. Subform B uses the value in the textbox as a filter. My problem is how to make VBA pickup a specify value within...

Hi, I am trying to create a form with two subform in it. When users click on a row in subform A (datasheet), the row will change colour and the details will pop up in subform B (datasheet). I know this is possible as I have seen it in this forum a year back. I have search in this forum but...