Search results

I Cant Add add the query field to a form. i am doing it by control source. =([Query]![Annual Budget 2018]) its giving me error of (#Name?)

how to create a report like monthly and yearly report?

what is the formula? if my value is empty cell show me 0 or equal to 0. i am working in the form design. what is the formula and where to add the formula?

here is My Formula: Total: DSum("[Invoice Amount]","[PR33103]","[PR ID]<=" & [PR ID]) Whats Wrong?

I Did the Dsum Formula and its working and the result is good. but when I want to see Query Table in Design View so i cant see the dsum formula in my total field. its hide the formula. why? why i cant see the Dsum Formula? how can i view it?

how to allow input Alphabet in numeric field ?

Dear All, i am Getting Error while to apply the VBA. here is my VBA Code: Option Compare Database Private Sub Form_AfterUpdate() Call Form_Current End Sub ' make this Public so we can call in subform Public Sub Form_Current() Me.TotalInv = Nz(DSum("[InvAmount]", "[PR 33101]", "[PR...

I Create a Budget Plan For a Year. I have 3 field in my Form. 1: Annual Budget Amount : 80000 2: Total use Amount: 60000 3: Remining Budget Balance: 20000 Now what I want, if I enter the amount more the annual budget plan its should give me a popup message. Thanks.

This is Mark Form Jeddah.