473,714 Members | 2,330 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Check Boxes to Pass into Query

ChaseCox
294 Contributor
I would like to use a Check Box, or several check boxes, that will allow a user to select differnent product lines. The user should be able to select one or many. I also need each check box to reference numerous product codes, becuase each product line has several 4 digit codes, each unique to its product line. For example:

All of the Happy Lines Codes might be 0412, 0413, 0456, 0458
All of the Sad Lines Codes might be 0524, 0544, 0569, 0588

thanks.
Jan 9 '07
71 6313
NeoPa
32,569 Recognized Expert Moderator MVP
I've redone post #4 with a little more detail.
If you need more help you'll need to post the names of the fields; tables; queries; etc you are using (as well as the SQL of the query(s) of course).
1. Create CheckBoxes called chkHappy; chkSad; etc.
2. Add Event procedures for the AfterUpdate event of each CeckBox of this form :
Expand|Select|Wrap|Line Numbers
  1. Private Sub chkHappy_AfterUpdate()
  2.     Call MakeFilter
  3. End Sub
  4.  
  5. Private Sub chkSad_AfterUpdate()
  6.     Call MakeFilter
  7. End Sub
  8. ... etc for all CheckBoxes
3. Create the procedure :
Expand|Select|Wrap|Line Numbers
  1. Private Sub MakeFilter()
  2.     Dim strFilter As String
  3.  
  4.     'Reset strFilter to empty string
  5.     strFilter = ""
  6.     If chkHappy then
  7.         strFilter = strFilter & ",'0412','0413','0456','0458'"
  8.     End If
  9.     If chkSad then
  10.         strFilter = strFilter & ",'0525','0544','0569','0588'"
  11.     End If
  12.     '... etc for all CheckBoxes
  13.     If strFilter > "" Then _
  14.         strFilter = "([YourField] In(" & Mid(strFilter,2) & "))"
  15.     Me.Filter = strFilter
  16.     Call Me.Requery
  17. End Sub
Jan 11 '07 #11
ChaseCox
294 Contributor
Tables: Generic Material, Generic Labor
Queries: Material Query, Labor Query
Expand|Select|Wrap|Line Numbers
  1.  
  2. Private Sub chkipk_AfterUpdate()
  3.  
  4. Call MakeFilter
  5.  
  6. End Sub
  7.  
  8. Private Sub chkody_AfterUpdate()
  9.  
  10. Call MakeFilter
  11.  
  12. End Sub
  13.  
  14. Private Sub chkpre_AfterUpdate()
  15.  
  16. Call MakeFilter
  17.  
  18. End Sub
  19.  
  20. Private Sub chkvoy2_AfterUpdate()
  21.  
  22.  Call MakeFilter
  23.  
  24. End Sub
  25.  
  26.  
  27. Private Sub chkvoy3_AfterUpdate()
  28.  
  29.  Call MakeFilter
  30.  
  31. End Sub
  32.  
Expand|Select|Wrap|Line Numbers
  1. Private Sub MakeFilter()
  2.  
  3.  
  4.  
  5.     Dim strFilter As String
  6.  
  7.     strFilter = ""
  8.     If chkvoy2 Then
  9.         strFilter = strFilter & ",'0463','0465','0467'"
  10.     End If
  11.     If chkSad Then
  12.         strFilter = strFilter & ",'0382'"
  13.     End If
  14.  
  15.     If strFilter > "" Then _
  16.        strFilter = "([Material Query]![PROD_CODE]  In(" & Mid(strFilter, 2) & "))"
  17.        Me.Filter = strFilter
  18.        Call Me.Requery
  19.  
  20. End Sub
  21.  
Some Questions and Points:

1. When I select a check box, is this code passing the selection into the query? Or how do you do that?

2. Does this string of code allow multiple check boxes to be selected?

3. Do I need to place some code in my query to let it know to look at these boxes?

4. Does this code cause the query to run? I need it to wait unti l the user clicks the appropriate run query button.



