Recent content by Designer156

Ok, got it cracked... Private Sub Notes_DblClick(Cancel As Integer) Me.Notes = Me.Notes & vbCrLf & vbCrLf & Date & " - " End Sub Thanks!!

Actually, I've discovered how to add the carriage return: Private Sub Notes_DblClick(Cancel As Integer) Me.Notes = Me.Notes & vbCrLf & vbCrLf & Date End Sub Now I just want to add a space after the date

I'm building a Dbase to log some jobs that come into my team, jobs will be allocated to an individual and come from a set of pre-determined customer's. A job can consist of one or multiple tasks from a list of around 20. Once complete I will be seeking feedback scores on the job and the...

That does the job! Thanks! One more thing, how can I add a carriage return before the new date?

This is for a notes field about a customer. When I call them I want to just double click and add some notes baout the call in the same field as the rest

Hi, This is an old post of mine and it worked well, but now I need to improve it a bit... If I have a blank file dand I double click in it it inserts the current date, but if the field already has data, it overwrites the current data with the date. How can I modify the code to add the date to...

For anyone searching for the solution, the following criteria did it for me: Between #01/04/2007# And DateSerial(Year(Date()),Month(Date()),0) and for the number of months passed: =DateDiff('m',#01/04/2007#,Date())

Works a treat. Thanks!

What would be the correct syntax, given that the control name is 'Completed_Date' and the Form is called 'Opportunity' ?? All I have right now is: Private Sub Completed_Date_DblClick(Cancel As Integer) End Sub

Guys, I've done it before, but can't remember how..I want to automatically insert the current date into a control on a form by double clicking it. I understand i need to select event proceedure and then add some code that includes '=date()' but what else? Thanks

Thanks guys, I'll look into those.

I need to create an expression that will limit the results of my query. I only want to display all records where 'Completed' date falls within the following criteria: Between the 1st April and the end of last month. I do not want to include this month, because by definitiion it is not complete -...