|
Information about excel vs db tools
Hello,
I have an application that I wrote in excel. It has 80 fields that I wrote a front end just to put data into the excel spread sheet. Now, the customer would like to view and change records thru the front end. I am not sure to go about this using excel. But I believe that using a db tool like MSaccess would allow the functionality that the customer requires. But the customer is unwilling to invest in the project - there in lies the rub. Is there a tool out there that is freeware that will allow me to import what I have built (GUI front and/or data from the excel sheet.) But will allow for the reports (like access) based on the tables? Or is there a way to write the change and review functionality in excel? Any advice would be appreciated. |
Information about excel vs db tools
Ok. mmm, haven't done that. Any quick tutorials?
Tom Ogilvy wrote: If you used a userform to allow the user to enter data, then pulling up existing data, allowing the user to edit it and writing it back should be trivial. If you formatted a worksheet for this purpose, again, adding code for the additional functionality should be very easy. -- Regards, Tom Ogilvy wrote in message oups.com... Hello, I have an application that I wrote in excel. It has 80 fields that I wrote a front end just to put data into the excel spread sheet. Now, the customer would like to view and change records thru the front end. I am not sure to go about this using excel. But I believe that using a db tool like MSaccess would allow the functionality that the customer requires. But the customer is unwilling to invest in the project - there in lies the rub. Is there a tool out there that is freeware that will allow me to import what I have built (GUI front and/or data from the excel sheet.) But will allow for the reports (like access) based on the tables? Or is there a way to write the change and review functionality in excel? Any advice would be appreciated. |
Information about excel vs db tools
Existing code to write data
range("A1").Value = Userform1.Textbox1.Text Now add additional functionality to retrieve date Userform1.Textbox1.Text after it is edited range("A1").Value = Userform1.Textbox1.Text obviously, there is more involved, but with no details, this should give you the idea. -- Regards, Tom Ogilvy wrote in message ups.com... Ok. mmm, haven't done that. Any quick tutorials? Tom Ogilvy wrote: If you used a userform to allow the user to enter data, then pulling up existing data, allowing the user to edit it and writing it back should be trivial. If you formatted a worksheet for this purpose, again, adding code for the additional functionality should be very easy. -- Regards, Tom Ogilvy wrote in message oups.com... Hello, I have an application that I wrote in excel. It has 80 fields that I wrote a front end just to put data into the excel spread sheet. Now, the customer would like to view and change records thru the front end. I am not sure to go about this using excel. But I believe that using a db tool like MSaccess would allow the functionality that the customer requires. But the customer is unwilling to invest in the project - there in lies the rub. Is there a tool out there that is freeware that will allow me to import what I have built (GUI front and/or data from the excel sheet.) But will allow for the reports (like access) based on the tables? Or is there a way to write the change and review functionality in excel? Any advice would be appreciated. |
Information about excel vs db tools
Thank you.
I also see that you have written a number of responses about this subject. A search of 'editing userform data' brought out a number of informational responses. I need to digest all of this information but it looks very capable of being done in excel. Thank you, Tom Ogilvy wrote: Existing code to write data range("A1").Value = Userform1.Textbox1.Text Now add additional functionality to retrieve date Userform1.Textbox1.Text after it is edited range("A1").Value = Userform1.Textbox1.Text obviously, there is more involved, but with no details, this should give you the idea. -- Regards, Tom Ogilvy wrote in message ups.com... Ok. mmm, haven't done that. Any quick tutorials? Tom Ogilvy wrote: If you used a userform to allow the user to enter data, then pulling up existing data, allowing the user to edit it and writing it back should be trivial. If you formatted a worksheet for this purpose, again, adding code for the additional functionality should be very easy. -- Regards, Tom Ogilvy wrote in message oups.com... Hello, I have an application that I wrote in excel. It has 80 fields that I wrote a front end just to put data into the excel spread sheet. Now, the customer would like to view and change records thru the front end. I am not sure to go about this using excel. But I believe that using a db tool like MSaccess would allow the functionality that the customer requires. But the customer is unwilling to invest in the project - there in lies the rub. Is there a tool out there that is freeware that will allow me to import what I have built (GUI front and/or data from the excel sheet.) But will allow for the reports (like access) based on the tables? Or is there a way to write the change and review functionality in excel? Any advice would be appreciated. |
Information about excel vs db tools
to retrieve date
Userform1.Textbox1.Text should have been to retrieve date Userform1.Textbox1.Text = Range("A1").Value -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Existing code to write data range("A1").Value = Userform1.Textbox1.Text Now add additional functionality to retrieve date Userform1.Textbox1.Text after it is edited range("A1").Value = Userform1.Textbox1.Text obviously, there is more involved, but with no details, this should give you the idea. -- Regards, Tom Ogilvy wrote in message ups.com... Ok. mmm, haven't done that. Any quick tutorials? Tom Ogilvy wrote: If you used a userform to allow the user to enter data, then pulling up existing data, allowing the user to edit it and writing it back should be trivial. If you formatted a worksheet for this purpose, again, adding code for the additional functionality should be very easy. -- Regards, Tom Ogilvy wrote in message oups.com... Hello, I have an application that I wrote in excel. It has 80 fields that I wrote a front end just to put data into the excel spread sheet. Now, the customer would like to view and change records thru the front end. I am not sure to go about this using excel. But I believe that using a db tool like MSaccess would allow the functionality that the customer requires. But the customer is unwilling to invest in the project - there in lies the rub. Is there a tool out there that is freeware that will allow me to import what I have built (GUI front and/or data from the excel sheet.) But will allow for the reports (like access) based on the tables? Or is there a way to write the change and review functionality in excel? Any advice would be appreciated. |
| All times are GMT +1. The time now is 10:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com