Web Database Form Buttons No Wizzard!!!

[tucker1003]

I noticed something when creating a Combo Box in my WEB database Form.
I don't get the wizard nor I don't get as many actions to apply to that combo box or buttons either! I have 3 ebooks on Access 2010 that I reference and all never give any detailed help in how to apply actions without the wizard.

Can anyone please help figure this out?

I want to use a Combo Box to be able to enter a value or select from previous entered values. I am able to enter the first value, and set an action to SaveRecord, but there is no action to Add New Entry. How can I accomplish this?? Remember this is a Web Database.



Thanks in Advance!

[pkstormy]

I'm not sure if there are any differences for a web combobox versus a combobox on an MSAccess form but on an MSAccess form, you'd set the 'Limit To List' = Yes and then use the 'On Not in List' event which has a 'NewData' parameter for the new text which you can write code against (ie. open a recordset and append the NewData value). You may also want to set the Response = acdataerrcontinue (1st line of vba code in the On Not in List event) so it does it silently.

BUT don't get this confused with the combobox on the form for a recordsource where it only ever gets a single value for that record.

In the Not In List event you need to write vba code to open a recordset and append the NewData value to the correct table (and then probably requery the combobox so the new value shows in the rowsource (ie. dropdown) for the combobox).

[khudsonllb]

Note that you cannot write VBA code for web databases. You can write the code in the client application, and it will be stored on the SharePoint site, but will only run in the client when a user downloads the database to his/her desktop.

Some functionality is not available in web databases. This may be one example.

[pkstormy]

You can write vb.net code for web development (same syntax as vba) but typically, stored procedures/views are writtin in SQL Server and the web application then calls those procedures as needed.

I myself avoid SharePoint for several reasons.

[pkstormy]

I am able to enter the first value, and set an action to SaveRecord, but there is no action to Add New Entry. How can I accomplish this?? Remember this is a Web Database.

Thanks in Advance!

You need a stored procedure on SQL Server (or whatever backend) to actually perform the action of adding the data to the db. The stored procedure is then simply callled with the php or web coding.