Search results

  1. H

    'type conversion failure' import error

    I have numerous excel sheets that contain number data that I am trying to import into an access database. The excel files were originally in text form but I was able to convert them to excel worksheets through a number of procedures. I have excel files for each month. Each excel file has hourly...
  2. H

    FileSearch takes a long time

    I have a program that will search for files. I only want the 'FileSearch' command to return files that occur after a specified date that the user inputs. I use the 'PropertyTest.Add' method of the 'FileSearch' command and it works, but it takes way too long. In fact, it takes so long that I went...
  3. H

    DefaultValue

    I have a form that has a text box that contains a date. When I push the 'UpdateDate' button I would like to change the default value of the text box to the current date. This I can do, but the default value is not saved the next time I open the form. Rather, it resorts to the original default...
  4. H

    Returning properties with 'FileSearch'

    Here is my problem: I am using VB to import text files into an Access Database. This is done, but currently it will only do one file at a time. I am now trying to get my program to search for the files I am interested in and import them. This is simple enough and I have the code written to do...
  5. H

    change the action of an existing button

    :confused: Here is what I want to do: Be able to change the action of a particular button. I know that I can do this with the 'OnAction' method. In fact, I have changed what happens when the user selects 'Close' from the 'File' menu. However, since very few people would ever close a window that...
Back
Top Bottom