I want to run query by using a criteria on a checkbox. The query will output the list of records if user has selected the check box. How can I write my criteria? :confused:
Thanks a bunch for any help advance...
having used a query to generate data from a set of records where i can select the criteria (they are two letter abrv and are in a single field in the table but there may be multiple criteria). As I would like others to do it without using the query my first thought was a form with a series of check boxes tick for inclusion in the query or not. As i have built the query am I looking at changing that or taking it all into VB and using some code to pull the relavant 'ticks' across............ and how the hell would i do that......
many thanks in anticipation......
having used a query to generate data from a set of records where i can select the criteria (they are two letter abrv and are in a single field in the table but there may be multiple criteria). As I would like others to do it without using the query my first thought was a form with a series of check boxes tick for inclusion in the query or not. As i have built the query am I looking at changing that or taking it all into VB and using some code to pull the relevant 'ticks' across............ and how the hell would i do that......
many thanks in anticipation......
I have a table(Product Change) with these fields:
Tracking Number
Approved (a check box)
Engineering (text box that represents department)
Purchasing (text box that represents department)
Quality (text box that represents department)
Production (text box that represents department)
Customer Service (text box that represents department)
I want my query results to show all records that have the "Approved" check box...checked, and then only the records that have one of the Department fields with a null value.
So I'm looking to see only records that are "Approved" and out of those....only the records with at least one department field empty(Null).
Any help doing this is SQL view would be great...or even design view.
I have 3 queries populating 3 subreports on a report, i have a checkbox on my main form i launch the report from - i reference it in a filter on the form to ignore certain error types - id like it do to the same in the queries that populate the reports
So the reports atm give - an over all count of error types, a count per person and then a breakdown on type per person
Thats all fine but id like the option to ignore one type of error (as we sometimes look at it and sometimes dont).
I need to pass values of my two check boxes on my Form
Check box US and Check Box Canada
if both checked the criteria would be "UD", "ud',"b","B","us","US","CD","cd"
if Canada check box checked criteria would be "cd","CD"
if US only checked criteria would be UD", "ud',"b","B","us","US"
how to write the criteria statement on the query?this probably would be a complicated iff statement?
What is wrong with this criteria...
RecSet.FindFirst ("[SomeField] = '" & mMESTO & "'") and ([CheckField] = True)
I would like to make a DLookup that check 2 criteria in two different columns in the same table. The reason to use a DLookup is that I would like to check if two parts already have been linked together. The user therefore selects two values in to different comboboxes (lstLinkPart and lstLinkToPart). In this case the value of the first combobox is column: ComponentPN in tblProductLinkComponent. For the second (lstLinkToPart) column ProductPN, in the same table, has to be checked.
If both values from the comboboxes match the values in both (and only) columns I don't want to continue and made a code to be executed.
I found multiple examples on the internet for using multiple criteria but something similar to what I require.
I have a form with a check box. A query is run that looks at that check box and decides what the criteria are based on that. So, if the check box is checked, it should pull in all data in the field that is a Y. If it is not checked, i want it to pull all data (Y's and N's and blanks).
here is my criteria:
IIf([Forms]![frm_Query_Form]![CheckBox]<>0,"Y","*")
This does not seem to work. I have also tried:
IIf([Forms]![frm_Query_Form]![CheckBox]<>0,"Y")
IIf([Forms]![frm_Query_Form]![CheckBox]<>0,"Y",Like "*")
IIf([Forms]![frm_Query_Form]![CheckBox]<>0,"Y","like "*"")
how can i make a image appear in my form when there is a check in the check box from the table?
View 14 Replies View RelatedLong time lurker, first time poster.
I'm in need a of a check-in/check-out application for my company. We have about 550-600 employees at any given time and our turnover is about 20-30% per year. Our check-in/check-out process requires our employees to personally visit between 30-40 areas in our company (personnel, safety, credentials, parking, insurance, etc) within the first month of employment. This is currently done manually and is a huge drain on labor, especially when check-in sheets are lost, misplaced or, in some cases, forged.
I'm looking to build a database that would be intranet based, password secure (by check-in area) that would allow the new employee to present at a particular check-in, check-out site, complete that portion of the check-in/out process and then allow the person responsible for the check-in/out to enter the status into the database. At any point in the process, I would want to know the status of the person checking in/out (how long they've been checking in/out and what portion of the process have they completed).
Can this be done in ACCESS?
Thanks
Hi
I have sendkey "{f7}" on loss focus.
this works great as a spell check but then I get the mesage box that spell check is complete.
How do I stop this box from occuring?
I have set up a database that stores actions (i.e jobs). In the table; two of the fields are...'required completion date' and 'actual completion date'. I wish to lookup, by using a query, all of the open actions (those which havent yet been complete (i.e the 'actual completion date' is null)) and then later on all those which are overdue (i.e the 'actual completion date' is null And the 'required completion date' <today....this being the criteria for an overdue action).
However, I have used a form which has a combo box which contains the values open and overdue. When a selection has been made I want a form to display with the results depending on the selection that has been made. I am capable of creating a form based on a query, but am unsure of how to construct the query with the correct criteria based on the option that is selected from the form.
Any help would gratefully be appreciated. Thanks
I created a form that allows the user to choose the criteria that they want to see on a report using =Forms!formname!controlname in my query. It works great but I want to also allow the user to choose nothing and return all records instead of limiting them to choose just one type of record. Is this possible? Before I created the form my query had the [Enter parameter] on one criteria line and [Enter parameter] Is Null on the next criteria line and that was working great for my use but I need to create a simple form for other users.
View 1 Replies View RelatedI have data for hundreds of stores. The data was pulled for the top 15 items by store, so I cannot obtain only the top 5 items that I need. How can I query this data to extract only the top (or bottom) 5 Subjects, by store, based on the percentage column?
StoreSubjectSalesSales %
1516Fiction56431.5-24.15%
1516Audio Unabridged1650.8-231.04%
1516History / Military History10081.1-29.99%
1516Role Playing / Graphic Novels14773.9-20.27%
1516Mystery13152.6-19.84%
1516Audio Abridged1785.9-141.84%
1516SciFi / Fantasy27535.3-7.93%
1516Juv Audio/Video1580.6-100.13%
1516Biography8103.6-15.89%
1516Sports7910.8-15.64%
1516Current Affairs / Law8141.9-14.34%
1516Reference7183-16.22%
1516Juv Non-Bk4585.9-25.02%
1516Science / Tech2961.4-33.98%
1516Movies / TV / Music / Dance3395.3-29.46%
1872Fiction307344.3-7.49%
1872Business134307.5-13.48%
1872Psych / Self Improvement100650.4-10.05%
1872Audio Unabridged29165.9-27.32%
1872Cookbooks57463.3-13.56%
1872Computers59235.7-12.37%
1872Regional59883.4-11.22%
1872Health & Fitness64713.8-10.29%
1872Maps19358.4-27.66%
1872Current Affairs / Law47927.1-11.08%
1872Travel Foreign42583.7-12.27%
1872Religion / Bibles80255.6-6.07%
1872SciFi / Fantasy67641.4-6.49%
1872Study Aids / Notes38299-11.24%
1872Games41745.1-9.79%
Does anyone know or have an example of how to use check box's to filter out things in a form. What I want to do here is I have like 5 different locations and I want to be able to choose which of those location, whether it be one or more checked at a time and then have whatever those check boxes are checked to be filtered out.
View 1 Replies View RelatedHello,
I have a continious form containing data from the table "tblToernament".
On that form there is a combobox containing teams that are stores in the table "tblTeams".
The table looks like this:
ID | TeamName
1 | Team01
2 | Team02
3 | Team03
4 | Team04
When I select, for example, Team02 in the combobox I want that value on, after I selected it from the combo NOT to be in the combobox.
Can anybody please help me on this?
Hello, im making a database for a charity as part of my work experience and id just like someone to check over it for me. If you see any issues please let me know. Im already aware of changing text PK's to autonumber, this is a prototype so im not going to change the PK's at the min.
Any ideas, or ways to improve it?
You can find the LDM or ER-D here: (i understand that it may be difficult for you to follow since you dont know the system! But please have a go...) 17447
Thanks very much for your help.
Ant...
Hey guys..
I was working on my project again as usual, which is about transaction of cars coming in and going out (car pool system), So i created a table then a form for this. In the table, i put the option of 'Yes/No'. So, for the form, i want to create a search system which will include a search system.
My Idea:
I want to make a check box, as a search system, so when it is checked and clicked on a command button, it searches for all records with 'Yes'. and if not checked, and clicked on command button, then it searches for all records with 'No'.
Now i did my research, on google and stuff also in the access help but it ddnt help much.
To be honest with you guys, i dont know much of visual basic writing, but i do understand most of it. ( you know, when you understand one language but can speak it?? same way :o ).
So i would request some one to give me instructions on this one. It would really be appriciated.
thanks a million !
Do check boxes have to be bound to be able to save them in your forms? In other words, when you check the box and click save, does the check box have to be bound so that the check mark can be saved? Thanks.
View 6 Replies View RelatedI want to connect a single check box to a record of check boxes, so that when it is on yes (checked) all the other boxes are yes (checked) automatically. How do I go about doing this? Is there an expression I can build for it?
:confused:
Hi,
Is it possible to change the size of a check box? When I modify the height and width of the checkbox it doesn't appear to do anything.
Thanks
Kabir
Hi,
I know there is probably a simple answer to this question, but im wondering if there is a way to make the value of a "true" checkbox anything but -1. i'd like the checked box to display a positive 1 in the corresponding table, so that they may be added up for a further query.....
i am working with IIF statements now with no luck,
Please tell me how i can fix it, and if there is a simple way of changing the value to a positive number, or even to a letter or word!
Cheers!
Em
I have a access form that when a user clicks a button it runs a report for that particular record. When the user clicks this button to run the report I would like to have a check box or whatever else you recommend on the form that would become checked once the user runs this report so that they will know that they have already ran a report for this record. If they try to run it again a msg box will appear letting them know that a report has already been created but if they want they can run it again. Any Ideas or HELP?????
THANKS!!!!!!!!!!!!!!
how do you check if a check box is checked?
I have tried this but it does not work...
If Me.Check25.value = "no" Or Me.Check25.value = "" Then
MsgBox "You must agree to the terms below.", vbOKOnly, "Required Data"
Me.Check25.SetFocus
Exit Sub
End If
What the easiest way to turn text to an integer - ir have vaiable defined as long and an inputbox - want to keep asking for an input until I get an integer.
Have IsNumeric - can this be applied to int.
Or could I use localised error handling?
Thanks