From and To option using text-boxes.

  • Thread starter Thread starter agm
  • Start date Start date
A

agm

Hi all

I want to use the following in MS-ACCESS forms:

I've to enter serial numbers of the cards every day to access table in
the following format:
Serial Number Denomination Date

I want it to be entered via text-boxes as follows:

Serial Number from:
Serial Number to:
Denomination:
Date:

So, as i enter the FROM and TO values (say FROM value -001; and TO
value - 009), i get 001, 002, 003, 004 and so on

Please help and make this possible.

Reg
Deepak
India.
 
Hi Deepak

Create a new query based on your table (if you don't already have one).
In the column that holds the "serial number" there is a space for your
Criteria. Enter this in this space

BETWEEN [Enter Start Number] AND [Enter End Number]

This will prompt the user for these 2 numbers before the query is run.
You query will then be filtered using this Criteria.

It will ask the questions if you are running the query or a form or report
based on that query.
 
Back
Top