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...

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...

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...

Hi, I have one excel spreadsheet with 10 columns. The users will select which columns they want to read. Then I want to display those records in the DataGrid. 1)How do I call columns without using the actual header name?? You know know I can call the worksheet like [Sheet1$] in my SQL statemetn...

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??

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.

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...

Hi! I have a mainform A with a button to call another form B. Say mainform A is People form and form B is book form I want to enter name of books a person read. Mainform A ID Name 12 John from this form click a button to open the form B to enter name of books he read. Form B must show...

Hi! I have SQL server as the backend and access forms as the front end. There are a lot of reports in the access. I am in the process of updating the reports and looking for a reporting tool I can use, something easy to use. I am planning to convert all the access forms to the web-based web...

Hi! How do I call the stored procedure in sql server from the access report using ADO or DAO?? Say I have spGetAddress stored procedure. How do i call this in the access using the ado or dao? THanks.

Hi! I have several questions. I have a button(passes a open arguement, say it is nameID) which calls a main report and this main report has three sub reports, a)Name subreport b)Address subreport c)BankAccount subreport. 1) I am using the pass through query like this. This is on the SQL server...

I have an access database application which ran fine but right after the IT guy tried(but failed) to install the MS VS.net and MS SQL server developer edition. I started to get this error" "Missing or broken reference to the file "msado15.dll" version2.5. So I went to the access vb Editor...

Hi! I have a monthly report query and would like to run it on the first day of each month for the previous month and email the report to my manager. I have the access database and monthly report query(report). Can you hint me in how to start this ? Thanks.

I thought I understood pass through query. Can you explani this for me?? I have this pass through query. ptPersonAddress => SELECT Person.ID, Person.LastName, Address.City FROM Person INNER JOIN Address on Address.PersonID = Person.ID WHERE Address.ID = '{90545B04-AEDB-4290-924B-345555AC8FD7}'...

Hi! I am trying to understand how the image gets saved. I have a table and a form for the image. How does this work?? TblPhoto ID autonum Photo OLE object Form to paste the image. say i paste an image called dog.jpg on the form. How does this get saved?? does table have name of image or...

hi! Currently I am using the access report which is created using a lot of subforms..it is very painful to code. I just upgrade the access database to the sql server. I want to get advises on the sql server reporting service. Is it easy to use and can I quickly create reports? How about the...