473,761 Members | 4,082 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Preventing Autosave on form with multiple subforms

I have an application with a master form with a tab control containing
nine tabs, each tab contains a subform. I have command buttons on my
main form including: Save , Cancel , Close.

My question is, how can I prevent Access from auto-saving changed or
entered data on both the main form and any subform?

The main goal is to force the user to use the 'Save' button to save any
data. I need the 'Cancel' button to just undo any changes since
opening the form or since last save. And I need the 'Close' button to
just close the form without saving any changes since last time 'Save'
button was clicked.

In previous applications without subforms I was able to accomplish a
similar scenerio with using me.undo in the unload event of the form
and/or on the click event of both the Cancel and Close buttons. This
doesnt work with the subforms, because the command buttons are on the
main form and not each subform, nor would I want that. It is also not
working all the time with the data on the master form, certain
scenerios are still saving data when closing the form. It is also
auto-saving data on the subforms as I move between the tabs, I would
like to prevent this as well

Is there anyway to accomplish this goal? Only thing I could think of
would be to make each subform and/or field unbound, and pass the data
to the tables only at the time of clicking Save. Are there any other
options as this would be a lot of code for 9 subforms, some with as
many as 20 or so fields to populate?

Any guidance is appreciated as I'm on a tight time schedule to finish
development and deploy this app.

Apr 26 '06 #1
4 3758
As soon as you leave a subform the data will be saved.
You can not prevent that, other than going 'unbound'.
Maybe you could try temptables to 'collect the data' and some append-query's to save the data to the real tables?

But do you indeed need 9 subforms to collect your data or am I missing something here??

Arno R

"microb0x" <wo*******@gmai l.com> schreef in bericht news:11******** **************@ j33g2000cwa.goo glegroups.com.. .
I have an application with a master form with a tab control containing
nine tabs, each tab contains a subform. I have command buttons on my
main form including: Save , Cancel , Close.

My question is, how can I prevent Access from auto-saving changed or
entered data on both the main form and any subform?

The main goal is to force the user to use the 'Save' button to save any
data. I need the 'Cancel' button to just undo any changes since
opening the form or since last save. And I need the 'Close' button to
just close the form without saving any changes since last time 'Save'
button was clicked.

In previous applications without subforms I was able to accomplish a
similar scenerio with using me.undo in the unload event of the form
and/or on the click event of both the Cancel and Close buttons. This
doesnt work with the subforms, because the command buttons are on the
main form and not each subform, nor would I want that. It is also not
working all the time with the data on the master form, certain
scenerios are still saving data when closing the form. It is also
auto-saving data on the subforms as I move between the tabs, I would
like to prevent this as well

Is there anyway to accomplish this goal? Only thing I could think of
would be to make each subform and/or field unbound, and pass the data
to the tables only at the time of clicking Save. Are there any other
options as this would be a lot of code for 9 subforms, some with as
many as 20 or so fields to populate?

Any guidance is appreciated as I'm on a tight time schedule to finish
development and deploy this app.

Apr 26 '06 #2
Yes, Unfortuneatly, the design specs provided to me calls for 9
seperate tabs to organize the data being captured. Each tab basically
represents a different system the users are gathering data from to
imput into Access. I suppose some of the subforms could be combined
into a single table, however with a single subform I'm appearantly
going to run into this issue, so the number of tabs or subforms
shouldnt really be a factor other than amount of code required.

It appears I just have a lot of work ahead of me to make these forms
unbound....

Apr 26 '06 #3
"microb0x" <wo*******@gmai l.com> wrote in news:1146070359 .598148.228590
@j33g2000cwa.go oglegroups.com:
I have an application with a master form with a tab control containing
nine tabs, each tab contains a subform. I have command buttons on my
main form including: Save , Cancel , Close.

My question is, how can I prevent Access from auto-saving changed or
entered data on both the main form and any subform?

The main goal is to force the user to use the 'Save' button to save any
data. I need the 'Cancel' button to just undo any changes since
opening the form or since last save. And I need the 'Close' button to
just close the form without saving any changes since last time 'Save'
button was clicked.

In previous applications without subforms I was able to accomplish a
similar scenerio with using me.undo in the unload event of the form
and/or on the click event of both the Cancel and Close buttons. This
doesnt work with the subforms, because the command buttons are on the
main form and not each subform, nor would I want that. It is also not
working all the time with the data on the master form, certain
scenerios are still saving data when closing the form. It is also
auto-saving data on the subforms as I move between the tabs, I would
like to prevent this as well

