Using wildcards with MS Access

jwebber

I have a database in MS Access for a community calendar. It has a dropdown
list from which to select a particular type of event, Art, Music, etc.

The list works correctly for displaying the particular type of data.
However, when the user first opens the page, I would like to show all events.
To do this I have used the wildcards characters "%%" in the control
parameter. But this just gives me a blank listing. I have also tried "**"
and "*". These do not work either. Here is the code I'm using:
<SelectParameters>
<asp:ControlParameter
ControlID="DropDownList1"
DefaultValue="%%"
Name="Event_Type"
PropertyName="Text"
Type="String" />
</SelectParameters>
Can you tellme what i am probably doing wrong? Thanks

Nov 2 '06 #1

Subscribe Post Reply

1078

mscertified

wrong forum

"jwebber" wrote:

I have a database in MS Access for a community calendar. It has a dropdown
list from which to select a particular type of event, Art, Music, etc.

The list works correctly for displaying the particular type of data.
However, when the user first opens the page, I would like to show all events.
To do this I have used the wildcards characters "%%" in the control
parameter. But this just gives me a blank listing. I have also tried "**"
and "*". These do not work either. Here is the code I'm using:
<SelectParameters>
<asp:ControlParameter
ControlID="DropDownList1"
DefaultValue="%%"
Name="Event_Type"
PropertyName="Text"
Type="String" />
</SelectParameters>
Can you tellme what i am probably doing wrong? Thanks

Nov 3 '06 #2

by: Bharath Dhurjati | last post by:

Hello, I am looking for documentation that specifies the following behavior exhibited by java. The following (assuming MyClass.class is accessible and has a main()) java MyClass * yields...

Java

os.access with wildcards

by: mike | last post by:

i'd like to use os.access(path,mode) where path may contain linux style wildcards. i've failed so far. my workaround is the bash command. os.system('' % fn )

Python

Multiple LIKE comparison using IN operator

by: Evil Bert | last post by:

Is there anyway to compare a field with multiple string values using LIKE? Here's the statement I have now: SELECT * FROM list WHERE email LIKE CONVERT( _utf8 'hotmail@hotmail.com' USING latin1...

MySQL Database

Wildcards with Like in Microsoft Access

by: Alex | last post by:

Hi all, I'm trying a very simple Like statement in MS Access XP, but it's acting strange. I've always used a percent (%) for wildcards in MS SQL, and I thought this was the same in MS Access......

Microsoft Access / VBA

wildcards in rename()?

by: Alvaro Puente | last post by:

Hi all! Do any of you know if wildcards are accepted when calling rename() function? Thanks/Alvaro

C / C++

Question about filtering in Data Access Page using a Command Button

by: aviklund | last post by:

Hi, I made a simple data access page with a search button that does work properly, but now I would like to add a filtering to the command button also. Ideal solution would be like this: ...

Microsoft Access / VBA

FileSearch Object. Strange result with Wildcards

by: Alan Carpenter | last post by:

Access 8 on Win98 and WinXP I'm having trouble with wildcards in the .Filename property of the FileSearch Object giving different results on win98 and XP. I've been successfully using...

Microsoft Access / VBA

Query Criteria - Using Wildcards on values of varying lengths

by: servantofone | last post by:

I'm using Access 2003. I'm building a query and wish to display all records with values in a certain field (HIST) made up of all zeros. The field has a range of text values including alpha-numeric...

Microsoft Access / VBA

Open Excel File from Access Form using Wildcards

by: brunpam | last post by:

Hello, I'm somewhat new to Access and I'm trying to open an Excel file from an Acess form command button. The only problem is the Excel filename includes a date and the date changes on a weekly...

Microsoft Access / VBA

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

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

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

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Using wildcards with MS Access

Similar topics