G
Guest
Using Microsoft Access 2k3
Database is Access 2k format
Have tryed converting it to 2k3 but still same problem
I downloaded the Members database file 01018584.mdb from microsoft. I liked
the features of the database and started to expand on it to fit my criteria.
I created a new form and want to add a autofill of the current system date so
I used this code.
Private Sub SideBody_GotFocus()
Me![BreakDate] = Date
End Sub
When I click on the combo box I get the following
Run-time error '2465'
Microsoft can't find the field 'Date' refferred to in your expression
I don't understand why because the form-Member Payments, uses this code also
and it works fine. So I highlighted and clicked on Definition and received
this message.
Cannot jump to 'Date' because it is in the library 'C:\Documents and
Settings\Default\My Documents\01018584.mdb" which is not currently referenced
The library VBA is already referenced. The other form Member Payments, if
you do the same it opens the object browser to VBA,DateTime,Date. I can not
seem to find a way to fix this. The Time Function and Now Function work fine
but I wish to used the Date Function and why it is not working when it is
already referenced it beyond me. Any help would be useful. Thanx
Database is Access 2k format
Have tryed converting it to 2k3 but still same problem
I downloaded the Members database file 01018584.mdb from microsoft. I liked
the features of the database and started to expand on it to fit my criteria.
I created a new form and want to add a autofill of the current system date so
I used this code.
Private Sub SideBody_GotFocus()
Me![BreakDate] = Date
End Sub
When I click on the combo box I get the following
Run-time error '2465'
Microsoft can't find the field 'Date' refferred to in your expression
I don't understand why because the form-Member Payments, uses this code also
and it works fine. So I highlighted and clicked on Definition and received
this message.
Cannot jump to 'Date' because it is in the library 'C:\Documents and
Settings\Default\My Documents\01018584.mdb" which is not currently referenced
The library VBA is already referenced. The other form Member Payments, if
you do the same it opens the object browser to VBA,DateTime,Date. I can not
seem to find a way to fix this. The Time Function and Now Function work fine
but I wish to used the Date Function and why it is not working when it is
already referenced it beyond me. Any help would be useful. Thanx