This is the code for the query mentioned in my string of code above. it is for material. The field name is Prod_Code
Expand|Select|Wrap|Line Numbers
  1. SELECT [Generic Material].CLAIM_NBR, [Generic Material].DETAIL_NBR, [Generic Material].CLAIM_TYPE_DESCR, [Generic Material].[CLAIM DATE], [Generic Material].[SHIP DATE], [Generic Material].PROD_CODE, [Generic Material].PROD_CODE_DESCR, [Generic Material].RFC_CODE, [Generic Material].PROD_GRP, [Generic Material].RFC_FAILURE_DESCR, [Generic Material].RFC_FAILURE_MAT_IND, [Generic Material].RFC_FAILURE_LBR_IND, [Generic Material].RFC_LEVEL_ONE_DESCR, [Generic Material].RFC_LEVEL_TWO_DESCR, [Generic Material].RFC_LEVEL_THREE_DESCR, [Generic Material].RFC_LEVEL_FOUR_DESCR, [Generic Material].RFC_SHORT_DESCR, [Generic Material].BU_ID, [Generic Material].PART_PART_NBR, [Generic Material].PART_DESCR, [Generic Material].SUBMIT_OFFICE_NAME, [Generic Material].PARENT_SERIAL_NBR, Mid([ORDERED_MODEL],1,38) AS [Model Number], [Generic Material].COST_CENTER, [Generic Material].ACCOUNT, [Generic Material].TASK_CODE, [Generic Material].TASK_DESCR, [Generic Material].SALES_ORDER_PRIME, [Generic Material].[DATE ENTERED], [Generic Material].[DATE APPROVED], [Generic Material].[DATE STARTED], [Generic Material].[DATE FAILED], [Generic Material].DETAIL_QTY, [Generic Material].SumOfEXP_TYPE_AMOUNT, [Generic Material].CLAIM_JOB_NAME
  2. FROM [Generic Material]
  3. WHERE ((([Generic Material].[CLAIM DATE]) Between [Forms]![Form1]![cmbcd] And [Forms]![Form1]![cmbcde]) AND (([Generic Material].[SHIP DATE]) Between [Forms]![Form1]![cmbsd] And [Forms]![Form1]![cmbed]) AND (([Generic Material].RFC_LEVEL_ONE_DESCR) Like ("*" & [Forms]![Form1]![cmbrfcl1dscr] & "*")) AND (([Generic Material].RFC_SHORT_DESCR) Like ("*" & [Forms]![Form1]![cmbrfcsd] & "*")) AND (([Generic Material].PART_PART_NBR) Like ("*" & [Forms]![Form1]![cmbpn] & "*")) AND ((Mid([ORDERED_MODEL],1,38)) Like ("*" & [Forms]![Form1]![cmbm1] & [Forms]![Form1]![cmbm2] & [Forms]![Form1]![cmbm3] & [Forms]![Form1]![cmbm4] & [Forms]![Form1]![cmbm5] & [Forms]![Form1]![cmbm6] & [Forms]![Form1]![cmbm7] & [Forms]![Form1]![cmbm8] & [Forms]![Form1]![cmbm9] & [Forms]![Form1]![cmbm10] & [Forms]![Form1]![cmbm11] & [Forms]![Form1]![cmbm12] & [Forms]![Form1]![cmbm13] & [Forms]![Form1]![cmbm14] & [Forms]![Form1]![cmbm15] & [Forms]![Form1]![cmbm16] & [Forms]![Form1]![cmbm17] & [Forms]![Form1]![cmbm18] & [Forms]![Form1]![cmbm19] & [Forms]![Form1]![cmbm20] & [Forms]![Form1]![cmbm21] & [Forms]![Form1]![cmbm22] & [Forms]![Form1]![cmbm23] & [Forms]![Form1]![cmbm24] & [Forms]![Form1]![cmbm25] & [Forms]![Form1]![cmbm26] & [Forms]![Form1]![cmbm27] & [Forms]![Form1]![cmbm28] & [Forms]![Form1]![cmbm29] & [Forms]![Form1]![cmbm30] & [Forms]![Form1]![31] & [Forms]![Form1]![32] & [Forms]![Form1]![33] & [Forms]![Form1]![34] & [Forms]![Form1]![35] & [Forms]![Form1]![36] & [Forms]![Form1]![37] & [Forms]![Form1]![38] & "*")) AND (([Generic Material].TASK_CODE) Like ("*" & [Forms]![Form1]![cmbtc] & "*")) AND (([Generic Material].TASK_DESCR) Like ("*" & [Forms]![Form1]![cmbtd] & "*")) AND (([Generic Material].[DATE STARTED]) Between [Forms]![Form1]![cmcsd1] And [Forms]![Form1]![cmcsd2]) AND (([Generic Material].[DATE FAILED]) Between [Forms]![Form1]![cmcfd1] And [Forms]![Form1]![cmbfd2]))
  4.  
