Recent content by Wysy

One more question please. The code if ss then msgbox else msgbox end if functions like if ss=true then the first condition, if ss=false then the second condition performed. Is this the automatic designed logic with boolean values not provided in the first line of the if...

Thank you very much for the clarification!

Sorry i was giving confusing information. So the boolean is missing =true than it is handled automatically false.Correct?

Hi, I have just came across a code i used successfuly, but would like to ask for a bit of interpretion for curiosity dim ss as boolean if ss then msgbox else msgbox end if This code gives the same result than the if ss=true then msgbox else...

Thank you so much! It works!

Hi, I have a form with a subreport. The subreport consits entries with dates and a generated field of the week number. On the form, there are two buttons: Days and Weeks. There is also a listbox, which shows the dates/weeks depending on with button is pressed. What i would like to do is link...

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