Wildcard Entry

Aug 17, 2005

Hi,

Im having a little problem with the following code in one of my queries

Expr1: IIf(IsNull([Forms]![editLookForm]![Company_Name]),True,[Company Name]=[Forms]![editLookForm]![Company_Name])

What this does is, it take an typed entry from the form (editlookform) and seaches for that entry in the query

i want to add wildcard entrys to this so that the person operating doesnt have to know the complete company name - i just dont know where to put them

Help please

View Replies


ADVERTISEMENT

Queries :: How To Trigger By Date To Create A New Entry In Database Based On Old Entry

Aug 6, 2014

I have a database that makes use of standing orders. That means that if a client has a standing order to receive products during for example 4 time as year (quartely at the end of the month). to automate the new entry by copying an old entry in the database.

Let's say I have a client where we will have to send a product at the end of June, it will look at a field where the next send date is, and when it reaches 2 weeks for that date, to create a new entry in the database based on that entry. This way, it will pop-up in our open cases and we are aware of it and also will be visible in our report.

View 1 Replies View Related

Forms :: Combo Box To Verify With Last Entry And Display Other Options Than Last Entry

Sep 8, 2013

I am working on creating an access database for tracking physical assets linked to locations. I need to make a combo box list to show items other than the current location of the asset. Basically I need it to refer to last enery of the user and define the new possible entries. so we have a unique relationship between location and asset. The assets and location will always remain fixed and there is never going to be any addition. I am creating a web form so that it can be uploaded into sharepoint.

View 3 Replies View Related

How To Use Wildcard?

May 15, 2006

i've try and no luck... using Like "* *"

i'm tryin to create one that if i search for like let say "brisbane" it would show the results of the complete spelling, but let say if i was to just type "b" or "bris" it would show u a list of "B" towns or matching words of "bris".

any assit would be great

View 1 Replies View Related

Pop-Up WildCard

Jan 31, 2005

I have a field in a table that has the following data in it:

W-01-2005
W-02-2005
W-03-2005
W-04-2005
etc..

I created a query against this table and put a pop-up on this field so they can enter the search criteria needed, or leave blank for all.

I'd like to modify this pop-up code to ignore the W- and -2005. When the pop-up appears and asks them what week they want, I'd like for them just to enter 01 or 02 or 03 etc... not W-01, W-02 etc..

This is the code I have currently in this field.

Code: Like [Enter Two Digit Week] & "*"

Thanks, Leap!

View 6 Replies View Related

Wildcard Using Mid Statement

Jul 4, 2005

Can anyone say what the syntax would be for the "incorrect" statement below?

Like *Mid([checking]![COMPANY NAME],1,InStr([checking]![COMPANY NAME]," "))*

As the statement above doesnt work, just returns errors.

Thanks in advance

View 1 Replies View Related

Wildcard Queries

Aug 17, 2005

I am running a query that links to a "wildcard" form so that the user can basically run a query filtered on any field they want.

For some reason when I try to use wildcards along with Criteria in my query the query will not return any results. I know the link to the textbox is right because if I take out the wildcard and put an exact word from the table I get a result.

I have tried using many different combinations inclusive of the following:

Like [Forms]![Refurb-WildcardReport]![RefurbWildcard-Name]
Like "[Forms]![Refurb-WildcardReport]![RefurbWildcard-Name]"
"[Forms]![Refurb-WildcardReport]![RefurbWildcard-Name]"
[Forms]![Refurb-WildcardReport]![RefurbWildcard-Name]

Any help would be appreciated, as always thank you ahead of time.

View 14 Replies View Related

Using Wildcard Characters

Oct 6, 2005

I have several queries looking up products from a table. I use a simple form to access the query and in the criteria of the field I use [Forms]![EnterCroft]![ProductName] to filter by name. (EnterCroft is the name of the form).

It works fine but doesn't like the asterisk (*) for all products.

I also want to use wildcard before and after key words in the product names, eg *cup* for anything with CUP in it's name.

How can I do this?

Thank you very much.

View 2 Replies View Related

Problem With WildCard

Dec 13, 2005

ok in access 2003 i have tried everything to get the Like "*oak*" to work but to all fail it replaces "Like" with "ALike" i have tried to find some info on this but have not it seams like something easy i wanted to do.

