Search results

I am trying this the following but getting a bit stuck: DocDateVal: =IIF([DocumentDate] Is Not Null, DateValue(Left([DocumentDate]),10), 0)

thanks Bob :-) - I worked out that I needed an expression name: So I've got this DocDateVal: DateValue(Left([DocumentDate],10)) Now I'm going to hunt down a solution for where there are NULL values

I have the following date/time string 2006-03-08-00.00.00.000000 I need to convert it into 08/03/2006 Any advice most appriciated

Modified Code Private Sub cmdSaveWorkflow_Click() On Error GoTo err_handler If IsNull(Me.txtTaskDueDate) Then MsgBox "When does this task need to be completed by?", vbCritical, "Form Completion" Me.txtTaskDueDate.SetFocus Exit Sub Else End If If IsNull(Me.txtTaskWorker) Then MsgBox "Who this...

I solved the issue by putting the email notification code into a separate module and then calling it within my existing code.

Create a 'Import Specification' Select the table in your database, right click and choose import, and create the import specificaiton from there. Then you can simply refer to the import specification in your code

Are they two unrelated database's (what version of Access?) or are you using linked front End / Back End? If you use a split database then it could be more straightforward

I've tested the command without the email notification code and the issue doesnt arise. Although the mail notification code works perfectly?

The code executes properly, the history record is created, its just hte date picker field which is the issue.

Hi Rural, I'm using error handline code which is supposed to catch any unhandled errors - but none are highlighted. Here's the code behind the command. As a note re my email code, errors to do with missing information or inability to contact the server are handled. Private Sub...

Hi, I'm using Access 2007 and on a Form I have two date fields, txtTaskStartDate & txtTaskEndDate. The code behind my form runs a few sql strings to enter data into tables, refresh some listboxes and then some code which sends an emil notification of a task created. However, I've noticed...

I need, in a query, to be able to remove the "C:\TestDataToImport" part of the string. Any advice/clues reved most greatfully C:\TestDataToImport\AB3491\Payroll\2008\080411__P35 - Employer ANnual Return April 07 to April 08.tif Thanks

This code works fine, can/how could it be modified to also look into and includes files in sub-directories?

It sure does! But it looks as though (I havent fully tested) but it looks as though one has to create the export spec against the query (in access 2010). Now I will have develop from scratch to fully understand the process but this looks very good. you are right about other users potentially...

you are quite right in that yes it is a comma delimited file but what I get is: 1323,"141102tsDCIR.doc","C:\Test Top Level\TestDataToImport\AB2222\preSingleview\","C:","Test Top Level","TestDataToImport","AB2222","preSingleview",,,"C:\Test Top...

My app basically looks at a windows folder, containing directories and files, it then creates a list of all files into TblFiles with fields FileID (AutoNumber), FName, FPath I then use a qury/module to create a query which essentiall gives me a table but with the file path split into values...

Thanks, I did get it working and then it stopped working! Now have got it working again and it works as expected by the code. Thanks soo much for your kind assistance. I will have to figure it out and understand it better but this is a great start.

Hi, and thanks for the code sample which I've tweeked and almost works. The only issue at the moment is that Access says that it cant find "Test1.csv" - I know the file is there as I created it after it said it couldnt find it the first time. Its a runtime error 3011 "Access couldnt find the...

I'm creating a utility which looks at a windows folder structure and contained documents which will be used to import the documents into a document management system using a csv file to pick up references and the respective location of each document. All of that I can successfully do. What...

Thanks for the assistance given and advice from previous thread which worked a treat! I've attached a copy in case it could be of use to others. Howerver, it is an Access 2010 Db.