Recent content by replyrpatil

Private Sub TradeMark_AfterUpdate() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim StrProductNum As String Dim StrTrademark As String If (Forms![FrmMAINform]![cmbProductCode] & "" = "") Then Exit Sub Set dbs = CurrentDb() StrProductNum = Forms![FrmMAINform]![cmbProductCode] Set rst...

I have tblProductName ( ProductNumber and TradeMark ) Sample ProductNumber TradeMark 123 T1 123 T2 234 T4 234...

This VerifyIMGChange in a sub module in report . On format I call it like Call VerifyIMGChange ( PRODIMAGE , PRODIMAGE , PRODIMAGE) because the InProcess and Active sub forms are driven from queries based on same table it will have the same control name

I did this ( see bellow) but it gives me Compile Error : ByRef argument type mismatch ----------------------------------------------------- Sub VerifyIMGChange(FldA As Control, FldIP As Control, FldC As Control) Dim ImFldA As Control Dim ImcFldA As Control Dim exFldA As Control Dim...

Dear PHV can you please help me convert this in module I need to compare two image reports side by side and if there is a change I need to indicate if there is change or no change. Main report has two sub report (rptPIactiveImages and rptPIInProcessImages ) rptPIactiveImages has...

I need to compare two image reports side by side and if there is a change I need to indicate if there is change or no change. Main report has two sub report (rptPIactiveImages and rptPIInProcessImages ) rptPIactiveImages has following filed name (All the four have height set to zero.) 1)...

I need to compare two image reports side by side and if there is a change I need to indicate if there is change or no change. Main report has two sub report (rptPIactiveImages and rptPIInProcessImages ) rptPIactiveImages has following filed name (All the four have height set to zero.) 1)...

What I am trying to do: I need to print a compact access report (font 6 size) created using RTF2 program developed by Stephen Lebans to generate a TIF image of custom size (5.5 in x 2.0 in) Problem Recreation : Download attached RAR file (http://download.yousendit.com/627919383AFAA7E3 )...

What I am trying to do: I need to print a compact access report (font 6 size) created using RTF2 program developed by Stephen Lebans to generate a TIF image of custom size (5.5 in x 2.0 in) Problem Recreation : Download attached RAR file (http://download.yousendit.com/627919383AFAA7E3 )...

What I am trying to do: I need to print a compact access report (font 6 size) created using RTF2 program developed by Stephen Lebans to generate a TIF image of custom size (5.5 in x 2.0 in) Problem Recreation : Download attached RAR file (http://download.yousendit.com/627919383AFAA7E3 )...

What I am trying to do: I need to print a compact access report (font 6 size) created using RTF2 program developed by Stephen Lebans to generate a TIF image of custom size (5.5 in x 2.0 in) Problem Recreation : Download attached RAR file (http://download.yousendit.com/627919383AFAA7E3 )...

Thank you PHV your code worked perfectly ........... I had a typo in my filed name when calling the function that is wny i was getting “ Compile Error : ByRef argument type mismatch) Thank you once again Thanks

PHV, I am using this in event afterupdate , when i tried your code it gives me error “ Compile Error : ByRef argument type mismatch) I have copied the code in module , made it as public function. then in field f1 after update called it like Private Sub f1_AfterUpdate() Call ImgCheck (f1)...

I have 35 fields and 35 images associated to these fields ( Example filed name is f1 then the Image/Picture filed associated to it is named as IMGAUGE ) Let us say if other filed names are f2 , f3 ………..f35 I don’t want to copy paste the same code 35 times ( i.e. for f2 I will select the code...

What my user wants to do is select certain portion of the filed and make it BOLD. I have a form for this data entry ( The filed name is ProductDescription ) but MS access wont allow me to bold partial section. My user does not have certain rule which portion of the filed they want to Bold...