Jan 11 '07 #12
ChaseCox
294 Contributor
updated code:

Expand|Select|Wrap|Line Numbers
  1. Private Sub MakeFilter()
  2.  
  3.  
  4.  
  5.     Dim strFilter As String
  6.  
  7.     strFilter = ""
  8.  
  9.     If chkvoy2 Then
  10.         strFilter = strFilter & ",'0463','0465','0467'"
  11.     End If
  12.  
  13.     If chkvoy3 Then
  14.         strFilter = strFilter & ",'0382'"
  15.     End If
  16.  
  17.     If chkipk Then
  18.         strFilter = strFilter & ",'0383','0393','0422'"
  19.     End If
  20.  
  21.     If chkody Then
  22.         strFilter = strFilter & ",'0419','0411','0416','0418'"
  23.     End If
  24.  
  25.     If chkpre Then
  26.         strFilter = strFilter & ",'0281','0282','0279','0280','0284','0287','0513','0514','0515','0516','0517','0518'"
  27.     End If
  28.  
  29.     If chkwsp Then
  30.         strFilter = strFilter & ",'0328','0331','0176','0075','0326','0332','0042','0142'"
  31.     End If
  32.  
  33.     If chkchil Then
  34.         strFilter = strFilter & ",'0361','0362','0385','0386'"
  35.     End If
  36.  
  37.     If strFilter > "" Then _
  38.        strFilter = "([Material Query]![PROD_CODE]  In(" & Mid(strFilter, 2) & "))"
  39.        Me.Filter = strFilter
  40.        Call Me.Requery
  41.  
  42. End Sub
  43.  
Jan 11 '07 #13
NeoPa
32,569 Recognized Expert Moderator MVP
Tables: Generic Material, Generic Labor
Queries: Material Query, Labor Query
Expand|Select|Wrap|Line Numbers
  1.  
  2. Private Sub chkipk_AfterUpdate()
  3.  
  4. Call MakeFilter
  5.  
  6. End Sub
  7.  
  8. Private Sub chkody_AfterUpdate()
  9.  
  10. Call MakeFilter
  11.  
  12. End Sub
  13.  
  14. Private Sub chkpre_AfterUpdate()
  15.  
  16. Call MakeFilter
  17.  
  18. End Sub
  19.  
  20. Private Sub chkvoy2_AfterUpdate()
  21.  
  22.  Call MakeFilter
  23.  
  24. End Sub
  25.  
  26.  
  27. Private Sub chkvoy3_AfterUpdate()
  28.  
  29.  Call MakeFilter
  30.  
  31. End Sub
  32.  
