Search results

I have a recordset with multiple fields on which i want to build my report The reason why i want to do it programmatically is because i want to split the table created in the report into multiple tables.

Create report programatically from scratch using VBA

Hello I want to know how to create dynamic reports from scratch using VBA I want to have absolute control from VBA code(Creating header and footer, formatting fields, etc...) Thanks in advance

Hello I want to know how to make Application Forms Responsive so it can fit all screens Thank you

HI I checked the post but i did not find answeers that help Thank you anyway

Ok I got it Would please tell me how to delete a thread?

Edit: I'm sorry. I got confused The report is not shown minimized. It is shown as illustrated in the attached image. Some sort of 0 height

Hello I have a form with multiple levels of subforms Within the sbFrmA subform on the last level, I have a button "Report" that calls a report where i have dragged a built query that takes its parameters from combo boxes in sbFrmA. Then, I hided the the ribbon and the navigation pane and the...

Hi Thank you everybody. I think I found a solution. 1- Disable the focus on the subform by setting focus on another control from the parent form 2- Set the visibility of the subform to false Once again, I appreciate your help

Hi It is exactly as you mentionned. After few searches online, I came across the idea of hiding subforms as if they are being closed. I disabled the focus on the subform by setting the focus on another contol from the parent form and then I set the visibilty of the subform to none Thank you...

Hi I attached to images 1- The parent formA within which is frmB 2- The code in the "close button" event As you can see, I only used DoCmd.close command

Hello I have 2 forms: frmA and frmB. frmB is a subForm of frmB frmB has a close button. I used the DoCmd.close command attempting to close frmB but what happens is that frmA also closes. What can I do to prevent frmA from closing? In other words, I want to close only frmB

It worked fine. Thank you very much

Thank you anyway. I tried @isladogs suggestion and it worked fine.

Hello Thanks for the suggestion but it did not help 😁 Now the clicked listbox row and the other control are both highlighted

Hi I have a ListBox that shows search results based on some criteria What i want is that after each click on the search button (new search) to remove the focus (highlight) generated on the listbox after clicking on it Thanks

Hi So i have a database created using powerdesigner modeling tool. I saw a tutorial online about how to generate an access database from the sql script generated by powerdesigner. The method described in the video tutorial requires using an access file (.mdb). My issue is that this...

Thanks for everyone. I tried what you suggested and it worked fine

I don't get error message. When i click the login button, nothing happens. This did not occur with the accdb file(the query that searches the username and the password worked fine). Furthermore, the same thing happens for example with search forms. When i click on the search button, nothing happens

Hi About #1 would you please add more details. What is the extra work required For #2, i just read while searching online that i need tpoconvert it to MDE file. Am i going right or should i use something else ? Thanks