Search results

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)...

Well actually the query is based on both tables and the field in common is the FileNO.

Thanks. I have attached the sample. Very simple.

Hello friends, My db has two main tables (table1 and table2). Table1 gets its records periodically from a text file that I import and that I cannot change. Table2 is used to store new data, like changes in phone number, email, addresses, etc. I use this table like an historical log and need...

Thank you for your reply. But will I be able to create a report based on unbound fields?

Hello, I have a form with two tab pages. One picks data from a table, the second one has unbound fields that once updated are saved into a different table. I am having problems in printing this second page. I have tried two options: 1) The following command: DoCmd.PrintOut acSelection...

Thank you. Sorry but where should I write it. Not very familiar with it. Should I create a query and how can I refer to the unbound fields?