Close a Data Access Page Using a Command Button

[hcisteve]

I am new to using data access pages. I want to use the page for data entry. But I want people to only enter one set of data. I set the command button to save the data but I don't know how to get it to close the page or go to an different page with a message on it.

 

[Slippenos]

But I want people to only enter one set of data.

What you could do is just manipulate the navigation bar. Set everything equal to False except 'New' and 'Save'. Do this by right-clicking on the Navigation bar in design view and clicking Propertes. You'll see a slew of the buttons all in a row.

As far as closing the page- you can add buttons or links. Just activate them with a Sub in VBScript or a Function in Javascript:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/programdap.asp

[red]An Alternative[/red]:

It sounds like a simple alernative would be to create your front-end in a web-based form and your back-end in Access. You could still use your daps, too.

That way, upon submitting a form- your user could be redirected to a new form or a different page.

I find that DAPS are only good for editing records via the web and viewing them.

For starters, refer to this link for creating forms:

http://www.w3schools.com/html/html_forms.asp

You'll also need to know how to insert form information into an Access database, refer to these pages:

Forms:

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

Forms to Database:

http://www.codefixer.com/tutorials/form_to_database.asp

Via FrontPage:

http://support.microsoft.com/kb/q175770/

The above is only a suggestion. I ran into too many problems with daps back in the day and I will never use/create another one.

FYI-
They are slow and volatile. I think a dap will only handle some five concurrent users before it lags (or even crashes).

 

[cesemj]

Hello,

Does anyone know how to write the vbscript syntax to make a command button close a data access pages and open up a main menu form in access.

Thank you in advance.