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: BoydMT
  • Content: Threads
  • Order by date
  1. BoydMT

    Excel: Expand/Collapse with Data from Other Spreadsheet

    I have a spreadsheet containing summary-level data. The columns are as follows: "Department", "Budgeted Hours", "Actual Hours", "Variance", and "Expenses". I have a 2nd spreadsheet with detail-level data .. "Department", "Employee", "Work Date", "Hours". What I've been asked to do is display...
  2. BoydMT

    Set SelectedIndex of Datagrid DropDownList

    When 'Edit' is clicked, I want a drop-down list to display the value that is in the cell prior to clicking 'Edit'. I use the following code to do this: Private Sub dgProposals_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles...
  3. BoydMT

    Datagrid DropDown - OnSelectedIndexChanged

    I have a datagrid with a number of fields. Among them are [CompanyName] and [CompanyType]. In Edit mode, [CompanyName] is a drop-down list, and [CompanyType] remains a label. Whenever the value in [CompanyName] is changed, I need to search a table for the appropriate company type, and change...
  4. BoydMT

    Datagrid Drop-downs

    My app is connected to 3 SQL tables (tblCompanies, tblContacts, and tblProposals). I've created a datagrid to maintain the data from tblProposals. This datagrid contains the following 4 fields: [CompanyName],[ContactName], [ContactTitle], and [ProposalID]. When the user clicks 'Edit', the...
  5. BoydMT

    Looping within a Stored Procedure

    As a VBA programmer, I've been creating loops within my code for years. However, I now want to do the same using SQL Server, but have heard to avoid them if at all possible. I have a table named 'tblFollowUp'. The table consists of 3 fields ([Name], [Date], [Comment]). An example of the data...
  6. BoydMT

    Schema script could not be propogated

    I have created a pull subscription from a SQL2k publication. When I attempt to synchronize thru Windows Synchronization, I receive the following error: 'The schema script '\\SQLServer1\E$\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\SQLServer1_DB1_Pub1\20031113142755\SomeTable_1.sch'...
  7. BoydMT

    Multiple Syncs Running

    I am in the process of creating 3 Push Subscriptions from 1 Distributor/Publisher. Basically, I need all 4 SQL Servers to have the same data replicated between each other. Are there any known issues with setting up all 3 Replication Schedules to run at the same times during the day? I want to...
  8. BoydMT

    Single User

    I need to put a database into single-user mode so I can run DBCC CHECKDB with repairs. This database is a distributor for replication. How can I do this? Thanks, Mark
  9. BoydMT

    SQL table corrupt

    My backup software for a SQL7 database is failing with the following message: Table Corrupt: Object ID 734690461, Index ID 2. Keys out of order on page (1:78526), slots 145 and 146. How can I determine what table is actually corrupt? I am thinking about running DBCC CHECKDB. Can this cause...
  10. BoydMT

    Linked Server Login

    I have linked 2 SQL Servers (SQL1 and SQL2) using sp_addlinkedserver. I used this sproc to link SQL1 to SQL2, then SQL2 to SQL1. In Enterprise Mgr on SQL1 or SQL2, I can access the other server without a problem. When I use Enterprise Mgr on my laptop, I cannot connect to either server. I...
  11. BoydMT

    Reference db on other server

    I have 2 SQL Servers, SQL1 and SQL2. I need to run stored procedures on SQL1 that reference tables in a database in SQL2. Is this even possible? If so, how do I format the code? Any help is greatly appreciated. Thanks, Mark
  12. BoydMT

    Hand Cursor

    Is there a way to display the hand cursor while hovering over a button? Thanks, Mark
  13. BoydMT

    Hand Cursor

    Is there a way to display the hand cursor while hovering over a button? Thanks, Mark
  14. BoydMT

    hash.web

    Sometimes when I try to run a project, the browser opens with an error message stating the path to "...\hash.web" is denied. Has anyone seen this before? It's very inconsistent. TIA, Mark
  15. BoydMT

    Email Undeliverable

    I am using code to automate the sending of email. I decided to use smtp code which I've seen fairly frequently around this forum. If I use my yahoo account in the "To" field, the email sends without a problem. However, if I use my work email address in the "To" field, I...

Part and Inventory Search

Back
Top