Recent content by ajentp

Hi to All, First, I will thank all of you who has contributed this forum as I learned a lot by just going through different posts. Now I have a question, and I am really counting on you guys. I am trying to make a report format for the database attached. The database is a financial tool to...

Re: Search function I checked your video, You work is awesome. I have the question if the same trick can work where main form has two sub forms. Also if instead of using combo box, can we use text box where user type in the some thing and it can populate the form for that records such as if...

I am trying to find out if there is a way to add search function into the Form where user will type one filed and background code can populate all the fields. The search field' source will be "productcode". My best guess is that I will add a button "search". When user presses, it will hide all...

Thank you for reply. I found out that due to relationship constraints, the data was not being updated. I change the structure and add two Combo boxes. Now it is working fine and I can update the data. Sorry for not being clear about my question. Thank you

My database is not letting me to add new records through Form/2 sub form interface. I am using several tables with 1 to many relationships. Any help is much much appreciated. File is attached. Big Thank You.

Thank you very much. I finally found what you meant.

Believe it or not. I can not see LinkMasterFields and LinkChildFields in the subform if it is already bonded. However If I add an undonded subform I can see them as long as it does not get bonded. Is there anything I am missing? I am using Version 2000.

Hello Lagbolt, That was awesome. However for some reasons I could not view LinkMasterFields and LinkChildFields in the subform properties/under tab. All I see here under Data tab: Record source, filter, Order by, Allow filters, allow edit..... etc. Any help please? Thank You.

It is a very beginner question about SUb form. I am trying to make a sub form to show records of merchandise on the main form and their available color in the sub form. I am able to create the form but not able to connect each item with correct color. The main form (FormFromQuery) and sub form...

Hi CEH, Thank you. It is working now. My code is: =" 1 " & Format(CDbl([Price1]),"Fixed") & " 2 " & Format(CDbl([Price2]),"Fixed") It will give output like: 1 69.10 2 65.34

Hi CEH, Thank you for the tip. It is working now. My code is =" 1 " & Format(CDbl([Price1]),"Fixed") & " 2 " & Format(CDbl([Price2]),"Fixed")

I have similar problem . Is this correct code Like Format(CDbl.....), "Fixed). It is not working for me. Any help please