Search results
-
R
Using Month() in If Then Statement
Thank you! That was definitely part of the problem - my field name is not [Time.Date] it's actually [Time_Date] :o With that piece solved, can you point me in a better direction towards getting this to work if not by referring directly to a field in a table? I'm trying to notify the user that...- rachelkm2
- Post #5
- Forum: Modules & VBA
-
R
Using Month() in If Then Statement
Thanks for your quick response! I tried that, but then I get: The expression On Click you entered as the event property setting produced the following error: Block If without End If I think the issue is with using the Month() function. I had similar syntax issues elsewhere, but finally got...- rachelkm2
- Post #3
- Forum: Modules & VBA
-
R
Using Month() in If Then Statement
I'm trying to create an If Then Statement using criteria based on a calculated Month field. My code currently looks like: If [tbl_ImportedMonths].[ImportMonth] = Month([tbl_Time].[Time.Date]) Then MsgBox "The month you have chosen already exists. Continue?", vbYesNo, MonthAlreadyImported End...- rachelkm2
- Thread
- Replies: 15
- Forum: Modules & VBA
-
R
mail merge help
I have a mail merge function in Access 2007 which is supposed to merge the records (multiple) from a query (in which the user selects different criteria) into a letter in Word. The merge works - except that it only merges the first record. I want to be able to merge all the results of the...