Inputs from dialog box

MontainDoctor

Hi Folks

How do I use user inputs from dialog box as criteria in the query? I
need to run a query on multiple criteria, using message box is very
crude.
Please help.

rakesh

Mar 30 '06 #1

Subscribe Post Reply

1631

Wayne Morgan

The best way, especially for multiple criteria, is to make your own form
that will ask for the necessary information then open the query. For this to
work, the form must be open when you open the query. However, if you don't
want the form to show once the user has made their selections, you can hide
the form by setting its Visible property to False. In the query, you would
then refer to the controls on the forms for your criteria.

Example:
=[Forms]![frmMyCriteria]![txtMyTextbox]

--
Wayne Morgan
MS Access MVP
"MontainDoctor" <dr************@gmail.com> wrote in message
news:11*********************@v46g2000cwv.googlegro ups.com...

Hi Folks

How do I use user inputs from dialog box as criteria in the query? I
need to run a query on multiple criteria, using message box is very
crude.
Please help.

rakesh

Mar 30 '06 #2

by: Chris Beach | last post by:

Hi there. I'd like to be able to group together inputs on an HTML form inside, say, a <div> or <fieldset> and then use javascript to iterate through the controls in the group and disable them....

Javascript

parsing complex user inputs

by: Sven Neuberg | last post by:

Hi, I have been handed the task of updating and maintaining a web application, written in ASP and Javascript, that takes complex user inputs in HTML form and submits them to server-side ASP...

Javascript

Customize Common Dialog

by: George | last post by:

Is there a way to customize the open file common dialog? I am trying to modify the button text so I can create a delete file common dialog. I need the same functionality of the open file common...

C# / C Sharp

Dangerous inputs in asp.net web forms

by: cesark | last post by:

Hi ! I have important doubts about how to handle the security in asp.net vb.net web forms. Somebody can help me? 1. If you have setting ‘validateRequest=true’ in .net framework1.1, What can...

ASP.NET

Modal Dialog - This Almost Works

by: Guadala Harry | last post by:

I have a modal dialog that currently does all of the following except item 4. 1. lets users select a graphic from a list of thumbnails (and when selected, displays the full-size image in a...

ASP.NET

How to select an input from a set of inputs?

by: shana07 | last post by:

Hi All, I do really need to consult you guys about my java assignment. Please guide me how to make an algorithm to select an input from a set of inputs? Suppose I have a program p (a), an...

Java

dialog's Form.FormClosed is not run

by: Zytan | last post by:

I have created a new form from the main form. When I close the main form with the 'x' close button, its Form.FormClosed event is run, but not the dialog's. Is this normal? It is ok /...

C# / C Sharp

many inputs

by: shana07 | last post by:

good day all! Need to consult about input array in main. I have one program that need two inputs (a & b) in main. Please see codes below: public static void main(String args) { ...

Java

hidden inputs and viewstate

by: dawidg | last post by:

I have an asp.net page with viewstate disabled. I have a control on the page that dynamically creates controls inside itself, no viewstate. The controls aren't created in Init, but in Load. With...

ASP.NET

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Similar topics