Ever wondered how to create a
How to build a dynamic
Create a connection to DBF
Basically, I had the problem
table, view or procedure
dropdown list with ASP and
files using JetOLEDB
of needing a marquee to
with MS Access? This article
database data. Then, how to
provider (DSN-less,
scroll important updates but
shows us how to create all
use ADO and recordset
ODBC-less connection), basic
everyone who needed to
three and work with them
filtering to produce a
work with DBF files (select,
update it was not HTML
from an ASP script.
structured list.
insert, update), other ISAM
savvy. So I made it form
formats + FOXPRO option,
based. And the coolest part
real sample code, create a
about it is, you can control
new DBF file.
the background color, and
the text color. That is good
when you want different
color combinations to have
communicate different
things. Like, black
background and red text
could mean urgent and blue
background* and yellow text
could be Happy Birthday!
Date: Aug, 27 2003 Date: Aug, 27 2003 Date: Jun, 18 2003 Date: Jan, 06 2003 |
How do I get the Unique ID or
Dropdowns or combo boxes are
Learn how to add records with
Learn how to edit records
Auto ID of the record I just
an excellent way to get
an SQL statement instead of
with an SQL statement
entered? The solution is
input from a user. One of
a Recordset. Here are two
instead of a Recordset. Here
really quite simple.
the biggest problems with
examples. One will use a
are two examples. One will
user input is spelling and
query string and the other
use a query string and the
formatting. Here is how to
gets the info from a form.
other gets the info from a
use and populate dropdowns
Both examples include an
form. Both examples include
from a database.
example of a DSN-LESS
an example of a DSN-LESS
connection.
connection.
Date: Dec, 10 2002 Date: Aug, 05 2002 Date: Aug, 05 2002 Date: Aug, 05 2002 |