Help with MS Access 2007

[Druach]

Hi, I have been asked by my company to investigate whether Ms Access 2007 is the tool we need.

I dabbled with access (2002) about 7 years ago when I was a Lotus notes developer which is why I was asked to investigate it but haven't looked at it since and it has changed a bit.

I have downloaded the Real Estate template and have played with it to change field names etc into British english and not American english.

However, I need to know whether it is possible to create a pop-up alarm from a date field as we would need to know when we need gas appliances and fire alarms checked. If not is there a calendar table that is available for Access and if that is not possible can I link it to the calendar function of MS Outlook 2007.

I have searched numerous databases for this info but it all seems to relate to previous versions and these solutions don't seem to work with the 2007 version.

Many thanks for any assistance.

Don

 

[FoFa]

As long as Access is running, you can.
You can set a timer event on a form and have it check something every so often.

But you must remember, access is not an engine that is running all the time, so access has to be running for code to run.

 

[Trevor G]

Hi, I have been asked by my company to investigate whether Ms Access 2007 is the tool we need.

I dabbled with access (2002) about 7 years ago when I was a Lotus notes developer which is why I was asked to investigate it but haven't looked at it since and it has changed a bit.

I have downloaded the Real Estate template and have played with it to change field names etc into British english and not American english.

However, I need to know whether it is possible to create a pop-up alarm from a date field as we would need to know when we need gas appliances and fire alarms checked. If not is there a calendar table that is available for Access and if that is not possible can I link it to the calendar function of MS Outlook 2007.

I have searched numerous databases for this info but it all seems to relate to previous versions and these solutions don't seem to work with the 2007 version.

Many thanks for any assistance.

Don

Why not think of using the scheduler system from the desktop, you can use the timer events there and if necessary the system adminstrator can run the schedule for you. There unless there are additional processes you need you wont need a database, or you can link a macro to the scheduler, you have to look at the control panel, the Administrator tools and scheduler is inside there.

 

[Mr. B]

Druach,

To address each issue:

I need to know whether it is possible to create a pop-up alarm from a date field as we would need to know when we need gas appliances and fire alarms checked.

You certainly can have a form that would "popup" when you open an Access database applicaiton and have it remind you of various events like you describe.

is there a calendar table that is available for Access

I think that what you are refering to here is a form view that looks like a calendar and provides the activities that are scheduled on a specific date and time. If this is the case, the "Yes" it it possible to display a schedule in a Calendar View. I have a demo of a form that I developed that will display data in a "calendar view". I have attached a zip file that contains a demo of this form in Access 2007 format.

I have been asked by my company to investigate whether Ms Access 2007 is the tool we need

In my opinion, Access would be a good solution for doing what you want to do. It will take some development to have it do what you want, but certainly can be done at a much more resonable cost than any other development platform.