Search results

It is working now, thanks a lot. For the colors, yes I need to adjust it, I will search how to work on it. Can your confirm if the below part of the Modules is the CSS portion that I need to edit

hi Arnelgp, It resolves the query no.2 based on the test in a database2, thank you. I transferred the VBA code and the module that you made to our actual database but when I run it there is a "Compile error" Sub of Function not defined" at this level "Call OutputHTML("Email", sFile)" Attached...

hi Doc Man, Thank you for all the suggestions, appreciated

hi Doc Man, Thank you for the solution on the first query, it works as expected. About the second query, I heard about the option to attach the generated report in the email. but in this case the request is how to automatically add the report information as part of the body of the email...

Hi All, I would like to seek your assistance on the output that I wanted to generate. I made a simple database2 with Table, Query,Form, Report to show the required assistance I needed. In form there is a button (Send Email) with VBA code to generate an outlook email but due to lack of my...

Thanks arnelgp

hi arnelgp. Thank you very much for the design database. It might be different to what I am expecting but its close to my target result and I can use it. The report view is okay. I created a split form called "Mainform" (below screenshot) and a button New for new transaction. I just want to...

hi arnelgp, I'm creating report wizard to display the items Vendor, Date, ITem, Distribtuion and Notes but an error occur as those items are not all connected to each other, may I request you to edit the same file you did addition of Report with the mentioned items on it. Thanks

hi, I noticed you added new tables, Queries and Forms.. I'm trying to understand the set up, are all below files required or which one I can remove

Hi Gasman, Pat, arnelgp, Regarding Q2... After Filling up Item, Distribution and Note, new set of those field will appear and it should be on the same ID number. (not sure if this is allowed in access). There were cases that the Vendor delivered more than 2 items ( its not fixed), which means...

Got the solution for Q1 thanks For Q2, I don't get what you meant, can you explain further

Hi everyone, Hope someone can help me on this task. I attached the Database for your reference with table and form only. Query 1: I have a combo box Item with dropdown values Item1, Item2 and Item 3. Would it be possible that when I selected Item 1, the combo box "Distribution" will display...

Thanks arnelgp got it. Issue resolved! Good day to all

Perfect, it works. I'm looking the event vba code but cant find in the fields, can you please advise how to do it so I can apply to some part of the my database.

DBGuy, The_Doc_Man, sxschech...Thanks for your suggestion, apprciated.

Hi, the database plan is not to have a color on the field box. Really appreciate if it could be as flashing text as per initial request

hi DBguy, happy to see you replying again...this is already a form..attached is the database, please help

Hi, Good day to all. Reference below, can someone please help me to create a code that when ActualD field is empty the SchedD field is flashing/blinking (in red color text) Once a value is added in the ActualD field the blinking in SchedD field will stop and back to color black text. Thank...

All the best AWF team

Hi Gasman and cheekybuddha, I would like to thank both of you. Being new in this forum and in access (especially in vba codes) your patience is very much appreciated. Good day!!!