Search results

@Cronk I inherited the database from a predecessor and am now tasked with trying to cure its ills and expand its capabilities. Despite not being an access aficionado myself. I both understand and appreciate your position completely. Thank you for the assistance you have provided. I threw the...

@Cronk, thanks for your continued assistance. I'm afraid I'm hopelessly lost. I looked at the loop information you recommended. However, I'm not sure how to incorporate that into the code. Rather than try to explain my difficulties I've uploaded a simplified database which shows current state...

@Cronk, DBguy, Pat Hartman Thank you all for the assistance I appreciate it. Cronk, as far as whether I have multiple individual reports or 1 multipage report I can work with either. I do not believe it would be unreasonable for a supervisor to have to sift a multi-page report. However - Pat...

Sorry about that! Here it is. Private Sub btnEmail_Click() Dim oApp As New Outlook.Application Dim oEmail As Outlook.MailItem Dim fileName As String, todayDate As String 'Export report in same folder as db with date stamp todayDate = Format(Date, "MMDDYYYY") fileName =...

Hello, I have a pickle. I have all the pieces of what I want to accomplish. I just cannot determine how to put them together. My database tracks what courses an individual has completed. An individual's supervisor needs periodic updates on their personnel's completed (or incomplete) training...

Hello, I have a login form which is working well with the exception of login attempts. It should only allow a limited number, but currently this function is not working. I am new to vba and hoping I just missed something simple. Thanks in advance.