I have to be honest as I haven't done an all out search on this problem, due to having to get this database completed by tonight, and this problem just popped up.
Ok the problem is that I have had a nicely working form except when I tried to run through my records (via the form) everytime I pushed the advance button to move to the next record I would get an error message that "something" did not have the correct data blah blah blah. I finally figured the problem out. I had two checkboxes (yes/no) that were causing the problem. One checkbox indicated the conditions were ok at a railroad crossing, thus check the box and go on. Now if all the conditions weren't good, then you keep the first checkbox empty, and check the second checkbox to indicate there was a problem.
So only one checkbox would actually get a checkmark for each record. Unfortunately, Access felt that both checkboxes needed to have a checkmark, thus causing the error statement described above. Once I cleared the error, then the next record would pop up, so basically it was working with a major annoyance in between.
My solution was to delete one of the checkboxes, and convert the other to a textbox, then when I put it on the form, it would become a combo box with two items....yes the crossing is compliant, or sent to SIRP Log.....It works good, except;
Everytime I attempt to open the form, I'm getting a Query parameter box asking for a value for the former SIRP Log checkbox. Ok, this tells me that there is a query tied to the records and they need to be gotten rid of which I've done. I've also eliminated all of the sample data, and confirmed there is no relationships that call for that dang checkbox.
The only place I see ANY reference to the former checkbox is in the field list box, and I can't delete it from there.
Ok, any ideas on how I can track this frustrating error down and fix it? I would sure appreciate any help you can.
As always, thanks for your help
mtgrizzly52
4  1589 
Sorry to have bothered you....I figured it out on my own. It was in the form's SQL statement under the data tab. Gee you all are very smart sending me the answer telepathically! *grin*
mtgrizzly52
MMcCarthy 14,534
Recognized Expert Moderator MVP
Sorry to have bothered you....I figured it out on my own. It was in the form's SQL statement under the data tab. Gee you all are very smart sending me the answer telepathically! *grin*
mtgrizzly52
Glad you got it figured out. Those telepathy skills come in very handy sometimes :D
One checkbox indicated the conditions were ok at a railroad crossing, thus check the box and go on. Now if all the conditions weren't good, then you keep the first checkbox empty, and check the second checkbox to indicate there was a problem.
Just as an aside: Why didn't you simply have one check box and
Checked = Problem
Unchecked = OK
rather than having two checkboxes?
NeoPa 32,579
Recognized Expert Moderator MVP
Sorry to have bothered you....I figured it out on my own. It was in the form's SQL statement under the data tab. Gee you all are very smart sending me the answer telepathically! *grin*
mtgrizzly52
Nice one Grizz.
That musta been Mary of course :D
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Steve K |
last post by:
Hi,
The site I've just created, when tested on a windows PC has an unwanted
white space (about 2-4 pixels high) in between two tables. I would like
there to be zero space there. Here is the test site:
http://aem.cornell.edu/farmlink/
The line goes all the way across the page and it's where the NYFarmlink
Logo is, the two hands shaking, it goes right through that graphic and
|
by: Steve K |
last post by:
While reading "Eric Myer on CSS" I decided it was time to replace the
buttons on my page (which were graphics) with some CSS "buttons" but I
hit some snags.
The first set of buttons I replaced seem to be working great, these are
the buttons on the left side, the main navigation buttons. But the four
buttons at the top (Prospective students, Alumni, Current Students,
Corporate) are not working as well as I'd hoped.
I'm getting some...
|
by: Max |
last post by:
I'm reading some files in a directory using php code for the end result of
allowing these files to be deleted.
The problem is some of the file names have hyphens in them, and this cannot
be changed.
The php code prints each file name on a page and has a delete link for each
seperate file. I pass the name of the file via a variable using onclick to a
javascript confirm function when the delete link is clicked on. But when the...
|
by: Buck Rogers |
last post by:
Hi guys!
Task 1: Write a program which presents a menu with 5 options. The 5th
option quits
the program. Each option should execute a system command using system().
Below is my humble offering.
===================================================
#include <stdio.h>
#include <stdlib.h>
|
by: Steve Litvack |
last post by:
Hello,
I have built an XMLDocument object instance and I get the following string
when I examine the InnerXml property:
<?xml version=\"1.0\"?><ROOT><UserData UserID=\"2282\"><Tag1
QID=\"55111\"><Tag2 AID=\"5511101\"></Tag2></Tag1><Tag1 QID=\"55112\"><Tag2
AID=\"5511217\"></Tag2></Tag1><Tag1 QID=\"5512282\"><Tag2
AID=\"551228206\"></Tag2></Tag1><Tag1 QID=\"55114\"><Tag2
AID=\"5511406\"></Tag2></Tag1><Tag1 QID=\"55115\"><Tag2
| | |
by: Robert |
last post by:
Vb.Net Make dll that contain one function. Help Please.
I would like to call a function from different applications.
I think i have to make a dll.
I have Visual Basic.net 2003 Standard Edition, that teorically does
not make dll,
but pratically does.
I search vbc.exe and copy it to a new folder, in which i have the
|
by: lovecreatesbeauty |
last post by:
/*
When should we worry about the unwanted chars in input stream? Can we
predicate this kind of behavior and prevent it before debugging and
testing? What's the guideline for dealing with it?
As shown below line #21, I should remove the unwanted characters in
input stream there at that time. Do I miss some other possible errors
in i/o which will happen to occur sometimes in other places? And
welcome your kind comments on following the...
|
by: Abhinay |
last post by:
hi,
this is abhinay,
i have data ie xml file
Ex:
<root>
<child1>
<cc1>aaa</cc1>
</child1>
|
by: barbaros |
last post by:
Hello everybody,
I am building a code for surface meshes (triangulations for instance).
I need to implement Body objects (bodies can be points, segments,
triangles and so on), then a Mesh will be a collection of bodies,
together with their neighbourhood relations.
I also need OrientedBody objects, which consist in a body
together with a plus or minus sign to describe its orientation.
So, basically an OrientedBody is just a Body with an...
|
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...
|
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...
| | |
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: 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...
|
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();...
|
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: 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...
| |
