Running SQL inside forms

Similar Threads:

1.appear or add more form inside form , or inserting more textfield inside form

2.Running Form based module inside of macro

RE: Access 2003

On frmMain, I have a command button that has a module for the click
event: 'Private Sub cmdRunQuery_Click().
frmMain also has an option group called "optQueryCriteria" which has
four different options for the 'condition' for the single block of SQL
that runs from the command buttons' click event.
Right now the user checks one of the four options from
optQueryCriteria, then clicks the "Run Query" button to get their
result.

In order to de-clutter my screen, I would like to transfer this logic
to have a menu option called "File/Queries", then inside of that menu
option have the four listed as options.

When I first investigated this,  it seemed as though custom menu
options only allowed macros to be run from the command button, not
Private Subs that resided inside of a form.  Having learned that, I am
stumped as to how I can get cmdRunQuery_Click() to fire within a
macro.  Do I have to make it a Public Sub inside of a standalone
module object?

Secondly, I'm having trouble nesting choices inside of custom menus.
It's been ages since I last used custom menus for my apps because my
apps are all in-house small corporate apps.  (custom menus were so
easy to set up in VB6)
I'd like to have File...then dropping down inside of that have
"Search", then "Queries", then inside of "Queries", have "Query1,
Query2, Query3, Query4".  Right now all of these menu options are at
the highest level of the menu bar and are not nested.

3.Using SQL inside a Form

Hello,

I have a form that has two fields in it (FILE NUMBER and CASE NUMBER) - I 
would like to set up the form so that when the form loads, it queries the 
PERSON table for those two parameters, then retrieves the First and Last 
name from the PERSON table, deletes all the records from another table 
called PERSON_DROPDOWN, and then inserts the First and Last name values into 
that PERSOn_DROPDOWN table. Any ideas? 

4.refer to a form's text box.text inside a SQL clause

On 16 Feb, 15:03, "giannis" < XXXX@XXXXX.COM > wrote:
> How can i refer to a form's textbox.text inside a SQL clause ?
>
> I know how is that in Access* but at VB i receive error.
>
> * SELECT FIELD1 FROM TABLE1
>    WHERE TABLE1.FIELD2=[FORMS]![TEXTBOX].[NAME]


Hi Giannis try this

Dim strwhereclause as string  =textbox1.text

SELECT FIELD1 FROM TABLE1 WHERE TABLE1.FIELD2= " ' " + strwhereclause
+" ' "

OR

SELECT FIELD1 FROM TABLE1 WHERE TABLE1.FIELD2= " ' " + textbox1.text
+" ' "

Thanks

Adam

5.refer to a form's text box.text inside a SQL clause

How can i refer to a form's textbox.text inside a SQL clause ?

I know how is that in Access* but at VB i receive error.

* SELECT FIELD1 FROM TABLE1
   WHERE TABLE1.FIELD2=[FORMS]![TEXTBOX].[NAME] 

6. child form inside the page

7. Creating 2nd transaction form inside db ?

8. displaying a form inside a report.