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 Chriss Miller 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: *

  • Users: primagic
  • Content: Threads
  • Order by date
  1. primagic

    Find out who has file checked out on Sharepoint

    I have the code which checks if the file has been checked out on Sharepoint. Is there anyway of finding out who has the file checked out using VBA (Excel). Thanks
  2. primagic

    Trying to copy data from one workbook to another in VBA

    I have the following code so far. From one workbook, I have it opening another workbook from sharepoint. this works fine. I am trying to copy data from the original workbook into the opened sharepoint file, however I am getting the error 'PasteSpecial method of Range class failed' on the line...
  3. primagic

    Find last column and copy formulas

    All my content will be stored in the following range: Range("S5:AD49") I have the following code which takes the formulas from the first column and paste them into the next column, then copies the values in the first column and pastes over themselves. Range("S5:S49").Select Selection.Copy...
  4. primagic

    Copy specific sheets to a new workbook

    I have the following code which works perfectly copying all sheets in current workbook to a new workbook. How do I modify so I can choose specific sheets not to copy. Can I use a range with sheetnames? Sub CreateUKPBFile() 'Change segment selection to UKPB Range("D3").Value = "UKPB" Dim...
  5. primagic

    Query Help

    I have a query which retrieves a year's worth of data. In one of the fields I have a number which specifies how many month's a client has accrued. So Client A may have accrued the last 3 months. So I only want to retrieve the last 3 months for him. Client B may have accrued the last 6 months...
  6. primagic

    'Dropdown list' has a SelectedValue which is invalid because it does not exist in the list of items

    I have a range of textboxes and dropdown lists on my page. On the load event I am populating to these controls with a record from a table in the database. I have a field called AgeRange. I want to display the value in the field as the selected item of a dropdownlist. Then they can change if...
  7. primagic

    Sumif across rows and columns

    I am trying to sum across rows and columns Section Jan 13 Feb 13 Mar 14 A 10 10 10 A 10 10 10 B 5 5 5 What I am trying to do is sum everying up until today for each section
  8. primagic

    Reading XML file to SQL Server

    I have the following code which is importing data from XML fine but only for the parent node. Dim Mapping1 As New SqlBulkCopyColumnMapping("submission-reference", "SubmissionRef") Dim Mapping2 As New SqlBulkCopyColumnMapping("created-at", "DateCreated") Dim Mapping3 As New...
  9. primagic

    Index was out of range. Must be non-negative and less than the size of the collection. Parameter nam

    Getting the error Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index Here is my code: Protected Sub gvHosts_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) If e.CommandName =...
  10. primagic

    Help with Query

    I have two tables tblHosts & tblHolidays I am trying to get a list of all the HostID's who have no holidays between two dates. Kind of like an availability list. So far I have SELECT HostID FROM dbo.tblHosts WHERE (HostID NOT IN (SELECT HostID...
  11. primagic

    Open Jquery Dialog box from Gridview.

    I have a button within a template field in a gridview. I am using the following code to try to open a dialog form but nothing is happening. <script type="text/javascript"> $(document).ready(function () { $("#dialog-create").dialog({ autoOpen: false, modal: false...
  12. primagic

    Binding a datalist with paging to Stored Procedure

    I am using the following code to bind a datalist to a query from an SQL database: Dim Query As String = "select * from Customers" objcn = New SqlConnection(ConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString) objAd = New SqlDataAdapter(Query...
  13. primagic

    Windows Authentication

    I am running an application on an intranet. I am trying to retrieve the windows username but it is returning the application pool username instead. I have the following in my web.config file: <system.web> <authentication mode="Windows"/> <authorization> <deny users="?"/>...
  14. primagic

    Jquery Dialog box

    I have a .net page. From code behind I am calling some jquery dialog boxes like: If A = B Then ScriptManager.RegisterClientScriptBlock(Me, [GetType](), "A", "success();", True) Else ScriptManager.RegisterClientScriptBlock(Me, [GetType](), "B", "invalidclientcode();", True) End If My...
  15. primagic

    Jquery Dialog Form

    I have the following code which opens up a form in a jquery dialog. <%@ Page Language="VB" AutoEventWireup="false" CodeFile="dialog.aspx.vb" Inherits="dialog" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html...
  16. primagic

    Help with Stored Procedure

    I have the following stored procedure which exports some results to excel. USE [BusinessSupportReporting] GO /****** Object: StoredProcedure [dbo].[spMonthlyProvidentCompliance] Script Date: 04/02/2014 10:25:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE...
  17. primagic

    Help with SQL

    I have the following sql: select c.FullCodeDescription, l.[Date], COUNT(l.Curr1) as Volume, d.clientcode, sum(l.Curr1) as value from openquery([bcw-apps],'select bcwref,clientcode,code from dial_attempts_js where clientcode in...
  18. primagic

    Import Data from Excel to SQL Server

    I have developed a windows form to import data from an excel spreadsheet into an sql table. The following code opends a dialog box for them to choose the file: Protected Sub btnChooseFile_Click(sender As Object, e As EventArgs) Handles btnChooseFile.Click Dim myStream As Stream =...
  19. primagic

    Uploading Excel to SQL Server

    I have the following code to upload an excel spreadsheet to sql table. The code runs with no errors but the data is not populating the table. Any ideas? Thanks Private Sub btnChooseFile_Click(sender As System.Object, e As System.EventArgs) Handles btnChooseFile.Click Dim myStream...
  20. primagic

    Create Excel file.

    I Am using the following code to create and excel file. The problem is, it doesn't seem to create the file. private void excelexport() { SqlConnection cnn; string connectionString = null; string sql = null; string data = null...

Part and Inventory Search

Back
Top