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...
the value is created in a subform countin the number of records..then show in main form...at the subform footer i put a textfield which count the records wif count(*)..then i show it in the textfield in main form...how can i do it...i try to count it in the subform but its still the same n it...
i got a problem onli when the value is equal to 3 then the msgbox will appear,value greater than 3 does not make the msgbox appear...wat is wrong wif my code?...
If Me![Text21] >= 3 Then
MsgBox "xxx"
End If
hi Bob
the value in the textbox is auto calulated thru number of records in the subform..
i tried after update and on dirty but could not work..
actually wat i wan is..if textbox value is equal or greater than 3 then i wan to popup a reminder..is there a better way to do it?..
Jo
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.