Re: Showing certain record only

I have been trying to work out the easiest way to display certain
records only. In my database I have a toggle button that once pressed
indicates the record/project has being invoiced. Once a project has
being invoiced I would like it to hide itself from selection when
navigating through the database.
Easy enough! I made a query and it works fine but what if I wanted a
toggle button for the whole database so that when its in its down state
it displays all records including the invoiced ones and when in its
upstate shows uninvoiced projects only?

I want to do this with affecting the input for the invoiced button
cause it is important to the overall structure.

My Main form is called frmProject which gets it data from a query
called qryProject.

One way to do it.

I add a frame to a form (framZeros) with 2 option buttons
The option buttons, when selected...
1) assign a value of 1 or 2 to framZeros
2) assigns a value of 1 or null to an unbound textbox (txtZeros)
3) populates a label caption with "Show Zeros" or "Don't Show Zeros"

I have a query that filters a table as the recordsource for a listbox.
I add a field named "Sort" to the table and populate with 1s or 0s,
depending on criteria.

The AfterUpdate procedure, below, assigns a value of 1 or null to the
unbound textbox, txtZeros.

Relevant Pages

Re: improving performance by indexing query criteria fields... establish relationships first in the relationships window.... My advice is to index fields that you use to specify criteria and sort orders. ... important in a multi-user database, where the back-end is on a file server. ... appropriate records (assuming the query optimizer can use the index). ...(microsoft.public.access.setupconfig)

Re: improving performance by indexing query criteria fields... establish relationships first in the relationships window.... My advice is to index fields that you use to specify criteria and sort orders. ... important in a multi-user database, where the back-end is on a file server. ... appropriate records (assuming the query optimizer can use the index). ...(microsoft.public.access.queries)

Re: Database Results Using Page Variable... You can modify the Pick list example to use a hyperlink to pass the query (your criteria) ... Right above the 1st grey code just enter the ASP code to get the query value from the sending page ... But the database results in the include page should show ...(microsoft.public.frontpage.programming)

RE: updated numbers in report...criteria for a number of queries. ... But i have one more question, its about a textbox.... textbox will be located alongside with the combobox where the belonging ... will not make the input to the query....(microsoft.public.access.dataaccess.pages)

RE: updated numbers in report... it is looking as you have described, when using only the criteria from the ... for the input in the query it is not. ... i was thinking this, that the combobox... have a list from the table, and the textbox have not. ...(microsoft.public.access.dataaccess.pages)