On Tuesday 15 November 2005 08:49 am, David Rudel wrote:
> Hello,
> A friend of mine is having problems with base. She has the current JRE and
> is running 2000 Professional.
> Two problems in particular:
> 1. It appears to hang sometimes.
> 2. She cannot figure out how to save a spreadsheet within the database. She
> is not given the option of "Save" or "Save as" or anything within the
> spreadsheet. It appears the only way to save is to close the spreadsheet
> and save from the main database window, and she has reported this not
> actually saving all the data she had entered into the spreadsheet. There
> must be some simple way of saving spreadsheets she is working on.
> What are we doing wrong?
> -David
Spreadsheet do not exist within a Base file: Base only connects to the
spreadsheet. Furthermore, The connection between Base and the spreadsheet is
strictly read only: you can not write to the spreadsheet from Base.
I assume she wants to have certain fields with which she imputs
information into the spreadsheet. I also assume she wants to be able to use
the speadsheet to do calculations on those fields.
A Base file can be created to hold these fields and their values. A query
can then be created to place the fields she wants in the correct order. The
data from these fields can then be inserted into pre-determined cells of the
spreadsheet. (This is done by using the Data to Text icon.) Any calculations
she then wants to make can be made. There are several steps necessary to do
this. If she wants the details on how to do this, have her email me.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