Is there anyway to accomplish this goal? Only thing I could think of
would be to make each subform and/or field unbound, and pass the data
to the tables only at the time of clicking Save. Are there any other
options as this would be a lot of code for 9 subforms, some with as
many as 20 or so fields to populate?

Any guidance is appreciated as I'm on a tight time schedule to finish
development and deploy this app.


Access is good as it is.

--
Lyle Fairfield
Apr 26 '06 #4
"microb0x" <wo*******@gmai l.com> schreef in bericht news:11******** **************@ u72g2000cwu.goo glegroups.com.. .
Yes, Unfortuneatly, the design specs provided to me calls for 9
seperate tabs to organize the data being captured. Each tab basically
represents a different system the users are gathering data from to
imput into Access. I suppose some of the subforms could be combined
into a single table, however with a single subform I'm appearantly
going to run into this issue, so the number of tabs or subforms
shouldnt really be a factor other than amount of code required.

It appears I just have a lot of work ahead of me to make these forms
unbound....


Temptables will be a lot easier than going unbound IMO.
Not difficult to copy table structures and change the query-strings for your (sub)forms.
But do it your way if you like.

BTW: I just saw your other (same) post at microsoft.publi c.access
Please do NOT multipost.

Arno R
Apr 26 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
4042
by: William Wisnieski | last post by:
Hello Everyone, Access 2000 I have a form with multiple pages on it. There is one text field on the third page of the form that I need the user to complete before leaving the form or moving to the next record. So, in the BeforeUpdate event of the form itself I have the following code:
4
3336
by: Mike MacSween | last post by:
It's a form, with (so far) 4 tab pages on it, each of which holds 2/3/4 subforms. (I like tabbed forms by the way - do we all?) Basically the subforms are different ways of looking at the data. It's the orchestral management thing still. So tab 1 looks at each musician, the events they're booked onto, which jobs they're doing etc.
0
2702
by: misscrf | last post by:
I am currently working on a database, in 3rd normal form, which is for candidates who apply for a job with the law firm that I workd for. My issue is with good form design. I have a main form. Then I have 3 pages on a tab control ( 4 if the type of candidate validates that is is to be shown) Each page has a subform. The subforms can be either single or continuous, I think I am still deciding what I want to lock down this entry...
7
2623
by: jaYPee | last post by:
I am using dataset as a datasource for my datagrid. I'm wondering how to program to autosave the changes made in a datagrid just like microsoft access. any help is greatly appreciated.
2
2339
by: Groove | last post by:
Hey guys - I've used the Thread.Sleep(xyz) method before to trigger a pause in a sub or function. I was wondering if anyone knew of a method to have a page autosave itself after X minutes? Here's the situation. I have a form with a lot of multi-line textboxes in a site with the user is required to be logged into. The log in info is stored in a session variable. Even though I can increase the session timeout value on the server to...
5
4289
by: dzulai | last post by:
i have a continuous subform and its AllowAdditons and AllowEdits property are set to false. A command button("Add") in my main form sets both properties to True, enabling the New Record to appear. My question is, is it possible to limit edits only to the new record? and also, is it possible for the new record not to be saved automatically to the DB? The new record must only be saved when the "Save" command button is clicked. thanks
3
2316
by: John Wright | last post by:
I want to create an autosave and crash recovery module for my program. I imagine I would have to use a timer control on the form to call the autosave functionality but I need a starting point. I would like it similiar to the functionality in word when a PC goes offline (power failure, etc) it will ask to recover open files, I would like to have this same functionality. Does anyone have any suggestions or point me in the right direction?...
4
6058
by: Harlequin | last post by:
I have a question concerning the need to trigger events within a "child" subform which is itself enbedded within a master "parent" form and which is accessible via a tab in the parent form. Becuase this is all very difficult to explain in words, please bear with me as I endevour to explain what it is I am trying to do. It would be helpful if I could attach a graphics file to this posting that would help explain what it is I'm trying to achieve...
4
2935
by: louisjones | last post by:
Please help! I'm new to this but I'll try and be as clear as possible... I have a table tblCase with an autonumber key field CaseID. I have four other tables each having a many-to-one relationship to CaseID. There is a form for each table and I’m trying to have the four subforms open from buttons within the parent form. Is this actually possible? I have been able to create a parent form with four subforms actually within, but it is too...
0
9522
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9336
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10111
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9948
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9902
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9765
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8770
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6603
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3866
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.