I'm using a select query to attempt to create a list of jobs available to be booked onto. However i get multiple records due to the relationship between
job>booking<Engineer
The form it is being used on the booking form as a subform. the query is called "Current Available Jobs"
if anyone has any suggestions would be really appreciated!
Paul
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 RelatedHi everyone
when I open my form i SET UP A QUERY IN THE CONTROL SOURCE that would only selected records that I wanted. That part work fine. The problem that I have its when i get to the last record , how do you determine that you are at the last filtered record?
hi all
is it possible to use a check box to excecute different parts of a query? or to select which queries i want to run. and if so how can i do this.
Ex...
i run different queries on different tables all the time...table names change but they have the same columns and thus my query stays the same except for the table name. but i don't run all the queries on all the tables,,,how can i select, using a check box, which queries i want to run???
please help
regards
I'm looking to create a query which I can use to produce a report. In one of my tables I have an "In Progress" check box.
I'd like to create a query which will show all records with the "In Progress" box checked. I'm just not sure what to enter in the criteria field in the query.
hi,
can anyone help i don't know how to show all the records that have been checked in a check box. Do i need to use the expression builder??
thx in advance
I have a form that has unbound check boxes on it. They are linked to a query. The query has the following script in the criteria section
[Forms]![frmTEST]![Check0]
This is set up so that when I put a check in the checkbox and press the control button it envokes the query. I have 6 boxes on the form with the same script for the exception of the [Check0] number.
Right now the way it is set up I have to check the exact sequence in order to get any data. Is there a way that I can simply check a box and pull up all the records that are checked. (Ex. I check "Box 1" and push the control button. I want it then to show me all the records that have a check in "Box 1" regardless of what the other check boxes are.) So far I have not found a way to do this.
Hi
I have a form that displays the results from a query.
I have a check box that users select in order to show they want to print that record
However, it has stopped letting me change the check box, and simply gives me the helpful windows 'bing' when I click on it.
All the controls are set to allow me to write to it.
Has anyone got any ideas of why this might happen?
Cheers
Ben salt
P.S. If I go into the table directly, I can still change the status of the check box
Hello,
I have a form that has a check box on it. I have a query that calls all records where the check box is checked.
Once I peform my required action using the query I want to change all of the check boxes back to "Not Checked"
Is this possible? Currently I open the query and manually uncheck them.
Thanks!
I have a form I am creating from a query that has numerous yes/no checkboxes. I have been able to enter over 2/3rds of the yes/no boxes. However, I'm trying to enter the last of these into the form, and they suddenly change to text boxes. When I go back and check the query, they have also changed to text boxes there as well. I've checked and re-entered the data from the table to the query and finally to the form again. Same thing happens everytime. Any idea what's going on here?
Thank you ~
How do I make a simple query check to see if an query gives any match.
The background is that I want to do a checkup if a customer is already in the table before the user enter a new one.
As it is now a form popups after the user have entered a name for the new customer. In the popup I list all customer that match.
What I want to do is to not show the popup if there is no match.
I open the popup with DoCmd.OpenForm with filter information.
Is there something like
if currentdb.execute("select * from customers where name LIKE '*" & name & "*') = true then .....
I have a filed and I want to find out its length then in the next column i have to add the data like if filed 1's length is 1 then it should be 000+field1.value, if it is 2 then 00+field1.value, if it is 3 then 0+field1.value and so on...any help is appreciated , thanks
View 2 Replies View RelatedI have a query that has several checkbox fields. When I open the query it shows the checkbox not the value (see attached 1), when I export the data it comes into excel as TRUE and FALSE. Is there a way I can in the query show the value ie True or False and secondly add some code in the query that takes a True value and makes it say something else like "BOB".
View 2 Replies View RelatedHi. I have a load of records, that some of the first letter of a field, are not capitals, otherwise they are ok. the are loads of them though, so would take too long to go through by hand, is there a query i can run, to check it and change it if not?
Thanks
Alex
I have a query problem that I have had no luck solving either through books or other post on this fourm. It might be because of my lack of Access skills or just might not be possible. I have a query that looks at one field in a table to count how many records have the check box checked. It works great when the query can find at least one as it reports it back, but when there are none with the boxes checked it comes back blank. What I really need it for when there are no records checked for it to come back with a 0. I have tried using NZ with no luck. If anyone has a solution to this either using NZ or some other way please let me know. Also please explain in beginner terms as Im still learning.
Thanks in advance
Can someone tell me why my check box selections on my form aren't inputting into my table?**BlueStreak and Rework are check boxes on both the form and tableINSERT INTO tblRules ( Origin, Destination, [Road to], Train, Block, Junction, [T/C], [L/E], [S/R], BlueStreak, Rework )SELECT Forms!AddForm!txtOrigin AS Expr1, Forms!AddForm!txtDestination AS Expr2, Forms!AddForm!txtRoad AS Expr3, Forms!AddForm!txtTrain AS Expr4, Forms!AddForm!txtBlock AS Expr5, Forms!AddForm!txtJunction AS Expr6, Forms!AddForm!txtTC AS Expr7, Forms!AddForm!txtLE AS Expr8, Forms!AddForm!txtSR AS Expr9, Forms!AddForm!chkBlueStreak AS Expr10, Forms!AddForm!chkRework AS Expr11;
View 14 Replies View RelatedI made a database on a survey that I want my agency to fill out and return. I need to know how many checked off yes for each question. I can't figure out how to run the query to get the count of all of the check marks.
Please help!
All,
I have a problem building a query using multiple check boxes. The situation is as follows:
I have a database to monitor enquiries which come into a central email account. I have devised a system where several check boxes are used to define the nature of the enquiry. Users can tick any number or none of the options to describe the enquiry.
I would like to create a query where users can search the database based on the check boxes which have been ticked. For example, if users want to search for enquiries where a specific three check boxes have been ticked, I would like all of the records where these three boxes are checked to appear, and so on for all different combinations of check boxes ticked.
I've tried a few methods, including creating a seperate form for the query where users check their search criteria in line with the enquiry form, but I can't link this with the original form.
I hope my description adequetly conveys the problem I have!
Any thoughts would be most welcome.
Rob
:confused:
Hello all,
I have a form that looks at my "master table" where users put in general info about a sheet of material.
There are two combo boxes on this form, Batch# and Lot#. They will use the same Batch# and Lot# for many sheets. Every time a new batch and lot are entered, this will bring up a pop-up form where the user needs to take a measurement of that batch and lot for QA. This will go into a different table, where the batch and lot #'s are unique(many of the same batch#'s with different Lot#'s).
After the lot# is entered, I want to run a query in VB that looks for those unique identifiers, and if it doesn't find a record, my pop-up form will run.
This is probably something very easy....... It was a very long weekend and I'm tired of thinking.
Thanks
Scott
I am running a simple query. Three Fields
Customer
Standard SLA
Non Standard SLA
The two SLA fields are Check boxes. I wish for the query to bring back only the customer name if the check box is ticked. I have tried putting Yes, True and -1 in the criteria. Some come back with no results and others come back with all the Customers listed even though not all have the field checked. What should my criteria be to only show the checked boxes. What am I missing?
Alan
i am very new to access and even vba. I have a form called FrmAgent. Here there are 5 check boxes [CheckBob] [CheckJim] [CheckNikita] [CheckNoe] [CheckKyle]. I have one button named "RecieveData". I have one table named "Agent" and a query called "QryAgent". in the same column there are five people Bob Jim Nikita Noe and kyle. What i need is to have the button when its clicked run my query to produce the data. However, if multiple boxs are checked i need the data for those people. As of right now if i click the button (doesnt matter how many boxs are checked) it gives me data for all five people. Is there a way i can do this where i can receive the data only for the people that their boxs are marked?
View 2 Replies View Relatedhaving 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......
Good Day!
I have a simple table where the user enter expiry date for visa. User also enter return date of visa holder.
I am looking for a way whereby, every time I start my database a report is automatically sent if Visa Expiry daye is close to departure date.
I already have the query and the report based on it, but how to have this checked and sent?
This is in my query
VISA_CHECK: IIf([Visa_LOI_end_date]-[Return Date]<7,'Fail','Pass')
If it fails this should trigger the report being sent.
I hope I have been clear and that someone can help.
Thank you in Advance
Enrico
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 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?