Search results for query: *

I'm maintaining a Access 2003 application that has two forms. Each form uses a combo box (shipment prefix) and a text box (numeric identifier) which are then concatenated to create a shipment ID. An Add button puts the shipment ID into the table behind a subform on the same form. The table is...

Wayyyy back in the mists of time (early 90s) DOS and Windows 3.x ran in 16 bit space. In those days, there was a program called sweep.exe that would start in the current directory and execute a DOS command (with arguments) on that directory and all of its subdirectory tree, e.g. sweep del *.bak...

I'm an experienced programmer, but am new to Oracle. I have an Oracle table that I am querying, that contains a VARCHAR2 field (DESCRIPTION) whose text contains newlines (the kind is uncertain, but the client runs on Win2K and the server is Solaris). I need the query to use a function to remove...

We are using an Excel spreadsheet (with a single sheet) as a data file, with a number of columns containing Boolean (TRUE/FALSE) cells. We read the file using VB6 and ADO. For some reason, ADO retrieves some TRUE Booleans as FALSE or Null. In a few cases, FALSE values have been retrieved as...

Here's the gist of a Human Resources applet I'm working on. A user enters a Notes database, withe default "view" being an empty shared folder. The user presses a button, and an Inputbox requests the user's employee ID (EMPID). If the user enters his number and presses OK, the folder gets filled...

This tip has also been posted in the VBA Forum. I have a VB6 application that opens an arbitrary Word document using Microsoft Word 97, and scans the document for a keyword. Some of the documents are large and complex, and would hang at the next document manipulation statement past the...

We have an export file with personnel information, with each record associated with a Notes address in rfc821 format, that is first_last@domain.ext, stored in the field INTERNET_ADDRESS. We need to use this information in a Notes database to restrict access by a user to just the records...

Has someone out there figured out a good way to search for a keyword in the Footnotes() collection (if any) in a Word (2000 or newer) document? I already have code that searches for each occurrence that keyword in the ActiveDocument.Content range. The footnotes in a document do not seem to be...

I need to print a report of the structure of a multiway tree of nodes, stored as two tables in an Access 2000 database. The master table contains node information. The other table stores connections between nodes that have inputs and their inputs. Fortunately, a simple way to print the...

I have a VB6 application that opens an arbitrary Word document using Microsoft Word 97, and scans the document for a keyword. Some of the documents are large and complex, and would hang at the next document manipulation statement past the "WordObj.Documents.Open" statement. The bug...

Here's the deal. My customer edits an Access database that contains data that many other people would like to access or query. The deal is, we don't want those other people to be able to modify that database. While I have developed a way for the users to view the data in either read-only or...