Error Number: 3010

[amcnee]

Im not an expert on creating Macros but does anyone no why this wont run and extract the information anymore?

Private Sub cmdExecuteProgram_Click()

Select Case [frmSelectOptions]
    Case 1
  DoCmd.RunMacro "mcrImportData"
    Case 2
  DoCmd.RunMacro "mcrCleanData"
    Case 3
  DoCmd.OpenTable "tblData"
    Case 4
  DoCmd.RunMacro "mcrExtHospital"
    Case 5
  DoCmd.RunMacro "mcrCalculate&PrintReport"
    Case 6
  DoCmd.RunMacro "mcrDeleteAll"
    Case 7
  DoCmd.RunMacro "mcrExeptions"
  
    
 End Select
 
End Sub

Macro Name: mcrCalculate&Pr intReport
Action Name: OpenQuery
Argument = qtyCreatePrinti ngTable, Datasheet, Edit

[Rabbit]

If you google the error number, it says that the error is "Table already exists". That means the macro is trying to create a table, but it already exists so it can't create something with the same name.

[NeoPa]

Please post the error description when asking for help on an error. Being the most important piece of information relative to your problem it's very hard to understand why you posted your question without it.