Search results for query: *

Ref thread705-1703957 I am using code based on 1DMF's method in a database I wrote a number of years ago. This code has been working perfectly ever since for a client company transferring .csv order files created in an access database and then passed to their suppliers for fulfilment. The...

I have a small Access (Office 2007) application which uses Excel to display a "room chart" from data held in the Access tables. The Excel workbook and sheet are automatically opened and populated/updated as changes are made within the Access forms. When the Access form is closed the Excel sheet...

I have a database in Excel which consists of a couple of thousand rows or so which users need to sort, filter and manually amend regularly. I need to include a calculated value on each row based upon the results of a combined match,index,index formula as follows...

A very small part of my current app requires me to read an existing Access 97 table containing a single record and to display the contents of a field as soon as they are changed. I have no control over how or when the data is placed into the Access table (it is a call logging output)...

Hi I have a spreadsheet which open a csv file and converts it to another csv format (processing the rows as it goes). All worked if I opened the input csv file with the statement: Set wbIN = Workbooks.Open(Filename:="g:Trans.csv") except that the second column is sometimes misinterpreted as...

Hi Ref MS ACCESS 2003 (2000 compatible) I have a couple of forms which use subforms displayed as datasheets. When I add a control to the form such as a textbox it is generated with the default name TEXT22 etc. I set the control source of the textbox and change its name to something "user...

Hi, Hope somebody can help. I have an Access based app which creates mails into outlook 2003 for editing etc by the user. Has been running perfectly for some months and is loaded on a number of machines. Recently one m/c has started generating an error when trying to create the outlook...

I have a report containing a number of numeric columns. The report groups the data and produces subtotals on each change of group and a grand total at the end. I also need to print in the page footer a total of only those records printed on the page above but I cannot figure out how to do...