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.
[email protected]

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

<[email protected]> wrote in message
news:[email protected]...
> 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.
> [email protected]
>

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
>
> <[email protected]> wrote in message
> news:[email protected]...
> > 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.
> > [email protected]
> >

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



<[email protected]> wrote in message
news:[email protected]...
> 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
>>
>> <[email protected]> wrote in message
>> news:[email protected]...
>> > 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.
>> > [email protected]
>> >
>

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,
[email protected]
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
>
>
>
> <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >>
> >> <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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.
> >> > [email protected]
> >> >
> >

to retrieve date
Userform1.Textbox1.Text

should have been

to retrieve date
Userform1.Textbox1.Text = Range("A1").Value

--
Regards,
Tom Ogilvy


"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>
> <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>>
>>> <[email protected]> wrote in message
>>> news:[email protected]...
>>> > 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.
>>> > [email protected]
>>> >
>>
>
>