Search results for query: *

Hello all I want to get a listing of files in a particular directory and turn that into a table in MS Access. I also want to get the lastmodified date of the file and also the filesize. Since the contents of the directory change, I'll need to refresh the table either automatically when the...

Hi- I need to remove all spaces and punctuation from a string. What function do I need to use? For example: Trees. Blue Spruce Trees, Large. Redwood Output: TreesBlueSpruce TreesLargeRedwood Thanks for your assistance!

I have been reading the FAQ's and don't know the best and easiest way to approach this. Plus, I don't have a lot of experience writing SQL statements, so would appreciate some help. I have a table "Main" that has a one-to-many relationship with table "tbl_names". They are linked on field...

I have a combo box with a number of options. When the option changes to "Catalog" I want to run some code but only if the current option was set to "Review". Which event properties do I use to check the value of the current option vs. the changed option? Thanks for your help.

Is anyone aware of a completely free Microsoft Word to HTML batch conversion tool (EXE, VBScript, JScript, etc.)? I've looked at the popular download sites like CNET and haven't found anything. Thanks. Mully

I have a series of numbers in a field like this: 6.10 7.12 8.100 8.101 8.102 9.10 9.11 10.10 10.20 This was originally set as a text field, but it wouldn't sort the numbers correctly, so I changed it to a currency field. Now, however, if the decimal place is set to "auto", the third digit...

I need to change the value attribute on an <input> element created by a database form. The form is created by a database program, so I don't have control over how that form is created. I only want to change the value of one of the <input> elements after the page loads. The form looks like...

I want to have a combo box that lists the filenames that are in a specific directory. Only files that have a &quot;txt&quot; or &quot;doc&quot; extension will show up in the list. Users will be able to select one of these files from the list and it will be stored in a table field so that the...

I have a field that I want to be able to put some type of &quot;marker&quot; in to indicate a carriage return or linefeed. I was thinking of something like <cr>. So a sample text string might be: &quot;I want a carriage return <cr> here and also <cr> here&quot; How can I parse the string to...

I need to change a string that contains a series of words (separated by spaces) in ALL CAPS, to title case, where only the first letter of each word is capitalized. Example: ABSTRACTS AND PROSPECTUS to Abstracts And Prospectus I know how to use the translate() function to drop the case of...

I have fields named size1 size2 size3 ... through size20. I want to create a condition in a macro that checks to see if size1 - size20 fields are null. Is there a way to refer to all 20 fields in one statement (other than OR-ing them together :-) ) Thanks for the help.

When a particular form opens, the find box automatically pops up which allows a user to search for a particular word in the form. Unfortunately, two of the fields are quite lengthy, and sometimes it finds a word that is not in the displayed portion of the field, so you can't tell where or in...

I have a subform called &quot;all orders&quot; with field &quot;Order number&quot; and it's parent form called &quot;order form&quot; with the same field (based on the same table &quot;orders&quot;). The subform lists all of the order numbers associated with a particular customer so you can...

Several people helped me get my text validation for a text box (http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/181/qid/153356), but now I have a new problem! I also want to use the same input validation *first*, before the string is checked against whether it's in the list. I put...

I have a switchboard form when my database first opens. I originally used the built in buttons to create links to forms, etc. It used to set focus on the first button in the list of options. Now I created some new customized buttons with a graphics editor, and now when the switchboard form...

Is there a way to either hide the title bar for a form completely, or at least not display any text on it? Thanks. :-)

Refreshing combo box when item not in list and you've just created a new list entry. OK, I've got a combo box and an entry must be chosen from the list. If the item entered is not in the list, then a data entry form opens so they can add it. Now when they close this data entry form, I want...

I have a text field. What will be entered in this field is a series of letters (length varies) followed by a space and then followed by a series of numbers: e.g. NA 4555 or Jones 1234 I want to make sure that people always put a space between the series of letters and numbers. Since the...

I have a very long form with a page break in the middle. Is there some code I can put in that will prevent it from printing a second page if there's no data on that page?

Hello: When a search returns no records (form based on a query), you get a blank screen. Are there any other options, like having a msg box open or something? I know you can have it display all records if nothing is found, but that's not useful to me. Thanks.