Expand|Select|Wrap|Line Numbers
  1. Private Sub MakeFilter()
  2.  
  3.  
  4.  
  5.     Dim strFilter As String
  6.  
  7.     strFilter = ""
  8.     If chkvoy2 Then
  9.         strFilter = strFilter & ",'0463','0465','0467'"
  10.     End If
  11.     If chkSad Then
  12.         strFilter = strFilter & ",'0382'"
  13.     End If
  14.  
  15.     If strFilter > "" Then _
  16.        strFilter = "([Material Query]![PROD_CODE]  In(" & Mid(strFilter, 2) & "))"
  17.        Me.Filter = strFilter
  18.        Call Me.Requery
  19.  
  20. End Sub
  21.  
Some Questions and Points:

1. When I select a check box, is this code passing the selection into the query? Or how do you do that?

2. Does this string of code allow multiple check boxes to be selected?

3. Do I need to place some code in my query to let it know to look at these boxes?

4. Does this code cause the query to run? I need it to wait unti l the user clicks the appropriate run query button.



This is the code for the query mentioned in my string of code above. it is for material. The field name is Prod_Code
Expand|Select|Wrap|Line Numbers
  1. SELECT [Generic Material].CLAIM_NBR, [Generic Material].DETAIL_NBR, [Generic Material].CLAIM_TYPE_DESCR, [Generic Material].[CLAIM DATE], [Generic Material].[SHIP DATE], [Generic Material].PROD_CODE, [Generic Material].PROD_CODE_DESCR, [Generic Material].RFC_CODE, [Generic Material].PROD_GRP, [Generic Material].RFC_FAILURE_DESCR, [Generic Material].RFC_FAILURE_MAT_IND, [Generic Material].RFC_FAILURE_LBR_IND, [Generic Material].RFC_LEVEL_ONE_DESCR, [Generic Material].RFC_LEVEL_TWO_DESCR, [Generic Material].RFC_LEVEL_THREE_DESCR, [Generic Material].RFC_LEVEL_FOUR_DESCR, [Generic Material].RFC_SHORT_DESCR, [Generic Material].BU_ID, [Generic Material].PART_PART_NBR, [Generic Material].PART_DESCR, [Generic Material].SUBMIT_OFFICE_NAME, [Generic Material].PARENT_SERIAL_NBR, Mid([ORDERED_MODEL],1,38) AS [Model Number], [Generic Material].COST_CENTER, [Generic Material].ACCOUNT, [Generic Material].TASK_CODE, [Generic Material].TASK_DESCR, [Generic Material].SALES_ORDER_PRIME, [Generic Material].[DATE ENTERED], [Generic Material].[DATE APPROVED], [Generic Material].[DATE STARTED], [Generic Material].[DATE FAILED], [Generic Material].DETAIL_QTY, [Generic Material].SumOfEXP_TYPE_AMOUNT, [Generic Material].CLAIM_JOB_NAME
  2. FROM [Generic Material]
  3. WHERE ((([Generic Material].[CLAIM DATE]) Between [Forms]![Form1]![cmbcd] And [Forms]![Form1]![cmbcde]) AND (([Generic Material].[SHIP DATE]) Between [Forms]![Form1]![cmbsd] And [Forms]![Form1]![cmbed]) AND (([Generic Material].RFC_LEVEL_ONE_DESCR) Like ("*" & [Forms]![Form1]![cmbrfcl1dscr] & "*")) AND (([Generic Material].RFC_SHORT_DESCR) Like ("*" & [Forms]![Form1]![cmbrfcsd] & "*")) AND (([Generic Material].PART_PART_NBR) Like ("*" & [Forms]![Form1]![cmbpn] & "*")) AND ((Mid([ORDERED_MODEL],1,38)) Like ("*" & [Forms]![Form1]![cmbm1] & [Forms]![Form1]![cmbm2] & [Forms]![Form1]![cmbm3] & [Forms]![Form1]![cmbm4] & [Forms]![Form1]![cmbm5] & [Forms]![Form1]![cmbm6] & [Forms]![Form1]![cmbm7] & [Forms]![Form1]![cmbm8] & [Forms]![Form1]![cmbm9] & [Forms]![Form1]![cmbm10] & [Forms]![Form1]![cmbm11] & [Forms]![Form1]![cmbm12] & [Forms]![Form1]![cmbm13] & [Forms]![Form1]![cmbm14] & [Forms]![Form1]![cmbm15] & [Forms]![Form1]![cmbm16] & [Forms]![Form1]![cmbm17] & [Forms]![Form1]![cmbm18] & [Forms]![Form1]![cmbm19] & [Forms]![Form1]![cmbm20] & [Forms]![Form1]![cmbm21] & [Forms]![Form1]![cmbm22] & [Forms]![Form1]![cmbm23] & [Forms]![Form1]![cmbm24] & [Forms]![Form1]![cmbm25] & [Forms]![Form1]![cmbm26] & [Forms]![Form1]![cmbm27] & [Forms]![Form1]![cmbm28] & [Forms]![Form1]![cmbm29] & [Forms]![Form1]![cmbm30] & [Forms]![Form1]![31] & [Forms]![Form1]![32] & [Forms]![Form1]![33] & [Forms]![Form1]![34] & [Forms]![Form1]![35] & [Forms]![Form1]![36] & [Forms]![Form1]![37] & [Forms]![Form1]![38] & "*")) AND (([Generic Material].TASK_CODE) Like ("*" & [Forms]![Form1]![cmbtc] & "*")) AND (([Generic Material].TASK_DESCR) Like ("*" & [Forms]![Form1]![cmbtd] & "*")) AND (([Generic Material].[DATE STARTED]) Between [Forms]![Form1]![cmcsd1] And [Forms]![Form1]![cmcsd2]) AND (([Generic Material].[DATE FAILED]) Between [Forms]![Form1]![cmcfd1] And [Forms]![Form1]![cmbfd2]))
  4.  
