Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. qajussi

    Web Services on SharePoint 2003

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

    Moving(adding) records from one list to another??

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

    Moving(adding) records from one list to another??

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

    Join tables??

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

    How to use dataAdapter created by VS2003?

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

    Sort Excel worksheet from 3rd rows down??

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

    Sort Excel worksheet from 3rd rows down??

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

    Sort Excel worksheet from 3rd rows down??

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

    reading records from Excel spreadsheet using ASP.NET?

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

    Display Outlook calendar on the web page??

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

    Display Outlook calendar on the web page??

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

    find and replace values in the table in SQL Server??

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

    how to insert into access table and get back the autonumber??

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

    &quot;don't have enough free disk space for temp work files&quot;??

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

    &quot;don't have enough free disk space for temp work files&quot;??

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

    index or primary key can't be null value when I click a new record??

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

    index or primary key can't be null value when I click a new record??

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

    index or primary key can't be null value when I click a new record??

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

    index or primary key can't be null value when I click a new record??

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

    how & where does new id of the record??

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

Part and Inventory Search

Back
Top