RE: adding fully fuctional spreadsheet to a form

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

Can someone help us on this?

"Danny" wrote:

> 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 !
>
> "GeorgiaK" wrote:
>
> > 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!!!
> >
> > "Danny" wrote:
> >
> > > Is there a way of adding say excel to a form - which would have the same
> > > functions availabilty as the normal excel application.
> > >
> > > I wanted to avoid the user changing from one application to another i.e.
> > > access to excel and back to access.
> > >
> > > I have searched all the web sites, but cannot find anything apart from this
> > > , but do not know hoe implement it.
> > > http://www.vbdotnetheaven.com/Code/Jul2003/2124.asp
> > >
> > > Thanks
> > > Danny
> > >
> > >
.

Relevant Pages

  • RE: adding fully fuctional spreadsheet to a form
    ... It's hard to beleive that with all the MV and programmers that a solution is ... it that it's not in MS's interest to add this to the functionality of access! ... 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 ...
    (microsoft.public.access.modulesdaovba)
  • Re: Excel should allow a number formats of HEX, OCT and BIN.
    ... Excel is *NOT* a tool for programmers. ... statistical analysis, engineering, genetic research, and a whole host ... If you want this functionality in a spreadsheet, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: how do i enable the old menu bar
    ... MVP FAQ site: http://mvps.org/ ... box" with which multiple changes could be made to Excel 2007 charts. ... for the new ribbons, ... they seem to provide about 90% of the previous functionality of ...
    (microsoft.public.word.docmanagement)
  • Re: how do i enable the old menu bar
    ... MVP FAQ site: http://mvps.org/ ... box" with which multiple changes could be made to Excel 2007 charts. ... for the new ribbons, ... they seem to provide about 90% of the previous functionality of ...
    (microsoft.public.word.docmanagement)
  • Re: Data Analysis Toolpak Add-In for Excel
    ... functionality to Excel 2004. ... advertising the removal of additional features on their web site... ... I truly hope that error bar functionality and add-ins will be reinstated ... McGhie Information Engineering Pty Ltd ...
    (microsoft.public.mac.office)