Search results

Hi Guys Thank for the Tips. Controls is the key .. i finally make it work.. Private Sub SubmittalSearchBtn_Click() If Len(Me.SubmittalSearchBx) = 0 Or IsNull(Me.SubmittalSearchBx) = True Then MsgBox "Please Input and Search submittal number First" Else Dim...

Hi Guys, Actually my problem is Drawing Register Form and Submittal Form are link to one table which is Submittal table. and the DocumentType Field Contains not only DWG SDW Code But More like CAL, MES, ITP.. Etc, in short it is mixed with other documents & Drawings. so i created an open...

Hi Guys, Good Day! you guys don't mind if i ask more silly questions right. :giggle: .. i'm try to pass this argument .. my code can't validate, if it is a drawing or not, its just saying all is not a drawing .. some thing like proceed the filter if it contains Document type drawings...

Email Code Works also Private Sub SendEmailBtn_Click() Dim sTo As String Dim sCC As String Dim sBCC As String Dim sSub As String Dim sBody As String Dim strCC As String Dim OutApp As Object Dim OutMail As Object Dim varPress As Variant strMess = "You are about to send an email message to...

I just want to thank you guys again.. it really work.. see attach screen shoot.. Private Sub AttachedSubject_Click() Dim StrFrmName As String StrFrmName = "SubmittalEditRecord" With Forms(StrFrmName) Me.MsgSubject = "Contractor Ref: " & .SubmittalRefNo & " Client...

yeah .. it really did now its working .. earlier i was doing filtering approach to match the record in another form ..ges its totally wrong. thanks again Mr. VBA

wow ! thanks a lot..

wow! you guys are great, i relay appreciate the help.. :D

This is my what i have on my email form Private Sub SendEmailBtn_Click() Dim mess_body As String Dim add As String Dim appOutLook As Object Dim MailOutLook As Object Const olMailItem As Long = 0 Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook =...

Hi Mr. Gizmo, Actually what i'm trying to achieve is like this. kindly refer to attached file and screen shot. i want copy data from one form to another , so i can send it through email. but i think my approach is wrong not filter i guess. as you can see on a the screen shot. copy the current...

Hi, Mr. Gizmo, yes, they are referring to a different form forms SubmittalEmailOut and SubmittalEditRecord. basically i just wanted to put a button on SubmittalEditRecord form and filter SubmittalEmailOut form. anyway thanks for your reply. nice to meet you Mr. Gizmo.

Hi, i'm kind of new to this forums. i am trying to figure this code. how can i reference unbound txtbox from one form to another. maybe you can help me out. Private Sub EmailDistOut_Click() DoCmd.OpenForm "SubmittalEmailOUT" Dim stfilter As String stfilter = stfilter &...

Hi Mr. Gizmo actually my dad is a big fan of that movie and he named me after that crocodile, i mean i don't know whats with that crocodile that he like. i'm from UAE.

Hi Guys. Good Day! :giggle: