Recent content by jpittawa

Yes. I just tested it with Access 2003. Public Function vbNullStringTest() Dim s As String If s = vbNullString Then s = "It works" Else s = "It fails" End If Debug.Print s End Function Immediate Window: ?vbNullStringTest() It works

This solution will always have the problem you describe. Shell() returns the task number for a stub process used by Windows to start the application specified, not the application itself. In other words, it returns the task ID for Shell() process, not the targeted program. As you discovered...

lupins46 (MIS) >If you already have a deployed Access application then all you need to reissue is the mdb or mde file on its own. The error I'm is reference unavailable... Background: The Access application was written by a now defunct consulting firm and is distributed from a central server...

I need to buy Office 97 Developer Edition AKA Office Developer Edition (ODE). This is not be confused with the Office 97 Professional. I need to use it's Package and Deployment Add-in to rebuild the MDE for a mission-critical application.

Give this a shot. Public Function CopyMonster() Dim sPath As String Dim sFullFileName sPath = "//Mars/Shared/ClientViewDocs/FolderX" 'Make sure the folder exists: If Dir(sPath, vbDirectory) = "" Then MkDir sPath End If 'Zap the file...

The mail server's time stamp is off. I assume that it uses the system time, but I can not remember how to set that.

IdoMillet (Instructor) I must be missing something. In regardless of the sort selection, all three metrics are summarized. I can only envision this working if I could ignore two of the metrics. What am I missing? Could you show some code? (Sorry, I'm not usually this dense.) JP

I misunderstood your intent. My apologies. My only excuse ist that, absent body language and intonation, intent is so easily construed. I do believe that a tutorial on the writing of Add-Ins is beyond the scope of this forum. I have yet to see the topic covered in under 40 pages. The reason I...

strongm (MIS) >And why do you think that IDE Add-Ins are beyond the scope of this forum? Or do you just mean your specific add-in code? Why do feel the need to be insulting in your reply?

My reports are deployed using Crystal Enterprise 9.0 on an intranet server. The user's access the reports using ePortfolio. I have a report that groups on Vendors, Sales Reps, and Customers in that order. The detail level is individual contracts. Groups: G1: Vendors G2: Sales Reps G3...

I'm trying to do the ASP.NET Walkthroughs and I get the following error when following their directions: The Web server reported the following error when attempting to create or open the Web project located at the following URL: 'http://localhost/MyWebForm. 'HTTP/1.1 403 Access Forbidden' I'm...

By now I think you understand that the function must be public or called by a routine on the form that is public. What gets tricky is setting a variable on one form from another. If you need to do that, you must set a reference to the specific instance of the targeted form on the form that will...

Thanks. This really helped! :-D

I need to dial out a parameter passed with the URL and I am completely new to JavaScript, although I am a reformed C hack. :-)

Are you using early binding? You establish that through the Project/References menu. In the References dialog select "Microsoft Word x Library". The "x" is the level of Word on your machine. Office 2000 uses "Microsoft Word 9 Object Library". Next declare an...