Re: Macro for running text in Memo fields as SQL

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

Dear Rhysickle:

Here is my suggestion, if you want to have all those unbounded fields
and check boxes create a SQL string, then have some VBA code that reads
the status of each of these checkboxes and such and build your sql
string from that.

Not know more specifics, that is what I can tell you so far.

Joe P.


-----Original Message-----
From: Rhysickle [mailto:Rhysickle@xxxxxxxxxxxxxxxxxxxxxxxxx]
Posted At: Monday, June 19, 2006 8:35 AM
Posted To: microsoft.public.access.macros
Conversation: Macro for running text in Memo fields as SQL
Subject: Macro for running text in Memo fields as SQL

I have a form with various unbound tick boxes & combo boxes. I want to
build
a macro which runs a different SQL query depending on what state the
tick
boxes and combo boxes are in.

The various combinations of tick boxes and selections in the combo boxes
is
potentially huge, and I don't really want to clutter my database with
dozens
of queries. Is there a way to set up a table where the SQL code is
entered in
a memo field, and where a macro can look up a record, treat the text
string
in th ememo field as SQL and run it as a query.

Thanks for any help

Rhys

Relevant Pages

  • Re: Using combo box selection to supply criteria for query
    ... Sorry, I am still learning SQL and VBA, I don't think that I made the ... The form contains 5 combo boxes; SBT Account, Region, ADM, Month, Year ... If I only make a selection in the Region combo box ... Post the query SQL. ...
    (microsoft.public.access.forms)
  • RE: passing data to new form using open args
    ... If the SQL you are trying to send to the form is the data you want for your ... As to the SQL you have for your combo boxes. ... Row Source type to Table/Query and put the SQL in the Row Source property. ...
    (microsoft.public.access.formscoding)
  • Re: QUERY - AND/OR for search panel
    ... Here is the SQL that got the job done. ... FOR an AND Query between five boxes: ... An easier solution would be to build the WHERE clause ...
    (microsoft.public.access.queries)
  • Re: Access with Linked SQL Tables
    ... I also find the same occurs for combo boxes on forms. ... table which in tern resolves to sql server...you find a delay occurs. ... This trick will increase your load time by a lot on forms with several combo ... Albert D. Kallal ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help to Automate XSS and SQL
    ... Create a list of all the possible inputs (search boxes, ... Then you can start trying various javascript and SQL inputs to attempt ... but later on it was detected that it has XSS and SQL ... Security Trends Report from Cenzic ...
    (Pen-Test)