Recent content by zhbuyi

Thanks, I will try. Just for discussion purpose, I don't like this either for the same reason I don't like the table solution, because forms and tables are not intended to store such global values. It feels like getting a cell phone just for the calendar in it.

I am assuming using VBA to store the constant? But how do I do that without VBA so that the queries will recognize the constant? What I meant was that is there a "Global Constant" for Access by itself Also, if I write that into VBA, at what point should I invoke the program?

I have several queries which use the same parameter. The parameter is updated once in a while. To avoid having to change the parameter for all the queries, I have thought of two solutions, but have not executed. 1. Define a "global constant" to store the value, and every time I want to...

I would like to combine several reports into one report. Therefore, I created a main unbound report and move the sub reports to the "Report Header" section of the main report. The detail section of the sub report shows fine, but the page header and page foot header sections of the sub report...

I work with Access 2003. I created a form on a table using wizard. There is a memo field. I'd like to be able to enter multiple lines in the field. However, when I press "enter" it goes to the next field. What properties can I change in the table and/or the form to be able to enter multiple...

I made a query (and its pivot table view) and would like the numbers to be in certain format. I could format the underlying table but not the query itself. 1. Is there any way to format it? 2. if not, may be the query is not the best place to format data, do I have to do it in forms and...