Search results

I need to format English dates into French i.e. long date in English would be "January 8, 2016" and in French it would be Le 8 janvier 2016. THANK YOU ------------------------------------------------------------------------- (see solution on last thread)

Great idea! Will need to play with it. Thank you so much. Another question - unrelated - if you wish I will post another thread... (not sure I got that wording right, lol) I am trying to make a query return 1 record - there one that has the closest date entered to today's date. My date...

Thank you for answering! Sorry about the ambiguity. The correspondence consist of reports. They are part of a database that I am currently building. These reports will be printed and mailed, again and again, with some content variation. For example, the Rent Increase Report. A form is...

Hi! Hope someone can assist :) I have several reports which are sent to members residing at a specified Unit in a Coop. I would like to track - automatically vs manually (going into each record), which reports (letters...) have been sent (mailed) to unit 1, unit 2, unit 3... with the date...

Thank you Gina - you are a gem! Can you - again - refresh my memory and tell me how to insert this link in the record source? How is it written? Does it go in the query or in the report's properties?

Hi, I would like to update this coding so that the Outlook email window opens directly, with the document attached, and allows me to write a message and click Send... I also do not need to preview or view this document before it is included in the email. --- Please note that the following...

Works for me as well - TY:)

Will follow your advice! Thank you!

Ok, made it work this way - thanks to you - had no idea how to code... May not be the best way but it works. DayNo: DatePart("d",[BirthDate]) with Criteria set to: DatePart("d",Now()) MonthNo: DatePart("m",[BirthDate]) with Criteria set to: DatePart("m",Now()) What do you think?

It is returning Data Type Mismatch in criteria expression. Awww it is so close... do I need to define the day and month?

Thank you Paul but if I knew how to do that, I would have done it. Can anyone just provide the missing coding where the question marks are located? THANK YOU - much appreciated.

Hi all, I have a query - here is the coding: SELECT Patients.BirthDate, [FirstName] & " " & [LastName] AS FullName, Patients.Email FROM Patients WHERE (((Patients.BirthDate)=?????need coding here?????) AND ((Patients.Email) Is Not Null) AND ((Patients.Deactivate_Ind)="N")); I would like...

Hi again Bob, I found a solution - way more than what I had asked - but really terrific! I am amazed I got it to work! http://allenbrowne.com/ser-24.html Thank you!!

I don't know how to insert a "breaking point" but I have check and double checked - the code is in the right field, in the AfterUpdate event in the Properties. Sorry it took so long to reply but looked up how to put a breaking point... tried a few things but nothing worked.

Same, tried that also, nothing. No error but no text "copied" either. Weird, no?

It does not return an error but does not work. Simply does nothing - left the record, came back... nothing in that field. Others are there, filled out manually. Mmm??!

Nothing. This is what I have: Is there not a command for Ctrl apostrophe - where I could put in double click let's say...

Ok no errors but does nothing... even after I get out of the record, cursor back to my main form and note Ctrl ' does work... just tested in case

Mmm... I put this coding - as is - in the on click event of the field. Even with a previous record entered and saved, it is returning: Run-time error 13 - type mismatch. Just a text field.

I will try it and see what it does when there is no previous record entered. But sounds great to me! Thank you (again!)