Firstly, comments on your code :
1. You have mentioned 5 CheckBoxes (chkipk; chkody; chkpre; chkvoy2 & chkvoy3). Each of these needs to have an 'If' statement associated (In the MakeFilter procedure) to ensure it is included in the filter.
2. In your version of the following code you have indented the last two lines which are NOT associated with the If. This is not good. Also, your reference to [Prod_Code] should not specify a query name as it is actually referencing the form's Record Source rather than running any query explicitly. I have changed this version.
Expand|Select|Wrap|Line Numbers
  1.     If strFilter > "" Then _
  2.        strFilter = "([PROD_CODE] In(" & Mid(strFilter, 2) & "))"
  3.    Me.Filter = strFilter
  4.    Call Me.Requery
Your questions :
Q1. When I select a check box, is this code passing the selection into the query? Or how do you do that?
A1. Not exactly. It is telling the form that, when it runs the query that it (the form) is bound to, it should filter the records returned as specified in your string. The active part of this (as opposed to the setting up of the string etc), is done in the last two lines of the code a few lines above (Me.Filter = ...etc).

Q2. Does this string of code allow multiple check boxes to be selected?
A2. Yes.

Q3. Do I need to place some code in my query to let it know to look at these boxes?
A3. No, this is handled by the filter which is an attribute or property of the form. This means that the query will still run exactly as expected when simply opened, but can be modified for when the form is used (exclusively for the form).

Q4. Does this code cause the query to run? I need it to wait unti l the user clicks the appropriate run query button.
A4. Yes it does. The 'Call Me.Requery' line is the one that does that so if you need to disable that until later simply remove that line.

Last point.
I'm very suspicious of your [ORDERED_MODEL] selection code in the WHERE clause of your query. It looks very kludgy - but may be ok for all I know as it refers to things I know nothing of.
Jan 11 '07 #14
ChaseCox
294 Contributor
updated code:

