Data Access Page

[Darrenc]

Problem Editing a Data Access Page

Hi, I’ve come across a very annoying problem with creating a Data Access Page, I have limited knowledge with using the feature, but for the most part it does work.

My frustrating problem is, after I have created the page and tested what I’ve done, I can’t add or move anything on the page when going back into design mode.
I’ve searched high and low for an answer to this problem, but I can’t find anything on it.
The page I’ve created is a simple ID based error log which I want to put on our company intranet, the form works the way I intended, but its very frustrating that I can’t edit the form in anyway once it has been created.
I am using Access 2000.

Any help with this would be greatly appreciated.

Thanks
Darren.

 

[Darrenc]

Bump!

 

[Darrenc]

Sorry to bring this to the top again, i'm having to re-visit data access pages again, and again i'm having the same problem.
Am i asking for something that access 2000 isn't capable off? Or am i missing the obvious?? (kinda hope its the latter)

Can someone put me out of my misery....please?

 

[Big2]

You might when you created your form selected that the form could not enter design mode from any state. Therefore you will have to enter the .mdb file holding shift which then should solve your problem of not being able to edit the form, as you enter the whole database in design mode.

The options in which you allow design view are the actual form properties, prob need to check them.

 

[Darrenc]

Thanks for the reply Big2, I'm sure that the whole database is editable, but i did the shift key trick just in case.
I've checked the page properties in design mode for the DAP, and the 'ContentEditiable' property is set to 'true'.
I can add fields to the page, and i can re-size them too, i just can't move the fields around the page like i can when designing forms.
When i drag a new field to the page, it just drops it to the next available gap on the page.
I hope i'm explaining this ok, its really frustrating me now.

Has anyone else created data access pages and been able to move fields around in design mode like you can when designing forms?

Thanks

Darren.

 

[reclusivemonkey]

I've played around with DAP a bit and its not very intuitive or user friendly IMHO. Try copying and pasting the page and see if a new copy will allow you to move the fields.

 

[NewfieSarah]

Data Access Page Help

hey guys, I see that you have been chatting about Data Access pages and was wondering if you could help me. I am new to Data Access Pages I havent used them before, but me and my employer have been trying to explore this option. I have changed my form to an data access page and now, none of my command buttons will work?? What might be the problem. I would also like to know some information on filters and trying to add a writing tablet as well. Any and all the information you could give me would be great.Thanks for your help

 

[reclusivemonkey]

Hi Sarah,

Its better to start your own thread when asking for help

Copying a form to a DAP page won't work; they are entirely different technologies. As DAP is a HTML page, to get any interactivity you will need to use JavaScript or VBScript AFAIK.

I've only used DAP on an intranet (its not designed for the internet), providing a Read Only report filtered by a drop down list of dates. They can be tricky, so if you are wanting to do anything complex on a DAP, you might want to reconsider your options. One gotcha I did discover is that you must have a Primary Field in the table you want your DAP page to write to.

 

[NewfieSarah]

Thanks for the advice, I have said copy however I mean i changed it from a form to a DAP. I see that I need Javascript, or VBScript, which I am not fimilliar however, once I saw that the extension changed from a form to a DAP i would think that it would function the same however, it did not. How complex do you think is complex?? Thanks for the help

 

[reclusivemonkey]

I'm not sure what you mean by a "DAP" extension... a DAP page is saved as a HTML page. You can open this up in a text editor and play with the HTML if you are comfortable with that.

With regard to DAP, I would consider anything other than the most simplest of forms complicated. If you need any VBA to make the form work, then it will e tricky to recreate this behaviour in DAP. If you can send me a little more description on what you are trying to achieve, I may be able to advise you better.

 

[NewfieSarah]

Yes I know that I can see the HTML code, However It doesnt look any better then the jave script, all a big pile of code. I cant understand any of it. In the Html code, you have a bit of html code, mixed with javaa script, and then more java script by its self and then vb by its self. I think it doesnt look like they are linked and that is why it isnt working. Do you think I will need to us ASP for it to work. Cause I have read that is what it needs.

 

[reclusivemonkey]

Yes I know that I can see the HTML code, However It doesnt look any better then the jave script, all a big pile of code. I cant understand any of it.

If a "big pile of code" isn't your bag, I would stear clear of trying anything complex with DAP. If you get get away with using the navigation buttons available on the dap, and the grouping and filtering features you are provided with. Not sure what you mean by a writing tablet.

Do you think I will need to us ASP for it to work. Cause I have read that is what it needs.

ASP is definitely a better option for a browser frontend to access. If you have this available, I would recommended it over DAP. However, ASP is more code unfortunately. There's a ASP forum here, where you will find help, and this is a good starter;

http://www.w3schools.com/asp/default.asp