Search results for query: *

Hi, I am trying figure out how to create Web services on the SharePoint. I want to retrieve data from a list(certain view of the list) of SharePoint in asp.net webpage. I created a web reference in Visual Stuio to http://mysharepointserver/_vti_bin/lists.asmx I have this asp.net webpage to...

I thought about that too. Do you know how to create auto-increment columns? There is one id column but I need additional column to filter out records?? Thanks much.

Hi, I need a kickstart in how to go about doing this. Basically, I have three lists on the SharePoint site(2003), MasterList, AList and BList. Each of those lists have same column names and type. They are same lists. Let's say these are the column headings...

Hi, I am trying to join 5 tables. I want to create one big table CommDevices as primary key. Here are table names: CommDevices, People, Facility, Organization, Event and CommDevices. There are junction tables(middle tables), PeopleCommDevices, FacilityCommDevices, OrganziationCommDevices and...

Hi! I created dataAdapter and DataSet using the VS2003 toolbox's wizard. When I created the dataAdapter, it also created the connectin object for me. How do I use these in my code? If I were to bind this to the datagrid, I did datagrid1.datasource = dataset11 datagrid1.databind() All I got...

I just needed a button on the menubar or toolbar. This code does the job. I just want to remove those blanks. Another question. When I open two different excel spreadsheets, I get that menubar on both spreadsheets. Why is that? Even though the other one doesn't have this code in their...

THANKS everyone for all your help. Can I ask one more question? I created a menubar and put a button. I am adding this menubar when I open the spreadsheet and delete it when I close it. A while I was testing it I forgot to deleted them. So I made 5 menubars. I deleted the button control. but...

Hi! I want to sort the worksheets by certain column I choose. I can do the simple sort but I am having problem figuring out how to sort from 3rd row down. first 2 rows have some header info and titles. I also don't know how many rows I will have. But I know all the worksheets have data from 3rd...

...I call columns without using the actual header name?? You know know I can call the worksheet like [Sheet1$] in my SQL statemetn like this, "select * from [Sheet1$]" How do I call columns?? Say I want to select columns 2,3,7 and 8. "Select 2,3...From [Sheet1$]" 2)How can I skip first two...

OK, How do you do that? I should be more clear. I want to embed the Outlook calendar in the web page? I know you save the outlook calendar as html but that doesn't let you edit the appointments. I want to be able to edit the appointment on the calendar. Thanks. Philip

Is possible to display the Outlook calendar on the webpage?? Thanks.

How do you replace values of one column in several tables? What script do you use? I have a table containing office symbols. listOfficeSymbol ID officeName 1 English <==== need to change it to Tiger 2 Math <==== Rabbit 3 Music <==== Eagle Etc... And there are...

how to insert values into access table and get back the auto number of the record I just inserted??

Thanks PCLewis! How can I fix it? How can I make the temp file bigger? I delete out the temp folder. It still does that. I believe the report gets created. I see the report opens up.However because it is in the memory(???) and shoots up that error message. It looks like it doesn't get saved as...

A while the report is created I get this error, "The report snapshot was not created because you don't have enough free disk space for temporary work files" Anyone knows why this happens?? THanks in advance.

BSman, My primary key's data type is GUID so they have to be unique. Is it ok to make indexes to be nulls? I can't find this error... I am lost where to look. Thanks so much for your input. Q

Thanks guys. I don't know where the error is coming from. It happens when I click a new record from the main page. I can do whatever on subforms and other tabs until I hit the new records button. ANyone knows what is going here?? Thanks. Q

I hit the new record button it creates the primary key in the table automatically behind the access since i don't write any code to do the insert. it has been working fine. I just can find the exact location to trap this error. Only place I do any insert in when they fill in the forms on the...

Hi! I have a main form(tabbed) with subforms on each of the tabbed forms. I can navigate bewteen records but as soon as I click a create a new record button, I get this error "index or primary key can't be null value" and can't locate where it is coming from. I am navigating through from the...

Sorry for not enough info. Book Form has this as record source: Select PeopleBook.PeopleID, Book.* from PeopleBook inner join Book on peopleBook.BookID = Book.BookID where PeopleBook.PeopleID = '123' What if PeopleID ='123' has no book record yet. So book from should come out empty right?? I...