Recent content by kegz

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?