Recent content by borolee13

Does anyone know if it is possible to create a calendar, with term dates inserted by myself, that others could then use when planning courses ???

Thanks Pat. Where else would you suggest that i put the code???

Thanks for that All working ok now

Thanks for that. I have now found another problem. If all of the fields have been completed, then I want to send an email too the user. If not, i don't, until all the fields have been completed. Thnis is the end of my code, and it sends an email even when all the fields ar not complete. I'm...

Does anyone understand why I am having this problem????

Chris, Have compacted your database??? I think this resets the autonumber

Thanks for the help i received. I have now changed my code as suggested, but when i click on the Save Input button, I now get 'Run Time Error 13 - Type Mismatch' When i debug, it goes to the following line of the code: ElseIf ((IsNull(Me.Address1) Or Me.Address1 = "")) Then MsgBox "You...

So it is ok to have this on a Save button on the form???

I have a database on a network which is shared by other users. These users are supposed to use this database monthly to montitor there budgets. I want to be able to create an audit trail on each time they open the database. I am using the OSUserName function to get there netwotk login id. Can...

I am trying to validate fields in a form, before an email is sent saying the form is OK. this is my code : Private Sub Save_Click() If Me.Team = "" Then MsgBox "You must enter your Team name", "Data Validation" Me.Team.SetFocus ElseIf Me.Customer = "" Then...