Search results for query: *

Hi, I was wondering is there any way to unlock and lock the machine at a particular time without any human intervention. What I was thinking was to be able to write a batch file to unlock the machine and schedule the Task Scheduler to run it at a particular time. I want to do this because, I...

Hi, I have written a batch file to run a macro in MS Access. The macro has several automated keystrokes such as =Date() etc. I have scheduled the Windows Task Scheduler to run the Batch file which in turn runs the Macro every 3 hours. When computer is unlocked everything works fine. However...

Thank You for your sugesstions...

Hi All, I have written a batch file to run a macro in MS Access. I have scheduled the batch file to run at a particular time of the day. The Task Scheduler and the batch file works fine until I lock the computer. If the computer is locked, the scheduled task starts that brings up the access and...

Thank You, The Birth Day was a date field and when I put the above formulas in the Field Explorer it worked... Again Thank You...

Thank You...Appreciate your help.

Thank You all for your responses, but I need more help on this. It may be that I wasn’t clear enough when I asked the question, So let me state the problem again, I'm creating a report, which shows the Birth Days of students in a chronological order in the year. For example if two people have...

Thanks BruceBussell and synapsevampire for the tips, however, I'm still ruggling to get it to work. Synapsevampire, You suggested that I should create a formula for sortation as month({DateField}), can you elaborate more on how to create it and where to put it like in Select Expert or...

Hello, I'm doing a report where I have to take in the date field in mm/dd/yyyy format. While displaying the results, i have to sort them using the Month only, e.g. all JAN. results will be together irrespective of the date and the year associated with it same for all the months of the year. Can...

Hello, I'm writing a report with several fields such as ID#, Phone No#, Last Name, First Name etc. I want the report to only display the records which have special characters such as ( ' ) or ( - ) etc. in the Last Name or the First Name fields. Can somebody guide me to the correct way to get...

I want to create a report that displays records if the memo(string) field is not blank i.e. there is some information in it. I was able to do it with non memo fields by using the select expert and filtering out not null values. However, this string is too long and is a memo field. So I can not...