I'm working with a form & a query that allows the user to filter the
data using several combo boxes. One of the combo boxes allows them to
select the first letter of a a particular field, and it will use that
first letter in the criteria of the query to include only records with
a value beginning with that letter. The tricky part is that one of the
possible values for that field is - *.* - not values I would have
chosen, but they are coming from another system, so I have no control
over it. If you select the * value, it ends up returning all of the
records. Is there any way I can still use this setup, and still filter
for records beginning with an asterisk? I tried enclosing the asterisk
in quotes, but it doesn't return any values. i'm stumped - any
suggestions? 2 9156
On Mon, 4 Aug 2008 05:02:50 -0700 (PDT), Coll wrote:
I'm working with a form & a query that allows the user to filter the
data using several combo boxes. One of the combo boxes allows them to
select the first letter of a a particular field, and it will use that
first letter in the criteria of the query to include only records with
a value beginning with that letter. The tricky part is that one of the
possible values for that field is - *.* - not values I would have
chosen, but they are coming from another system, so I have no control
over it. If you select the * value, it ends up returning all of the
records. Is there any way I can still use this setup, and still filter
for records beginning with an asterisk? I tried enclosing the asterisk
in quotes, but it doesn't return any values. i'm stumped - any
suggestions?
For just a leading asterisk, place the * within brackets.
Like "[*]" & "*"
For the *,* combination, use:
Like "[*]" & "," & "[*]" & "*"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
On Aug 4, 10:46*am, fredg <fgutk...@examp le.invalidwrote :
On Mon, 4 Aug 2008 05:02:50 -0700 (PDT), Coll wrote:
I'm working with a form & a query that allows the user to filter the
data using several combo boxes. One of the combo boxes allows them to
select the first letter of a a particular field, and it will use that
first letter in the criteria of the query to include only records with
a value beginning with that letter. The tricky part is that one of the
possible values for that field is - *.* - not values I would have
chosen, but they are coming from another system, so I have no control
over it. If you select the * value, it ends up returning all of the
records. Is there any way I can still use this setup, and still filter
for records beginning with an asterisk? I tried enclosing the asterisk
in quotes, but it doesn't return any values. i'm stumped - any
suggestions?
For just a leading asterisk, place the * within brackets.
Like "[*]" & "*"
For the *,* combination, use:
Like "[*]" & "," & "[*]" & "*"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Works great - thank so much!! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Steve Wright |
last post by:
I want to build an email subject containing text and a form field.
Have have got so far but all I seem to be able to do is generate another
page in the browser with a text string. (code attached)
I think that some how I need to pass the generated string as the action but
can't figure how to do it.
Can someone please tell me where I am going wrong and maybe suggest a
solution.
|
by: John Smith |
last post by:
This is what I'm trying to do:
In a form, a user enters a value (e.g. John) and clicks on submit.
Submit opens up a query with one of its values (e.g. Name) set to the value
of the control that the user just typed "John" into.
Thus far, this works fine, and it pulls up all the records where Name =
John.
|
by: ShyGuy |
last post by:
I have a table with 4 fields. Three are used for criteria.
I can get the DLookup to work with 1 criteria with the following but
can't get it to work with 2 or three.
NumofAppts = DLookup("", "LookUpAppts", "
= " & Forms!!NumofPeople)
Can someone tell me how to add multiple criteria? I tried "And" but
it doesn't seem to work.
|
by: Zlatko Matiæ |
last post by:
There is a form (single form) and a combobox. I want that current record of
the form is adjusted according to selected value in the combobox. Cuurrent
record should be the same as the value in the combobox.
What is the solution?
Thank you in advance.
|
by: cai_rongxi |
last post by:
Anyone has the solution to the question "Given an array a with value
1...N, find a repeted value" in C code?
Thanks a lot
| |
by: Jerome |
last post by:
Hi all,
I'm trying to use forward declaration with value class but I don't succeed
in compiling my (quite simple) sample code.
This is my code I'm trying to compile (Visual Studio 2003)
namespace managedDll
{
public __value class VecDouble;
public __value class VecFloat
|
by: bjaj |
last post by:
Hi
How do I use a boolean criterian with the funktion DLookup ?
I know the syntax for strings, numeric and date as follows
For numerical values:
DLookup("FieldName" , "TableName" , "Criteria = n")
For strings: (note the apostrophe before and after the value)
|
by: JamesQ |
last post by:
Hello there, I have a dropdown on a form which i use as a criteria for a query. However the field being searched contains many entries - it holds a list of subject choices - so when i pass a value using forms!! it only returns those records that have that exact match.
For example, Field = Subject, values are Computers, Photography, Maths. My control/drop down if i select Maths, returns only those records that have Maths on its own. When i...
|
by: Man4ish |
last post by:
How can we sort the map with value? Generally maps are sorted by key but i need map to be sorted by value. How comparator can be used to do such thing.
Regards
Manish
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |