Search results for query: *

I killed inetinfo in the Task Manager (a goof), and I think this managed to **** up Explorer (oh, it's a browser application, not an integral part of the OS,right...?). I couldn't get System Restore to run, so I used the original XP disc (Dell) to reinstall/repair XP Pro. Now in the middle of...

I've got some simple Word VBA that worked fine in a couple of docs, but now it goes into BREAK mode on every iteration (with no errors). What gives? TIA Sub RevisionsToTextFile() On Error Resume Next Dim Rev As Revision Dim intFreeFile As Integer Dim lngRevCount As Long, i As...

I've got an Excel object variable declared in the page-level declarations. I initialize it in a sub and then refer to the variable in other subs. It worked but has stopped working (getting "object required" errors when trying to refer to it). This should not be happening, and it appears that...

I'm creating some Excel named ranges in VBA from a VB Script file. The names appear in the Insert>Define menus afterward but not in the names box. When I try to import the names from Access VBA they "can't be found" (and I'm saving the workbooks before attempting). Interactive, menu-driven...

I recently found a college course page with a SQL exercise for DIVISION, i.e. find which members of a table have existing matchings with another table in an intersection table. Something like "find the customers who have ordered every part in the catalogue". What I'm looking for is...

I'm working on my Oracle SQL skills and trying to get a groups with TOP n records for each group. This works in Access/SQL Server using a correlated subquery that selects top n records ordering by the pertinent field and then selecting based on correlation to a join field in the outer query...

I've been doing db and front development for several years and am constantly on the fence between development programming and data programming. I really prefer data but just don't see as many jobs (but the dev jobs are getting more scarce now). Question 1: I never see SAS mentioned in career...

OK I got over the FK squeamishness... Are there favorite admin GUI's anyone strongly recommends? Freeware is always nice, but a value for the buck is fine too. Ideally it would: --script out data as INSERT files --export data as CSV --create DDL scripts for tables,indexs, etc. --provide...

I'm new to mySQL. Is there a way to get a good synoptic view of tables,cols,indexs, etc. by querying internal dictionary tables as you can in Oracle & SQL Server? Also is there a way to script an entire database out to DDL and insert scripts? Thanks! Turn your headache into my project...

(I'm not a regular in this forum, so I did a keyword search first and didn't find a good treatment of this topic.) If I write a page that relies heavily upon CSS for layout (I can do tables no problem but CSS is so much better if you can count on faithful browser rendering), and I'm wondering...

Are there JS editors that anyone recommends? I don't mind Notepad but it makes code indenting a spacebar/tab chore, and when I introduce an error somewhere with some dumb typo then it would be nice to have a synax error color and save lots of looking and alert('got here');'s. Thanks! Jeffrey...

I've got Oracle 8.1.5 on XP (NT). It has worked just fine previously but now I'm getting if SERVEROUTPUT is on (and of course I need it on) PLS-00553: character set name is not recognized I've got PC settings at English/US. Thanks for any insight into this! SQL> set serveroutput off SQL>...

I'm working with cookies in JS for the first time. I've done the backround reading and have what should be solid code. I'm not seeing the cookies when I test locally or with the transferred site on web host. Code: var PATH = "localhost/"; function...

I've been working in CSS as a newbie and have a site that looks cool in local display. I ftp'd files (same names and paths) to a host site and now the CSS isn't doing anything. I put up a very spare test.htm to see if any CSS formatting is coming through at all and no. A javascript library is...

We're getting "Cursor conflict error" when merely trying to run the UPDATE method against an ADO Forward-Only cursor. This was working last week (and should) but now it's blowing up. We installed a new security hot fix for SQL Server last week. The error still occurs even after...

I've got a view that's feeding an Access form. Although I'm using Round(field,2) for output I still get the trailing zeros that correspond to the original field precision. What I need is something akin to Oracle's Truncate, that actually gets rid of unwanted precision. Is there a way to do...

This fails: update reports set page1_review_date = '11/14/2002', recommendation_blood_pressure='bp rec', recommendation_antiprotein='ap rec', recommendation_protein_intake='bp rec' where visit_guid='{F2482D81-95A4-11D6-987F-064514469200}' With this message: Server: Msg 295, Level 16...

Funny that the most recent thread is about xp_SendMail... I've got xp_sendmail working, and it's wrapped up in a proc that only asks for the "TO:" as a parameter (the other mail fields are hard coded). I want to periodically run a job that goes through a cursor of email addresses...

I've inherited a web app to maintain and modify. I'm used to ADO, but in a fat-client setting. I'm still figuring out to what extent global (asa or include) functions can pass connection and rs objects. The sub used in a globalinclude file is: Sub SetUpAndOpenRecordSet(ByRef rsRS, strSource)...

I've got a form with record control buttons (client request) that should be enable/disable acc. to record status. Here's the approach I'm using--please critique if you find a better way or a problem; please borrow if you like it: In order to make the buttons' status reflect the appropriate...