Expand|Select|Wrap|Line Numbers
  1. Private Sub MakeFilter()
  2.  
  3.  
  4.  
  5.     Dim strFilter As String
  6.  
  7.     strFilter = ""
  8.  
  9.     If chkvoy2 Then
  10.         strFilter = strFilter & ",'0463','0465','0467'"
  11.     End If
  12.  
  13.     If chkvoy3 Then
  14.         strFilter = strFilter & ",'0382'"
  15.     End If
  16.  
  17.     If chkipk Then
  18.         strFilter = strFilter & ",'0383','0393','0422'"
  19.     End If
  20.  
  21.     If chkody Then
  22.         strFilter = strFilter & ",'0419','0411','0416','0418'"
  23.     End If
  24.  
  25.     If chkpre Then
  26.         strFilter = strFilter & ",'0281','0282','0279','0280','0284','0287','0513','0514','0515','0516','0517','0518'"
  27.     End If
  28.  
  29.     If chkwsp Then
  30.         strFilter = strFilter & ",'0328','0331','0176','0075','0326','0332','0042','0142'"
  31.     End If
  32.  
  33.     If chkchil Then
  34.         strFilter = strFilter & ",'0361','0362','0385','0386'"
  35.     End If
  36.  
  37.     If strFilter > "" Then _
  38.        strFilter = "([Material Query]![PROD_CODE]  In(" & Mid(strFilter, 2) & "))"
  39.        Me.Filter = strFilter
  40.        Call Me.Requery
  41.  
  42. End Sub
  43.  

This will not run properly, any ideas?
Jan 11 '07 #15
ChaseCox
294 Contributor
Firstly, comments on your code :
1. You have mentioned 5 CheckBoxes (chkipk; chkody; chkpre; chkvoy2 & chkvoy3). Each of these needs to have an 'If' statement associated (In the MakeFilter procedure) to ensure it is included in the filter.

I am not sure what you mean, could you please expound on this statement.

2. In your version of the following code you have indented the last two lines which are NOT associated with the If. This is not good.
Can you clarify more, please?

Last point.
I'm very suspicious of your [ORDERED_MODEL] selection code in the WHERE clause of your query. It looks very kludgy - but may be ok for all I know as it refers to things I know nothing of.
This is becuase there is a 30 digit model #. Is some instancea the user may want to only search on the 5,7,6 and 19,21, and 30 digits, since each digit means something.
Jan 11 '07 #16
ChaseCox
294 Contributor
I am having an error code thrown when I click the check box. run Time error 94. It says invalid use of null.
Jan 11 '07 #17
ChaseCox
294 Contributor
chkvoy3 is where the error takes me when I tell it to debug, I have placed that line in bold.
Expand|Select|Wrap|Line Numbers
  1. Private Sub MakeFilter()
  2.  
  3.  
  4.  
  5.     Dim strFilter As String
  6.  
  7.     strFilter = ""
  8.  
  9.     If chkvoy2 Then
  10.         strFilter = strFilter & ",'0463','0465','0467'"
  11.     End If
  12.  
  13.     If chkvoy3 Then   <this is the error code it takes me to
  14.         strFilter = strFilter & ",'0382'"
  15.     End If
  16.  
  17.     If chkipk Then
  18.         strFilter = strFilter & ",'0383','0393','0422'"
  19.     End If
  20.  
  21.     If chkody Then
  22.         strFilter = strFilter & ",'0419','0411','0416','0418'"
  23.     End If
  24.  
  25.     If chkpre Then
  26.         strFilter = strFilter & ",'0281','0282','0279','0280','0284','0287','0513','0514','0515','0516','0517','0518'"
  27.     End If
  28.  
  29.     If chkwsp Then
  30.         strFilter = strFilter & ",'0328','0331','0176','0075','0326','0332','0042','0142'"
  31.     End If
  32.  
  33.     If chkchil Then
  34.         strFilter = strFilter & ",'0361','0362','0385','0386'"
  35.     End If
  36.  
  37.      If strFilter > "" Then _
  38.        strFilter = "([PROD_CODE] In(" & Mid(strFilter, 2) & "))"
  39.    Me.Filter = strFilter
  40.  
  41.  
  42. End Sub
  43.  
