Recent content by Wysy

Also, i have another question: when i let the report to be opened in acDialog mode the opened window is resizable even tough such property is set to no, i.e. positioning the cursor at the border, it is possible to resize the window. Is it possible to turn this off too?

Sorry i was away for short. I am talking about a report. Actually i am using the reports to summarize data for viewing only. However for optic reasons , i have put a command button for closing the report. Whenever i move the cursor around, records are selected in the form with a grey bracket...

Hi, I am looking for advise on how to turn off the highlighting of the row selection. thank you

using DatePart to retrieve year month and date in 3 different field makes the trick. But is there a simpler solution maybe?

I have found a way that brings me nearer: for the field it used the following format: Format([calculated_fieldt], "\#mm\/dd\/yyyy\#") However it fails to order on the year part, but only the month/date. Any idea?

Hi, I have a query with a calculated field that contains the latest date using a Dmax statement. It works fine. However when i want to order it by ASC or DESC it handles it not like date, but to me it seems like integer. Is there a work around? thanks

Thank you! This helped a lot.

Hi, i am looking for something where i am not really sure about the wording. I would like to have a form in datasheet view listing records. While cliking on a record i would like to have a subform opened under the records (like in case of the tables with one-to-many relations). Is this...

i will. Thanks

Thanks. Exactly that is what i am looking for. "filter as you type..." was the wording i have missed.

I have an unbound textbox that has an afterupdate property set to filter a form. I wondered to tirgger the filtering while typing, i.e. after each character entered, the filter would activate. Private Sub txtSearch_AfterUpdate() Me.Form.Filter = "Partner Like'*" & Me.txtSearch & "*'"...

Hi, Is there anyway to read out the content of an unbound textbox in runtime? What i mean is how to get the values while typing for example. Thank you

thank you!

Hi, i have just experienced that if i open a report in acdialog than the set ribbon is not displayed. Is this the normal behavior of the program? thanks

I did. In case of forms there is the .movesize that works great for me. I am looking for something like that. Report pops-up to show information and i would like to resize/adjust that window. So i guess it is not the report itself that i would like to adjust, but the window where it is shown