Need help with a access page

[philip]

hello everybody, I've been struggling with a "problem" for a while now. Here goes

I've done an access database with a nice llittle menu, but I want to convert the menu to a page. But for some reason I cant get the command button on the page to open another form on the same database.

Can you please help

 

[saintsman]

Start again and use the wizard.

 

[philip]

Thanx for the reply, but do u know of any manual way to do this?

 

[saintsman]

In the properties for the command button, enter what form you want to open where it says 'On Click'.

 

[philip]

there is no onclick in the properties box

 

[saintsman]

Have you got the 'Event' or 'All' tab displayed on the properties?

 

[philip]

The "all" tab

 

[saintsman]

Well if you don't have an on click property it has stumped me.

I know it may be obvious but have you highlighted the command button before you look at the properties?

 

[philip]

yes, Ive done that.
Maybe there is another way to do this, can you convert a form to a page or create a hyperlink to open the form. The wizard wont work cause it is requesting a table to use, but the menu is not from a table it is a blank form with a bunch of command buttons on it.

Is there a way of creating a table to act as a menu?

 

[saintsman]

I think you are doing something wrong.

There is nothing wrong with using a blank form with a number of command buttons, each one an option in your menu.

Forgive me if you have already done this:

On you blank form, attach a new command button. The wizard should open and give you a choice. Select 'form operations' and 'open form'.

You will then see a list of forms that you select from. It should not show any Tables. From that point the instructions should be clear.

HTH

 

[philip]

I think there is a miscomunication, I know how to do a form, but access has got the option to create a page (web page) within the database. this is where I'm having problems, there is no wizard on a page, and the prperties for a command button on a form differs from the one on a page.

 

[saintsman]

Sorry, I haven't looked at web pages before so I can't help you. I suggest that you re-post your question with reference to that specific problem otherwise people may think your problem has been resolved.

Good luck.

 

[philip]

thanx for the help, I aprreciate it

 

[Hayley Baxter]

Haven't used DAP much but I think I am right in saying that if you place your command button on the Data Access Page, right click but instead of going into the properties go into the Microsoft Script Editior and you can open another form from here.

Hay

 

[Autoeng]

Hayley is correct. The call must be done in the Script Editor. Unfortunately the entire page script is displayed so you must search down the button.

There really isn't a lot of info out there on DAP's as not too many people are taking advantage of them yet. I am having a class cutom made for myself and others in my company. After the class I will post the guide.

Autoeng

 

[philip]

sorry to be a bother but I have never worked with the scripts, do any of you have an example for me?

 

[Hayley Baxter]

Go into the Northwind database there is a sample page called review orders. If you make a choice from the list box you are then presented with a command button to view the orders. Go into the design and right click on this button then go into the editor and have a look here. This might give you some idea as to how it is done.

 

[philip]

sorry but I have no idea where to start looking for this, can you possibly help me on how to do this?

 

[Autoeng]

Do you know about the Northwind sample database? OK, we'll assume you don't. Included with Access is a sample db called Northwind. Use Windows Explorer to find it. Not there? It probably wasn't installed with Access. Install it from disk or download it from Microsoft's website.

Now, open the Northwind db and select the pages tab. Open the Review Orders page. Select a supplier from the drop down box. Now you have buttons on the page to open the orders to that supplier. Change to design mode. Select the button, right click and select Microsoft Script Editor from the menu. There you go.

Go down to the second "Order Details Extended" and there you will see the calls to add the various elements.

Autoeng

 

[philip]

thanx, Ill try to figure it out