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 |
#1
|
|||
|
|||
AfterUpdate
I want to have a field [Store] that stores the value of ContactName.Column(1)
after the user selects a contact name. I tried making an "EventProcedure" on the AfterUpdate property of Contact Name: [Store]=ContactName.Column(1) but it isn't working. How would I fix this? |
#2
|
|||
|
|||
AfterUpdate
"...isn't working..." leaves a lot open for the imagination.
By the way, I'm hoping the "... that stores the value of ..." comment meant "... that displays the value of...". Since you are working in MS Access, a relational database, you don't need to redundantly store the Store. A more specific description will probably lead to more specific suggestions... Regards Jeff Boyce Microsoft Office/Access MVP "awach" wrote in message ... I want to have a field [Store] that stores the value of ContactName.Column(1) after the user selects a contact name. I tried making an "EventProcedure" on the AfterUpdate property of Contact Name: [Store]=ContactName.Column(1) but it isn't working. How would I fix this? |
#3
|
|||
|
|||
AfterUpdate
awach,
It appears that you've posted this question several times. Please stay with one thread while folks are trying to help. Otherwise folks will end up offering duplicate solutions, and the "flow" of the problem won't be clear. Keep all the posts together so responders can see what the progression has been during the problem determination procedure. Also, what does "isn't working" mean exactly. Try this test... just place a Beep in the AfterUpdate event procedure, and update your ContactName combo. Get a beep when you select an item? And... Try this test... place an unbound text control on the form, and give it a ControlSource of... =ContactName.Column(1) Does it display the correct value you want to see from the ContactName combo? Your EventProcedure should be run on the AfterUpdate event of the ContactName combo. Store should be a "bound" text control I take it you placed the [Store]=ContactName.Column(1) in the form module, and not just in the text box for the ContactName AfterUpdate event. (sorry but I have to ask) OK, please answer these very basic questions, and we'll keep "drilling down" till we figure out why it doesn't work. This is a very simple process, so I suspect there is something you haven't indicated in your posts, or something we're not understanding about your setup, that's causing the problem. -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "awach" wrote in message ... I want to have a field [Store] that stores the value of ContactName.Column(1) after the user selects a contact name. I tried making an "EventProcedure" on the AfterUpdate property of Contact Name: [Store]=ContactName.Column(1) but it isn't working. How would I fix this? |
#4
|
|||
|
|||
AfterUpdate
Al
I was with you up to the part about [Store] being a bound column. If the data is already available elsewhere, and the OP would use something like a combobox (with columns) to find the correct store, wouldn't storing the ID, rather than the text, make more sense? Regards Jeff Boyce Microsoft Office/Access MVP "Al Campagna" wrote in message ... awach, It appears that you've posted this question several times. Please stay with one thread while folks are trying to help. Otherwise folks will end up offering duplicate solutions, and the "flow" of the problem won't be clear. Keep all the posts together so responders can see what the progression has been during the problem determination procedure. Also, what does "isn't working" mean exactly. Try this test... just place a Beep in the AfterUpdate event procedure, and update your ContactName combo. Get a beep when you select an item? And... Try this test... place an unbound text control on the form, and give it a ControlSource of... =ContactName.Column(1) Does it display the correct value you want to see from the ContactName combo? Your EventProcedure should be run on the AfterUpdate event of the ContactName combo. Store should be a "bound" text control I take it you placed the [Store]=ContactName.Column(1) in the form module, and not just in the text box for the ContactName AfterUpdate event. (sorry but I have to ask) OK, please answer these very basic questions, and we'll keep "drilling down" till we figure out why it doesn't work. This is a very simple process, so I suspect there is something you haven't indicated in your posts, or something we're not understanding about your setup, that's causing the problem. -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "awach" wrote in message ... I want to have a field [Store] that stores the value of ContactName.Column(1) after the user selects a contact name. I tried making an "EventProcedure" on the AfterUpdate property of Contact Name: [Store]=ContactName.Column(1) but it isn't working. How would I fix this? |
#5
|
|||
|
|||
AfterUpdate
Jeff,
I thought the problem was that Awach couldn't get the AfterUpdate of his combo box to set the value for Store. I assumed that ContactName is a combo with StoreID in Col(0), and Store (Name?) in Col(1). Col(0) would be hidden, and I assumed ContactName is actually bound to StoreID. (I don't think I've pieced together "all" the various separate posts on this problem, but that's what gathered from this latest thread.) It was previously suggested by Klatuu... and you... that capturing Store was not advisable, (I agree) but in other posts I saw, the OP indicated he "had" to save it. (I still don't see why though) So... I took it that Store would be bound field that will use the AfterUpdate of combo ContactName to set it's value from the Col(1) text. I tried making an "EventProcedure" on the AfterUpdate property of Contact [Store]=ContactName.Column(1) but it isn't working. How would I fix this? The balance of my post was suggestions that might help determine why the OP's code... "isn't working". Did I miss, or misunderstand, something about what the OP wants... or has... so far? -- Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Jeff Boyce" wrote in message ... Al I was with you up to the part about [Store] being a bound column. If the data is already available elsewhere, and the OP would use something like a combobox (with columns) to find the correct store, wouldn't storing the ID, rather than the text, make more sense? Regards Jeff Boyce Microsoft Office/Access MVP "Al Campagna" wrote in message ... awach, It appears that you've posted this question several times. Please stay with one thread while folks are trying to help. Otherwise folks will end up offering duplicate solutions, and the "flow" of the problem won't be clear. Keep all the posts together so responders can see what the progression has been during the problem determination procedure. Also, what does "isn't working" mean exactly. Try this test... just place a Beep in the AfterUpdate event procedure, and update your ContactName combo. Get a beep when you select an item? And... Try this test... place an unbound text control on the form, and give it a ControlSource of... =ContactName.Column(1) Does it display the correct value you want to see from the ContactName combo? Your EventProcedure should be run on the AfterUpdate event of the ContactName combo. Store should be a "bound" text control I take it you placed the [Store]=ContactName.Column(1) in the form module, and not just in the text box for the ContactName AfterUpdate event. (sorry but I have to ask) OK, please answer these very basic questions, and we'll keep "drilling down" till we figure out why it doesn't work. This is a very simple process, so I suspect there is something you haven't indicated in your posts, or something we're not understanding about your setup, that's causing the problem. -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "awach" wrote in message ... I want to have a field [Store] that stores the value of ContactName.Column(1) after the user selects a contact name. I tried making an "EventProcedure" on the AfterUpdate property of Contact Name: [Store]=ContactName.Column(1) but it isn't working. How would I fix this? |
#6
|
|||
|
|||
AfterUpdate
Jeff,
This part of my last post should read... I assumed that ContactName is a combo with StoreID in Col(0), and store's (ContactName?) in Col(1). Col(0) would be hidden, and I assumed ContactName is actually bound to StoreID. I'm a bit confoosed about the OP's naming scheme... I would have set it up this way StoreID StoreName ContactName 142 Boston John Doe and then gone for Col(2)... select a store by name, and then AfterUpdate... ContactName = OPsCombo.Column(2) Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Jeff Boyce" wrote in message ... Al I was with you up to the part about [Store] being a bound column. If the data is already available elsewhere, and the OP would use something like a combobox (with columns) to find the correct store, wouldn't storing the ID, rather than the text, make more sense? Regards Jeff Boyce Microsoft Office/Access MVP "Al Campagna" wrote in message ... awach, It appears that you've posted this question several times. Please stay with one thread while folks are trying to help. Otherwise folks will end up offering duplicate solutions, and the "flow" of the problem won't be clear. Keep all the posts together so responders can see what the progression has been during the problem determination procedure. Also, what does "isn't working" mean exactly. Try this test... just place a Beep in the AfterUpdate event procedure, and update your ContactName combo. Get a beep when you select an item? And... Try this test... place an unbound text control on the form, and give it a ControlSource of... =ContactName.Column(1) Does it display the correct value you want to see from the ContactName combo? Your EventProcedure should be run on the AfterUpdate event of the ContactName combo. Store should be a "bound" text control I take it you placed the [Store]=ContactName.Column(1) in the form module, and not just in the text box for the ContactName AfterUpdate event. (sorry but I have to ask) OK, please answer these very basic questions, and we'll keep "drilling down" till we figure out why it doesn't work. This is a very simple process, so I suspect there is something you haven't indicated in your posts, or something we're not understanding about your setup, that's causing the problem. -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "awach" wrote in message ... I want to have a field [Store] that stores the value of ContactName.Column(1) after the user selects a contact name. I tried making an "EventProcedure" on the AfterUpdate property of Contact Name: [Store]=ContactName.Column(1) but it isn't working. How would I fix this? |
#7
|
|||
|
|||
AfterUpdate
Al
Sorry for the delay -- I live in the path of that quasi-hurricane that blew through Washington state last week, and still don't have power at home. When I responded to the OP, I didn't feel I had enough info to make an informed suggestion. I was just posing a question about the notion of (re-)storing a Store Name. Regards Jeff Boyce Microsoft Office/Access MVP "Al Campagna" wrote in message ... Jeff, This part of my last post should read... I assumed that ContactName is a combo with StoreID in Col(0), and store's (ContactName?) in Col(1). Col(0) would be hidden, and I assumed ContactName is actually bound to StoreID. I'm a bit confoosed about the OP's naming scheme... I would have set it up this way StoreID StoreName ContactName 142 Boston John Doe and then gone for Col(2)... select a store by name, and then AfterUpdate... ContactName = OPsCombo.Column(2) Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Jeff Boyce" wrote in message ... Al I was with you up to the part about [Store] being a bound column. If the data is already available elsewhere, and the OP would use something like a combobox (with columns) to find the correct store, wouldn't storing the ID, rather than the text, make more sense? Regards Jeff Boyce Microsoft Office/Access MVP "Al Campagna" wrote in message ... awach, It appears that you've posted this question several times. Please stay with one thread while folks are trying to help. Otherwise folks will end up offering duplicate solutions, and the "flow" of the problem won't be clear. Keep all the posts together so responders can see what the progression has been during the problem determination procedure. Also, what does "isn't working" mean exactly. Try this test... just place a Beep in the AfterUpdate event procedure, and update your ContactName combo. Get a beep when you select an item? And... Try this test... place an unbound text control on the form, and give it a ControlSource of... =ContactName.Column(1) Does it display the correct value you want to see from the ContactName combo? Your EventProcedure should be run on the AfterUpdate event of the ContactName combo. Store should be a "bound" text control I take it you placed the [Store]=ContactName.Column(1) in the form module, and not just in the text box for the ContactName AfterUpdate event. (sorry but I have to ask) OK, please answer these very basic questions, and we'll keep "drilling down" till we figure out why it doesn't work. This is a very simple process, so I suspect there is something you haven't indicated in your posts, or something we're not understanding about your setup, that's causing the problem. -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "awach" wrote in message ... I want to have a field [Store] that stores the value of ContactName.Column(1) after the user selects a contact name. I tried making an "EventProcedure" on the AfterUpdate property of Contact Name: [Store]=ContactName.Column(1) but it isn't working. How would I fix this? |
#8
|
|||
|
|||
AfterUpdate
Jeff,
No problem... I've been in contact with a friend from this NG (near Redmond) when I heard the news about the storm/s in the Northwest. He didn't have power either. He had to email from work. Pretty nasty affair... Hope your OK, and that you'll get power soon. I'm still confoosed about the OP's setup, and the necessity for "saving" any combo column in the situation as I understood it. So I just ignored the setup and just tried to deal with the upshot of the problem. The OP hasn't responded since. I think I scared him off! :-D Have a good holiday Jeff, -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Jeff Boyce" wrote in message ... Al Sorry for the delay -- I live in the path of that quasi-hurricane that blew through Washington state last week, and still don't have power at home. When I responded to the OP, I didn't feel I had enough info to make an informed suggestion. I was just posing a question about the notion of (re-)storing a Store Name. Regards Jeff Boyce Microsoft Office/Access MVP "Al Campagna" wrote in message ... Jeff, This part of my last post should read... I assumed that ContactName is a combo with StoreID in Col(0), and store's (ContactName?) in Col(1). Col(0) would be hidden, and I assumed ContactName is actually bound to StoreID. I'm a bit confoosed about the OP's naming scheme... I would have set it up this way StoreID StoreName ContactName 142 Boston John Doe and then gone for Col(2)... select a store by name, and then AfterUpdate... ContactName = OPsCombo.Column(2) Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Jeff Boyce" wrote in message ... Al I was with you up to the part about [Store] being a bound column. If the data is already available elsewhere, and the OP would use something like a combobox (with columns) to find the correct store, wouldn't storing the ID, rather than the text, make more sense? Regards Jeff Boyce Microsoft Office/Access MVP "Al Campagna" wrote in message ... awach, It appears that you've posted this question several times. Please stay with one thread while folks are trying to help. Otherwise folks will end up offering duplicate solutions, and the "flow" of the problem won't be clear. Keep all the posts together so responders can see what the progression has been during the problem determination procedure. Also, what does "isn't working" mean exactly. Try this test... just place a Beep in the AfterUpdate event procedure, and update your ContactName combo. Get a beep when you select an item? And... Try this test... place an unbound text control on the form, and give it a ControlSource of... =ContactName.Column(1) Does it display the correct value you want to see from the ContactName combo? Your EventProcedure should be run on the AfterUpdate event of the ContactName combo. Store should be a "bound" text control I take it you placed the [Store]=ContactName.Column(1) in the form module, and not just in the text box for the ContactName AfterUpdate event. (sorry but I have to ask) OK, please answer these very basic questions, and we'll keep "drilling down" till we figure out why it doesn't work. This is a very simple process, so I suspect there is something you haven't indicated in your posts, or something we're not understanding about your setup, that's causing the problem. -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "awach" wrote in message ... I want to have a field [Store] that stores the value of ContactName.Column(1) after the user selects a contact name. I tried making an "EventProcedure" on the AfterUpdate property of Contact Name: [Store]=ContactName.Column(1) but it isn't working. How would I fix this? |
#9
|
|||
|
|||
AfterUpdate
Happy Holidays, Al!
Jeff "Al Campagna" wrote in message ... Jeff, No problem... I've been in contact with a friend from this NG (near Redmond) when I heard the news about the storm/s in the Northwest. He didn't have power either. He had to email from work. Pretty nasty affair... Hope your OK, and that you'll get power soon. I'm still confoosed about the OP's setup, and the necessity for "saving" any combo column in the situation as I understood it. So I just ignored the setup and just tried to deal with the upshot of the problem. The OP hasn't responded since. I think I scared him off! :-D Have a good holiday Jeff, -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Jeff Boyce" wrote in message ... Al Sorry for the delay -- I live in the path of that quasi-hurricane that blew through Washington state last week, and still don't have power at home. When I responded to the OP, I didn't feel I had enough info to make an informed suggestion. I was just posing a question about the notion of (re-)storing a Store Name. Regards Jeff Boyce Microsoft Office/Access MVP "Al Campagna" wrote in message ... Jeff, This part of my last post should read... I assumed that ContactName is a combo with StoreID in Col(0), and store's (ContactName?) in Col(1). Col(0) would be hidden, and I assumed ContactName is actually bound to StoreID. I'm a bit confoosed about the OP's naming scheme... I would have set it up this way StoreID StoreName ContactName 142 Boston John Doe and then gone for Col(2)... select a store by name, and then AfterUpdate... ContactName = OPsCombo.Column(2) Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Jeff Boyce" wrote in message ... Al I was with you up to the part about [Store] being a bound column. If the data is already available elsewhere, and the OP would use something like a combobox (with columns) to find the correct store, wouldn't storing the ID, rather than the text, make more sense? Regards Jeff Boyce Microsoft Office/Access MVP "Al Campagna" wrote in message ... awach, It appears that you've posted this question several times. Please stay with one thread while folks are trying to help. Otherwise folks will end up offering duplicate solutions, and the "flow" of the problem won't be clear. Keep all the posts together so responders can see what the progression has been during the problem determination procedure. Also, what does "isn't working" mean exactly. Try this test... just place a Beep in the AfterUpdate event procedure, and update your ContactName combo. Get a beep when you select an item? And... Try this test... place an unbound text control on the form, and give it a ControlSource of... =ContactName.Column(1) Does it display the correct value you want to see from the ContactName combo? Your EventProcedure should be run on the AfterUpdate event of the ContactName combo. Store should be a "bound" text control I take it you placed the [Store]=ContactName.Column(1) in the form module, and not just in the text box for the ContactName AfterUpdate event. (sorry but I have to ask) OK, please answer these very basic questions, and we'll keep "drilling down" till we figure out why it doesn't work. This is a very simple process, so I suspect there is something you haven't indicated in your posts, or something we're not understanding about your setup, that's causing the problem. -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "awach" wrote in message ... I want to have a field [Store] that stores the value of ContactName.Column(1) after the user selects a contact name. I tried making an "EventProcedure" on the AfterUpdate property of Contact Name: [Store]=ContactName.Column(1) but it isn't working. How would I fix this? |
Thread Tools | |
Display Modes | |
|
|