Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Sub SubEmptyPreviousWeeksData() Dim db As DAO.Database Dim QryDefinition As DAO.QueryDef Dim strSql As String On Error GoTo errorhandler strSql = "DELETE tmptblWeeklyInvoice.* FROM tmptblWeeklyInvoice;" Set db = OpenDatabase(CurrentProject.Path & "\MyComicShopTables.accdb") strSql.Execute db.Close Set db = Nothing QryDefinition.Close Set qrydefintion = Nothing Exit Sub errorhandler: MsgBox Err.Number & ":" & Err.Description End Sub
|Need help filtering dates in Access Query to return all records with date greater than or equal to the past two months.||3||12|
|John, do you have a function to change the pairs back to text?||3||21|
|Confirm a record has been added MS Access||4||19|
|Change format of subform||3||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
26 Experts available now in Live!