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!

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

    Installed Vis. studio .net, but failure with .net compact?

    I just went through hours of utter frustration trying to install MS Visual studio 2005 (.net). It bombed 4 times during setup, some issue with ".net compact version 1.0." So, what's with all the versions of .Net and all the different failures of these versions? I thought .Net would lead us...
  2. TroyMcClure

    Does XP Pro directly support 2 processors?

    If I get a dual processor board, and have XP Pro as the OS, can I expect to be able to run 2 apps, each running full out with it's own processor? For example, let's say I have a video capture program and a video editing program. On my current box, a P4 with 1 gig ram, the video capture will...
  3. TroyMcClure

    Create Relationship--"No unique index found for blah blah.."?

    I'm losing my mind. I have 2 tables--TicketHeader and TicketDetail. Header PK key is: OrdDate OrdNum TktNum Detail PK key is: OrdDate OrdNum TktNum TktLine I'm trying to create one-many as shown: Header Detail OrdDate---OrdDate OrdNum----OrdNum TktNum----TktNum But I get the error: "No...
  4. TroyMcClure

    Is Asp generally better/worse/just different than PHP?

    I'm trying to get a general idea about the opinions web developers have as far as using php or asp as a development tool. With this being an Asp forum, I imagine I'll get positive response towards asp, but I'm also looking for an honest assesment of what asp's weak points may be, such as...
  5. TroyMcClure

    How do I copy html elements, then redisplay them with changes?

    I have an html table in an IFrame. The table is filled with data fetched from a sql-server database. I want to insert a row in between two existing rows, say, in the middle of the table. The row is hardcoded, so I don't want to refresh the page which would require a trip to the server. I...
  6. TroyMcClure

    How to get window.event.keycode from an I-frame?

    I have javascript in the main page, which has an Iframe. Within the Iframe, there are textboxes. I want to trap keystroke keycodes from those textboxes inside the iframe. The source of the iframe is an asp page, and I have a function call for the onkeydown of the texboxes input tag. The...
  7. TroyMcClure

    Editing/Deleting virus registry entries--won't allow?

    I'm trying to stop a virus/spyware by taking out it's registry key, but I get the error "error deleting key" or "can't modify key". I've explicitly set permissions for myself for this key and all child keys--the intruder had given my user read-only access when it installed itself. Why can't I...
  8. TroyMcClure

    How to embed Picture on MDI Form?

    I have an MDI form where, in design view, there is a picture background. I know I can set the .Picture property at runtime, but how do I change this at design time so that: A. When I open the project I don't have to look at that picture. And... B. So I don't have to ship the actual new .jpg...
  9. TroyMcClure

    Long delay in Dialog box to open .mdb file

    Sometimes, when I open the the MSAccess.exe application (not an .mdb app), and then I go to the File|Open to select an .mdb--the dialog opens but takes a huge amount of time before it lists any files. There is an hourglass and I'm completely locked until it decides to free the dialog. By 'huge...
  10. TroyMcClure

    Bizarre Parameter problem

    I made a quick query, saved it as 'query4', just because it was only to be a temporary make-table query. I made a table called 'SomeTempTable' using query4. I then deleted query4 Then I made another select query (called 'query10') using 'SomeTempTable' as it's source. When I run Query10, it...
  11. TroyMcClure

    How to stop mouse flicker?

    Hi, I have a bit of javascript code causes the mouse to flicker. How can I prevent this? The code takes about 1/2 second to run, but in that time, the flicker is noticeable and jarring. Thanks for any help, --T
  12. TroyMcClure

    Is there a CASE statement in TSQL, for logic flow?

    I've seen examples of a CASE statment for Select statements, but I want to control logic flow, here's a simple pseudo code: Select Case @DoWhat Case 'update' Update tblTest Set kang = 'testing'; case 'delete' Delete from tblTest Where kang = 'testing'; case 'insert' Insert into...
  13. TroyMcClure

    How do I temporarily shut down just my website?

    ...Or maybe shutting it down isn't needed. The problem is that I am running standard ASP, and there is a visual basic .dll that the ASP pages call for certain functions. When I need to make a change to that dll and put a new one in the winnt\system32 directory, the file can't be copied because...
  14. TroyMcClure

    What is the escape char for *?

    I want to find all records in a table where a certain field contains the asterisk character anywhere in the field. I've tried Like "*" & Chr(42) & "*", but this just returns all records. I'm thinking there must be an escape char, but I've tried some standard ones (/,\,[], etc), and none seem...
  15. TroyMcClure

    How to convert constant or field to Float data type for calculation?

    This is a problem that's I swear I've solved before, but I never can remember what I ended up doing. I have 2 fields, say [num1] and [num2], which are stored in the db as long integer. In a report's ControlSource, I try to avg as: =Csng(Csng([num1])\Csng([num2])) This ALWAYS results in a...
  16. TroyMcClure

    How to get ADO .Execute method to return number from SQL sp?

    Hi, In a stored procedure I want to return a certain calculated number from that sp to a VP app that uses an ADO Command.Execute to run it. I want to return this value to the 'RecordsAffected' argument of the .Execute command (I do NOT want to use an OUT param) My last statement in the SP is...
  17. TroyMcClure

    How to return a specific numeric value from SP?

    Hi, In a stored procedure I want to return a certain calculated number from that sp to a VP app that uses an ADO Command.Execute to run it. I want to return this value to the 'RecordsAffected' argument of the .Execute command (I do NOT want to use an OUT param) My last statement in the SP is...
  18. TroyMcClure

    How to delete .mdb file when users (supposedly) are in it?

    Ok...I'm at the console of a server and we have a corrupted .mdb file. I can't open it to repair it because it claims someone has it open. Nobody does, this is a fact. I go into the .ldb file and it won't let me delete that bcause of similar 'sharing' violation. Now, I'm the admin of the...
  19. TroyMcClure

    How do I set Module Editor properties?

    I don't know if I'm going crazy or not, but I can't find where to set the Tab Indent, Syntax Check, etc. options for VB Modules. Where are these settings? -T
  20. TroyMcClure

    Cursor dynamic SQL revisited

    I had asked recently about creating dynamic sql, ie, a string variable with a select statement, then how do I execute that. I answered my own question by finding the sp_executesql proc. Now I need to open a cursor using a sql string stored in a variable. I tried "...cursor local for...

Part and Inventory Search

Back
Top