Search results

Could anyone help me sort this out. My database inputs records into a template document in word. I have the template set up with bookmarks, but as soon as there is a blank record, the whole process stops. This is what I have been using Private Sub MergeButton_Click() 'Start...

Hi I need a way of showing decimal time in minutes and seconds. i.e I need 14.75 to be 14hours and 45minutes. Is this possible? Thanks

I have a form which sends an email when closed using a button with a SendObject macro on it. I was hoping to put a hyperlink in the message text, but I don't seem to be able to make it be a hyperlink and not simply appear as the file path in text. I have looked at other posts and used things...

Turns out I was being daft, thanks everyone that looked at my post, sorry to have wasted your time!

Thank you so much for replying. I have worked around the problem by removing all the "required" fields from the table (and then writing some code to force the user to enter data in the relevant box), disabling the X and then making my own close button which runs a macro which closes the form...

I want to close a form and I am using Private Sub Form_Close() Application.Quit End Sub as the form opens with the access application window hidden, and I found that the .ldb file didn't close if I simply used the X. I have a series of fields with validation rules which activate on exit...

I thought that the validation rule would force the field to be required even if it was not set that way in the table, am I being daft?

I have set up a validation rule "Is Not Null" in the properties field of my form. I have added validation text that I thought would appear when this rule was not met. The field in the table is set to required "No" I have a macro which OnClick closes the form and sends an email and when I...