RE: Is the Folowing Applicationb Possible

Hi Adam

Thanks again for your time

Interesting, Therfore are you saying it is possible to create a useable app
that uses SQL properly - but based around Sharepoint 'front end' AND is easy
to setup, or would i still be better to look for a commercial app

As you can tell I am certainly not a databse man and the idea is somewhat
nerve racking!!!

What I would like to achieve is something like the following - have , say,
um! letters along the top to quckly get to specific owners.

Then have a drop down list so that a users could easliy pick the owner.

When picked have the owner details in the top part of the screen and contact
details dataviewf orm startingwith DATE then NOTE then automatically have the
relevant user enterred who dealt with it (NAME)

If I create the basic outline in ACCESS can Ithen upload it to SP or SQL for
all users to work on

Cheers
Matt


"adam@xxxxxxxxxxxxxxxxxxxxxx" wrote:

Sure. SharePoint will let n number of users work with a document providing
that the revision controls aren't tripped. So, that would cover your problem
there, unless a user does a check out which would case the rest to have read
only copies.

The reason I suggest a list is that you can just make a list with like

Owner Name (Single Line Text Field)
Owner Condo (Multi Line Text Field)
Owner SSN (Single Line Text Field)
Owner Time Share Dates (Date Picker)
etc.

You could make it pretty nice.

Once you have that list, you have a front to all of your data that you can
either consume through the SharePoint list we service (lists.asmx) or use a
dataview and convert it to an XSLT view so that you can manipulate the
displayed XML.

If you wanted to take it further, then you could then add your printview
with javascript:

function PrintPreview()
{
var sURL=document.location.href;
if (sURL.indexOf('?') >0) {
sURL=document.location+"&PrintPreview";}
else {
sURL=document.location+"?PrintPreview";}

window.open(sURL);

Adam Buenz
http://www.sharepointsecurity.com

etc.


"Matt" wrote:

Hi Adam - Thanks for the reply

Could you explain a little more please - also my last point?(one document
multiple users

cheers
Matt

"adam@xxxxxxxxxxxxxxxxxxxxxx" wrote:

I would put it in one large custom list, with a column that had a time
selection and an assigned to field, then you could merge all the data later
with XSL or consuming the web service and doing it programmaticly. Doing a
document library with templates would be a lot of overhead for a task such as
that, and require a lot of client time processing (opening word, etc.).

Adam Buenz
http://www.sharepointsecurity.com

"Matt" wrote:

Hello All

I'm just finishing an instalation and my customer has seen Sharepoint and
has asked one of 'those' questions.

My customer has a small office (5 PCS 8 users) and needs all users to note
down Telephone calls with owners (Timeshare Complex) and generally have an
online database of owners details, which then could be printed out say when a
page of A4 the notes fill an an A4 page.

Can Sharepoint cope with say a word Document (template) open by a number of
users at the same time?

Is this possible with Sharpoint? To me it shouts An SQl App but have
upgraded SP to SQL

Thanks in advance
Matt
.

Relevant Pages

  • Re: Question about forms and data storage
    ... app that synchs the data from SQL to a list, ... or look at moving the core data into the sharepoint ... list over the database... ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Is the Folowing Applicationb Possible
    ... that uses SQL properly - but based around Sharepoint 'front end' AND is easy ... Then have a drop down list so that a users could easliy pick the owner. ... When picked have the owner details in the top part of the screen and contact ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Missing table
    ... execute the commands within Query Analyzer. ... The first piece of sql displays the table owner, type, and the name of the table. ...
    (microsoft.public.sqlserver.server)
  • RE: Is the Folowing Applicationb Possible
    ... SharePoint will let n number of users work with a document providing ... Owner Name ... My customer has a small office and needs all users to note ... To me it shouts An SQl App but have ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: DAP & SQL 2000
    ... I imported everything I had in Access to SQL, ... everything I imported has the owner "quote" ... Even tho I imported 3 tables I only use 1 (which does have a primary key) ... > on the Data Outline view and, in the case of the source, has the owner be ...
    (microsoft.public.access.dataaccess.pages)