Can this be done via Access?

Hi Experts,

After a long M.I.A. time I'm back again.

I would like to know if the following could be accomplished via Access & its
reporting;
- I need to have a rectangular floorplan divided into square sections all
named i.e. A01, A02,...etc
- Within a data entry form user selects/enters one or several cells
- User indicates these selection(s) are confirmed/temporary
- The report will print this floorplan with shaded cells showing i.e. C in
each selected cell
- Rest of the cells shall remain white (no fill)

I have a feeling that it should be done but just can't figure out how/where
to start and basically the logic.

Any help, guidance will highly be appreciated.

Thanks in advance.

Alp


.

Relevant Pages

  • Re: building a reporting sheet which reports by date and shows values of another sheet
    ... look in another cell for the date and you can use indirect to make the sheet ... Then you just have to update cells B9 and B10 with your code and don't have ... > reporting values will change to that day, the only thing is, is i don't ... > change the values in my reporting table, basicaly COUNTIF statements ...
    (microsoft.public.excel.programming)
  • Re: "File error: data may have been lost."
    ... Thanks for reporting, Dominik! ... spreadsheets have in common is that they have a number of merged cells, ... and then select that merged group of cells and do chose ...
    (microsoft.public.mac.office.excel)
  • RE: excel 2007 edit comment problem
    ... Thanks for reporting back with that information. ... "gage" wrote: ... on the sheet, instead of using UNDO immediately, choose a few of the cells ... and see if their contents actually got deleted or if the video display simply ...
    (microsoft.public.excel.misc)
  • Find and report
    ... reporting ... to be able to search all of the cells in a worksheet ... referencing the header/column letter where the cell was found. ...
    (microsoft.public.excel.misc)