Search results for query: *

Op Sys: Windows 2000 Aceess: 2000 MS Office: 2002 I want to import a Excel file in Access as a table. I get the error: Error in loading DLL. Access does not specify which DLL. I have uninstalled and re-installed Access 2000, but still the same error. I have upgraded Access to 2002, but still...

I am using Acces 2000 on Windows 2000. In the FORM view, I want to click a button, the click of button should do the following: 1. Add the record in the table 2. Move to the next record 3. In the list of drop down combo boxes, make all the previous records available. At present, 1. it adds the...

Hi, I have five columns in a work sheet. one column has telephone number, another has name of the person, the other 3 coluns have different information. I want to write a macro, so that it asks for the phone number in a pop-up box, looks for that number in the whole excel file, and if it finds...

How can one install the Berkeley DB on a Win 2K PC? Do I need C libraries on my PC? I can not run the make commands on a Win 2K PC. Thanks, Indiana

I am running Apache 2.0.50 Web server on a MS Win 2K PC. I also installed Active Perl 5.8.x I want to use a script in Perl to work as a Search Page. It requires that I have a DB_File module on my PC. I downloaded the DB_File module but so far I am unsuccessful to install it. Then it also seems...

I am running ActivePerl 5.8.4.810 on a Win 2K PC. I do not have DB_File module installed. I downloaded it from http://simplythebest.net/scripts/perl_scripts/perl.html for Windows. When I ran it : pppm install DB_File.ppd I got the following errror: Error: no suitable installation target found...

I am running Apache web server on a Windows 2K PC. I also have Active Perl 5 installed. I want to create a search engine, such that, it should query on the key words entered by me, and look for the documents that have the key words in the document title. Do I need to write a script? If yes, is...

I am using MS Access 2000. On a form, I want to place a button, when clicked, it should: 1. add the record to the table 2. Take the focus to the first field in the table (this is not the tab order) 3. the values in the fields do not get cleared once the record is added and the focus is sent to...

I am running Apache web server on a Windows 2K PC. I also have Active Perl 5 installed. I want to create a search engine, such that, it should query on the key words entered by me, and look for the documents that have the key words in the document title. Do I need to write a script? If yes, is...

I am running Apache web server on a Windows 2K PC. I also have Active Perl 5 installed. I want to create a search engine, such that, it should query on the key words entered by me, and look for the documents that have the key words in the document title. Do I need to write a script? If yes, is...

I have created a FORM in Access 2000. The FORM is built using ONLY one table. I have 3 fields defined as combo boxes. What I Want: I enter the data in the fields(combo box) and if I go back, I do not have to retype the data, if I click on the drop down, I should be able to see the data or if I...

Hi, I am using MS Access 2000. I have created a form from only ONE table. The form contains one drop down field, which can have only two values; A or B. This drop down is also from the same table. If I select A, I can enter data in fields G, H, and I. If I select B, I can enter data in fields C...

Hi, I am using Access 2000 on a Win 2K OS. I have created a form from only ONE table. The form contains one drop down field, which can have only two values; A or B. This drop down is also from the same table. If I select A, the form should grey out fields C, D, and E, and I should be able to...

I have database, queries, tables, and reports on server A. The webserver is on server B. I can load the webpages from server B. So far, in order to run the report, I go to server A, and click on the MS Access report I want to run. I want to place a link on the webpage, so that it runs the...

I understand the concept of group by and have used it successfully. However, the table at hand has a column for car names, e.g., Camry1, Camry2, chevy1, chevy2, maxima1, maxima2. I want to get a count of toyotas, nissans, and chevys, etc. I believe I need to use group by, but since chevy1 is not...

Hi Folks: I am writing a query in which I need to specify a date range, e.g. Start_Date (1/1/2004) and End_Date (1/11/2004). When I use the 'Between #1/1/2004# and #1/11/2004#' in the criteria field, I get the desired results. I want to make the Criteria so that when I run the query it asks...

Hi Folks: Table has a column which contains students country of birth, e.g. Germany, France, Sweden, China, Japan. I want to find out the number of students from a region of the world, e.g. Asia, Europe. I have written two queries to do this, one for the students from Asia and one for...

Hi Folks: I am writing a query in which I need to specify a date range, e.g. Start_Date (1/1/2004) and End_Date (1/11/2004). When I use the 'Between #1/1/2004# and #1/11/2004#' in the criteria field, I get the desired results. I want to make the Criteria so that when I run the query it asks...

Hi Folks: The table has rent_date column in the form of mm/dd/yyyy. Table date format can not be changed. I need to find the total number of cars rented in a month, grouped by day of the week. I am trying to write a query, so that, the query should not return more than 7 rows - one row for each...

Hi Folks: The table has rent_date column in the form of mm/dd/yyyy. Table date format can not be changed. I need to find the total number of cars rented in a month, grouped by day of the week. I am trying to write a query, so that, the query should not return more than 7 rows - one row for each...