Search results for query: *

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

You need to give a more detailed explanation the problem. It sounds to me like you have to syncronize the data from one table in a database with the data from a table in another database. Further, it sounds like some of the fields are identicle, i.e. they have the same data type and...

Hypatia, your suggestion works if there are no blank lines in the targeted information in the input file.

>Thank you very much. You are welcome. I enjoyed figuring this out. A couple of things have come to mind since I posted this code. First, If Event Details portion were to contain a comma as part of the text, that would throw the Split() off. I would recommend a tilde "~" for the...

You vFilePathIn assignment will never work. It looks like you are trying to make some kind of pick-list and hand to the FSO's FileExist method for evaluation. The FileExist's filespec parameter requires a string that specifically identifies one file. Wild cards are not supported, otherwise one...

I'm not sure what version "Access 7" means. If it is an Office 2000 MDB, then Jet 3.51 will not read it. You need Jet 4.0 installed. MDAC_EXE no longer has JET. http://www.microsoft.com/downloads/details.aspx?FamilyID=af693865-2bab-4ae5-b001-42840473ef39&DisplayLang=en will get you...