Search results for query: *

Lilliabeth, I used your suggestion only without the inline If and it worked like a charm thanks!

Lilliabeth, I used your suggestion and plugged it into: IIf(IsNull([Enter]),"Like *" & [Enter] & "*",[Enter]), but that did not work either way. If I entered a criteria it returned no records or if I left it blank it returned no records, any other suggestions? Thanks, David B.

By using a user-defined variable, [Enter X Data], in an Access query, how can you make the query display all records if the user enters no criteria? I've tried an IIf statement like IIf(IsNull([Enter X Data]), "Like *", [Enter X Data]), but that didn't work either. Thanks in advance, David B.

I have an Access report that I developed that essentially is just a report that was developed from the Access Report Wizard. At the end of the report, I modified the form to include two end pages that both of them break down the record totals that were listed in the previous pages. I had my...

I have tried that, too, and it did not resolve the issue. Thanks anyway.

No, It is an instance of the control "dragged and dropped" on the form that is giving the error. Thanks again, David Bowles

I get the error "Microsoft Visual Basic: Licensing information for this component not found. You do not have an appropriate license to use this functionality in the design environment." The component that it is referencing is Microsoft Common Dialog Control 6.0 (SP6). If I pull this...

So are you saying that I should replace "SYSTEM" in the line CALL SYSTEM USING COMMAND-LINE. with /bin/sh, because the line CALL SYSTEM USING COMMAND-LINE. is working, however it is not parsing the text correctly that is stored in the WORKING-STORAGE variables. Thanks, David B.

I apologize I didn't check the faqs first. I am using AcuCOBOL 74 on a SCO UNIX box. Is there a different command than calling system? The faq seems to indicate those are for Windows OS's. Thanks again, David B.

Is there anyway to execute command line commands through COBOL and if so, what is the syntax? Thanks, David B.

Is there a way to view a table of an .MDB file you are writing to during runtime if you have the MDB opened exclusively by the program? I haven't been able to find any type of Add-In for VB and was wondering if anyone may know of a solution... Thanks, David B.

I was told that the Clipboard cannot be used to copy to the System clipboard because of the security settings within an Applet and the only way around this is to create a signed applet which i think is going to far out. Is this not true? David Bowles

Hello All, Can someone give me a page to view or provide me the details of the simplest way to develop an applet that will allow the copying of text in JTextAreas and JTextFields from the applet into a Windows Application that is compatible with the System Clipboard? Thanks, David Bowles

Yes, I know that much but once you actually are into SQL*Plus is there any way to cache the prompt history inside the CLI? For example SQL> select * from test; If I execute that command and want to change it to "select * from test2;" without having to retype the entire line is there any...

Hello, Can anyone tell me if it is possible with SQL*Plus or if there may be an alternate program like SQL*Plus that has the capability of storing prompts in history and retrieving them like linux and Windows allows by using the up/down arrow and/or F3? It would be much easier to reload the...

Hello, Is it possible to write a web query in Excel to query a table from a site that is password protected? I am almost positive that it is possible because a co-worker supposedly wrote an excel macro that pulls it and she was able to execute the query from home one time but now we cannot...

BTW I forgot to mention I have a Toshiba E335 that runs on the Intel XScale 300Mhz processor.

Hello, Does anyone know of a Java SDK that is compatible with at least 1.2 that runs on Pocket PC 2002 that is free? I have seen many that work with 1.0 or 1.1 but I want an SDK that is Java 2 compatible. Thanks, David B.

Tony, Thank you so much for helping me out, I finally got the code completely finished. It overall takes 18 reports that each report pulls data from midnight to 11:59PM and cuts all of the fluff out and pastes them into another excel sheet that manipulates them to show us an overall summary of...

Tony or Anyone else for that matter, I think I have found my problem. I cannot find any specific documentation on the proper procedures on programatticaly switching sheets in Excel. In my case I am moving data from one sheet to another. Should I have my macro stored in a module or in a sheet...