Search results

If you view Query properties in design mode you will see a "Filter" property. When I put a WHERE statement in this section and click the "Apply Filter" button it works exactly as I anticipated, filtering out the records I want. Does anyone know the syntax to change this property in VBA...

Is BlowerId part of a compound Primary Key in tlbOrderDetails?

Say you have this as the dataset for your main report: District_Leader_ID Zone_Count This gives the main report a primary key referencing the district leaders, and a count of the number of pages each needs to receive. The dataset for your subreport should include: District_Leader_ID Zone_ID...

I believe the only way you can do this is if a) the count control is bound to report recordset, and b) you are using subreports to display the zone and district information. If this is the case, you can add the following line to your code where appropriate: DoCmd.GoToRecord , , AcNext This...

Sounds like your running into a concurrent operations issue. Access concatonates the text from your two combo boxes and updates the Route field simultaneously, so the concatonated text isn't ready for the field when Access tries to move it. Try this instead: Private Sub Text27_AfterUpdate()...

It sounds like you are trying to create a calculated field, but are entering the calculation in the "criteria" section rather than the "field" section. Try entering this in the "field" section of the query: Total Expenses: [FoodExpenses]+[OtherExpenses]

Does anyone know how to filter data in a query in code? This is what I assumed would work but I am hitting some strange "Can't find the field" errors: Queries![MyQuery].Filter = stMyFilter I am creating an SQL string in stMyFilter based on selections the users make on the form. They then...

Why is it you always find the solution the second after you post? It's fairly simple; just use a period instead of an exclamation point: Reference a control: [Forms]![MyForm]![MyControl] Reference a variable: [Forms]![MyForm].[MyVariable] Dont I feel stupid.

Anyone know how to reference a global variable as criteria for a query? I am currently using invisible text boxes on an intermediary form as criteria for my query and it works fine, but this solution seems inellegant and I'm looking for something a little smoother. I just need the correct...

Anyone know if it is possible to apply a filter to a control? Specifically, I want to reuse the same subform on multiple pages of a tab control, filtering the data in the subform according to criteria specified on each page of the tab control. Each page on the tab control is named according to...

Ok, thanks, I was afraid of that.

Hi All! I am trying to create an updateable non-calculated field in a select query. Specifically, I want to create a Yes/No data type called "Fail". This is a multiple-user application so I can't solve the problem by using append and delete queries to modify records in a table. This has...