Question: I need Standard Coding examples of MS Access? 

Answer: SELECT tblMain.[DVD Title], tblMain.Genre, tblMain.[Actual DVD], tblMain.[Backup DVD]\nFROM tblMain\nWHERE (((tblMain.Genre)="Drama"))\nORDER BY tblMain.[DVD Title];\n\n-This is SQL coding for a query I have created for a database project.\n\nHere's an example of VBA:\n\nPrivate Sub cmdOpenAnime_Click()\nOn Error GoTo Err_cmdOpenAnime_Click\n\n    Dim stDocName As String\n    Dim stLinkCriteria As String\n\n    stDocName = "frmAnime"\n    DoCmd.OpenForm stDocName, , , stLinkCriteria\n\nExit_cmdOpenAnime_Click:\n    Exit Sub\n\nErr_cmdOpenAnime_Click:\n    MsgBox Err.Description\n    Resume Exit_cmdOpenAnime_Click\n    \nEnd Sub\n\n-This is a VBA example of coding to link a command button to a new form in Access.
This question from the Yahoo Q&A forum is categorized in the topic: Politics & Government