Search results for query: *

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...

Does any one know how to eliminate white space on form ? Duane : I can't think of any other way to organize this table

I have one main form were user have an option to select a criteria from the drop down. The criteria table contains the CriteriaType as one column/filed and other 130 fields (say filed F1 through F 130 that are Yes/No check box) CriteriaType F1 F2 F3 F4 F5 F6 F7...

I have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout Even when I set the property of the Datasheet “Allow Design Changes: Design View Only” users are able to unhide the hidden columns and they can also change the size of the...

I have main form and that has one sub-form , this Main form governs/determines the data in the sub form. This Sub form ( DataSheet Mode) has approximately 130 columns and based on the Main form criteria only ~ 20 columns has to be filled. What I want to do is based on the main forms criteria I...

Sorry I am new to Access so do not know what is 4th argument of the DoCmd.OpenForm method. Can you please let me know Thanks