Search results for query: *

I'm trying to use "gampm = Right(CTime({datetimefield}),2)" to get the AM/PM part of the DateTime field. However I get the message "A string is required here" with the cursor positioned after "Right(". What type does CTime() return? How should I accomplish this?

In debugging a report, I need to investigate the values of Shared Variables, and would prefer to do so without having to return them as the result of the formulas. Can this be done?

I have a setup where there is a master table which is related via CaseNo field to three child tables. For each master record, there will be data in only one of the child tables. Using only one detail line, I need to include data from the master table and the child table that is not at end of...

I have two tables in which I need to link: Quelist.CallId --> Calls.ID Can this be done? Note: The Quelist table also has an ID field. By default, the visual linker tries to link the two ID fields, which aren't even supposed to link.

Correction: Since creating that thread, I've learned that the Package and Deployment Wizard doesn't work, on the installation side, in all situations. See the Helpful Tips thread "When Moving Apps, Always use the Package and Deployment Wizard" for a discussion of this. Seems to work...

I understand from one of Zor's posts that "it won't put my application on an NT machine". I'll still look into the MS Visual Studio Installer for future installations, but I've already got the installation package burned into a CDR and I'd hate to waste it. Besides, my situation is...

When delivering an application to a client's site, just copying the app's EXE file will NOT work. You need to create an Installation Setup Package. I learned this the hard way. I took a copy of the exe to the client's site, ran it, and got "Runtime Error '713' 'Application Defined or...

When I take the application to the client's site, and try to run the application from the icon, I immediately get the above runtime error. When I run the application here at the office, it works fine with no problems. Therefore, the problem is unduplicable at the office. I'd hate to have to...

I have the following loop in my program: lSkipEOF = 1 Do While lSkipEOF = 1 'Record specific variable initialization 'No Tissue Quantity entered If Left(sTissueUser, 1) = "Y" And Len(Trim(sTissueQty)) = 0 Then lRetVal =...

I've asked this question in the Visual Basic forum, where I was informed to use App.PrevInstance . That works fine for VB generated EXEs. But when I try it in a Word macro, I get the error "Runtime Error 424: Object Required". What do I need to do?

At the beginning of my Word macro, I would like to have a simple If structure to determine that the correct document is open before continuing with macro processing, maybe by checking the file name. How can this be done ?

I don't want the program to be run on top of another copy of itself. I want something simple to place at the very start of my Main procedure. My application has no forms. I picture a simple If structure as follows: If ______________ Then lRetVal = MsgBox("Program is already...