Search results

To get the name of the month of a given date use the Month() and MonthName() functions. Month() gives the month no. 1,2,3... MonthName() gives the whole name of the month. Try: =MonthName(Month([DateFiedl])) HTH, Lyn

Graham, In an unbound textbox in the report header in design veiw try: =Forms!FormName!UserNameControl Catch: The form must be open for the report to get the UserName. HTH, Lyn

Kbrooks, In an unbound text box in the report footer try: =Count([Incident#]) HTH, Lyn

Alternatively, in an unbound text box at the report footer try: =[Name] It works in A2K.

This behavior is usually caused when the PopUp property of the calling form is set to "Yes". In the form's design view, click Properties, click the "Other" tab, and set the PopUp property to "No". HTH, Lyn

Ditto A2k. ControlSource was also not listed but I used the property anyway in a report using the above method and lo! it worked. Lyn

You seem to have some VBA code in the controls. I have read that when you set conditional formatting of text or combo boxes in a continous forms the formatting of the controls on the first record will be propagated to other controls in the other records regardles of the value of the controls...

I'm curious. Can you pls. describe how you setup your conditional formatting. I do use this feature but I haven't had this problem. Lyn

You wrote: >>If Forms!MonthSelect!Month="January" Then Score.ControlSource = "Score.Jan" Else If etc...<< Try: ... Score.ControlSource = "=Score.Jan" ... i.e. an equal sign between the open qoutation mark and the capital S. HTH Lyn

After several hours of brain bashing,"sweat" wiping, sleepless nights and the words of wisdom from the AccessPhantom I finally have the report. A million thanx to AccessPhantom. What I did was to make a select query with the criteria for the Jan 1 of the year and the current month in which the...

Hello Everybody and Mabuhay (Longlive)!!! In Access2K, I would like to print a 3-column report that shows the following: e.g. Income Souce/February/Total Todate 1. License / P100.00 / P300.00 2. Fines / 200.00 / 500.00 Income Source column is the listing of sources of income. February...