I have a WEB enabled Access 2010 database, uploaded on a sharepoint site. the database contains 3 form and a 1 navigation form. The navigation form is the first to show up in the browser, and has the role of presenting the rest 3 forms, as tabs. So you first enter the navigation form and then navigate by choosing the tab you want.OK with that..
One tab is a form that submits data to the database. BUT> if i choose this tab >after> enter a random value to a random field >after> abandon the form by choosing another tab (like quiting, so its WITHOUT PRESSING the "submit" button) the tab changes, BUT the record updates..
this is something i dont want... does anyone know how can i avoid that
The form will probably have a BeforeUpdate event procedure. If you ensure that the Cancel parameter is always set to True unless the update is triggered by the code behind the Submit button then that should give you what you're after.
9 2197
You can set 'required' property to "Yes" for an important field/s in the table. Until & unless you maintain proper record in that field/s data will not be saved. That way you can easily control that.
the form contains courses' fields, a date picker (that has a default value =date() , and two buttons (submit, exit)
i cant make any of the courses lesson required for obvious reasons (maybe one day this course is not taught)
i cant make the button-pressing required i guess,
so the only way is to leave the date blank and put there the "required" right?
Its better to set 'Required' property in tables, instead of doing it in forms. If Date is the only field, then, Yes, may be that will be the only option.
yes i meant to set it in the table so i have the option of setting a custom message if the rule is not ok.
i was thinking of setting something like a macro saying "if (the button submit IS NOT pressed,delete all inputs)" or "if (the other tabs are pressed, delete all inputs" something like this..ofcourse the syntax is wrong but jsut to explain you... would it work(if applicable)?
--sorry my first thought is wrong ..about the macro no1
NeoPa 32,556
Expert Mod 16PB
The form will probably have a BeforeUpdate event procedure. If you ensure that the Cancel parameter is always set to True unless the update is triggered by the code behind the Submit button then that should give you what you're after.
I found the solution>>
there is the navigation form's panel (typically the buttons on the left). every button is one form. if you press another button in the middle of a form's completion, the form switches and if not any ristriction, submits the data(something i didnt want).BUT
if you make the form open by a button, then the only available
form-opening-method is "dialog"...so it opens the form you choose, in a dialog boz, where you have no option to press something else, except for SUBMIT it and EXIT...
so it works perfect!!
Also, many many bugs if you use sharepoint with IE and CHROME...many..
George, I'll call it as a 'workaround' for doing this. This is not fool proof. What NeoPa advised is best practice, for sure.
In any database, there are numerous ways to achieve your aim, but what is the best practice is something that matters.
However, if it serve your purpose, then you can close this thread.
i obviously respect 1)when someone responds to my thread2)the answer itself..
actually the popup of the form is better as a solution for me. Probably not for everyone.
thank you again :)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Matt |
last post by:
Hi everyone, still pretty new to MySQL. I was
wondering if there is a way to automatically filter
records based on a mysql userlogin name??
I have serveral databases that I want to combine
in...
|
by: Jason |
last post by:
I am trying to filter records in a primary form based on records in
related tables. The data in the related tables is being displayed in
the primary form
through subforms. To be more specific, I...
|
by: Kevin Myers |
last post by:
Hello,
Please forgive my reposting of this note with hopefully a more relevant
subject line.
On an Access 2000 form under Windows 2000 I would like to use a Kodak Image
Edit Control to...
|
by: Ellen Manning |
last post by:
I've got an A2K continuous form based on a query of 2 tables. The
query returns results if the field "Outstanding" = Yes. The form's
recordset type is set to Inconsistent Updates. If the user...
|
by: Sandy |
last post by:
Hi all,
I have a form to list records (frmListIssue) which I call from different
other forms. My wish is to display a message when the form is called and
empty; no records to display. I want to...
|
by: vermon |
last post by:
Is there any way to make a web app that updates automatically when the
server updates some flags? An example would be a web mail interface that
automatically updates the new email count as emails...
|
by: Yarik |
last post by:
Hello,
Here is a sample (and very simple) code that binds an Access 2003 form
to a fabricated ADO recordset:
' Create recordset...
Dim rs As ADODB.Recordset: Set rs = New ADODB.Recordset
'...
|
by: ringer |
last post by:
I need to run an append query when I open my db that will look at a date in
the records and copy the records when date() >= and some
other criteria.
I have the append query working perfectly. But...
|
by: John Kirkpatrick |
last post by:
Hi all,
I am having difficulty displaying records on a frontend MS Access 2000 form using a MySQL backend. The following code works well with the Jet database engine but doesn't work properly...
|
by: shripal |
last post by:
hello,every one
i have made the application to fill up the web form automatically in c#.net but i am not able to submit the form automatically that is submit button should be pressed automatically...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| | |