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

  1. Quehay

    is null statement producing wierd numbers

    There's no "is null" statement in SAS except in SQL statements. Is this data step or PROC SQL?
  2. Quehay

    Using a variable in a title1

    Looks like you're expecting the macro variable to hold a text character, which it will, but you're not populating the variable in macro code, e.g.: %local _param; %let param=SYSPARM(); title1 "Report for &_param.". You're treating it as if it were a datastep variable, and you can do this but...
  3. Quehay

    Checking an if-then statement using a long list of values

    Is there a way to check this code?" Yeah review it. How could a set of literal values be checked otherwise? Or did I misunderstand this question? *Ignore if this is a dead issue.
  4. Quehay

    Reinstall Problems

    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...
  5. Quehay

    Access query using Excel VBA

    Suggestions (you may have inherited names...) --get rid of spaces in table names as a general rule --use aliases to make the code more legible and compact --debug.print the SQL string once it's put together, copy to clipboard, create new query in Access and paste SQL into it to see if it works...
  6. Quehay

    Word VBA Goes into BREAK w-out Reason

    Thanks Roy. I tried those too (I set break on all errors to true to confirm that no errors were occurring and reset to break on unhandled; save VBA project and compile.) Sounds like you suspect the same sort of thing (a residual code project property from having a break point in place). I'll...
  7. Quehay

    Word VBA Goes into BREAK w-out Reason

    Thanks PHV...you know, I put that in there as a potential fix--it was doing so prior ;-) I've seen this before with Word. I didn't try a reboot, so I wonder if stepping through with F8 set some session property that's causing this. Jeff Roberts Insight Data Consulting Access and SQL Server...
  8. Quehay

    Word VBA Goes into BREAK w-out Reason

    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...
  9. Quehay

    Programatically determine path to linked tables

    Here's a freebie (assumes that all linked tables reside in the same file): Set DB = CurrentDb For Each Tdf In DB.TableDefs If Len(Tdf.Connect) Then strExternalMdb = Tdf.Connect Exit For 'One table is sufficient End If Next Jeff Roberts Insight Data Consulting...
  10. Quehay

    VBA editor acts erratically

    Have you tried making sure that all unnecessary objects are closed and you've saved both form object (if working on a module behind form) and vba project? I get a cursor that won't even space away from first code word when there's too much in the edit buffer (just like what you're describing)...
  11. Quehay

    How to Connect to an Access DB remotely

    You can program Access with VB Script: Set objAcc = CreateObject("Access.Application") objAcc.QueryDefs.Add strSQL etc. How remote? WAN or HTTP? If it's WAN a copy of Access elsewhere can connect remotely. Jeff Roberts Insight Data Consulting Access and SQL Server Development...
  12. Quehay

    PROC SQL - WHY 'ON' INSTEAD OF 'WHERE'??

    Sorry for the late post folks... SQL 89 select t1.*, t2.* from t1,t2 where t1.joinfield=t2.joinfield SQL 92 select t1.*, t2.* from t1 inner join t2 on t1.joinfield=t2.joinfield It's just different syntax for the join. The problem with outer joins is application support & syntax...
  13. Quehay

    How to Connect to an Access DB remotely

    Sure, VBScript will do that. Now do the homework...the time you spend will more than equal the cost of an Access stand-alone. Jeff Roberts Insight Data Consulting Access and SQL Server Development www.InsightDataConsulting.com
  14. Quehay

    connecting Access 2003 to Oracle

    ADO is superior to ODBC, although it may not make a hill of bills at the end of the day. --can't tell you how many times I've posted these, but what you need to know is here: http://www.connectionstrings.com/ http://www.able-consulting.com/ADO_Conn.htm Jeff Roberts Insight Data Consulting...
  15. Quehay

    VBA editor acts erratically

    I get cursor problems when I haven't saved in VBA editor or when there are too many objects open for design. I think this is a memory issue. So don't climb 50 feet up before placing a protection point, so to speak. Save often, keep only needed objects open. Jeff Roberts Insight Data...
  16. Quehay

    Pass Recordset to Sub

    This shouldn't give you trouble (assuming that you've just omitted the code that opens the recordset) --I pass RST's all the time as parameters. You might want to clarify though with (ByRef RsClaim as rst, ByRef Pat as string). But think about it--you're not really passing the recordset, but...
  17. Quehay

    Could not find installable ISAM

    jpiscit, Post your connection code...SQL is typically much cleaner to get a connection with than Access BE's. Also: www.ableconsulting.com www.connectionstrings.com (If I didn't remember the URL's verbatim do a Google search on these titles--they are great connection string example pages.)...
  18. Quehay

    Module level variable going out of scope

    tsuji, Thanks--I wondered if maybe the dll was fried or something. I found an earlier version of the same script that ran correctly (I printed copies and there were NO DIFFERENCES in the problems areas). So I copied new subs/lines into the old script, and it ran. This was the most mysterious...
  19. Quehay

    Module level variable going out of scope

    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...
  20. Quehay

    Where are the table.field descriptions stored?

    Hey don't let the "death of DAO" paranoia get you--when it goes Access probably will too. DAO is so much better for native Access stuff--even Microsoft still says that it's faster for native Jet work. ADOX is the one you want though...set a reference to it and look in the object browser. It...

Part and Inventory Search

Back
Top