Sharepoint Lists Questions 

Hey guys, I have installed Microsoft Office 2007 Enterprise.
However, I think that something is missing...
Is SharePoint included only in server edition ?
and what is project 2007 ? why don't I have it? It's the enterprise edition!
I need someone to list me the features of the enterprise edition and if i have to buy sharepoint seperate.. :(

I'm using Access VBA to manage incoming work queues received on SharePoint libraries/lists (InfoPath as front-end). Some of the request types are repetitive in nature and the back-office user simply needs to access 3270 (QWS3270 Secure) and do a mundane task. I would love to have access COM/OLE control a 3270 window, but haven't done that before. Alternatively, I can build the scripts in Access programatically (have done that before), but the more steps I can take out, the better.

Know of any good reference sources to get me pointed in the right direction? Blogs, books, or helpful tips are welcome!

I know, i know, i am DIFFICULT ahahaha. but you mis understood my question :(

you said

"Create a calculated field called secondtuesday with the formula:

=DATE(YEAR(Begin), MONTH(Begin), (8-WEEKDAY(DATE(YEAR(Begin), MONTH(Begin), 5))))+7

This will give you the second tuesday of the month of the begin date. Create a new view and filter out all of the items in your list where the second tuesday of the current month has passed."

but what i need is a way to hide all my items every second tuesday, biweekly, not every second tuesday of each month.

im sure the formula will look similar to this one you gave me before.

if that is the case, do i need to make a column for "date" "month" etc?

Thanks, hope there is an answer for this!

(ps, i put your name in the title so it catches your eye) :D

P

How do I move items in one list to an identical lins on a different page? Is this even possible without having to cut and paste?

WEbpart is in C# -
I have code to display the list in datagrid - few columns are editable.
now i have a button to update all the rows - one button save - should give me access to datagrids -

I get nothing in the datagrid.items.

Thanks

I'm making a calender list for my company staffs for ease in booking meeting rooms, but I'm unable to design a workflow so as not to have a recurring date and time at a specific room.

Eg:- User (A) has already booked Room (A) at Date and Time (A).
How to prevent User (B) to book the same room at the same date and time.

I'm using Sharepoint Designer and WSS 3.0.
Thanks for the comments.

how can I do that?

I'm an Administrator for dozens of portal sites, and when an employee leaves I need a way to remove them from the member list on every site. Isn't there a more efficient way than visiting each individual site to update the member list?

Open the view in Share Point Designer. Right-click the list view, and convert to XSLT. Mouse over the column you want to modify until you get the modify width cursor (looks like a double arrow, like this <---->). Single click, and drag the column until it is as wide as you need it. Save.

I have a list in sharepoint 07 which also contains a calculated column based on cost per usage. column x * column y = total. I have also identified a cost code to each record. I'd like to do a running sum of the totals by cost code. If it were a spreadsheet, I could just sum on the total column. But this is a list, which is grouped by cost code. Is there a way to do a final sum of the total column by cost code?

What I want to do is calculate the grand totals by division.

ok, ill explain first what i have.

i made my task list. then i made the today column (and later deleted it). then i made a "view until" calculated column. in this column i have '= [Today]+13'

i also made a column named "Time Calculator" that has this formula '=IF(Entered+13>Today,"yes","no")'

then what i did was made a new view so that it filters if the View Until column is greater than or equal to [Today] AND if Time Calculator is greater than or equal to Yes, it will show only those.

ok now what i need. although this works, it isnt exactly what i need. as you can see, it just hides them after 14 days. what i want is for it to hide them every second tuesday. so every second tuesday, it will get rid of th old ones and there is a brand new list.

im not sure if this makes sense....its sort of hard to explain what i want, but someone i work with said that there is no formula that will repeat itself every 2 weeks...so am i doomed to this? :)

Thanks

Paul

We are using SharePoint to post and store word files for a new project we are working on. My boss has asked for a list of those posted thus far. I exported the list from Sharepoint to MS Excel and unlinked it but the file names still remain as hyperlinks and everytime we click on one it opens the MS Word file.

Can anyone tell me how to stop them being hyperlinks? I just need a plain old list at this point!

Please help!

so, i have my task list and it works great. the only problem i am having is...i want to make it so that it automatically deletes items after a certain period of time (either 2 weeks or a month, havent decided yet).

do you know how i might be able to do this? is it even possible?

using wss adapter how to integrate biztalk and sharepoint list or document lib or sit

First off, you can't.

Second, here is a way to 'sort of' do it, but you will lose all of your 'created by' and 'created date' and 'modified by' and 'modified dates'.

Export your issues list into Excel. Make SURE you export using a view that shows ALL records (not just where current=yes).

Right-click anywhere in the Excel, and select List -> unsyncronize.

Import the excel file into SharePoint as a brand-new list.

Tweak, repeat until you have something you like.