473,833 Members | 2,199 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

bypass the error messages?

jayme
83 New Member
ms access 2000.
on my default switchboard there is a button that opens up a form(named Inquiry Find). on the form you can type in an "Inquiry Number" then click the button to look up that certain number and all the information that goes with it-which is on another form (named JOB TRACKING form). so it automatically brings up that record in the JOB TRACKING form. i have this set up so people can easily find the inquiry number they are looking for then edit the information.
well i was testing this out-so i opened up an inquiry number, made a change to it and when i hit the [>*] to save and then close the forms it comes up with an error saying that the changes were not successful becuase it would create duplicate values. so i hit ok then it says that it couldn't save the changes at this time. do you want to close the db object anyway? and i choose yes.
WELL-when i go back into the table and look at that record the changes are there!
so im confused why i am getting this error. its not a big deal but other users will be using this db so is there a way to just bypass the erros so they don't think something went wrong?

thank you!
Apr 18 '07 #1
16 2954
MMcCarthy
14,534 Recognized Expert Moderator MVP
ms access 2000.
on my default switchboard there is a button that opens up a form(named Inquiry Find). on the form you can type in an "Inquiry Number" then click the button to look up that certain number and all the information that goes with it-which is on another form (named JOB TRACKING form). so it automatically brings up that record in the JOB TRACKING form. i have this set up so people can easily find the inquiry number they are looking for then edit the information.
well i was testing this out-so i opened up an inquiry number, made a change to it and when i hit the [>*] to save and then close the forms it comes up with an error saying that the changes were not successful becuase it would create duplicate values. so i hit ok then it says that it couldn't save the changes at this time. do you want to close the db object anyway? and i choose yes.
WELL-when i go back into the table and look at that record the changes are there!
so im confused why i am getting this error. its not a big deal but other users will be using this db so is there a way to just bypass the erros so they don't think something went wrong?

thank you!
Check out the JOB TRACKING form. It sounds like you are trying to add a record as well as save changes. Check out the code in the forms close and unload events.
Apr 18 '07 #2
jayme
83 New Member
i looked at the events on the JOB TRACKING form and there are no close or unload events. so is that the problem? what needs to be in those events to make it work correctly?
Apr 18 '07 #3
MMcCarthy
14,534 Recognized Expert Moderator MVP
i looked at the events on the JOB TRACKING form and there are no close or unload events. so is that the problem? what needs to be in those events to make it work correctly?
No I thought there was something there that was causing the problem.

What is the query that is the record source of this form?
Apr 18 '07 #4
jayme
83 New Member
What is the query that is the record source of this form?
the record source of both forms is a table-when you fill out the [JOB TRACKING form] it updates the table. so for the [Inquiry Find] form it finds the requested inquiry number that is entered, in the table then pulls up the form for that record with all the information for that number.
does that make sense?
Apr 18 '07 #5
MMcCarthy
14,534 Recognized Expert Moderator MVP
the record source of both forms is a table-when you fill out the [JOB TRACKING form] it updates the table. so for the [Inquiry Find] form it finds the requested inquiry number that is entered, in the table then pulls up the form for that record with all the information for that number.
does that make sense?
Are you saying that the Inquiry Form is bound to the table? If so, why?
Apr 18 '07 #6
jayme
83 New Member
Are you saying that the Inquiry Form is bound to the table? If so, why?
i made the [JOB TRACKING form] to fill in the [JOB TRACKING] table - it is an easier and more organized way of filling in what needs entered into the table. then i got the idea of being able to just type in the inquiry number you need and that form that has been previously filled out comes up and you can edit it or whatever you need to do to it. so thats when i made the [Inquiry Find] form as like a preface to the actual [JOB TRACKING form]-it is just supposed to find the number we need and pull that form up.
Apr 18 '07 #7
MMcCarthy
14,534 Recognized Expert Moderator MVP
i made the [JOB TRACKING form] to fill in the [JOB TRACKING] table - it is an easier and more organized way of filling in what needs entered into the table. then i got the idea of being able to just type in the inquiry number you need and that form that has been previously filled out comes up and you can edit it or whatever you need to do to it. so thats when i made the [Inquiry Find] form as like a preface to the actual [JOB TRACKING form]-it is just supposed to find the number we need and pull that form up.
But you don't need the Inquiry Form bound to the table. Just a listbox or combobox bound to a query that has the required fields. You are then opening the JOB TRACKING form to the selected record in the listbox/combobox. By having both forms open to the same record at the same time Access is trying to compensate by creating a new version of the record.

Mary
Apr 18 '07 #8
Denburt
1,356 Recognized Expert Top Contributor
If you go directly to the table and you make the same changes directly in the table do you have the same problem?
Apr 18 '07 #9
Denburt
1,356 Recognized Expert Top Contributor
Mary definitely sounds like she has the issue nailed down (sorry Mary). ;)
Apr 18 '07 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

3
26291
by: hebandgene | last post by:
When I delete a record in a subform I get the warning that I'm about to delete a record, followed by an error "No current record." When I click OK obviously the record is deleted and it goes to the first record (as I've coded it to do) or it shows me a blank record if the deleted record was the only one. So, what I'd like to do is bypass that 'No current record' altogether to avoid user confusion. Is there any way to code it out...
10
2731
by: Brian Conway | last post by:
I have no idea what is going on. I have a Login screen where someone types in their login information and this populates a datagrid based off of the login. Works great in debug and test through VS, however, when I change to release and put it out on the web it fails giving me the following error message The underlying connection was closed. Could not establish a trust relationship with the remote server.
2
17990
by: Mahesh Devjibhai Dhola | last post by:
Can you please help me in my problem? I have a socket prog. application like http://www.codeproject.com/dotnet/csharpwhiteboard.asp My application is chat application like above architecture. I want to bypass firewall aswell as proxy if any on two chat clients like yahoo or msn can chat beyond proxy/firewalls...
2
2723
by: Thomas Guignard | last post by:
Hi there I need to run an XSLT stylesheet on XML files generated by another app that seem to have errors. When I try to run my XSLT processor (MSXML engine, run through the Cooktop editor), I get the following error message ERROR: pattern constraint failed. The element: '{http://www.loc.gov/MARC21/slim}leader' has an invalid value according to its data type.
1
1381
by: hepsi | last post by:
Can u please tell me How to ByPass the Secure Shell Connection from one server to other server...that is from Mysql to postgreSQL Mysql is local ... whereas PostgreSql is client one...remote host Through the SSH tunnel the records have to be updated.... There is an error....SSh not connected.... after tht another error stating tht... No Connection could be ade because the target machine actively refused it... Thr is no error i the code.......
3
11826
by: CanuckChuck | last post by:
I have a code for enabling a command button to password protect the enabling/disabling of the Shift bypass. For some reason though I keep recieving a syntax error when I try to use it. I copied the code from the following link: http://www.databasedev.co.uk/disable_shift_bypass.html It seems to have a problem with the part that reads: MsgBox "The Bypass Key has been enabled." & vbCrLf & vbLf & _ "The Shift key will allow the users to bypass...
1
6874
by: OlaPihl | last post by:
Hi, How can I by code enable and disable "Bypass proxy server for local adresses" in Internet Explorer / Tools / Internet Options / Connections / LAN Settings. I have made a program (VB.Net) that can enable and disable the proxy server but I can't find how to do the "bypass ......" Would really appreciate som help.
2
19506
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge. I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...
0
2897
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge. I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...
0
9796
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
10782
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
10500
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
10543
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
9323
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...
1
7753
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5624
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...
0
5789
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3972
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.