i tink i explain from the start...
the main form is to display a person information which includes his car number,then the subform is to display the number of traffic offences he has commits..
some of them has more than 1 offences.now i wan to open a form that is link with the record i...
i tried that but cant get it to work...i explain again,the subform is showing a list of records,now i wan to add details to a specific record in the subform,i wan to open the form with the criteria of the choosen record...can it be done?
any question bout the codes..pls feel free to ask..i will reply asap..
***********************************************************
Option Compare Database
Private m_objWord As Word.Application
Private m_objDoc As Word.Document
Public Sub CreateWord()
Dim m_strDIR As String
m_strDIR =...
"class does not support automation or does not support expected interface"...what is tis error?...
tis is my code
Public Sub sentMail()
Dim objOutlook As New Outlook.Application
Dim objMessage As MailItem
Set objOutlook = CreateObject("Outlook.Application")
Set objMessage =...
Public Function CreateWord(strDocuPath As String)
'function returns nothing, but I created this as a
'function so all those macro users out there could
'use it also. :P
'if no path is passed to function, exit - no further
'need to do anything
If IsNull(strDocuPath) Or...
i wan to open a report from my form...when i click the button to open the report...it gave me a error "Data type mismatch in criteria expression"...whats wrong?...can someone help?...
my code
Private Sub Command12_Click()
On Error GoTo Err_Command12_Click
DoCmd.OpenReport...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.