SELECT MainData.ModelName
FROM MainData
WHERE (((MainData.ModelName) ALike "*oak*"));

some reason it wont find all data with "oak" in it just returns empty

this is like query 101 but for some reason it has stumped me, along with one other problem but i am still researching that one.

View 6 Replies View Related

Wildcard Problems.

Dec 14, 2005

This is making me mad now :mad: i want a query to search for what a user inputs into the query. but for example if i seach in a field wheres there is one or more words in it. eg. I want to search my table for a address (60 donnington road etc) so in the user input box i type "donnington" but i get no results even though it should find "60 Donnington Road"

code i used. [Please enter address] now where does the wild card go?!?!

hope that makes sense :cool:
thanks

View 3 Replies View Related

Wildcard For One OR More Digits?

Mar 14, 2007

Hello, I'm trying to use wildcards to filter for records that contain a date somewhere within the string.

I'm using Like "*#.##.##*" which works for dates that have a day of the months >10, but what about those under?

Well, Like "*#.#.##*" only works for those with the day of month <10. Is there a wildcard character for "one or more digits"?

Also, the above example excludes Oct. - Dec. for the same reason.

help!

Thanks,
Gifford

View 4 Replies View Related

Wildcard Characters

Feb 24, 2006

Hey everyone, I've been busy creating a switchboard based on database, and I came across this issue. When I put a search through records command button, it seems that I can't use the wildcard characters, such as *,%,_ in order to find multiple records matching my criteria.

Am I supposed to "enable" them from somewhere or am I doing something wrong.

Any help?

Thanx in advance

View 1 Replies View Related

Modules & VBA :: Wildcard In URL / Before And After

Feb 21, 2014

I'm trying to add a spreadsheet from a folder using wildcards by just looking for a number in the file name.

strPath = "C:Training"
strFile = strPath & "*" + "(ZZ131008)" + "*.xls"
DoCmd.TransferSpreadsheet acImport, , "Training1", strFile, , ""

I get a response saying it cannot find the file and it shows the * in the path it cannot find. How can I make it find the right file?There are more files in the folder and the (ZZ131008) defines that course, I'd like to reuse the code for the other courses too.

View 3 Replies View Related

Wildcard Within A Combobox

Nov 20, 2013

I have a combobox with 2 columns where I manually set the following criteria:

"E";"English"
"F";"French"
"EF";"Bilingual"

In my employee table under the Languages field I have E,F or EF

I wanted to display in a sub-form a list of employees who speak a specific language but I can't use a wildcard in the combo-box properties. Basically when someone is looking for an English speaking employee they should get both E and EF employees not only E.

I tried doing "E*";"English" but it doesn't display anything.

View 10 Replies View Related

Wildcard On A Numeric Field

Jun 28, 2005

I have a query that prompts with a parameter box for the field Contributor_ID. Contributor_ID is a numeric field & Key and I use it to allow the user to print a report based on which Contributor_ID value the user enters. This works fine. However, I would like the user to have the option to enter * and then have the report include ALL the contributor IDs. I have done this before on a text field without a problem, however is this not possible on a numeric field as it is not working? I'm trying not to have another version for the ALL option.

If this is not possible, are there any alternatives?

View 2 Replies View Related

Update Query Using IIF And Wildcard

Feb 1, 2006

Hello,
I am not sure if this is possible, but I am running an update query to add text in a field if a certain criteria is met. However, if the field I am adding to already contains what I am trying to add, i don't want it to add it again. Everything works fine except the IIF statement in my update field. Here is what I have:


IIf(Temp_Vendor_Trips.[Reco Classification]="*" & "V3" & "*",Temp_Vendor_Trips.[Reco Classification],Temp_Vendor_Trips.[Reco Classification] & " " & "V3")


If the field contains the text V3, I want it to be left alone and continue to show what is already in the field, if not, i want it to add V3 to the end.

Thanks in advance for the help!

View 1 Replies View Related

Upper Case Wildcard?

May 26, 2006

Just been searching around, found a few posts of uppercase questions, none that quite fit with mine, anyway,

Basically, the data I am working on produces names as such "JoeBloggs" "FredPerry"

Anyway, Im going to use a query to seperate these out into first name and last name, but, I can't seem to find a way to specify a capital letter as a wild card. So far:

CapPos: InStr(2,[calllogs]![CalledNumber],"A")

Then I am going to use the mid function to seperate the two, depending on the position of the first capital letter.

But I just need to replace "A" with something that will find any capital letter.

Cheers

View 10 Replies View Related

SQL Wildcard And Is Null Statements

Jul 10, 2006

I have a SQL that enables the user to search the form from different combo boxes to narrow down the data. I can get this to work but it only finds the fields that exactly match their input data. I want them to be able to type something in the combo box and then it pull up anything with that value in that field, whether it is 1839B or B1839 it should find both if I type in 1839

Here is my sql statements

SELECT DISTINCT [WeldingSpecification].[Spec], [WeldingSpecification].[Steel Type], [WeldingSpecification].[Group11], [WeldingSpecification].[Group143], [WeldingSpecification].[Substitute1]
FROM WeldingSpecification
WHERE ((([spec] & "") Like IIf([Forms]![frmSearchCriteriaMain]![spec] Is Null,"*", [Forms]![frmSearchCriteriaMain]![Spec] & "*"))
And (([SteelType] & "") Like IIf([Forms]![frmSearchCriteriaMain]![SteelType] Is Null,"*",[Forms]![frmSearchCriteriaMain]![SteelType] & "*"))
And (([Group11] & "") Like IIf([Forms]![frmSearchCriteriaMain]![Group11] Is Null,"*",[Forms]![frmSearchCriteriaMain]![Group11] & "*"))
And (([Group143] & "") Like IIf([Forms]![frmSearchCriteriaMain]![Group143] Is Null,"*",[Forms]![frmSearchCriteriaMain]![Group143] & "*"))
And (([Substitute1] & "")([spec] Like "*" & Forms![frmSearchCriteriaMain]!Spec & "*" & "") Like IIf([Forms]![frmSearchCriteriaMain]![Substitute1] Is Null,"*",[Forms]![frmSearchCriteriaMain]![Substitute1] & "*"))

Any help is appreciated, please ask if you do not understand fully

Riley

View 12 Replies View Related

Using Wildcard In Switch Function

Jan 26, 2007

I am trying to use a Switch expression as a column heading in a crosstab query to generate statistics for how much work is done per client (Requester). Each requester is referred to by acronym, so it may look like "DOD/OUSD/FTT/ATA/B", but I want that column to include everything that starts with DOD, instead of listing each instance separately. This is my expression so far:

Expr1: Switch([Requester]="DOD*","DOD",[Requester]="DS/ATA","ATAP")

When I run the query, the column "ATAP" shows up perfectly with all the correct info, but it's as if I never entered "DOD*". Nothing appears, and since I didn't add anything in the Switch function for what to do with other requesters, the second column shows up as <>.

Do wildcard *'s not work in Switch functions? I don't get any errors, but this is definitely not the information I'm looking for.

Is there any other way to include all Requesters that start with DOD in one column?

This is my SQl if that's helpful:
TRANSFORM Sum([Q and D Database].[Word Count]) AS [SumOfWord Count]
SELECT [Q and D Database].[Source/Target]
FROM [Q and D Database]
WHERE ((([Q and D Database].[Out Date]) Between #1/1/2006# And #12/31/2006#))
GROUP BY [Q and D Database].[Source/Target]
ORDER BY [Q and D Database].[Source/Target], Switch([Requester]="DOD*","DOD",[Requester]="DS/ATA","ATAP")
PIVOT Switch([Requester]="DOD*","DOD",[Requester]="DS/ATA","ATAP");

Thanks!!!

View 2 Replies View Related

Working With Wildcard Char

Mar 28, 2007

I know I have seen post close to this one but not hitting what I need.
I currently have a query that is structured as such...
Service: IIf([Serv] Like '*AA*',' Bas ','') & IIf([serv] Like '*AB*','Exp ','') & IIf([serv] Like '*CA*',' Dig ','') & IIf([serv] Like '*89*',' 384 ','') & IIf([serv] Like '*8H*',' 3M ','') & IIf([serv] Like '*?5*',' 5M ','') & IIf([serv] Like '*=W*',' 10M ','') & IIf([serv] Like '*<1*',' Tele ','')
Works great except for the last IIF stmt has now been changed to look for the code *6 - not wildcard6 -
How can I get Access to realize that I need it to look for
anything to the left or right but it must find the *6
This IIf([serv] Like '**6*',' Tele ','') wont work b/c I have other codes that end in 6.

I am at a loss - any help is appreciated.

View 2 Replies View Related

Quick Wildcard Question

Sep 6, 2007

In my query Im using the criteria

="cashpayer*"

to bring up any records in this field which start with cashpayer but its not working. Is my text correct?

Cheers
Phill

View 3 Replies View Related

Wildcard Search Funtionality

Jun 13, 2005

I am working on a form that will be used to search records in a table. I have created the query shown below:

SELECT tblSTC.STC, *
FROM tblSTC
WHERE (((tblSTC.STC) Like forms!frmsearch!txtsearch));

I want my user to be able to enter search criteria and allow the use of a wildcard. When i run the query no data is found??

Can anyone help, thanks.

View 3 Replies View Related

Wildcard Character In VB Script?

Aug 26, 2004

I am setting up my own switchboard, and i have a quick jump menu that has every page on it. The pages are arranged as so:

1
1.1
1.2
1.3
2
2.1
2.2
3

When i'm setting up my code to push a person to a certain page, I want it to first check their access level (which is stored in a table in my database)

Is there a wildcard character in vb that will cover all the submenu's?
(I.E. Code:If MainMenu = "1*" And Userlevel = "PublicAccess" Then MsgBox "You do not have access to this area"End If)

Instead of having to put an if statement for every submenu under 1?

View 2 Replies View Related

Help With Wildcard Criteria On SubForm

Feb 21, 2005

I have a form with subform which use six fields on the form to determine
what data is returned in the subform. As long as every field has a valid entry the data is returned
correctly. What I would like to add to this is if a particular criteria field is left blank it will return all
values in that field. The current SQL Statement looks like this:

SELECT QryItemQtyProductLineLinked.FINISH, QryItemQtyProductLineLinked.SIZE, QryItemQtyProductLineLinked.COLOR, QryItemQtyProductLineLinked.BASISWGT, QryItemQtyProductLineLinked.PRODUCT_LINE, QryItemQtyProductLineLinked.MWIEGHT, QryItemQtyProductLineLinked.DFLT_VENDOR_ID, *
FROM QryItemQtyProductLineLinked
WHERE (((QryItemQtyProductLineLinked.FINISH)=[Forms]![FrmProductLineLookup]![MatchProduct]) AND ((QryItemQtyProductLineLinked.SIZE)=[Forms]![FrmProductLineLookup]![MatchSize]) AND ((QryItemQtyProductLineLinked.COLOR)=[Forms]![FrmProductLineLookup]![MatchColor]) AND ((QryItemQtyProductLineLinked.BASISWGT)=[Forms]![FrmProductLineLookup]![MatchBWeight]) AND ((QryItemQtyProductLineLinked.PRODUCT_LINE)=[forms]![frmproductlinelookup]![MatchProduct]) AND ((QryItemQtyProductLineLinked.MWIEGHT)=[Forms]![FrmProductLineLookup]![MatchMWeight]) AND ((QryItemQtyProductLineLinked.DFLT_VENDOR_ID)=[Forms]![FrmProductLineLookup]![MatchVendor]));

Thank you in advance for any help!

View 2 Replies View Related

Wildcard Criteria With Input Box

Feb 28, 2008

hi,

new to the forum so hello everybody,
what i have is a table of contacts. this table has a field called locations. i have created a queriy that askes me the location which works ok. i could also have the criteria that has like "lo*" in it

but what i really need it the query to run ask me the location and i only put in LO* OR BI* etc
and the results i get are either london or birmingham etc

thanks for you help
steve

View 2 Replies View Related

Date Queries And Wildcard

Jan 24, 2007

Hi
I am looking for ways to sort date columns.
Something like find all in one particular month, or year.

I know i have done this before to sort data into monthly queries,
but now i have forgotten
>> something like ="#*/7/*#" to sort all date on the 7th month.



By the way I cannot seem to get access to format dates in the
dd/mm/yy format, does anyone know if there is an option for this.

cheers

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved