Search results for query: *

I've run into a problem where I have two requirements for a *.csv file created from an access table. First, I need it to be comma delimited, without quotes around text fields, and secondly it needs to be a fixed width. With the TransferText method it seems I can do one or the other using the...

I would like to use a pass through query to pull information from an SQL 2000 database on a remote server and populate an Access 2k table with the data. For example, I have one big table in the SQL database which contains Customer contact information, and some Request for Quote information. I...

I have a variable getYear in which I would like to store the year as 04 from a string 09/17/04. How would i do this? Can it be done without using the "RIGHT" or "FORMAT" methods? I keep getting errors with computers that do not have xp installed when I use the "RIGHT" or "FORMAT" methods. I...

I have some users on Access 2k who are using an application dependent upon VB scripting. One script calls out getDate = Format(Now(), "yy"). evertime the script is executed the program stops on this line and retuns the message "Can't Find Project or Library" is there a work around to this...

I am having an issue where I am trying to send out an email with information from a form. However, the main form has a subform with important data I also want included in the email. When I use the code the below I get error messages regarding object property can't be found or improper usage...

I have a form that I want to use for data entry. In order to speed up the process I want the form to pull information from an existing table named MRF after the user enters a work order number. The relationship between the form the MRF table is wir_no=work_ord. I thought I could load a blank...

I need help with a loop. I have a workbook with 13 worksheets. I want to paste the same information into the same range on each worksheet. In order to keep the workbook flexible should I add more worksheets in the future I just wanted to use a For each loop. However, with my code I keep...

I have an Exel Worksheet that generates charts based upon data retrieved from an MS Access Database a server. I want to count the total number of records in a Query called ArrowElec. Then I want to count the number of records in the same Query where the field MDR is not null using the SQL...