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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by RobSchultz

  1. RobSchultz

    Set default startup folder

    Figured it out. A few months ago I was trying to not use the workspace as my default home page (corporate standard) and had erroneously picked the sub-folder instead of "Inbox" as the bookmark to use as the home page. Thanks, Rob
  2. RobSchultz

    Set default startup folder

    I'm using LN 6.5.4 and would like to know how to set the default startup folder. I would like it to be my Inbox but it wants to default to one of the subfolders underneath "Folders". I've tried everything I can think of but haven't found anything that works. I am a neophyte to Notes so I know...
  3. RobSchultz

    Clearing SQL Connections - passing conn by ref

    This is a two part question/problem and I apologize in advance for the rambling. They may be well known facts/issues/features but they are new to me... Setup: While trying to figure out how to pass a connection by ref to a subroutine I found that I couldn't use the ref keyword (error: Argument...
  4. RobSchultz

    Referencing WebForm from Class

    After a bit of a nudge from crazyboybert I came up with the following. It doesn't seem very elegant but it does the trick. I would be grateful for any suggestions to make it better. Create a web form with a few text boxes (txtBox1, txtBox2, etc) Public Class TestForm Inherits...
  5. RobSchultz

    Referencing WebForm from Class

    I would like to make a class that will allow me to re-use code among multiple forms. I would like to be able to pass a reference to a form to the class but can't figure out how to accomplish this in ASP.NET (sort of like in old VB you could use ByRef oForm as Form.) Ultimately, I would need to...
  6. RobSchultz

    PPT: how do I tell if a "save" or "save as" is in order.

    Don't know if it helps or not but could you use Application.ActivePresentation.Path as it will return an empty string if the document hasn't been saved yet? Perhaps you could check whether or not your custom properties exist and add/populate them if they don't. HtH, Rob Rob -Focus on the...
  7. RobSchultz

    File Count

    Here's one way... 'add reference to Microsoft Scripting Runtime Private Sub main() MsgBox CountFiles("c:\") MsgBox CountFiles("c:\", "txt") End Sub Private Function CountFiles(ByVal folderPath As String, Optional ByVal fileType As String = "*") Dim oFSO As New FileSystemObject...
  8. RobSchultz

    Merge text file

    I'm pretty sure all of the suggested methods will allow duplicate records to exist. Here is another method... Private Sub Main() Dim allRecs As Collection Dim result As Boolean Set allRecs = MergeFiles("c:\File1.txt", "c:\file2.txt", "c:\file3.txt", "c:\file4.txt") result...
  9. RobSchultz

    Using existing Access VBA with external VBScript

    This should give you an idea... Dim oWSH As WshShell Dim retVal As Long Set oWSH = New WshShell retVal = oWSH.Run("msaccess.exe c:\TestDB.mdb /x TestMacro", 1, True) Set oWSH = Nothing Make sure your macro ends with a Quit command so the access process will close and...
  10. RobSchultz

    Play a wave file on a remote computer

    It is possible to do this but probably not with VBScript. A simple way to accomplish this with VBS would be the following... 1) Have a "client" script that runs constantly and checks a particular location for a file (simply a do loop with a dir or FSO check for a file (a flag file)) 2) On the...
  11. RobSchultz

    Table vs. Query

    Nevermind, It all had to do with the fact that I was pre-seeding the qryPreviouslyInactiveAccounts.isPreviouslyInactive with -1 rather than tblAccounts.isInactive. Regards, Rob -Focus on the solution to the problem, not the obstacles in the way.-
  12. RobSchultz

    Expression to cng date to day not working

    This should show you how to use the different date functions... someTable id (autonumber) toDate (date/time) SELECT id, toDate, (Format(toDate,"dddd") & ', ' & Format(toDate,"mmmm") & ' ' & DatePart("d", toDate) & ', ' & DatePart("yyyy", toDate)) as formattedDate FROM someTable; HtH, Rob...
  13. RobSchultz

    Table vs. Query

    Is there a difference to Access/Jet that would keep me from using a query in the same manner as a table? Here is a simplistic representation of what I am trying to accomplish... tblAccounts accountID (autonumber) isInactive (yes/no) 1 0 2 -1 tblBalanceHistory balanceID (autonumber)...
  14. RobSchultz

    HELP!! Emergency Select 25 records only

    SELECT TOP 25 ... HtH, Rob -Focus on the solution to the problem, not the obstacles in the way.-
  15. RobSchultz

    Help with SQL Query - newest records

    This works SELECT A.accountID, B.balance, B.lastUpdated FROM tblBalances AS B RIGHT JOIN tblAccounts AS A ON B.accountID = A.accountID WHERE (((B.lastUpdated)=(SELECT Max(C.LastUpdated) FROM tblBalances as C WHere C.AccountID = B.AccountID) And (B.lastUpdated)=(SELECT Max(C.LastUpdated) FROM...
See more

Part and Inventory Search

Back
Top