Recent content by Massamiya

Thanks for the response. "PartName" is a textbox in the detail section of the report and if I am not wrong the TextBox control has a Forecolor property.

Please help me, I have hit a massive wall again. I am writing an estimation program and am having a run-time error 438 (Object does not support this property or Method）. On the estimation form is a command button whose on click event holds the command to open the Report DoCmd.OpenReport...

The On Activate event did the trick. Thanks very much. you and John have been a life saver. More grease to your elbows.

The On Got Focus event doesn't run after the form "frm_EstSpec" regains focus. I ran it in debug mode and the On Got Focus event never fired. I don't really know why. when I close the "frm_EstCost" form using the command DoCmd.Close and focus returns to the "frm_EstSpec" form there seem to be...

Yes, the value is committed to the variable in the routine of the "Save Command" button of the cost estimation form "frm_EstCost" like this PMachModel = Me!CMachModel PMachSize = Me!CMachSize PEstNo = Me!EstNo

Thanks John, I have tried the Form's On Got Focus event without any success. The Before Update displayed data after the "Save Command button" was pressed which is too late.

Hey guys, I am really a novice in VBA and would appreciate If you could help me with a problem I am having with regards To passing data between 2 unlinked forms in an Access 2003 databases I am writing an Estimation program and have 2 forms the General Spec Form named “frm_EstSpec” on which...

John, Thanks a million, It is working as advised, couldn't place in the on-click-event of the checkBox since the checkBox is dynamically checked and unchecked. But putting the code in the current event of the form did the trick. I was thinking of a easy way out by trying to use an IIF()...

I have a check Box, a comboBox and 2 option buttons (OptbtnA & OptbtnB) in an option group on the mainform and have created 2 select queries (qry_btnA and qry_btnB) based on 2 different tables (ProdMain & ProdAux). I want that when the checkbox is checked and the user selects an option button...

Thanks for the input. I succeeded with the delete and insert of a row on a continous form. However, I am facing a major problem with the deletion. I am able to delete a row or rows initially but when I navigate through the subform and attempt to delete another row or rows I am unable to delete...

Thanks again for the prompt suggestions. Sorry I have not been able to respond as well due to work assignment away from my base. I have yet to look into the suggestions raised and intend to do so when I get back home tonight. More grease to your elbows.

Thanks Linq & David for the prompt response. I am writing an estimation program , some parts have higher priority and the user may want the part to appear at the top or middle of a list that is initially displayed. This is what I am thinking and don't know whether it is the best possible...

Hello everyone, I have searched the internet without any success and would like to know whether it is possible to insert a new row anywhere beside the last row in a continous form ? If it is possible, would really appreciate if anyone would help me with code to achieve it. Thanks very much in...

Thanks everyone. Had the problem fixed. Just for others who might face the same problem, I had to replace the line DoCmd.RunSQL stq after the delete line to CurrentdB.Execute command Stq = "DELETE * FROM TBL_Estimate_Parts" CurrentDb.Execute Stq, dbFailOnError I will refrain as much as...

Marinus, Thanks for the prompt response. Konnichiwa (hope it is afternoon at your end) The main and the subform are unlinked and I did mention in my post, there are 3 option buttons denoting 3 product types, for the first two options "FANS" and "PARTS" the subform is populated with data. The...