Hello,
I am a self learning access user and I have some very basic experience with vba with random tasks that have been assigned to me at work. This is the first time that I am trying to use arrays with Access and I am facing some challenges. I have a fundamental understanding of arrays from c/c++ courses, but I have never used them in Access. This is my basic code that I am using to play around with arrays:
My set up is that I have a form called "arraypractice" and in the On Open event I have placed that code. When I change from Design view to Form view, I get a "module not found" error.
I think my main problem is that I do not know the proper way to use "Debug.Print" and I am having trouble googling clear instructions on how to use it.
I eventually want to be able to sort an unknown number of dates and use that sorted array to figure out how many dates are repeating.
Thanks for any guidance!
I am a self learning access user and I have some very basic experience with vba with random tasks that have been assigned to me at work. This is the first time that I am trying to use arrays with Access and I am facing some challenges. I have a fundamental understanding of arrays from c/c++ courses, but I have never used them in Access. This is my basic code that I am using to play around with arrays:
Code:
Private Sub Form_Open(Cancel As Integer)
Dim Event_Date(2) As Date
Event_Date(0) = 3 - 1 - 2001
Event_Date(1) = 4 - 1 - 2002
Event_Date(2) = 5 - 2 - 1980
Debug.Print Event_Date(2)
End Sub
My set up is that I have a form called "arraypractice" and in the On Open event I have placed that code. When I change from Design view to Form view, I get a "module not found" error.
I think my main problem is that I do not know the proper way to use "Debug.Print" and I am having trouble googling clear instructions on how to use it.
I eventually want to be able to sort an unknown number of dates and use that sorted array to figure out how many dates are repeating.
Thanks for any guidance!
