Recent content by amrizvi

It feel quite simple with regard to codes (may be a little complex for understanding logic behind it)! anyhow solution is DoCmd.TransferDatabase DoCmd.DeleteObject following are the code example, just fill the variables and add more codes as required 1. Assuming you dont want to...

as I understood, after update event is more approperiate suggested by pbaldy as you dont have to inturrpt the even if occure, you just want a message to display when event occured and before update is useful only when there is chance to inturrpt the event after checking. Private Sub...

What is Microsoft Jet-connected ODBC data source? Actually I am using MS Access Database and working with VBA and want to use object.EXECUTE dbSeeChange which is only available with Microsoft Jet workspaces and also want to work with External MS Access Database defined in ODBC (Data Source). As...

Set has field TRUE DoCmd.TransferSpreadsheet , 8, "RCO Data", strPath, TRUE , "RCO Survey!" & strRange There will be an error if in next import, worksheet has some additional columns therefore, before each import delete the RCO Data DoCmd.DeleteObject acTable, "RCO Data"...

Try this way If (Me!EventDelegateListFinalised = -1) And (Me!ScheduledNumber < Me!CourseMInDel) Then MsgBox "There are less than the minimum amount of delegates scheduled on this event.Please check before finalising" Exit Sub Endif If...

I am trying to Add two records in {Dbase III DBF file connected through ODBC} by using batch update in order to handle the Collision in multiusers environment. BUT receiving following error “ODBC--call failed.” on line dbUpdateBatch Details errors are as below: DAO Error 12: Client Cursor: 12 -...