Search results

Hello friends, Can anyone help me with this doubt? I have a form with a combo and a list box. The combo lists the various queries. Depending on the users' selection, the combo propagates it results in the listbox. My problem is that the listbox is set to 2 columns but some queries will required...

Thanks you. I like the idea but honestly would not know how to write this code. Or should I use a macro?

Hello, I am trying to change the name of my report before sending it as attachment by email. DoCmd.SendObject acReport, "Myreport", "PDFFormat(*.pdf)", "", "", "", "For your Info: " & Forms![frmMain]!LastName & " - " & Forms![frmMain]!FirstName, "Your action is required. Thank you", False, ""...

Thanks you quick reply. Walked through my code and ....yes, it was just a typo with the query name. Thanks

Hello, I have a form with a combo and a listbox. I would like to change the listbox records source depending on the selection of the combo. The combo's records source is Table1. I have then created two queries that should populate the listbox: If Me.myCombo.Value = "Clients" Then...

Hello, I am sure this has been discussed many times, but still having some problems in finding a solution for my db. My form (frmMenu) has 4 textboxes, 4 cmd buttons and a unique listbox. Textboxes are used to type the queries criteria (I have 4 different queries). The form also has another...

Perfect. Working great. Thanks

Hello and thank you for your quick reply. I was thinking of making my form more effective by changing the normal text we type in the Caption line (generally is the form's name) with a value that is showing in a text box. In my case, I would like to show the last name of the selected client...

Hello, I know this may look strange but is there a way I can add the value of a control (ex. a value of a textbox) in the forms' Caption field from the Property Sheet? Thank you

Thank you for your advise. I will go ahead and make the necessary changes.

Thank you for your advice and example. Indeed this it a better solution. The reason I wanted to come up with that idea is that I have several queries (in my sample I have added only two) that users can access from the frmMenu, through different command buttons that obviously open different...

Hello friends, Thanks to your terrific help. I have been able to almost complete by small application with exactly all the functions I wanted. There is still one other thing which I just cannot resolve. I will briefly explain what I need and post a sample of my database. My database has a...

Thank you

Hello, I have a main form with two cmd buttons. The first cmdbutton opens a subform on which there is a textbox that I use as a query criteria. Results are displays in a listbox always on the Subform. On the main form, I also have a second cmd button that should clear the contents of the...

Hello, just to give you an update. I have made a minor change to your code and it's now working great: SubMaster is the empty subform. SubSearch is the other subform that shows up (the source object) after the click event of my cmd button. Please note that my db main form is named frmMenu...

Honestly no. Do you have a sample or a link where I can get some ideas? Thanks

Thank you

Thank you

Thank you . I have created an empty subform, named it Test and the following code the the form Load event: Me.SubTest.visible = False. I have then added the following code to the the cmd buttons: Me!SUBTEST.SourceObject = SUBCLIENTS Me.SUBTEST.Visible = True Me!SUBTEST.SourceObject = subInfo...

Hello, I have created a form with several cmd buttons which should open different subforms. I would like that these subform open only on the click event and once closed either close down or are hidden. All the subform should have a specific position, in a sort of a frame (in my sample Box3)...