Code:
Private Sub cmdPrint_Click()
Dim appexcel As Object
Dim MyFile As String
Set appexcel = CreateObject("Excel.Application")
MyFile = Me.PR_Number
DoCmd.PrintOut acSelection
Private Sub cmdPrint_Click()
Dim appexcel As Object
Dim MyFile As String
Set appexcel = CreateObject("Excel.Application")
MyFile = Me.PR_Number
DoCmd.PrintOut acSelection
Private Sub cmdPrint_Click()
Private Sub cmdSave_Click() Dim strSQL As String Dim Fixt As Variant, Op As Variant Dim Prt As String Fixt = Me.FixtureNumber Prt = Me.ChoosenParts_subform!Part Op = Me.ChoosenParts_subform!Operation
Private Sub cmdLog_Click()
Dim
# strSQL = Replace(strSQL, "%S", .cboPersonnel1) # strSQL = Replace(strSQL, "%T", .txtNote1)
Private Sub Drawing_Click() DoCmd.OpenForm "Drawing", acNormal, , , acFormEdit, acWindowNormal, Me![PartNo] End Sub
Leave a comment: