I have tried just about everything that I can think of, so now I turn to you all for help!
I have created a form (titled "OAG") with an unbound textbox titled "DOW". I also have a Query that I have set up to return results using the abbreviations for the day of the week, and periods when that day is not present. For example, if the pattern is Monday, Wednesday, Friday, the query shows it as "Mon.Wed.Fri.." (periods replace Tues, Thurs, Sat, and Sun). There are several thousands of records with this type of pattern.
When I type in "Like *Mon*" in the criteria for the query, it returns only those results that contain Monday... which is perfect. However, I would like to link the form to the query so that when I type in "Mon" in the text box on the form, and then run the query, only the records that contain "Mon" show. I have created a report and a command button so that ultimately when I work out all the kinks, I can click the command button on the form and a report will pop up showing only the records that contain those days that I typed into the box.
I have tried to type "[Forms]![OAG]![DOW]" into the criteria of the query to link the two, but no data returns when I test it. I have also tried just about every combination of "Like" "Mon" "*" and "[Forms]![OAG]![DOW]" that I can possibly think of.
Any suggestions? I have the sql code available if needed... any help is GREATLY APPRECIATED!!
4 3647
I have tried just about everything that I can think of, so now I turn to you all for help!
I have created a form (titled "OAG") with an unbound textbox titled "DOW". I also have a Query that I have set up to return results using the abbreviations for the day of the week, and periods when that day is not present. For example, if the pattern is Monday, Wednesday, Friday, the query shows it as "Mon.Wed.Fri.." (periods replace Tues, Thurs, Sat, and Sun). There are several thousands of records with this type of pattern.
When I type in "Like *Mon*" in the criteria for the query, it returns only those results that contain Monday... which is perfect. However, I would like to link the form to the query so that when I type in "Mon" in the text box on the form, and then run the query, only the records that contain "Mon" show. I have created a report and a command button so that ultimately when I work out all the kinks, I can click the command button on the form and a report will pop up showing only the records that contain those days that I typed into the box.
I have tried to type "[Forms]![OAG]![DOW]" into the criteria of the query to link the two, but no data returns when I test it. I have also tried just about every combination of "Like" "Mon" "*" and "[Forms]![OAG]![DOW]" that I can possibly think of.
Any suggestions? I have the sql code available if needed... any help is GREATLY APPRECIATED!!
Have you tried
Like "*" & [Forms]![OAG]![DOW] & "*"
I have tried just about everything that I can think of, so now I turn to you all for help!
I have created a form (titled "OAG") with an unbound textbox titled "DOW". I also have a Query that I have set up to return results using the abbreviations for the day of the week, and periods when that day is not present. For example, if the pattern is Monday, Wednesday, Friday, the query shows it as "Mon.Wed.Fri.." (periods replace Tues, Thurs, Sat, and Sun). There are several thousands of records with this type of pattern.
When I type in "Like *Mon*" in the criteria for the query, it returns only those results that contain Monday... which is perfect. However, I would like to link the form to the query so that when I type in "Mon" in the text box on the form, and then run the query, only the records that contain "Mon" show. I have created a report and a command button so that ultimately when I work out all the kinks, I can click the command button on the form and a report will pop up showing only the records that contain those days that I typed into the box.
I have tried to type "[Forms]![OAG]![DOW]" into the criteria of the query to link the two, but no data returns when I test it. I have also tried just about every combination of "Like" "Mon" "*" and "[Forms]![OAG]![DOW]" that I can possibly think of.
Any suggestions? I have the sql code available if needed... any help is GREATLY APPRECIATED!!
Try this syntax in the criteria row of your query:
Like "*" & Forms![OAG]![DOW] & "*"
Try this syntax in the criteria row of your query:
Like "*" & Forms![OAG]![DOW] & "*"
Great minds eh PDB!!
Good to see you out and around. Hope all is well.
J
Great minds eh PDB!!
Good to see you out and around. Hope all is well.
J
Jeff!!
Have been so busy lately that I did not even realize that anybody had responded to this post until now. Hope you are happy in your new job and wishing you the best.....I am sure you are showing them the way it's done....
pDog
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Bill Brinkworth |
last post by:
I want the user to type in part of a word, and I want to return all words
from an Access word table that contains specified letters. If they were to
type "fe??", it should return all words in the...
|
by: Adam Short |
last post by:
I've never needed it before but now I do!
Does anyone know if you are able to perform a NOT Like search using Classic
ASP ADO?
i.e. myData.Filter = "Ref NOT LIKE '*1234*'"
by the way this...
|
by: joshsackett |
last post by:
I am starting an encryption project for my database and I'm performing
some tests on decryption speed. A lot of my application queries use a
LIKE parameter in the WHERE clause. To keep from...
|
by: Big John |
last post by:
in Access 2003 I am trying to get sql query to run using a field as
input, but I want to input into the field a value that uses the "like"
operator to find any value that starts with the value...
|
by: S. van Beek |
last post by:
Dear reader,
How can I filter a numeric field with Like as criteria in a query.
To filter a numeric field with <10 as criteria this will com back with the
result of those records for which...
|
by: Bruce Lawrence |
last post by:
Ok, I'm baffled...
I'm making a query in access 97 between 2 tables. There is a field in
both tables called "DWGNO".
OPENORD has a record with a DWGNO of "00000012345"
DIEDATA has a record...
|
by: brino |
last post by:
hi all !
i want to use the "like" function in a query but i want the user to
enter the search variable.
i have tried "like" but this doesnt return any
results for some reason.
any ideas ???
...
|
by: Drum2001 |
last post by:
Hello All!
I am using the following code during an On Click event for a button.
It works properly to create a query for a report:
Private Sub Command14_Click()
If IsNull(Me.Text30) Then
' No...
|
by: MLH |
last post by:
If I drop Like "*ABC*" in a QBE grid criteria cell,
the records returned include mixed case. Can I
force the uppercase limitation in a QBE grid?
|
by: erikbower65 |
last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps:
1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal.
2. Connect to...
|
by: linyimin |
last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
|
by: erikbower65 |
last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA:
1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
|
by: kcodez |
last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)
The start time is equivalent to 19:00 (7PM) in Central...
|
by: Taofi |
last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same
This are my field names
ID, Budgeted, Actual, Status and Differences
...
|
by: DJRhino |
last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer)
If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _
310030356 Or 310030359 Or 310030362 Or...
|
by: lllomh |
last post by:
How does React native implement an English player?
|
by: DJRhino |
last post by:
Was curious if anyone else was having this same issue or not....
I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
| |