Search results

Do i have to put save button for the form containing the start date and end date sir vbaInet?

I'll make a new one.. It's just a small application but a great training for a beginner like me... It's great that there's a very helping community for access.. I hope that you guys will not get tired helping newbies like me.. Thanks a lot

Thanks I will follow your advice... It'll be a lot of work.. Thanks a lot

So I'll create a new form? A blank form?

But I need that that parameter to track down my budget for a certain week, month or year.. Any suggestion you can give?

sql statement for the qryBudget SELECT tblContribution.ContriDate, tblContribution.Contribution, tblContribution.ContriCategoryID FROM tblContribution WHERE (((tblContribution.ContriDate) Between [Budget Start Date] And [Budget End Date]) AND ((tblContribution.ContriCategoryID)=1 Or...

1.Ok I will tell you the details of my qryBudget.... I chose the tblContribution as my reference table/query then I chose the following fields contriDate, ContriCategory with the criteria of 1 or 2 or 5 or 6, Contribution.. 2.The Details of my qryOpearation.. I chose the qryBudget as my...

I'm in trouble... 1. The record source of the report is qryExpensesLightandWater 2. Ok lets put it this way.. When i created the qryOperation I chose the qryBudget boz i want to get the sum of the budget for just 4 categories.. 3. Do you mean criteria?

DLookUp("[Light and Water]", "qryOperation") this one

aaree with above?

BTW the DLookUp() expression is DLookUp("[Light and Water]", "qryOperation")

A have a query named qryBudget with fields ContriDate, ContriCategory(criteria 1 Or 2 Or 5 Or 6), Contribution. Then I created a new query named qryOperation and I use the qryBudget to get the sum of all contributions. All the fields of qryOperation are all expressions to get a certain budget...

Everything is okay until I put a parameter in my query and all my textboxes bound to a DLookUp() function are displaying #Error.. Please Help...

Thank You it's a big help..

ahhhm I'm new to access, can you give me some example Mr. Galaxiom?

Thanks a lot.. I have another problem.. how can I update the budget? Ex. the budget for office supplies is php500.00 then I bought supplies for let's say php350.00 so the remaining budget will be php150.00 then the next day I bought supplies for php85.00, while the expenses is getting big the...

I tried that one but still it's not working.. By the way my budget report is full textboxes and the control source are all expressions. ex. the textbox for pastor budget [txtOperation]*.40

Is it possible that the control source of a textbox is from a query or report? ex. in my expenses form i'll put a textbox then the control source is =[rptBudget].[txtPastor] pls help...

Hi everyone, I'm totally new to access. I have my contribution table, expenses table and budget query. Now in my expenses form I want to see the budget of a certain budget category. for example the pastor budget so that I'm aware if my budget is running out.. What I did is I put a textbox...

that's a big help.. thanks a lot