Lookup Field across subsites

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Windows Services
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Link to all subsites of a top site? Is there someway to so users links to all sites they have access to below the top site? Tag: Lookup Field across subsites Tag: 5457
  - 2
    - It's Friday night and it's patch night! And if you are running NT/2k or XP have you patch your computer lately? This is a good time to run Windows update and patch. [This friendly reminder should be and please do cut an paste to all you know... there is a nasty vuln in the works... Run a quick Windows update and reboot and all is well. Susan -- http://www.sbslinks.com/really.htm Tag: Lookup Field across subsites Tag: 5453
  - 3
    - Trouble extending Virtual server When I extend a virtual server (using host header names). I get a page that says Access denied. Then when I go to the sites URL I get this message "The Web site that is referenced here is not in the configuration database." But if I go to the Virtual Sever List it shows the site as being extended and the site has a content database. What am I doing wrong? TIA, Patrick Tag: Lookup Field across subsites Tag: 5449
  - 4
    - Error: Adding user to OU FAILED. I am setting up a test of the "Server Farm" configuraion. When I try to add a new site the operation ends telling me it "cannot complete this action", and when I check the event log I see a message saying: "#1e0046: Adding User "xxxxx6" to OU "SharePoint Users" in domain "YYYYYYY" FAILED with HRESULT -2147467259. I have set up the administrator account following directions in the "Microsoft Windows SharePoint Hosting Configuration and Experience" white paper so, in theory, the STSAdmin account should have rights to add users. Any ideas? Tag: Lookup Field across subsites Tag: 5448
  - 5
    - WSS Search Webpart? Is there a webpart for searching a WSS site? I am using the search from the Microsoft Team site, and it works well, but trying to modify it visually in Front Page is driving me crazy. Tag: Lookup Field across subsites Tag: 5441
  - 6
    - Limit Lookup column choices (urgent) <Bump /> Anyone? "Troy" <a@b.com> wrote in message news:uGI2$mw7DHA.1632@TK2MSFTNGP12.phx.gbl... > We need to add a Lookup column to a WSS list based upon a WSS Custom list > that only shows choices where today is within a date range. > > For instance, if we created the following WSS Custom list: > > Title StartDate EndDate > A 01/01/04 04/01/04 > B 02/01/04 05/01/04 > C 03/01/04 06/01/04 > > A user choosing from the new Lookup column on any of the following dates > would be limited to the choices shown: > > Today Choices > 01/15/04 A > 02/15/04 AB > 03/15/04 ABC > 04/15/04 BC > 05/15/04 C > 06/15/04 - > > It is certainly possible to produce a listview that on the Lookup > column-based WSS Custom list that would return these results. Is there any > way to use that listview as the basis of a Lookup column? > > Does anyone have any other ideas about how this could be done? > > Tag: Lookup Field across subsites Tag: 5432
  - 7
    - Frontpage 2003 crashes :-( Note: I've already uploaded two crash reports. I have a customized grouped/filtered Data View Web Part on my site http://playground.doesntexist.org to show the announcements list which is called "Archive". Today I went into FrontPage 2003 (RTM) to change the grouping to collapse all entries by default. As soon as I hit the ok button after the change FrontPage crashes. Any ideas why? -- Cheers, Siegfried Weber If you want a smart answer, ask a smart question http://catb.org/~esr/faqs/smart-questions.html Tag: Lookup Field across subsites Tag: 5427
  - 8
    - database location Is there an easy way to determine the name or location of the database that my WSS site uses? I should have admin rights to everything, but someone else set it up, so I just don't know which database they used. Maybe there's something in the Central Administration pages? -- -Kim www.kimquigley.com **Chicks Make Great Programmers Too** Tag: Lookup Field across subsites Tag: 5422
  - 9
    - Hyperlinks from Data View Hi, I have a SharePoint site in which I am creating custom pages with FP 2003. I am using Data View to display a list on a Web Page that I created. I have a field in the list which contains a URL which points to another site. I insert the field as a Hyperlink, but Sharepoint appends the current Web Page library to the beginning of the my Hyperlink. How do I get it to just use the URL from my list field and NOT append the current site / library information? Thanks, John Tag: Lookup Field across subsites Tag: 5421
  - 10
    - Hyperlink URL I know how I can bring in a MS Excel filed with a hyperlink into SharePoint, but I want I'm looking to do is attach along URL field to a field name with a much shorter name. My Excel file looks like this: CompanyName Address FileName URL ABC Company 111 main ddd.pdf http://ddd.ddd.com/ddd/ddd/ddd.pdf XYZ Company 222 main eee.pdf http://ddd.ddd.com/ddd/ddd/eee.pdf DEF Company 444 main fff.pdf http://ddd.ddd.com/ddd/ddd/fff.pdf QRS Company 333 main ggg.pdf http://ddd.ddd.com/ddd/ddd/ggg.pdf We only want to show the filename on the SharePoint report with a link to the URL on the filename. Any suggestions? Tag: Lookup Field across subsites Tag: 5419
  - 11
    - Help me out here.... I know I'm going to get replies saying that I shouldn't do this, but.... Since there is no way to create an Event Handler for a normal list (other than doc libraries), I have come up with this solution: Wrote my code in .NET, and will use a DTS Package in SQL to reference it. Will then use a Trigger on the UserData table so that when new data is added for a specified list, it will start the DTS Package. Everything works fine when using the Trigger for an UPDATE on the UserData table, but if I use INSERT in my Trigger, then the WSS site gives a SQL Error when I add info to a list. It will go ahead and add the record to the database and site, but still returns the error. MY QUESTION: Why is it giving this error? I know that I am changing how the database is used by WSS, but I am using an AFTER trigger, not an INSTEAD OF, so WSS shouldn't worry about this. Anybody got any reasoning behind this, or any ideas to look at. Thanks for your time! Jared Tag: Lookup Field across subsites Tag: 5415
  - 12
    - WSS - Document Refrence Hi all - Three potentially simple questions - Is there a way to create a multipoint refrence to a document in WSS? (I would like to have a document reside in multiple document libraries, to provide refrence to a total of three groups. ) Any refrence's to a web part that would act as a "What's New" area for a site, displaying a refrence to new documnets that have been uploaded within the set filter? I haven't found any technical books on design for WSS - any suggestions - Borders etc results in Windows Server, or SQL when searching. Thanks Tag: Lookup Field across subsites Tag: 5414
  - 13
    - Use of wppackager to deploy webpart only to GAC Is there a wppackager option to deploy a webpart=20 immediately to the global assembly cache without the offer=20 to install the webpart in the virtual server=B4s bin- directory instead? What I want to acomplish is: To suppress the box with the=20 question "Install the following strong-named assemblies to=20 the global assembly cache?" at installation time. Thanks Tag: Lookup Field across subsites Tag: 5413
  - 14
    - Modifying XML in the DWP file I'm just starting into looking at programming with WSS... one thing I noticed it it looks like you can do alot with just the flat DWP file... javascript, vbscript, html, etc... has anyone found a good resource on this, namely what cannot be done? Like can you call an ActiveX objest? (I know now forms don't work from trying, but I had try and fail if there is info on this somewhere), depending what all is availible here is seems a good fast way of customizing WSS. Tag: Lookup Field across subsites Tag: 5405
  - 15
    - WSS WebService Login in C# I am trying to write a very simple test WinForm app to see what I can get from WSS using its Web Service interfaces. All I'm trying to do is connect to the server and draw down something from a list to start with. Once I get the basic connection sorted I'll progress from there. However I keep getting a 401 unauthorised error when trying to connect to our hosted WSS server. I am passing my own WSS login credentials (which have site admin rights). What am I missing here ? private void button1_Click(object sender, System.EventArgs e) { System.Net.CredentialCache MyCredentialCache; MyCredentialCache = new System.Net.CredentialCache(); MyCredentialCache.Add( new System.Uri("http://www.mydomain.com"), "Basic", new System.Net.NetworkCredential("OUTLOOK\MyAccount", "MyPassword") ); com.mydomain.www.Lists serviceLists = new WebServiceTest2.com.mydomain.www.Lists(); serviceLists.Credentials = MyCredentialCache; XmlNode nodeList = serviceLists.GetList("Timesheets"); richTextBox1.AppendText(ndLists.OuterXml); } Thanks in advance for any help or pointers, Al Tag: Lookup Field across subsites Tag: 5398
  - 16
    - DataView Master/Detail and target frame (already post in sharepoint.development but i found this ng more appropriate) Well maybe i'm dumb but i can't realize how to do this (and i've read all the ng on the earth...) It's really simple to connect two dataview with fp2003 even if the detail dataview is on another page. But what i want to do is open the detail dataview on a new window/frame (and possibly a light frame, not all the ie stuff). I tried to simply change the target attribute in the <a> tag in the dataview but it doesn't work as it call actually the __dopostback function. So it's this function that open the page in the same frame. How to change it ??? I had success with the "default target frame" property in the page settings (set it to _blank) but a new windows is opened whatever the link, not only de dataview. So it's not clean. Well maybe it's really simple but i really need help for the moment Thanks in advance Stephen Tag: Lookup Field across subsites Tag: 5397
  - 17
    - servername with invitation I have a SBS2003 domain, and a memberserver (win2003) in it with WSS on it. Users contact me from outside through ISA server by URL www.domain.biz. It works fine. ISA server passes through the request and STSSERVER answers But in the invitation (when I add a new user) and with sending alerts the email message contains the name STSSERVER in stead of www.domain.biz. When the user replies to STSSERVER there is of course no answer. How do I change the template for this alert email or invitation email? Joan, Uden Tag: Lookup Field across subsites Tag: 5391
  - 18
    - WSS new account error I have WSS running fine, but whenever I try to add a new user it comes back with an error "the user does not exist" It works fine if I manually add the user through active directory but will not add them through the sharepoint services application. Any help would be great. Mick Tag: Lookup Field across subsites Tag: 5385
  - 19
    - SDK to convert DDRK version 3 I uploaded the Crystal Report Web Part and when I attempt to use it I get "Cannot import a Digital Dashboard Resource Kit (DDRK) version 3.0 Web Part. For more information, see the Windows SharePoint Services SDK or the SharePoint Products and Technologies SDK." The only SDK I could find contain only chm help files. Where do I find the SDK that will allow me to convert these version 3 dwp files? Regards Peter Tag: Lookup Field across subsites Tag: 5383
  - 20
    - How to Use Global.asax feature in WSS site? Hi All, I want to use Session_Start and Application_BeginRequest events in my wss site. I want to execute some code in side this events. Is there any way to add global.asax feature to wss site or any other way to get this events? Thanks in advance Regards Anjan Tag: Lookup Field across subsites Tag: 5381
  - 21
    - version history Will I lose version history if I move an InfoPath form from one site to another? I tried using FrontPage to copy the files to another form library and didn't have any of the version history. So if the answer is that I won't lose version history, please also let me know how to do that. Thanks! -- -Kim www.kimquigley.com **Chicks Make Great Programmers Too** Tag: Lookup Field across subsites Tag: 5377
  - 22
    - Does web part cab pass data to each other? If i have 2 web parts at the portal. Can I pass the data from web part 1 to web part 2? Thanks Best Regards, Eilsa Tag: Lookup Field across subsites Tag: 5374
  - 23
    - HTML References, URLs in MS Excel to Sharepoint Reports... I have two columns in my MS Excel report, FILE NAME and URL. File Name is short description of a linked document on the Internet, URL is the path of the document. Is there a way to synch my report into MS SharePoint so the FILE NAME contains the URL and HTML link? I may have to do something in MS Excel first to 'combine' these two fields, or set a field as specific field type - I've tried a lot of combinations with no success. Thanks, Stephen Tag: Lookup Field across subsites Tag: 5360
  - 24
    - WSS, WMSDE, and Crystal Reports Do anyone know how to use Crystal Reports to report against a WSS site using WMSDE? My WSS site seems to be working fine, but I'm unable to tap WMSDE with anything (DSN creation, SQL Enterprise Manager, etc...) Any help on how to get to the WSS data would be greatly appreciated. Thanks, Russ Tag: Lookup Field across subsites Tag: 5359
  - 25
    - Sharepoint on the same server as SUS Hello, I have a windows 2003 server that I have been running SUS on for a few months. Last week I installed Sharepoint and created some sites. I went to approve the updates on the SUS server http:\\server\susadmin and it gives a 404 error. I have tried reinstalling the SUS server multiple times with the same result. Is there something in Sharepoint that breaks the SUS service or is there something that I need to configure in IIS to make it work on the same server as sharepoint? Thanks, KJ Tag: Lookup Field across subsites Tag: 5358
- Next
  - 1
    - Looking for a web part for a phone list that pulls from Active Directory I hate having data in multiple places and having to maintain it. I would like to find a web part that will pull in the Active Directory contact information and display a phone book within sharepoint services. I already maintain this so that my Exchange Address Book is up to date, so this would save another point of data entry. Anyone have any ideas? Chris Green Tag: Lookup Field across subsites Tag: 5357
  - 2
    - Search Title of Document I am having problems with the search function. I can search for terms within the document, but if I search for the title of the document I get no returns. Any idea on how to correct this? Thanks Shaun Scott Tag: Lookup Field across subsites Tag: 5353
  - 3
    - Remote WinForms app that queries WSS using the object model ? I'm interested in writing a C# WinForms app that connects to a WSS server/site, cycles through the content of a specific List and generates a custom formatted file from the results. I have seen the samples in the SDK but none seem to explain how to pass login credentials in code, how to debug the application on the development environment (assuming you can in Windows XP) or what dependencies are required for the client deployment. Thanks in advance for any help or pointers, Al Tag: Lookup Field across subsites Tag: 5350
  - 4
    - Template list - Visual Studio .Net I need to add the funtionality of a template list, like validations. Is it possible to edit a template list using .Visual Studio .Net? Thanks ! Tag: Lookup Field across subsites Tag: 5349
  - 5
    - Installing WebParts using just FrontPage 2003 ? I am attempting to install a test WebPart that I have built. However, the target WSS installation is on a server at a 3rd party hosting provider. They have provided us with access via FrontPage 2003 and, if we push them hard enough, FTP. All the installation guides I have seen seem to require running command line apps on the target server, is there any way to install one just using WSS, FrontPage and FTP ? If not, what is the minimum level of access I will need to complete the task ? Thanks in advance for any help or pointers, Al Tag: Lookup Field across subsites Tag: 5348
  - 6
    - "Edit in Visio" not working? Hello! I get the following error message when I attempt to edit a document in visio: The document could not be edited. The required application may not be installed properly, or the requested document could not be opened. Please ensure the necessary application is installed and that the path to the document is correct. If the application was set to install on first use, run the application and they try editing the document again. Visio is installed correctly and I'm able to bring up the documents when I do a Save Target As. I can also view the document when I click on the document name. . . I just can't select "Edit it Visio" Any known reasons for this? thanks in advance! . Tag: Lookup Field across subsites Tag: 5347
  - 7
    - Using the SharePoint 2003 OM, can the Created and Last Modified dates be overridden when a document is added to a doc library? Using the SharePoint 2003 OM, can the Created and Last Modified date properties for a document be overridden and set a specific value when the document is added to a doc library? If not, presumably the appropriate SQL content database table entries could be directly updated (although not recommended)? Thanks, Michael. Tag: Lookup Field across subsites Tag: 5345
  - 8
    - notification services I'm looking for ideas, best practices, or recommendations. On the first day of each month, I need to send an email notification with a link to the parent site as a reminder for people to update their data. Where would you put such a notification? -- -Kim www.kimquigley.com **Chicks Make Great Programmers Too** Tag: Lookup Field across subsites Tag: 5339
  - 9
    - Checked-out docs Read-Only When we check documents out of a document workspace, or just click on Edit Document in MS Excel (or Word or whatever), the documents always launch as Read-Only. This is a pain, because when they are changed, we need to save them somewhere locally, then upload and overwrite the document on the SharePoint site. Seems to defeat the purpose of SharePoint. Any tips on how to open documents from sharepoint, and then just be able to click the save button? Tag: Lookup Field across subsites Tag: 5338
  - 10
    - Login prompt for a few users... I have a W2K3 server running WSS and the main page has a Sign-In button that will verify the domain\name of users. Users login to the network on an NT 4.0 PDC. This works fine for just about everybody, but I have a couple of users who are prompted to login when they try to sign- in and it will invariably lock their PDC account without recording a security event that about a failed login. However, if I sign in these users on a Terminal Server session and got o the WSS site, they can sig-in and everything works fine. I surmize from this that their is a registry setting or something on their local system that is preventing their domain/name to pass in to the WSS system. Where does WSS look for this info and how do I fix this on the local system of the affected users? Thanks! Tag: Lookup Field across subsites Tag: 5335
  - 11
    - Customize ALERTS Hi guys, is there a way to customize the "Alerts" in a way, that it is possible to enter an employee-name in a list field and automatically an e-mail will be sent to this person? Some tips or some links to informations would be really great.. Thanks a lot.. Maik Tag: Lookup Field across subsites Tag: 5322
  - 12
    - Replacing WSS document management functionality We have a huge library of documents in Hummingbird DM (PCDOCS). We really like Windows Sharepoint Services--Microsoft has done a wonderful job, but for it to be really useful, we would have to replace the native document management functionality in WSS with that of Hummingbird DM. So, whenever a document is checked in to WSS, we check-in to PCDOCS rather than into a WSS document library. Similarly, documents would be checkout of PCDOCS, but for example, the view of documents in a PCDOCS library would be through the standard WSS document library interface. Additionally, we will be upgrading to Office 2003, so we will also want to keep that WSS integration. I know I can just write a Web Part to interface with PCDOCS, but I also want all of that cool Sharepoint functionality. The problem, as I see it, is two fold. The first is that the events (check-in, check-out ...) exposed by the Sharepoint object model are asynchronous--the functionality can be supplemented, but not replaced; the second being that there is no obvious way to reference a document once it is stored by Sharepoint. Has anyone tried it? I would be very grateful for some tips or pointers in the right direction. Thanks Rupen. Tag: Lookup Field across subsites Tag: 5318
  - 13
    - someone@example.com I have SMTP running with WSS. The server will send alerts and etc, but the sender address shows as someone@exapmle.com. I set up the desired From address and Reply address following the the Admin guide for WSS; (Or so I thought). I followed the steps in the Admin guide all except the command line section. Is it required to do the command line configuration or is that an optional way of configuring SMTP? Thanks... Tag: Lookup Field across subsites Tag: 5317
  - 14
    - Removing dates in MWS series Using Events list in WSS to add dates to a recurring Meeting Workspace. Deleting an Event does not remove the date from the MWS series. Any clues? Thanks. Tag: Lookup Field across subsites Tag: 5315
  - 15
    - SPS and frontpage extensions Does SPS use Frontpage extension? In other words if I uninstall frontpage extensions 2002 will I have to reinstall it after extending the virtual server. Thanks Tag: Lookup Field across subsites Tag: 5314
  - 16
    - search results I'm a little confused by search results. There are list items and there are documents. I don't see a difference. When I search for a word, the same document appears under list items and documents, so it seems redundant. My site is just a bunch of form libraries, so maybe if I had other types of lists this would make more sense. I'm thinking about editing the search page so that list items won't appear. Does anyone see a reason not to do this? -- -Kim www.kimquigley.com **Chicks Make Great Programmers Too** Tag: Lookup Field across subsites Tag: 5313
  - 17
    - MAC clients I have been pushing for the implementation of a SPS site for a group of committees with representatives from 4 universities. The reps from on university representing about a third of our members use MAC client machines. Does anyone have any hands on practicle experience using MAC machines to access SPS? Any significant shortcomings? Any recommendations for browsers and minimun OS requirements?\ Thanks for the help. Grant McDonald Tag: Lookup Field across subsites Tag: 5312
  - 18
    - Create template list programtically Is it possible to create a template list using Microsoft Visual Studio .Net ? Tanks ! Tag: Lookup Field across subsites Tag: 5311
  - 19
    - XML file analysis help!! I am having a sharepoint site where my users fill out infopath form and store them on the sharepoint site. I now have around 150 of these files, and I'd like to sort them using the data that's IN the form. I have no idea on how to do this, I know sharepoint can sort a set of xml files base on ONE tag, but I'd like to be able to do it on many tags, king of like you do in Excel when you filter colommns. Am I dreaming or is this possible to do somehow? Thanks a lot for your help Cyril Tag: Lookup Field across subsites Tag: 5309
  - 20
    - Import Contacts Hi guys, is there a way to import contacts (Oulook excluded) from a database or a text file into a list(contacts)? Thanks guys. Maik Tag: Lookup Field across subsites Tag: 5307
  - 21
    - "My Site" through Network Places Here is another, How do I get to "My Site" through Network places. I thought I had it and moved some documents over to my shared docs, when I went to the site through IE, there were not there! Now I am trying to figure out where they went. Andres Tag: Lookup Field across subsites Tag: 5301
  - 22
    - Can I use FrontPage to Edit "My Site"? Is it possible to use FrontPage 2003 to edit the "My Site" portion of the portal? If so how would you go about it? Andres Tag: Lookup Field across subsites Tag: 5300
  - 23
    - File Level Security Is it possible to set security at a file level in a document library? How would I be able to do this?. I have only been able to find permissions at the doc lib level. Thanks Tag: Lookup Field across subsites Tag: 5296
  - 24
    - Change the default text size for rich text Hi. I'm trying to use the rich text fields but the problem is that I need the size 2 (10px) instead of the default 3 (12 Px). It's really making me lose nerves because I have to change the text size all the times. Can the default be changed? Thanks. Tag: Lookup Field across subsites Tag: 5292
  - 25
    - Propegating custom properties to WSS doclibs I know, this has been hashed through a few times by Mike, myself and others but there's some new info that I thought I would share. With Office documents, there is a set of standard properties (title, author, company, etc.) that are not propagated to the WSS doc libs (except for title). This is by design for the current release of WSS. There is also a set of custom properties. These are things like DocumentNumber, etc. and available from the custom tab on the properties dialog in an Office document. These ARE propagated to a WSS document library but there's a bit of a catch (that a MS guy and I found today). First, as in Mikes FAQ on this, you need to create columns in your document library to match those in the custom tab (these can be the ones Office provides by default or your own). Next, you MUST (and here's the important part kids so pay attention) upload your document through the explorer view (or via a web folder) in order for these to make it into the document library. If you choose to choose upload document from the document library itself, then the values are blanked out in the form (because you haven't uploaded the document yet) AND SharePoint will actually blank them out inside the Office document after you upload it. Hope that helps someone who's looking to migrate documents and trying to preserve the Office META data. Cheers! -- Bil Simser Development Evangelist Canadian Pacific Railway (403) 319-7987 Tag: Lookup Field across subsites Tag: 5276

Is it possible to create a lookup field that will look in a list in a
different subsite? Using FrontPage?

Thanks,
John

Top