Any/All as a Choice in a Combo Box

[rana1978]

Dear…..,

I have created a database (see attached) where I can select only single item parameter for report. But I want to select single item and All Item (which ever I need) for reporting?

I have tried through Union Query, but failed to do so…

Please help me creating it in the attached file and send me the update file, Please…please…please


Rana

 

[khawar]

Use this sql in the row source of combo

SELECT ITEMLIST.Ttem_Name
FROM ITEMLIST
union select '<All>'  FROM ITEMLIST
order by Ttem_Name;

 

[marianne]

yep, "ALL" is there but not giving the result to show all records in the report.

 

[DCrake]

How are you employing the filter?

If you select an item from the list and it is not <All> then

If Me.Combo <> "<All>" Then
   Filter = "....."
Else
   Filter = ""
End If

 

[khawar]

You have to modify your query or apply a filter to report through form. I have used the query method
modified sample is attached

 

[rana1978]

Thank you very much .....

 

[rana1978]

Login User name in Data entry Form

Hello Khawar

I have developed an Inventory Database but facing some problem….

In the database there are some user names for entering the database. And the users have permission to input data. But I need to ensure the user names, who do input a specific data/record in the database. For this purpose it is necessary to show the user name (that is used for Login in the login Form) in the Data Entry Form and as well as in the main Database Table.

It will be very much helpful if any one can help me in the above issue.

Thanks

Rana