Despite Data Entry = False the edit box appears for the list & fields overflow

From: Karen Middleton (karenmiddleol_at_yahoo.com)
Date: 12/13/04 

Date: 13 Dec 2004 08:46:52 -0800

Hello All

I am using the Access Data Access pages to report against a Access
query and I have published a data Access page against the Access
query.

Despite having set the property of Data Entry = "false" I cannot edit
the data on the page that is what I want. But despite it the Data
access page shows all the cells data in a Edit box even though I
cannot edit the data I do not want the edit box but a simple HTML
table to display the data.

Please advise how to ensure that the data from my data access page
appears only as a HTML table or how to turn off the edit box. I tried
changing the classname from MsoTextBox to MSoLabel I want it to appear
like a lable but it did not work.

Please advise how to display data instead of a textbox as just labels.

Also, my Access query as 29 columns in it and when I select the access
query the first 12 columns appear to be fine on the page and after
that the columns appear to overlap and each other how can I overcome
this please advice.

Thanks
Karen

Relevant Pages

  • Re: Keeping Tracking of whos adding new data..
    ... Macro to open the form in Add mode, but no edit mode. ... You should be able to use your form query to set the RC criteria to... ... Not sure what you're doing with the TempLue. ... Candia Computer Consulting. ...
    (microsoft.public.access.formscoding)
  • Re: DB Result Wizard Error
    ... open the hidden folder /_fpclass/ and edit the ... > For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... > to display the new equipment information. ... > is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)
  • Re: Modifying the current record in code
    ... You should be able to modify the current record, ... I think that iterating ... > )) I think the best thing to do is run an update query and the ... >> You should remove the Edit and Update also. ...
    (microsoft.public.access.formscoding)
  • RE: Link Excel To Access
    ... You could then use the Links command to edit the file paths (very handy if a ... A query is a one-step data dump from an outside source. ... promtped with "enable automatic refresh" or disable automatic refresh" is ... Then, edit again under Import Data - Edit Query, setup your query to ...
    (microsoft.public.excel.misc)
  • RE: Select Query to create a Total field
    ... What is happening in your form when you edit a field value? ... Do I have to close and rerun the query or will the ... The calculation will update when the record is updated. ... The query works and returns the totals I require in a column Expr1. ...
    (microsoft.public.access.queries)
Loading