Search results for query: *

Hello! I am trying to determine the syntax to merge 2 tables together with different schema into a View. The 2 tables are identical except one of them has an additional column. Whenever the View is called, it will retrieve all data from each table with no conditions or restrictions. The...

Hello, I am new to Ruby and Windows programming and have a question regarding the WIN32OLE. The following sample code is used to launch MS Internet Explorer. require 'win32ole' ie = WIN32OLE.new('InternetExplorer.Application') ie.visible = true ie.gohome What I would like to do is launch MS...

Hello, I am having trouble creating a javascript function to parse through the HTML source code of a webpage using the Firefox browser. I have the following code, which attempts to make use of the built in function calls 'window.document.body.innerHTML' and 'HTMLsource.indexOf('bug.gif'...

Hi, I am running a script which is outputting the following error: Invalid default value for 'changed' This corresponds to the following portion of code: CREATE TABLE realm ( name CHAR(16) NOT NULL, title CHAR(64) NOT NULL, changed TIMESTAMP(14) NOT NULL DEFAULT '', PRIMARY KEY(name)...

Hi, I am wondering if anyone can direct me to some help regarding the use of the Spell Check Dialog Box. I would like to access Microsoft Excel's spell checking tool, but instead of clicking 'ok' to change words, I want to modify it so that a list of words can be separated into two lists of...

This should be an easy question, but as a novice programmer, I am not sure how to solve it. If I have the simple code below: Private Sub Command1_Click() Dim ExcelApp As Excel.Application 'Excel-object Dim colRange As Range ' Column in which to read values from Dim i As Range...

Hi, I would like to know how to import Unicode Text files into a list box. The method I am currently using is: Dim fnum As Integer Dim file_line As String fnum = FreeFile Open sDestFile For Input As fnum Do While Not EOF(fnum) Line Input #fnum, file_line lstDest.AddItem...

I am wondering if there is a simple way to import a text file of words (one per line) into a listbox, besides using the 'AddItem' method. Thanks

Hi, I am importing a unicode text file into Excel, modifying it, and then saving it. The problem i am having is that my command: xlBook.Application.SaveWorkspace "valid.txt" is not saving as a Unicode file, so when i try and reopen the modified file, it is gibberish. There are...

Hi, I am having a problem deleting a folder that is created within VB. When I try and delete the folder, I get a message: "Run-time error '75': Path/File access error". The folder cannot be deleted manually either, and displays the message "There has been a sharing violation...

Hi, I am a new VB coder trying to import a unicode text file into Microsoft Excel to perform a spell checking function, and then to have it save as a new text file. I am having problems with the saving of the text file, because it is creating a file full of unrecognizable words. I have some...