Hi All,
Let me just start by saying that this isn't a big deal, I did find a way to get it working, but I was just wondering what the "correct" way of going about this is.
I am using access 2003 and have designed a form to use for customer quotes. At the beginning of the form I declare a variable to be used by the whole form, something like, public disprice as integer, and then once a discount field is filled in, it sets disprice to equal the customer discount. Once the disprice is set, I use that in other sub's within the form to calculate prices and so on. The problem I am having, is that any time I add a new record, the variable disprice and the discount field does not reset to empty or null like I want it to, to enter in a new record. When paging through the old records, each record has the right discount shown and prices figured out, but it is when I add a new record, I want that variable to be null and the discount field to go blank.
The solution I have working right now is to clear the field when I click on the add new quote button.
Thanks all for any help!
1  2446 
Never Mind all,
I figured it out. My partner, who doesn't, well I should say isn't supposed to be messing with the programing end of things decided to set that field to have a default value and that is why it was coming up the way it was. Funny guy :D
Thanks anyways!
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Ken |
last post by:
How can I reset the initial form variables that are set with session
statements when clicking on a button?
I tried this but the function was not called:
<?PHP
function reset_form($none) { $_SESSION = array(); }
?>
<form enctype="multipart/form-data" name="company_info" method="post"
action="add_pic.php">
|
by: Richard Hollenbeck |
last post by:
I use a temporary table to assemble unrelated data for specific forms and
reports. After each use of this table, I have a delete query which empties
the table out for its next use.
I have one field I want to populate with the record number as it appears in
the form. That way I can use a comparison with Me.CurrentRecord to change
the background color of the text boxes for the OnCurrent property. I'm
doing this because I want the record...
|
by: Leslie |
last post by:
On a form, I create a record and save, and am ready to enter another.
I decide to Quit the form which executes an "Undo" in case there is
data entered. This then tries to "delete" my just saved record.
I want to "Reset" my Undo ability once I've saved a record. Is there a
way to reset the Undo?
Any help or tips would greatly help. I'm looking for syntax and
attachment points.
|
by: Fetty |
last post by:
How do I do this
--
David
|
by: Nathan Sokalski |
last post by:
I have a user control that contains three variables which are accessed through public properties. They are declared immediately below the "Web Form Designer Generated Code" section. Every time an event is fired by one of the controls contained in the User Control, these variable are reset. Here is my current code (I have a little more to add later, right now I am just concerned about the variables getting reset):
Public Class DatePicker2...
| | |
by: TD |
last post by:
I've read several posts here that say global variables are reset
whenever an unhandled error occurs. I want to use a custom form
property instead of a global variable to store a boolean value. My
question is does a custom form property get reset also? Was also
wondering if there is any reason one would ever use a global variable
since the consensus seems to be to never use global variables?
|
by: Kermit Piper |
last post by:
Hello,
How can you clear session variables when a reset button is pressed? I
thought I might be able to do something like:
<%
If request.form("Reset") = "Reset" then
Session("variable") = Null
%>
|
by: karsagarwal |
last post by:
I have a bounded form and after I click the button to update/save. THe
fields are still there. Is there a way to clear off the fields in the
bounded form.
Thanks,
SA
Here's the code that I have:
Private Sub cmdSave_Click()
|
by: ramprat |
last post by:
Hi All,
I currently need to store 3 variables to be used as global variables throughout my application. I need to record the username, their employee group and the task they are doing. The username, for example, is entered into a field on a table to indicate who last worked on that particular record. I have created the code below and it seems to work fine except when the application occasionally errors out at which point the global variables...
|
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,...
|
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...
| | |
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...
|
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...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
