RE: adding fully fuctional spreadsheet to a form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Tim

I oviously did not make my point clear enough.

Which is that , if you can add a spreedsheet version 10.0 (as at activx
control) on a form. Why do you loose any work that you do on that worksheet
when the form (in my case a form on a tabcontrol) is closed.
Yes I know you loose any work you do on that control - what I wanted to know
was can this work be saved, or was there a way of adding the same activx
control provided by another vendor.

And yes I do know the diff between spreadsheet and a databse - what I am
looking for is the flexability of working with in one application - so that
the end user does not have to switch between access and MS Excell.

Thanks your your comments

"Tim Ferguson" wrote:

> "=?Utf-8?B?RGFubnk=?=" <Danny@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> news:B7A548BF-B930-4F84-BFE9-E4AE236A7AB0@xxxxxxxxxxxxx:
>
> >> I have a question! I want to link a fully functional spreadsheet
> >> with formulas with my access database. I linked them however when in
> >> access: one column that does not contain formulas is blank...also
> >> another column with the following formula
> >> =IF(AA4<0,"$0.00",IF(AA4>0,AA4)) is showing up with the following:
> >> #Num!. Also is there a way to use access only and have the formulas
> >> updated? The reason I linked the 2 is all the information was in
> >> excel and I need the formulas and my company wants the info in access
> >> to run reports and to store the info. Am I going about this in the
> >> right way? Help!!!
> >>
> > It's hard to beleive that with all the MV and programmers that a
> > solution is not out there, there must be others out there that need
> > this solution or is it that it's not in MS's interest to add this to
> > the functionality of access !
>
> My hammer is not particularly good at making toast either, but I don't
> plan to complain to Black and Decker about it. The jobs that spreadsheets
> and databases do are just about as different...
>
> First of all, Access is simply just not going to make any sense of
> something that depends on row numbers. Records in a database are just
> records -- there is no implicit sorting or recordnumbers. Roughly the
> same applies to columns: although it is possible to call a field "AA4" it
> would be a really stupid thing to do. Furthermore, there is no sense in
> which it would be helpful to define one field purely in terms of the
> values in (an)other field(s). Sorry: this is primary school R theory and
> if you don't understand it, then you need to do some basic reading.
>
> See the other reply upthread from the anonymous at earthlink.
>
> There are plenty of things to moan at Microsoft about -- to many minds
> there is already to much Excel-like crossover going on in Access already
> -- but this has nothing to do with MS's interests, being more about not
> making a dog's dinner out of a pretty good desktop R database system.
>
> Best wishes
>
>
> Tim F
>
>
.

Relevant Pages

  • Jet cannot find the object ".
    ... I have a form with a Microsoft Office Spreadsheet 10.0 control on it. ... I have a procedure that manipulates the control to format it as required. ... Microsoft Jet database engine could not find the object ". ...
    (microsoft.public.access.formscoding)
  • Re: How do I Link an XL Program to a Access Database
    ... You can create a linked table that is actually what is in a spreadsheet: ... select the database window, ... right click on a blank area within the window ... that gives you complete control over everything. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Favorite word processor?
    ... elements, text boxes with full independent wordprocessing functions, ... user's control ... ... Hand off the spreadsheet to someone else, ... use that function on a cell fetched from a database" ...
    (comp.sys.mac.system)
  • Re: Spreadsheet vs Database for certain situations
    ... articulate these things? ... Save the data in a database, ... If your friend is using the spreadsheet for a what-if scenario fine. ... You have no control over the data in a spreadsheet and the "data" rapidly ...
    (comp.databases.paradox)
  • Re: FrontPage w/ Spreadsheet control
    ... Excel Services for .NET is coming... ... I wanted to indicate on the web page's spreadsheet shaded areas showing ... same import errors I was getting with the HTML import and that is the file ... Even with the owc executed I still can't see the spreadsheet control. ...
    (microsoft.public.office.developer.web.components)