If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
form records not stored in table
Yes, from datasheet view, the records can be updated, but not from the form
itself. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... This should be updating the table if you make changes on the form. If you open the datasheet view of the form's record source, can you update records? -- Duane Hookom MS Access MVP "smcalles" wrote in message m... Control Source: Q5 (field in the record source) Column Count: 1 Column Widths: 1" Bound Column: 1 Row Source: "";"Strongly Agree";"Agree";"No Opinion";"Disagree";"Strongly Disagree";"No Answer" Row Source Type: Value List Confirm that the value in Control Source is also in the field list. If what you're asking is whether, in this case, 'Q5' exists as a field in the table that acts as record source, then I can confirm. Many thanks, Sonia "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I have never heard of developers having issues with text boxes, combo boxes, list boxes, and other controls bound to fields in a form's record source. If your only issue is with list or combo boxes, find one that doesn't seem to work and provide these properties for us to review: Control Source: Column Count: Column Widths: Bound Column: Row Source: Row Source Type: Confirm that the value in Control Source is also in the field list. -- Duane Hookom MS Access MVP "smcalles" wrote in message om... I appreciate your help and I will certainly recreate the form. I am, however, uncertain that the answer is in my doing the same things I did before without making the same unidentified mistakes. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... If you have controls that are bound to fields in your form's record source and what you enter into these controls is not updating the record source, you have serious issues. Try recreate your form. -- Duane Hookom MS Access MVP "smcalles" wrote in message et... "Yes" to both questions: all the controls have a corresponding field from the record source (i.e., table) as their control sources. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... 1) does your form have a Record Source 2) do you controls have a field from the Record Source as their Control Sources -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... The problem now extends beyond the list boxes. I have other fields that are 1) not updating the record source and, when a new record is created, 2) the entries from the previous record will populate that record. I've tried working this on my own and I really can't figure it out. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... Values from list boxes will be stored in the form's record source if the list boxes have a control source that is a field from the record source. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Using Access 2003, I created a form with a number of list boxes. I subsequently read online that "Value List" boxes do not, in fact, populate the source table. However, when creating test records, I noticed that some box contents were populating some fields and others not. How do I create list boxes that will populate all the source fields in a table? Although I appreciate all offers of help, please note that I'm not a programmer. Sonia |
#12
|
|||
|
|||
form records not stored in table
I can't imagine what is happening in your database. I would consider
accepting a small sample (compacted) of you application to review and reply. Email me off line if this would work for you. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Yes, from datasheet view, the records can be updated, but not from the form itself. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... This should be updating the table if you make changes on the form. If you open the datasheet view of the form's record source, can you update records? -- Duane Hookom MS Access MVP "smcalles" wrote in message m... Control Source: Q5 (field in the record source) Column Count: 1 Column Widths: 1" Bound Column: 1 Row Source: "";"Strongly Agree";"Agree";"No Opinion";"Disagree";"Strongly Disagree";"No Answer" Row Source Type: Value List Confirm that the value in Control Source is also in the field list. If what you're asking is whether, in this case, 'Q5' exists as a field in the table that acts as record source, then I can confirm. Many thanks, Sonia "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I have never heard of developers having issues with text boxes, combo boxes, list boxes, and other controls bound to fields in a form's record source. If your only issue is with list or combo boxes, find one that doesn't seem to work and provide these properties for us to review: Control Source: Column Count: Column Widths: Bound Column: Row Source: Row Source Type: Confirm that the value in Control Source is also in the field list. -- Duane Hookom MS Access MVP "smcalles" wrote in message om... I appreciate your help and I will certainly recreate the form. I am, however, uncertain that the answer is in my doing the same things I did before without making the same unidentified mistakes. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... If you have controls that are bound to fields in your form's record source and what you enter into these controls is not updating the record source, you have serious issues. Try recreate your form. -- Duane Hookom MS Access MVP "smcalles" wrote in message et... "Yes" to both questions: all the controls have a corresponding field from the record source (i.e., table) as their control sources. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... 1) does your form have a Record Source 2) do you controls have a field from the Record Source as their Control Sources -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... The problem now extends beyond the list boxes. I have other fields that are 1) not updating the record source and, when a new record is created, 2) the entries from the previous record will populate that record. I've tried working this on my own and I really can't figure it out. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... Values from list boxes will be stored in the form's record source if the list boxes have a control source that is a field from the record source. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Using Access 2003, I created a form with a number of list boxes. I subsequently read online that "Value List" boxes do not, in fact, populate the source table. However, when creating test records, I noticed that some box contents were populating some fields and others not. How do I create list boxes that will populate all the source fields in a table? Although I appreciate all offers of help, please note that I'm not a programmer. Sonia |
#13
|
|||
|
|||
form records not stored in table
It does work for me, thank you very much. I can't tell you how much I
appreciate all the time you've taken to help me through this. But, I can't determine your email. Please email me with it? Sonia "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I can't imagine what is happening in your database. I would consider accepting a small sample (compacted) of you application to review and reply. Email me off line if this would work for you. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Yes, from datasheet view, the records can be updated, but not from the form itself. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... This should be updating the table if you make changes on the form. If you open the datasheet view of the form's record source, can you update records? -- Duane Hookom MS Access MVP "smcalles" wrote in message m... Control Source: Q5 (field in the record source) Column Count: 1 Column Widths: 1" Bound Column: 1 Row Source: "";"Strongly Agree";"Agree";"No Opinion";"Disagree";"Strongly Disagree";"No Answer" Row Source Type: Value List Confirm that the value in Control Source is also in the field list. If what you're asking is whether, in this case, 'Q5' exists as a field in the table that acts as record source, then I can confirm. Many thanks, Sonia "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I have never heard of developers having issues with text boxes, combo boxes, list boxes, and other controls bound to fields in a form's record source. If your only issue is with list or combo boxes, find one that doesn't seem to work and provide these properties for us to review: Control Source: Column Count: Column Widths: Bound Column: Row Source: Row Source Type: Confirm that the value in Control Source is also in the field list. -- Duane Hookom MS Access MVP "smcalles" wrote in message om... I appreciate your help and I will certainly recreate the form. I am, however, uncertain that the answer is in my doing the same things I did before without making the same unidentified mistakes. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... If you have controls that are bound to fields in your form's record source and what you enter into these controls is not updating the record source, you have serious issues. Try recreate your form. -- Duane Hookom MS Access MVP "smcalles" wrote in message et... "Yes" to both questions: all the controls have a corresponding field from the record source (i.e., table) as their control sources. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... 1) does your form have a Record Source 2) do you controls have a field from the Record Source as their Control Sources -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... The problem now extends beyond the list boxes. I have other fields that are 1) not updating the record source and, when a new record is created, 2) the entries from the previous record will populate that record. I've tried working this on my own and I really can't figure it out. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... Values from list boxes will be stored in the form's record source if the list boxes have a control source that is a field from the record source. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Using Access 2003, I created a form with a number of list boxes. I subsequently read online that "Value List" boxes do not, in fact, populate the source table. However, when creating test records, I noticed that some box contents were populating some fields and others not. How do I create list boxes that will populate all the source fields in a table? Although I appreciate all offers of help, please note that I'm not a programmer. Sonia |
#14
|
|||
|
|||
form records not stored in table
My email is Duane At Hookom Dot Net. You shouldn't post your
email address unless your want to get a ton of spam. -- Duane Hookom MS Access MVP "smcalles" wrote in message . net... It does work for me, thank you very much. I can't tell you how much I appreciate all the time you've taken to help me through this. But, I can't determine your email. Please email me with it? Sonia "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I can't imagine what is happening in your database. I would consider accepting a small sample (compacted) of you application to review and reply. Email me off line if this would work for you. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Yes, from datasheet view, the records can be updated, but not from the form itself. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... This should be updating the table if you make changes on the form. If you open the datasheet view of the form's record source, can you update records? -- Duane Hookom MS Access MVP "smcalles" wrote in message m... Control Source: Q5 (field in the record source) Column Count: 1 Column Widths: 1" Bound Column: 1 Row Source: "";"Strongly Agree";"Agree";"No Opinion";"Disagree";"Strongly Disagree";"No Answer" Row Source Type: Value List Confirm that the value in Control Source is also in the field list. If what you're asking is whether, in this case, 'Q5' exists as a field in the table that acts as record source, then I can confirm. Many thanks, Sonia "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I have never heard of developers having issues with text boxes, combo boxes, list boxes, and other controls bound to fields in a form's record source. If your only issue is with list or combo boxes, find one that doesn't seem to work and provide these properties for us to review: Control Source: Column Count: Column Widths: Bound Column: Row Source: Row Source Type: Confirm that the value in Control Source is also in the field list. -- Duane Hookom MS Access MVP "smcalles" wrote in message om... I appreciate your help and I will certainly recreate the form. I am, however, uncertain that the answer is in my doing the same things I did before without making the same unidentified mistakes. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... If you have controls that are bound to fields in your form's record source and what you enter into these controls is not updating the record source, you have serious issues. Try recreate your form. -- Duane Hookom MS Access MVP "smcalles" wrote in message et... "Yes" to both questions: all the controls have a corresponding field from the record source (i.e., table) as their control sources. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... 1) does your form have a Record Source 2) do you controls have a field from the Record Source as their Control Sources -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... The problem now extends beyond the list boxes. I have other fields that are 1) not updating the record source and, when a new record is created, 2) the entries from the previous record will populate that record. I've tried working this on my own and I really can't figure it out. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... Values from list boxes will be stored in the form's record source if the list boxes have a control source that is a field from the record source. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Using Access 2003, I created a form with a number of list boxes. I subsequently read online that "Value List" boxes do not, in fact, populate the source table. However, when creating test records, I noticed that some box contents were populating some fields and others not. How do I create list boxes that will populate all the source fields in a table? Although I appreciate all offers of help, please note that I'm not a programmer. Sonia |
#15
|
|||
|
|||
form records not stored in table
I believe the issue was the use of a list box control with a height that
displayed only a single value. Scrolling the list box to "display" a value does not select the value. The user must scroll and then click the value to actually update the field. My recommendation was to change the list boxes to combo boxes. -- Duane Hookom MS Access MVP "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... My email is Duane At Hookom Dot Net. You shouldn't post your email address unless your want to get a ton of spam. -- Duane Hookom MS Access MVP "smcalles" wrote in message . net... It does work for me, thank you very much. I can't tell you how much I appreciate all the time you've taken to help me through this. But, I can't determine your email. Please email me with it? Sonia "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I can't imagine what is happening in your database. I would consider accepting a small sample (compacted) of you application to review and reply. Email me off line if this would work for you. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Yes, from datasheet view, the records can be updated, but not from the form itself. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... This should be updating the table if you make changes on the form. If you open the datasheet view of the form's record source, can you update records? -- Duane Hookom MS Access MVP "smcalles" wrote in message m... Control Source: Q5 (field in the record source) Column Count: 1 Column Widths: 1" Bound Column: 1 Row Source: "";"Strongly Agree";"Agree";"No Opinion";"Disagree";"Strongly Disagree";"No Answer" Row Source Type: Value List Confirm that the value in Control Source is also in the field list. If what you're asking is whether, in this case, 'Q5' exists as a field in the table that acts as record source, then I can confirm. Many thanks, Sonia "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I have never heard of developers having issues with text boxes, combo boxes, list boxes, and other controls bound to fields in a form's record source. If your only issue is with list or combo boxes, find one that doesn't seem to work and provide these properties for us to review: Control Source: Column Count: Column Widths: Bound Column: Row Source: Row Source Type: Confirm that the value in Control Source is also in the field list. -- Duane Hookom MS Access MVP "smcalles" wrote in message om... I appreciate your help and I will certainly recreate the form. I am, however, uncertain that the answer is in my doing the same things I did before without making the same unidentified mistakes. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... If you have controls that are bound to fields in your form's record source and what you enter into these controls is not updating the record source, you have serious issues. Try recreate your form. -- Duane Hookom MS Access MVP "smcalles" wrote in message et... "Yes" to both questions: all the controls have a corresponding field from the record source (i.e., table) as their control sources. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... 1) does your form have a Record Source 2) do you controls have a field from the Record Source as their Control Sources -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... The problem now extends beyond the list boxes. I have other fields that are 1) not updating the record source and, when a new record is created, 2) the entries from the previous record will populate that record. I've tried working this on my own and I really can't figure it out. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... Values from list boxes will be stored in the form's record source if the list boxes have a control source that is a field from the record source. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Using Access 2003, I created a form with a number of list boxes. I subsequently read online that "Value List" boxes do not, in fact, populate the source table. However, when creating test records, I noticed that some box contents were populating some fields and others not. How do I create list boxes that will populate all the source fields in a table? Although I appreciate all offers of help, please note that I'm not a programmer. Sonia |
#16
|
|||
|
|||
form records not stored in table
Yep, it worked. Many thanks!
If this an issue with list boxes, what is the point of using a list box instead of a combo box? "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I believe the issue was the use of a list box control with a height that displayed only a single value. Scrolling the list box to "display" a value does not select the value. The user must scroll and then click the value to actually update the field. My recommendation was to change the list boxes to combo boxes. -- Duane Hookom MS Access MVP "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... My email is Duane At Hookom Dot Net. You shouldn't post your email address unless your want to get a ton of spam. -- Duane Hookom MS Access MVP "smcalles" wrote in message . net... It does work for me, thank you very much. I can't tell you how much I appreciate all the time you've taken to help me through this. But, I can't determine your email. Please email me with it? Sonia "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I can't imagine what is happening in your database. I would consider accepting a small sample (compacted) of you application to review and reply. Email me off line if this would work for you. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Yes, from datasheet view, the records can be updated, but not from the form itself. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... This should be updating the table if you make changes on the form. If you open the datasheet view of the form's record source, can you update records? -- Duane Hookom MS Access MVP "smcalles" wrote in message m... Control Source: Q5 (field in the record source) Column Count: 1 Column Widths: 1" Bound Column: 1 Row Source: "";"Strongly Agree";"Agree";"No Opinion";"Disagree";"Strongly Disagree";"No Answer" Row Source Type: Value List Confirm that the value in Control Source is also in the field list. If what you're asking is whether, in this case, 'Q5' exists as a field in the table that acts as record source, then I can confirm. Many thanks, Sonia "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I have never heard of developers having issues with text boxes, combo boxes, list boxes, and other controls bound to fields in a form's record source. If your only issue is with list or combo boxes, find one that doesn't seem to work and provide these properties for us to review: Control Source: Column Count: Column Widths: Bound Column: Row Source: Row Source Type: Confirm that the value in Control Source is also in the field list. -- Duane Hookom MS Access MVP "smcalles" wrote in message om... I appreciate your help and I will certainly recreate the form. I am, however, uncertain that the answer is in my doing the same things I did before without making the same unidentified mistakes. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... If you have controls that are bound to fields in your form's record source and what you enter into these controls is not updating the record source, you have serious issues. Try recreate your form. -- Duane Hookom MS Access MVP "smcalles" wrote in message et... "Yes" to both questions: all the controls have a corresponding field from the record source (i.e., table) as their control sources. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... 1) does your form have a Record Source 2) do you controls have a field from the Record Source as their Control Sources -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... The problem now extends beyond the list boxes. I have other fields that are 1) not updating the record source and, when a new record is created, 2) the entries from the previous record will populate that record. I've tried working this on my own and I really can't figure it out. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... Values from list boxes will be stored in the form's record source if the list boxes have a control source that is a field from the record source. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Using Access 2003, I created a form with a number of list boxes. I subsequently read online that "Value List" boxes do not, in fact, populate the source table. However, when creating test records, I noticed that some box contents were populating some fields and others not. How do I create list boxes that will populate all the source fields in a table? Although I appreciate all offers of help, please note that I'm not a programmer. Sonia |
#17
|
|||
|
|||
form records not stored in table
Normally list boxes are used for smaller lists and lists where you might
want to select multiple values. You rarely if ever create list boxes sized so only one item from the list is visible. I can't remember using a list box that is bound to a field for storing the value in a table. Combo boxes are much more popular. -- Duane Hookom MS Access MVP "smcalles" wrote in message . net... Yep, it worked. Many thanks! If this an issue with list boxes, what is the point of using a list box instead of a combo box? "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I believe the issue was the use of a list box control with a height that displayed only a single value. Scrolling the list box to "display" a value does not select the value. The user must scroll and then click the value to actually update the field. My recommendation was to change the list boxes to combo boxes. -- Duane Hookom MS Access MVP "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... My email is Duane At Hookom Dot Net. You shouldn't post your email address unless your want to get a ton of spam. -- Duane Hookom MS Access MVP "smcalles" wrote in message . net... It does work for me, thank you very much. I can't tell you how much I appreciate all the time you've taken to help me through this. But, I can't determine your email. Please email me with it? Sonia "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I can't imagine what is happening in your database. I would consider accepting a small sample (compacted) of you application to review and reply. Email me off line if this would work for you. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Yes, from datasheet view, the records can be updated, but not from the form itself. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... This should be updating the table if you make changes on the form. If you open the datasheet view of the form's record source, can you update records? -- Duane Hookom MS Access MVP "smcalles" wrote in message m... Control Source: Q5 (field in the record source) Column Count: 1 Column Widths: 1" Bound Column: 1 Row Source: "";"Strongly Agree";"Agree";"No Opinion";"Disagree";"Strongly Disagree";"No Answer" Row Source Type: Value List Confirm that the value in Control Source is also in the field list. If what you're asking is whether, in this case, 'Q5' exists as a field in the table that acts as record source, then I can confirm. Many thanks, Sonia "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... I have never heard of developers having issues with text boxes, combo boxes, list boxes, and other controls bound to fields in a form's record source. If your only issue is with list or combo boxes, find one that doesn't seem to work and provide these properties for us to review: Control Source: Column Count: Column Widths: Bound Column: Row Source: Row Source Type: Confirm that the value in Control Source is also in the field list. -- Duane Hookom MS Access MVP "smcalles" wrote in message om... I appreciate your help and I will certainly recreate the form. I am, however, uncertain that the answer is in my doing the same things I did before without making the same unidentified mistakes. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... If you have controls that are bound to fields in your form's record source and what you enter into these controls is not updating the record source, you have serious issues. Try recreate your form. -- Duane Hookom MS Access MVP "smcalles" wrote in message et... "Yes" to both questions: all the controls have a corresponding field from the record source (i.e., table) as their control sources. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... 1) does your form have a Record Source 2) do you controls have a field from the Record Source as their Control Sources -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... The problem now extends beyond the list boxes. I have other fields that are 1) not updating the record source and, when a new record is created, 2) the entries from the previous record will populate that record. I've tried working this on my own and I really can't figure it out. "Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message ... Values from list boxes will be stored in the form's record source if the list boxes have a control source that is a field from the record source. -- Duane Hookom MS Access MVP "smcalles" wrote in message . com... Using Access 2003, I created a form with a number of list boxes. I subsequently read online that "Value List" boxes do not, in fact, populate the source table. However, when creating test records, I noticed that some box contents were populating some fields and others not. How do I create list boxes that will populate all the source fields in a table? Although I appreciate all offers of help, please note that I'm not a programmer. Sonia |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"Recently used file list" has disappeared. | Frank Martin | New Users | 3 | January 12th, 2006 09:04 PM |
"Recently used file list" Alphabetically | Rick | General Discussion | 1 | January 6th, 2006 04:58 PM |
my archive folder is no longer in the "folder list"? | Todd H | General Discussion | 2 | November 16th, 2005 10:33 PM |
Outlook Rt click "Add Sender's Domain to BLOCKED sender's list" | john85374 | General Discussion | 2 | September 22nd, 2005 11:16 AM |