Jan 11 '07 #18
NeoPa
32,569 Recognized Expert Moderator MVP
You'll find answers in my previous post.
Try to include everything in there before reposting a question.

If you can't figure it out by tomorrow then post to say that and I'll explain in more detail (but please go through my previous post carefully before you take that step).
Jan 11 '07 #19
NeoPa
32,569 Recognized Expert Moderator MVP
If you keep posting in small snippets then there will be communication problems. I was responding to your first response to my post. I will have to look through all of these later. In future, please try to organise your thoughts and your comments before posting. That really is your responsibility and you shouldn't leave it to others to do for you. You'll guess I'm not overly impressed atm. ...but I will look at this again later - when I get a chance.
Jan 11 '07 #20

Sign in to post your reply or Sign up for a free account.

Similar topics

0
2387
by: Andrew | last post by:
Hello, I am trying to create a chart whose underlying query is linked to 2 combo boxes on the same form. I want to pass the values from the combo boxes into the chart query to allow the chart data to be manipulated easily. The combo box uses "Row Source Type" = Table/Query. The "Row Source" references a query to extract a distinct list of data.
1
3095
by: Jim in Arizona | last post by:
I'm having dificulty figuring out how to process multiple check boxes on a web form. Let's say I have three check boxes: cbox1 cbox2 cbox3 The only way I can think of to code the possibilities is something like:
10
15968
by: Jim in Arizona | last post by:
I'm having dificulty figuring out how to process multiple check boxes on a web form. Let's say I have three check boxes: cbox1 cbox2 cbox3 The only way I can think of to code the possibilities is something like:
5
7422
by: jimc52 | last post by:
Hello Everyone: I am hoping one of the gurus here will give me some help. I have designed a form with some check boxes. I put the checkboxes there on the form so later I could use them as flags on separate reports. Just to answer a few questions, yes, the subform is properly tied to the main form and they are all bound controls...been there, done that. Now, the purpose of a check box, as I see it is to have two logical conditions (checked =...
2
1761
by: vibee | last post by:
this might be a simple question but how do i assign values to a check box in a query condition, i have the following so far: Required: IIf(="existing",True,False) The problem is the check boxes dissappear in the query in data sheet view, and is replaced with 1's and 0's when i want the check boxes to have check marks. Thanks to anyone who helps.
15
6774
by: martin DH | last post by:
Good morning, I have added several posts out here on a project on which I am working - thank you very much to everyone who has responded with ideas and solutions! My new question: I am drawing up some forms to use in place of "Enter Parameter Value" boxes to initiate queries. In essence the forms display all of the paramter choices (in combos, text boxes, and popup calendars). One search criterion I have is "ProcessingCenter" with five...
1
11515
by: Euge | last post by:
Hi, I really hope someone will be able to help me with this one as I am sure im just missing something simple. I have an unbound form which has 20 yes/no unbound check boxes. The purpose of the form is to allow users to tick the various fields and a subform return the results. The subform, which does requery when a check box is ticked is based off a query. Initially, I wanted all the records to display before any check boxes are ticked so...
5
6738
by: Andrew Meador | last post by:
I have a form (Change Card List by Status) with a check box (cboNOT) and a list box (lstStatus). There is an Open Report button that opens a report (Report - Change Card List) which uses a query (SQL -Change Card List). What I want to do is have the form open the report where a filter is set to use the values from the check box AND the value selected from the list box to generate the report. What I can't figure out is how to use the...
1
3612
by: jerger | last post by:
I have not made a program or page from start yet. I have made modifications to our signoff asp pages like changing the questions, texts, shortening field lengths etc... I also have copied the files and reused them for other domains asp 1: Basically I have a signoff asp script... that asks a. name b. email address (then submit).. this data is written to a sub folder's text file with the same name signoff.txt if the signoff.asp is...
0
8802
marktang
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...
0
8711
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9017
tracyyun
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...
0
7953
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5948
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();...
0
4726
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3158
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
2
2522
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2111
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.