Search results

No problem

Something along the lines of:- If (Time() >= #6:26:00 AM# And Time() <= #6:29:00 AM#) Then MsgBox "System Maintenance On-going. Please check back after 3 minutes.", vbOKOnly DoCmd.Quit acQuitSaveAll ElseIf (Time() >= #7:26:00 AM# And Time() <= #7:29:00 AM#) Then MsgBox "System Maintenance...

Try Me.LetterPrinted = -1

No, the query you use as the source for the email will be filtered by due date, i.e. Due Date = Date() If you want absolutely no involvement then you need to run this code through an AutoExec macro and use a scheduling program to open the Database every morning

See my post (#10) in this thread:- http://www.access-programmers.co.uk/...411#post923411 To install CDO, go to Start>Settings>Control Panel>Add or Remove programs. With "Change or Remove Programs" selected, scroll down the list of currently installed programs, highlight Microsoft Office and...

Ok, and for ther second part of my question - what doesn't work?

Which event have you placed the code in and what doesn't work?

No problem. Feel free to ask any more questions

See my sample attached. When the timer reaches 00:00:00, a message box appears stating that the blinds will be raised. The timer then resets (simply by closing and re-opening the form). When you press the 'Reset Timer' button, you are asked to confirm that you wish to reset. If you select Yes...

Well as long as you're willing to learn I'm sure you'll pick it up in no time!

You should change it because you are currently only checking for a null value and not an empty string, i.e. a user could start typing an explanation and then delete it and then it is no longer a null value in which case your concatenated field will be set to equal the same value

Or even smarter would be:- If Len(Nz(Me.Explanation,"")) = 0 Then Me.Concatenated = "" Else Me.Concatenated = Me.Explanation End If

Without seeing your Database it is difficult to suggest what you should do, I can only say that the current solution is not a good idea!

Glad you got it sorted!

If the above statement is true then you really want to have a rethink on your design. An Access form has a lifetime limit of 754 controls and this includes controls you delete. If you are creating buttons dynamically as your statement suggests, then deleting them, creating them again etc then...

Try If Me.Explanation.Value = "VOID" Then Me.Concatenated.Value = Format(Me.chknum, "00000000") & " " & Me.Explanation End If

Why are you using the visible property? Do you not need to save records where text17's value is less than 37? I was under the impression that you always wanted to be able to save the record using the save button, but that the save button should also run a macro (which runs your append query)...

No problem. Its really simple too which is always a bonus!!!

If you have to output to Word then can I suggest you look into using bookmarks - this was the easiest way for me.

If I am understanding what you are saying correctly then you do not want to play with the visible or enabled properties of the command button as the command saves the record as well as running the macro. Instead you need to amend the code where the macro is run using an if statement to ensure...