| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
J-Walk Enhanced Data Form
HI,
I have downloaded the above form and customised it following the instructions. I have one question that I hope someone can answer. Is there any way (macro, vba code, anything) I can disable the New/Insert button. I only want to use this form for editing existing records. Can anyone help? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
J-Walk Enhanced Data Form
Hi Leanne
Buy the code and you can change it the way you want -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Leanne" wrote in message ... HI, I have downloaded the above form and customised it following the instructions. I have one question that I hope someone can answer. Is there any way (macro, vba code, anything) I can disable the New/Insert button. I only want to use this form for editing existing records. Can anyone help? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
J-Walk Enhanced Data Form
Never mind - I cant change the date from US format to UK format so I can not
use this add-in anyway "Leanne" wrote: HI, I have downloaded the above form and customised it following the instructions. I have one question that I hope someone can answer. Is there any way (macro, vba code, anything) I can disable the New/Insert button. I only want to use this form for editing existing records. Can anyone help? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
J-Walk Enhanced Data Form
Pay John the 20 bucks for the source code and edit as you wish.
Gord Dibben MS Excel MVP On Tue, 22 Apr 2008 07:22:05 -0700, Leanne wrote: HI, I have downloaded the above form and customised it following the instructions. I have one question that I hope someone can answer. Is there any way (macro, vba code, anything) I can disable the New/Insert button. I only want to use this form for editing existing records. Can anyone help? Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
J-Walk Enhanced Data Form
I have already emailed John and he can not resolve the data issue for me so
there is no point as I can not use the form. "Gord Dibben" wrote: Pay John the 20 bucks for the source code and edit as you wish. Gord Dibben MS Excel MVP On Tue, 22 Apr 2008 07:22:05 -0700, Leanne wrote: HI, I have downloaded the above form and customised it following the instructions. I have one question that I hope someone can answer. Is there any way (macro, vba code, anything) I can disable the New/Insert button. I only want to use this form for editing existing records. Can anyone help? Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
J-Walk Enhanced Data Form
Thanks for letting us know the outcome.
Unfortunate. Gord On Thu, 24 Apr 2008 07:19:01 -0700, Leanne wrote: I have already emailed John and he can not resolve the data issue for me so there is no point as I can not use the form. "Gord Dibben" wrote: Pay John the 20 bucks for the source code and edit as you wish. Gord Dibben MS Excel MVP On Tue, 22 Apr 2008 07:22:05 -0700, Leanne wrote: HI, I have downloaded the above form and customised it following the instructions. I have one question that I hope someone can answer. Is there any way (macro, vba code, anything) I can disable the New/Insert button. I only want to use this form for editing existing records. Can anyone help? Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
J-Walk Enhanced Data Form
Indeed it is unfortunate - any help I can get with this project is a god send.
-- Leanne M (Aussie) (Changed Display name from Leanne) United Kingdom (Don''t ask me what an Aussie is doing living in the UK!) "Gord Dibben" wrote: Thanks for letting us know the outcome. Unfortunate. Gord On Thu, 24 Apr 2008 07:19:01 -0700, Leanne wrote: I have already emailed John and he can not resolve the data issue for me so there is no point as I can not use the form. "Gord Dibben" wrote: Pay John the 20 bucks for the source code and edit as you wish. Gord Dibben MS Excel MVP On Tue, 22 Apr 2008 07:22:05 -0700, Leanne wrote: HI, I have downloaded the above form and customised it following the instructions. I have one question that I hope someone can answer. Is there any way (macro, vba code, anything) I can disable the New/Insert button. I only want to use this form for editing existing records. Can anyone help? Thanks |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
J-Walk Enhanced Data Form
If you're having trouble getting dates with John's enhanced userform (not John's
fault--that's the way excel works!), maybe you could modify his code to include a calendar control (instead of a textbox???). http://www.rondebruin.nl/calendar.htm From Ron de Bruin's site. Leanne M (Aussie) wrote: Indeed it is unfortunate - any help I can get with this project is a god send. -- Leanne M (Aussie) (Changed Display name from Leanne) United Kingdom (Don''t ask me what an Aussie is doing living in the UK!) "Gord Dibben" wrote: Thanks for letting us know the outcome. Unfortunate. Gord On Thu, 24 Apr 2008 07:19:01 -0700, Leanne wrote: I have already emailed John and he can not resolve the data issue for me so there is no point as I can not use the form. "Gord Dibben" wrote: Pay John the 20 bucks for the source code and edit as you wish. Gord Dibben MS Excel MVP On Tue, 22 Apr 2008 07:22:05 -0700, Leanne wrote: HI, I have downloaded the above form and customised it following the instructions. I have one question that I hope someone can answer. Is there any way (macro, vba code, anything) I can disable the New/Insert button. I only want to use this form for editing existing records. Can anyone help? Thanks -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
J-Walk Enhanced Data Form
I guess but I just left it as John said he tried all sorts and could not
change it. It is only because I am in the UK and we display the days differently to the US. ie we display day/mth/year -- Leanne M (Aussie) (Changed Display name from Leanne) United Kingdom (Don''t ask me what an Aussie is doing living in the UK!) "Dave Peterson" wrote: If you're having trouble getting dates with John's enhanced userform (not John's fault--that's the way excel works!), maybe you could modify his code to include a calendar control (instead of a textbox???). http://www.rondebruin.nl/calendar.htm From Ron de Bruin's site. Leanne M (Aussie) wrote: Indeed it is unfortunate - any help I can get with this project is a god send. -- Leanne M (Aussie) (Changed Display name from Leanne) United Kingdom (Don''t ask me what an Aussie is doing living in the UK!) "Gord Dibben" wrote: Thanks for letting us know the outcome. Unfortunate. Gord On Thu, 24 Apr 2008 07:19:01 -0700, Leanne wrote: I have already emailed John and he can not resolve the data issue for me so there is no point as I can not use the form. "Gord Dibben" wrote: Pay John the 20 bucks for the source code and edit as you wish. Gord Dibben MS Excel MVP On Tue, 22 Apr 2008 07:22:05 -0700, Leanne wrote: HI, I have downloaded the above form and customised it following the instructions. I have one question that I hope someone can answer. Is there any way (macro, vba code, anything) I can disable the New/Insert button. I only want to use this form for editing existing records. Can anyone help? Thanks -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
J-Walk Enhanced Data Form
Typing the dates into a textbox is different from using a popup calendar.
John didn't include anything to do with the calendar control. But if you wanted to type in the date, you could use 3 separate textboxes--month, day, year. Leanne M (Aussie) wrote: I guess but I just left it as John said he tried all sorts and could not change it. It is only because I am in the UK and we display the days differently to the US. ie we display day/mth/year -- Leanne M (Aussie) (Changed Display name from Leanne) United Kingdom (Don''t ask me what an Aussie is doing living in the UK!) "Dave Peterson" wrote: If you're having trouble getting dates with John's enhanced userform (not John's fault--that's the way excel works!), maybe you could modify his code to include a calendar control (instead of a textbox???). http://www.rondebruin.nl/calendar.htm From Ron de Bruin's site. Leanne M (Aussie) wrote: Indeed it is unfortunate - any help I can get with this project is a god send. -- Leanne M (Aussie) (Changed Display name from Leanne) United Kingdom (Don''t ask me what an Aussie is doing living in the UK!) "Gord Dibben" wrote: Thanks for letting us know the outcome. Unfortunate. Gord On Thu, 24 Apr 2008 07:19:01 -0700, Leanne wrote: I have already emailed John and he can not resolve the data issue for me so there is no point as I can not use the form. "Gord Dibben" wrote: Pay John the 20 bucks for the source code and edit as you wish. Gord Dibben MS Excel MVP On Tue, 22 Apr 2008 07:22:05 -0700, Leanne wrote: HI, I have downloaded the above form and customised it following the instructions. I have one question that I hope someone can answer. Is there any way (macro, vba code, anything) I can disable the New/Insert button. I only want to use this form for editing existing records. Can anyone help? Thanks -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enhanced lottery question | Excel Discussion (Misc queries) | |||
| Editing a column chart for Variance Walk negative numbers | Charts and Charting in Excel | |||
| 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 | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Linear Mode
