ryani210693
05-16-2007, 03:54 PM
Hi there.
Just to give a backgorund of where this will be used, it is for Radio City in Liverpool (UK radio station of the year 2007). So big stuff!
It will be used for what we already have in use, which is using frontpage, the person answering phones for the sport football phone-in, we key in the caller name, where they are from and what they want to talk about into a frontpage auto refresh we have, which refreshes every couple of seconds in the main on air studio. So we key in the details, it refreshes in the studio and can see what caller is there.
What we would like to do now is to have someway of auto adding the data into a database on auto refresh when it detects new information ahs been keyed in, and it adds each field into microsoft access. So this keeps a database of callers that have gone onto the show for future usage.
Is there any kind of way this is possible even just adding the caller into a new frontpage page automatically, maybe not access? Access would be easier, but is it possible at all?
I was thinking along the lines of "on refresh, detect new info, detect fields, add new info into database".
Hope you can help for this major project for such a major station! thanks, Ryan.
Just to give a backgorund of where this will be used, it is for Radio City in Liverpool (UK radio station of the year 2007). So big stuff!
It will be used for what we already have in use, which is using frontpage, the person answering phones for the sport football phone-in, we key in the caller name, where they are from and what they want to talk about into a frontpage auto refresh we have, which refreshes every couple of seconds in the main on air studio. So we key in the details, it refreshes in the studio and can see what caller is there.
What we would like to do now is to have someway of auto adding the data into a database on auto refresh when it detects new information ahs been keyed in, and it adds each field into microsoft access. So this keeps a database of callers that have gone onto the show for future usage.
Is there any kind of way this is possible even just adding the caller into a new frontpage page automatically, maybe not access? Access would be easier, but is it possible at all?
I was thinking along the lines of "on refresh, detect new info, detect fields, add new info into database".
Hope you can help for this major project for such a major station! thanks, Ryan.