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

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

    Excel cell text overhangs column edges

    A friend of mine has an Excel file that she says used to look right until someone installed some things on her computer, and now it doesn't look the same. The problem is that the text in some of the rows overlaps the left and right edges of the cell (the text is centered). This only happens in...
  2. Jerrycurl

    "Enter network password" popup. Why?

    I recently installed ASP.net 2.0 and was playing around with it yesterday. I created a web page on my local machine and everything was working fine. I published it to a web server on our network and that worked fine. Then I did *something*, I don't know what, and now when I try to load the...
  3. Jerrycurl

    On-demand subreport that displays on same page?

    I would like the user to be able to click on a group heading to show/hide the details section for that group. The problem is that when I configure the details section for drill-down, the drilled-down subreport appears on it's own page. I would like it to appear within the current page...
  4. Jerrycurl

    Validator within a Repeater problem

    I have a textbox and a button within a repeater. The OnItemCommand sub of the repeater looks like this: Sub RepeaterButtonSub(ByVal source As Object, ByVal e As RepeaterCommandEventArgs) Dim RejectTxt As TextBox = CType(e.Item.FindControl("txtRejectNote"), TextBox)...
  5. Jerrycurl

    Anyone know how to check rules in an event sink?

    I have an event sink that moves spam into the user's junk folder. The problem is that I want to check if the user has created their own rule to handle spam, and if so, not do anything. The easy ways to deal with rules programatically all seem to use CDO. As far as I can tell, CDO requires you...
  6. Jerrycurl

    Strange For loop problem

    Put a button on a form and add this code in the click event: Private Sub Command1_Click() Dim x As Date Dim starttime As Date Dim endtime As Date starttime = "5:00:00 AM" endtime = "8:00:00 AM" For x = starttime To endtime Step...
  7. Jerrycurl

    CreateMailbox() won't work

    I'm writing code to add a user to the Active Directory and create an Exchange mailbox for that user. Here's what I have: Try Dim de As New DirectoryEntry("LDAP://server.domain.net/cn=users,dc=domain,dc=net", "administrator", "password")...
  8. Jerrycurl

    CreateMailbox() won't work

    I'm writing code to add a user to the Active Directory and create an Exchange mailbox for that user. Here's what I have: Try Dim de As New DirectoryEntry("LDAP://server.domain.net/cn=users,dc=domain,dc=net", "administrator", "password")...
  9. Jerrycurl

    Do I have to buy a certificate in order to sign my code?

    I have some macro-containing Excel sheets that will be distributed to all the employees in my office. I don't want the users to get the warning about macros when they open the file. Signing my code with a certificate seems like the way to accomplish this. I've created a certificate with the...
  10. Jerrycurl

    Is there some new .NET-approved way

    Is there some new .NET-approved way to get the color of a pixel in a window (a window external to my program). In VB6 I would do something like this using API functions: GetCursorPos p hwnd = WindowFromPoint(p.x, p.y) deskhdc = GetDC(hwnd) rgbVal = GetPixel(deskhdc, p.x, p.y) retval =...
  11. Jerrycurl

    component not registered

    I know this has been asked before, and it's even in the MS KB (Q289493), but I just can't believe what it's telling me. My office just upgraded (almost) all of our users' computers to Windows 2000. I went around to all of them and installed my VB program (with the setup made by PDW) while...
  12. Jerrycurl

    "Cannot edit this cell". Why?

    We just upgraded our SQL 7 server to SQL 2000. When I open a table in enterprise manager, order the rows, and try to edit a field, I get the message "Cannot edit this cell". It doesn't happen for every table, and it only happens if the rows are sorted by certain columns. It's only...
  13. Jerrycurl

    Poor Enterprise Manager performance w/logins

    I'm running SQL 7 on an NT box. My Windows 2000 desktop has Enterprise Manager 2000 installed (we're not quite ready to upgrade the server to 2000), and is what I use most of the time to maintain and administer the database. The problem is that it takes a ridiculously long time to add or...
  14. Jerrycurl

    Can I specify bounds for my random number?

    I need to generate a random number between 1 and 216 with SQL Server 7. Any tips? Thanks.
  15. Jerrycurl

    I have a recordset-returning DataEn

    I have a recordset-returning DataEnvironment command thats source is a stored procedure. The stored procedure looks something like this: CREATE PROCEDURE sproc1 @var1 varchar(6) AS <SELECT statement 1> if @@rowcount = 1 return else begin <SELECT statement 2> if @@rowcount > 0...
  16. Jerrycurl

    Janus vs. Apex

    I have a program that makes extensive use of Apex's TrueDBGrid (ver 6) and minor use of Janus's Gridex (ver 1.6). I now have Janus Gridex 2000 and am giving serious thought to replacing my TrueDBGrids with Gridexs. The ability of Gridex to scroll rows as you use the scroll bar alone almost...
  17. Jerrycurl

    Can CR 7 Standard make reports from SQL Server 7.0?

    Do I need the Pro version?
  18. Jerrycurl

    Permissions problem with stored procedure

    I have a stored procedure that looks something like this:<br><br>CREATE PROCEDURE sp_dosomething @param1 varchar(5) AS<br>&nbsp;&nbsp;if @param1 = &quot;this&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;select * from database1.dbo.table1<br>&nbsp;&nbsp;else if @param2 =...
  19. Jerrycurl

    Is there a way to search my stored procedures for a string?

    Is there a way to search the text of my stored procedures in SQL 7 (or 6.5 for that matter) for a string?&nbsp;&nbsp;For example, I want to make sure I'm using &quot;IS NULL&quot; instead of &quot;= NULL&quot; in all my sprocs, so I want to be able to get a list of all the sprocs that have...
  20. Jerrycurl

    Problem passing a parameter with VB

    I'm using CR8.&nbsp;&nbsp;My report is based on a table.&nbsp;&nbsp;I have a parameter (@grant) that is used to filter the report; this is what my record selection formula looks like: {TEMP_WEEKLY_SCHEDULE.grant_name} = {?@grant}<br>The report works as expected in the Crystal Reports...

Part and Inventory Search

Back
Top