Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
I have a command button activate the standard Data form for a sheet as I have
no idea how to create a customer form to update records. My question is this - is there anyway to edit the standard form - really what I want is to disable the 'New' button so that users do not use it to create new records - there is a custom form for this. Any help would be appreciated as this is all very new to me. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
I don't think so.
John Walkenbach has an enhanced data form: http://j-walk.com/ss/dataform/index.htm And the source code is available for a small fee ($20 USA, IIRC). So you can modify it as much as you want. And if that's not sufficient, then maybe you could design your own input userform. Debra Dalgleish shares some tips: http://contextures.com/xlUserForm01.html Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Leanne wrote: I have a command button activate the standard Data form for a sheet as I have no idea how to create a customer form to update records. My question is this - is there anyway to edit the standard form - really what I want is to disable the 'New' button so that users do not use it to create new records - there is a custom form for this. Any help would be appreciated as this is all very new to me. Thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
Hi Dave,
I thought as much. I have already built a user input form (thanks to Debra's site) but the problem I have with that is I do not know how to get it to update existing data rather than enter new data. What I want to achieve with this form is for the user to make changes to an existing record. I will check out Peter's site and see if that sheds any light on the correct coding needed to update. Thanks "Dave Peterson" wrote: I don't think so. John Walkenbach has an enhanced data form: http://j-walk.com/ss/dataform/index.htm And the source code is available for a small fee ($20 USA, IIRC). So you can modify it as much as you want. And if that's not sufficient, then maybe you could design your own input userform. Debra Dalgleish shares some tips: http://contextures.com/xlUserForm01.html Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Leanne wrote: I have a command button activate the standard Data form for a sheet as I have no idea how to create a customer form to update records. My question is this - is there anyway to edit the standard form - really what I want is to disable the 'New' button so that users do not use it to create new records - there is a custom form for this. Any help would be appreciated as this is all very new to me. Thanks -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
Great sites but nothing shared on any of them about updating existing data
"Leanne" wrote: Hi Dave, I thought as much. I have already built a user input form (thanks to Debra's site) but the problem I have with that is I do not know how to get it to update existing data rather than enter new data. What I want to achieve with this form is for the user to make changes to an existing record. I will check out Peter's site and see if that sheds any light on the correct coding needed to update. Thanks "Dave Peterson" wrote: I don't think so. John Walkenbach has an enhanced data form: http://j-walk.com/ss/dataform/index.htm And the source code is available for a small fee ($20 USA, IIRC). So you can modify it as much as you want. And if that's not sufficient, then maybe you could design your own input userform. Debra Dalgleish shares some tips: http://contextures.com/xlUserForm01.html Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Leanne wrote: I have a command button activate the standard Data form for a sheet as I have no idea how to create a customer form to update records. My question is this - is there anyway to edit the standard form - really what I want is to disable the 'New' button so that users do not use it to create new records - there is a custom form for this. Any help would be appreciated as this is all very new to me. Thanks -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
I suggested something at your post "Help with Forms" in .programming.
If that didn't work, you'll have to provide some more details (well, for me to guess). Leanne wrote: Hi Dave, I thought as much. I have already built a user input form (thanks to Debra's site) but the problem I have with that is I do not know how to get it to update existing data rather than enter new data. What I want to achieve with this form is for the user to make changes to an existing record. I will check out Peter's site and see if that sheds any light on the correct coding needed to update. Thanks "Dave Peterson" wrote: I don't think so. John Walkenbach has an enhanced data form: http://j-walk.com/ss/dataform/index.htm And the source code is available for a small fee ($20 USA, IIRC). So you can modify it as much as you want. And if that's not sufficient, then maybe you could design your own input userform. Debra Dalgleish shares some tips: http://contextures.com/xlUserForm01.html Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Leanne wrote: I have a command button activate the standard Data form for a sheet as I have no idea how to create a customer form to update records. My question is this - is there anyway to edit the standard form - really what I want is to disable the 'New' button so that users do not use it to create new records - there is a custom form for this. Any help would be appreciated as this is all very new to me. Thanks -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
Hi Dave,
Yes sorry about not replying to that. In that instance I was not able to get it to work but did eventually resolve it - with help so can not replicate it! Belive it or not that was a totally different form to the one I am trying to create. Are you willing to communicate via email? Either way, so that I provide the right information, what would you need to know to start with? Sorry I am really new at this side of Excel - give me a formula or chart and I am fine! "Dave Peterson" wrote: I suggested something at your post "Help with Forms" in .programming. If that didn't work, you'll have to provide some more details (well, for me to guess). Leanne wrote: Hi Dave, I thought as much. I have already built a user input form (thanks to Debra's site) but the problem I have with that is I do not know how to get it to update existing data rather than enter new data. What I want to achieve with this form is for the user to make changes to an existing record. I will check out Peter's site and see if that sheds any light on the correct coding needed to update. Thanks "Dave Peterson" wrote: I don't think so. John Walkenbach has an enhanced data form: http://j-walk.com/ss/dataform/index.htm And the source code is available for a small fee ($20 USA, IIRC). So you can modify it as much as you want. And if that's not sufficient, then maybe you could design your own input userform. Debra Dalgleish shares some tips: http://contextures.com/xlUserForm01.html Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Leanne wrote: I have a command button activate the standard Data form for a sheet as I have no idea how to create a customer form to update records. My question is this - is there anyway to edit the standard form - really what I want is to disable the 'New' button so that users do not use it to create new records - there is a custom form for this. Any help would be appreciated as this is all very new to me. Thanks -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
By keeping the discussion in the newsgroups, you'll get a lot of potential
responders. You may want to post the details that make this a different problem. Leanne wrote: Hi Dave, Yes sorry about not replying to that. In that instance I was not able to get it to work but did eventually resolve it - with help so can not replicate it! Belive it or not that was a totally different form to the one I am trying to create. Are you willing to communicate via email? Either way, so that I provide the right information, what would you need to know to start with? Sorry I am really new at this side of Excel - give me a formula or chart and I am fine! "Dave Peterson" wrote: I suggested something at your post "Help with Forms" in .programming. If that didn't work, you'll have to provide some more details (well, for me to guess). Leanne wrote: Hi Dave, I thought as much. I have already built a user input form (thanks to Debra's site) but the problem I have with that is I do not know how to get it to update existing data rather than enter new data. What I want to achieve with this form is for the user to make changes to an existing record. I will check out Peter's site and see if that sheds any light on the correct coding needed to update. Thanks "Dave Peterson" wrote: I don't think so. John Walkenbach has an enhanced data form: http://j-walk.com/ss/dataform/index.htm And the source code is available for a small fee ($20 USA, IIRC). So you can modify it as much as you want. And if that's not sufficient, then maybe you could design your own input userform. Debra Dalgleish shares some tips: http://contextures.com/xlUserForm01.html Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Leanne wrote: I have a command button activate the standard Data form for a sheet as I have no idea how to create a customer form to update records. My question is this - is there anyway to edit the standard form - really what I want is to disable the 'New' button so that users do not use it to create new records - there is a custom form for this. Any help would be appreciated as this is all very new to me. Thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
Yes I understand.
It is the same problem in that I need information from the form to be returned to the existing record rather than create a new record. This I do not know how to right. What I want is - A form that can take data from a specified sheet (which is hidden but that can change if necessary) and populate the form. Then when changes are made to the entry the specified sheet is updated with that information for that particular record. The sheet is called 'Internal Sales Report' and the unique field would be 'Site Name' and there would be a total of 18 fields (including Site Name) that need to be displayed on the form. I do not know the number of rows but I have worked to the potential of 298 (to row 300 for simplicity). Several of the fields would be comboboxes and as these ranges are defined elsewhere I am ok with this part. What I do not know is how to populate the form with existing data and update the file with changes made on the form. I hope I have given the right information "Dave Peterson" wrote: By keeping the discussion in the newsgroups, you'll get a lot of potential responders. You may want to post the details that make this a different problem. Leanne wrote: Hi Dave, Yes sorry about not replying to that. In that instance I was not able to get it to work but did eventually resolve it - with help so can not replicate it! Belive it or not that was a totally different form to the one I am trying to create. Are you willing to communicate via email? Either way, so that I provide the right information, what would you need to know to start with? Sorry I am really new at this side of Excel - give me a formula or chart and I am fine! "Dave Peterson" wrote: I suggested something at your post "Help with Forms" in .programming. If that didn't work, you'll have to provide some more details (well, for me to guess). Leanne wrote: Hi Dave, I thought as much. I have already built a user input form (thanks to Debra's site) but the problem I have with that is I do not know how to get it to update existing data rather than enter new data. What I want to achieve with this form is for the user to make changes to an existing record. I will check out Peter's site and see if that sheds any light on the correct coding needed to update. Thanks "Dave Peterson" wrote: I don't think so. John Walkenbach has an enhanced data form: http://j-walk.com/ss/dataform/index.htm And the source code is available for a small fee ($20 USA, IIRC). So you can modify it as much as you want. And if that's not sufficient, then maybe you could design your own input userform. Debra Dalgleish shares some tips: http://contextures.com/xlUserForm01.html Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Leanne wrote: I have a command button activate the standard Data form for a sheet as I have no idea how to create a customer form to update records. My question is this - is there anyway to edit the standard form - really what I want is to disable the 'New' button so that users do not use it to create new records - there is a custom form for this. Any help would be appreciated as this is all very new to me. Thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
I guess I still don't understand why the previous suggestion won't work.
You'd have to change it to use the correct worksheet, column, control, though. Leanne wrote: Yes I understand. It is the same problem in that I need information from the form to be returned to the existing record rather than create a new record. This I do not know how to right. What I want is - A form that can take data from a specified sheet (which is hidden but that can change if necessary) and populate the form. Then when changes are made to the entry the specified sheet is updated with that information for that particular record. The sheet is called 'Internal Sales Report' and the unique field would be 'Site Name' and there would be a total of 18 fields (including Site Name) that need to be displayed on the form. I do not know the number of rows but I have worked to the potential of 298 (to row 300 for simplicity). Several of the fields would be comboboxes and as these ranges are defined elsewhere I am ok with this part. What I do not know is how to populate the form with existing data and update the file with changes made on the form. I hope I have given the right information "Dave Peterson" wrote: By keeping the discussion in the newsgroups, you'll get a lot of potential responders. You may want to post the details that make this a different problem. Leanne wrote: Hi Dave, Yes sorry about not replying to that. In that instance I was not able to get it to work but did eventually resolve it - with help so can not replicate it! Belive it or not that was a totally different form to the one I am trying to create. Are you willing to communicate via email? Either way, so that I provide the right information, what would you need to know to start with? Sorry I am really new at this side of Excel - give me a formula or chart and I am fine! "Dave Peterson" wrote: I suggested something at your post "Help with Forms" in .programming. If that didn't work, you'll have to provide some more details (well, for me to guess). Leanne wrote: Hi Dave, I thought as much. I have already built a user input form (thanks to Debra's site) but the problem I have with that is I do not know how to get it to update existing data rather than enter new data. What I want to achieve with this form is for the user to make changes to an existing record. I will check out Peter's site and see if that sheds any light on the correct coding needed to update. Thanks "Dave Peterson" wrote: I don't think so. John Walkenbach has an enhanced data form: http://j-walk.com/ss/dataform/index.htm And the source code is available for a small fee ($20 USA, IIRC). So you can modify it as much as you want. And if that's not sufficient, then maybe you could design your own input userform. Debra Dalgleish shares some tips: http://contextures.com/xlUserForm01.html Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Leanne wrote: I have a command button activate the standard Data form for a sheet as I have no idea how to create a customer form to update records. My question is this - is there anyway to edit the standard form - really what I want is to disable the 'New' button so that users do not use it to create new records - there is a custom form for this. Any help would be appreciated as this is all very new to me. Thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
Maybe I did not make the changes correctly. Most of the time I seem to get
it right simply by mistake. "Dave Peterson" wrote: I guess I still don't understand why the previous suggestion won't work. You'd have to change it to use the correct worksheet, column, control, though. Leanne wrote: Yes I understand. It is the same problem in that I need information from the form to be returned to the existing record rather than create a new record. This I do not know how to right. What I want is - A form that can take data from a specified sheet (which is hidden but that can change if necessary) and populate the form. Then when changes are made to the entry the specified sheet is updated with that information for that particular record. The sheet is called 'Internal Sales Report' and the unique field would be 'Site Name' and there would be a total of 18 fields (including Site Name) that need to be displayed on the form. I do not know the number of rows but I have worked to the potential of 298 (to row 300 for simplicity). Several of the fields would be comboboxes and as these ranges are defined elsewhere I am ok with this part. What I do not know is how to populate the form with existing data and update the file with changes made on the form. I hope I have given the right information "Dave Peterson" wrote: By keeping the discussion in the newsgroups, you'll get a lot of potential responders. You may want to post the details that make this a different problem. Leanne wrote: Hi Dave, Yes sorry about not replying to that. In that instance I was not able to get it to work but did eventually resolve it - with help so can not replicate it! Belive it or not that was a totally different form to the one I am trying to create. Are you willing to communicate via email? Either way, so that I provide the right information, what would you need to know to start with? Sorry I am really new at this side of Excel - give me a formula or chart and I am fine! "Dave Peterson" wrote: I suggested something at your post "Help with Forms" in .programming. If that didn't work, you'll have to provide some more details (well, for me to guess). Leanne wrote: Hi Dave, I thought as much. I have already built a user input form (thanks to Debra's site) but the problem I have with that is I do not know how to get it to update existing data rather than enter new data. What I want to achieve with this form is for the user to make changes to an existing record. I will check out Peter's site and see if that sheds any light on the correct coding needed to update. Thanks "Dave Peterson" wrote: I don't think so. John Walkenbach has an enhanced data form: http://j-walk.com/ss/dataform/index.htm And the source code is available for a small fee ($20 USA, IIRC). So you can modify it as much as you want. And if that's not sufficient, then maybe you could design your own input userform. Debra Dalgleish shares some tips: http://contextures.com/xlUserForm01.html Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Leanne wrote: I have a command button activate the standard Data form for a sheet as I have no idea how to create a customer form to update records. My question is this - is there anyway to edit the standard form - really what I want is to disable the 'New' button so that users do not use it to create new records - there is a custom form for this. Any help would be appreciated as this is all very new to me. Thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
If you can't get it going, it's good to post the code that you used. And
include a description of the important things (whatever that means!). Leanne wrote: Maybe I did not make the changes correctly. Most of the time I seem to get it right simply by mistake. "Dave Peterson" wrote: I guess I still don't understand why the previous suggestion won't work. You'd have to change it to use the correct worksheet, column, control, though. Leanne wrote: Yes I understand. It is the same problem in that I need information from the form to be returned to the existing record rather than create a new record. This I do not know how to right. What I want is - A form that can take data from a specified sheet (which is hidden but that can change if necessary) and populate the form. Then when changes are made to the entry the specified sheet is updated with that information for that particular record. The sheet is called 'Internal Sales Report' and the unique field would be 'Site Name' and there would be a total of 18 fields (including Site Name) that need to be displayed on the form. I do not know the number of rows but I have worked to the potential of 298 (to row 300 for simplicity). Several of the fields would be comboboxes and as these ranges are defined elsewhere I am ok with this part. What I do not know is how to populate the form with existing data and update the file with changes made on the form. I hope I have given the right information "Dave Peterson" wrote: By keeping the discussion in the newsgroups, you'll get a lot of potential responders. You may want to post the details that make this a different problem. Leanne wrote: Hi Dave, Yes sorry about not replying to that. In that instance I was not able to get it to work but did eventually resolve it - with help so can not replicate it! Belive it or not that was a totally different form to the one I am trying to create. Are you willing to communicate via email? Either way, so that I provide the right information, what would you need to know to start with? Sorry I am really new at this side of Excel - give me a formula or chart and I am fine! "Dave Peterson" wrote: I suggested something at your post "Help with Forms" in .programming. If that didn't work, you'll have to provide some more details (well, for me to guess). Leanne wrote: Hi Dave, I thought as much. I have already built a user input form (thanks to Debra's site) but the problem I have with that is I do not know how to get it to update existing data rather than enter new data. What I want to achieve with this form is for the user to make changes to an existing record. I will check out Peter's site and see if that sheds any light on the correct coding needed to update. Thanks "Dave Peterson" wrote: I don't think so. John Walkenbach has an enhanced data form: http://j-walk.com/ss/dataform/index.htm And the source code is available for a small fee ($20 USA, IIRC). So you can modify it as much as you want. And if that's not sufficient, then maybe you could design your own input userform. Debra Dalgleish shares some tips: http://contextures.com/xlUserForm01.html Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Leanne wrote: I have a command button activate the standard Data form for a sheet as I have no idea how to create a customer form to update records. My question is this - is there anyway to edit the standard form - really what I want is to disable the 'New' button so that users do not use it to create new records - there is a custom form for this. Any help would be appreciated as this is all very new to me. Thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
how to get a data form to fill you own exel sheet (was data-form | Excel Worksheet Functions | |||
data form | Excel Discussion (Misc queries) | |||
format data displayed on Excel data entry form | Setting up and Configuration of Excel | |||
have 3 worksheets, 1 is a form, the other 2 data for the form-wan. | Excel Worksheet Functions |