Re: Process to modify multiple queries simultaneously

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thank you gentlemen for your input.
Dale, I found an idea inside what you were saying. Being I already have
hundreds of combo box references already in my end user form I simply added
one to my Admin form where I was able to create a pointer in the Criteria
that references that Combo box.

Jeff, you lost me on data structure. Sorry. I am dangerous enough with
Access to break things yet naive enough not to know that it was broken. :)

"Jeff Boyce" wrote:

You've described a "how" (10 DELETE queries, ...) but not "what" (what data
structure are you working with?).

By the way, a field named "MONTH" will likely cause Access to get confused
.... "Month" is a reserved word.

If you'll describe your data structure a bit further, and provide an
example, folks here may be able to offer more relevant suggestions.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Guitarzann" <Guitarzann@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8BD102F4-CC3E-42F8-BF9E-CDC4AAEC1F04@xxxxxxxxxxxxxxxx
Greetings,

I have 10 DELETE queries set to remove data based on the MONTH field. The
month to be deleted is stored in the Criteria. My question is, is there a
query function where I can change the criteria each month for the 10
queries
in a single step instead of having to manually go into each query and
reset
the month?

Thanks for your help!



.

.

Relevant Pages

  • Re: Zero Rreferences (was:Stupid Question)
    ... > method to ensuring that there are no references left? ... IF one does not need a complex data Structure, ... Primates DO IT! ...
    (perl.beginners)
  • Re: Formatfunction displays #naam?
    ... The installation of new software on a PC may "break" links Access uses to ... refer to its code modules. ... Then go back into References and re-check, ... > Jeff Boyce schreef: ...
    (microsoft.public.access.reports)
  • Re: Parent Tables and Referential Integrity
    ... column references), and I could easily track everything with different tables ... "Jeff Boyce" wrote: ... As in why are you "dividing up this table?" ... analyzing with the table analyzer and I am dividing it up and I have ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Why could a suspended thread leak?
    ... that is reachable even without the thread executing, ... longer any references to them) are still somehow reachable? ... I'm referring to objects reachable via some other data structure. ... Suspend() is that there's nothing that would let your code know what ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: copying hashes without references
    ... > to parse). ... I created a hash with the common attributes and tried to ... If you want to really copy the contents of a data structure ... instead of the references it contains, this is called a "deep copy". ...
    (comp.lang.perl.misc)