Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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)...

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

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

OK, a small fly in the ointment. In a test environment I have the following data: tblAccounts: accountID isActive 1 Yes 2 Yes tblBalances: balanceID accountID balance lastUpdated 1 1 $5.00 1/1/2004 2 1 $10.00 2/1/2004 3 1 $15.00 3/1/2004 Using this query:SELECT A.accountID, B.balance...

Leslie, Thank you very much (especially for the quick response)! I tried something very similar but (obviously) didn't have all my ducks in a row. Thanks again, Rob -Focus on the solution to the problem, not the obstacles in the way.-

I have an accounts table and a balance history table. For discussion lets say the tables are set up as follows: tblAccounts accountID (autonumber) isActive (yes/no account is active) tblBalances balanceID (autonumber) accountID (FK to tblAccounts.accountID) balance...

With Application.Windows("Book1") .WindowState = xlNormal .Width = 400 .Height = 300 End With With Application .DisplayScrollBars = False .DisplayFormulaBar = False End With You will have to use some API calls to change the size of the...

Try this... Place this into a module... Option Explicit Public Sub BeginProcess() Dim oThisXLS As Excel.Worksheet: Set oThisXLS = Worksheets("Sheet1") Dim rowCount As Integer: rowCount = 0 Dim filePath As String Dim newValue As String Do rowCount =...