Search results for query: *

Hi All, I've made a script that I use to convert a set of tab separated text files into formatted excelsheets. The script works, except that it leaves an instance of excel open, even though I think I am closing it and removing it from memory. I read about 10 threads on different fora before I...

Hi All, I have created the code below (code block 1) to convert sets of tab-separated text files to MS-excel (2000) workbooks. I want to import the excel-files into MS-Access (2000), and I would prefer to run the conversion routine from text to excel from within Access as well. This way I could...

Hi All, I'm trying to create a batch-conversion script that converts a set of text files to a set of excel workbooks. I've currently made a script that I thought would do the trick, but upon saving I get the error message: Runtime error 13: Type mismatch Below is the script I'm using (the...

Hi all, I just tried installing ActivePerl-5.8.8.817-MSWin32-x86-257965.msi on a Windows XP Professional machine. I more or less accepted the default options, except I only checked the upper two checkboxes in the optional setup actions window. ("Add Perl to the PATH environment variable" and...

Hi all, I am making a simple cash book for my own administration. I structured the input of data like this: ______________ | | | Receipt data | Important field: Total sum on receipt. |______________| | 1. | _______?_many______ |...

Hi All, I'm trying to write a macro in Excel that pastes the text of several rtf-documents into a single Excel cell for each of the documents. What I have already is a macro that checks what rtf-files are available in a certain folder, and that copies the content of the rtf-file. It also pastes...

Hi All, I'm relatively new to InDesign, so don't be too hard on me! :-) Here's my question: I have a Master spread with a bitmap image covering the entire left page. I have made another master page based on the first master page. On this one I want to add chapter numbers, which I want to be...

Hi everybody, I'm trying to create a cash registry database. I have made a list of ledgers and a list of subsidiary ledgers, e.g. a ledger for household costs, for transportation, for sports, for salary, etc. and subsidiary ledgers for say food, personal care, petrol, Car maintenance, etc...

Hi all, I have used this tutorial to create a set of stylesheets between which I can switch. I fact, I switch between two stylsheets that contain specific markup and I have one main sheet that is always enabled. The code works in IE, but not in Firefox. Can anyone help me out? I really want it...

Hi all, I'm trying to build a vertical css menu that uses background images to get a menu that scales up together with the displayed font size. See http://www.alistapart.com/a rticles/slidingdoors/ for an article on how this technique should work for a horzontal bar with tabbed navigation. My...

Hi all, I have built a menu using css which you can find here. The CSS can be found here. The menu looks great in Firefox and Opera, and on first sight, even IE seems to render thing correctly. However, when you move the mouse over the menu, you'll notice that the hover state is not displayed...

Hi all, I am trying to make a smart selection using SQL in VBA. I have an address database in Access 2000. I have a table in which relations are made between persons in the database and groups they can belong to. Each person can belong to any number of groups and each group can contain any...

Hi all, I have a listbox with the multiple selections option set to extended. I need to know the listindex for each selected item. I think I need to do something with the itemsselected property of the listbox, but I'm not sure how to do it. This is the code I have now: intTeller = 0 For...

Hi All, I have a database in which I have a form containing a listbox. When a user selects some rows in the listbox and then hits a commandbutton, he should be taken to a new form, which has its recordsource turned into the records that correspond with the selection from the listbox. Here's the...

Hi all, I found some code from MS on this page that helps skipping used labels in an access report, and printing multiple copies of the labels on one page. The code works fine as long, as all the copies of the together with the white space do not take up more than one page in the report. When...

Hi All, I have a contacts database, and want to create a report to display the results from a custom query. The field "Gender" contains either one of the values "Male", "Female" or "Unknown". Since the report is use as layout for letters, I would like to use the Gender field to create a...

Hi All, I hope this is a simple question: I have a piece of code that updates a query throught the DoCmd RunSQL command: strSQL = "" For inti = 0 To 2 Set Q = db.QueryDefs("qrySelectionLabelsUpdate") 'Update fields for which Gender equals strGender(inti) strSQL = "UPDATE...

Hi All, I'm trying to create an Update query through VBA. This is the code I currently use to set the sql of the query: Set db = CurrentDb() strSQL = "" Set Q = db.CreateQueryDef("qrySelectionLabelsUpdate") strSQL = "UPDATE qrySelection SET qrySelection.Gender = 'Sir' WHERE...

Hi there, I want to create a query in which the field [gender] is evaluated (it can have three values: "Male", "Female" or "Male/Female"). I want the query to show "Sir" if the value is "Male", "Madam" if the value is "Female" and "Sir/Madam" if the value is "Male/Female". I have been trying...

Hi all, I am trying to create a selection tool in my contacts database. I have a form in which I can fill a listbox (lstZoekResultaat) with the results from a custom search that's based on text entered in some textboxes/comboboxes. This all works as it should! Now I want to be able to create...