Recent content by Daveswanton77

Ensure that references to as per attachment are selected

The script below imports multiple .txt files that have been put in an imports folder placed in the directory of the database. The data is imported into a temporary table and after that you can do whatever you need with the data. After import the files are moved to an archived folder. The...

You could always set the database to compact only when it reaches a defined size using the code below. Public sub subCompact() On Error goto Err_subCompact Dim fs, f, ProjectSize, filespec Dim strProjectPath As String, strProjectName As String strProjectPath =...

Use this code to import a file called Import.xls or whatever you want to call it by changing the Const value on the third row of code. The file is placed in the same directory as the database, it is then processed and placed into an Archived directory called Archived Imports in the database's...

Thanks very much I got it to work fine Regards Dave

Help... I have a table as shown below Week | Start | End | 1 |1/4/2004 |7/4/2004 | 2 |8/4/2004 |14/4/2004 | 3 |15/4/2004|21/4/2004| 4 |22/4/2004|28/4/2004| etc...... I need a Query / Function that would return the number for any given date i.e...

I am trying to format a field in a table which is created from a query. The field needs to be formatted as currency as an update query is used to enter monetary amounts from another table. At present when I run the update query the amounts change to whole numbers and not currency amounts. If I...