I have a form that is based on a table called CVA Defects Table. Three
of the fields in the table and form are Oil line defects, Gas line
defects, and Sub assembly defects. These fields use lookups into
another table called "defects table". If I input from the CVA Defects
Table everything works fine all the time. However when I input data
from the form I have problems.
The Oil & Gas line lookups work very well all the time in the form.
The Sub assembly lookup doesn't. I get this error message:
The record source'~sq_cCVA Line DC~sq_cSub Assembly Defect' specified on
this form or report does not exist.
So I've checked the record source property line and this is what is in
that line:
Select [CVA Defects Table].[Sub Assembly Defects] From [CVA Defects Table];
This appears to be correct. I'm not sure why the error message says
"CVA Line DC, that is the name of the form not the table.
I can make it work if I redo the record source. When I redo the record
source I type in exactly what I wrote above. I even highlighted the
line, cut it, and pasted it right back in. That made it work. I save
it close the form, open it back up and get the same error message.
I also deleted the combo box from the form, dragged a new one down from
the field list and it worked perfectly, until I re-opened it, then I got
the same error message again.
The defects table that holds the three defects data has three columns,
Oil defects, Gas defects, and Sub assembly defects. I use the record
source, column count, and bound column property boxes to control which
column the lookup uses.
Any ideas what is wrong?
Thanks for your help,
Don............ ...... 4 1548
On Sat, 15 Oct 2005 13:08:42 GMT, Don Sealer <vz******@veriz on.net>
wrote:
Queries starting with ~sq_ are generated behind the scenes by Access,
for example when you use query by form. Typically you can get rid of
them by compacting the db.
-Tom. I have a form that is based on a table called CVA Defects Table. Three of the fields in the table and form are Oil line defects, Gas line defects, and Sub assembly defects. These fields use lookups into another table called "defects table". If I input from the CVA Defects Table everything works fine all the time. However when I input data from the form I have problems. The Oil & Gas line lookups work very well all the time in the form. The Sub assembly lookup doesn't. I get this error message:
The record source'~sq_cCVA Line DC~sq_cSub Assembly Defect' specified on this form or report does not exist.
So I've checked the record source property line and this is what is in that line: Select [CVA Defects Table].[Sub Assembly Defects] From [CVA Defects Table];
This appears to be correct. I'm not sure why the error message says "CVA Line DC, that is the name of the form not the table.
I can make it work if I redo the record source. When I redo the record source I type in exactly what I wrote above. I even highlighted the line, cut it, and pasted it right back in. That made it work. I save it close the form, open it back up and get the same error message.
I also deleted the combo box from the form, dragged a new one down from the field list and it worked perfectly, until I re-opened it, then I got the same error message again.
The defects table that holds the three defects data has three columns, Oil defects, Gas defects, and Sub assembly defects. I use the record source, column count, and bound column property boxes to control which column the lookup uses.
Any ideas what is wrong? Thanks for your help, Don........... .......
Tom,
I think I follow what your saying but I don't have a query associated
with these tables or with this form.
I will however try compacting the database.
Thanks,
Don........
Tom van Stiphout wrote: On Sat, 15 Oct 2005 13:08:42 GMT, Don Sealer <vz******@veriz on.net> wrote:
Queries starting with ~sq_ are generated behind the scenes by Access, for example when you use query by form. Typically you can get rid of them by compacting the db.
-Tom. I have a form that is based on a table called CVA Defects Table. Three of the fields in the table and form are Oil line defects, Gas line defects, and Sub assembly defects. These fields use lookups into another table called "defects table". If I input from the CVA Defects Table everything works fine all the time. However when I input data
from the form I have problems.
The Oil & Gas line lookups work very well all the time in the form. The Sub assembly lookup doesn't. I get this error message:
The record source'~sq_cCVA Line DC~sq_cSub Assembly Defect' specified on this form or report does not exist.
So I've checked the record source property line and this is what is in that line: Select [CVA Defects Table].[Sub Assembly Defects] From [CVA Defects Table];
This appears to be correct. I'm not sure why the error message says "CVA Line DC, that is the name of the form not the table.
I can make it work if I redo the record source. When I redo the record source I type in exactly what I wrote above. I even highlighted the line, cut it, and pasted it right back in. That made it work. I save it close the form, open it back up and get the same error message.
I also deleted the combo box from the form, dragged a new one down from the field list and it worked perfectly, until I re-opened it, then I got the same error message again.
The defects table that holds the three defects data has three columns, Oil defects, Gas defects, and Sub assembly defects. I use the record source, column count, and bound column property boxes to control which column the lookup uses.
Any ideas what is wrong? Thanks for your help, Don.......... ........
I have compacted and repaired the db but it still gives the error
message. I don't really see any difference between any of the three
fields of similar construction. The fields and property boxes for the
other two defects works all the time. The one for sub assembly defects
rarely works. I just tried it after the compacting and it didn't work,
I got the same error message. However I went into the property box,
highlighted the record source line, cut the type, then pasted it back in
the record source line, switched to form view and the look up worked
fine. I saved and closed the form, opened it back up and I get the
error message.
I still don't understand.
Don............ ..
Don Sealer wrote: Tom, I think I follow what your saying but I don't have a query associated with these tables or with this form. I will however try compacting the database. Thanks, Don........
Tom van Stiphout wrote:
On Sat, 15 Oct 2005 13:08:42 GMT, Don Sealer <vz******@veriz on.net> wrote:
Queries starting with ~sq_ are generated behind the scenes by Access, for example when you use query by form. Typically you can get rid of them by compacting the db.
-Tom. I have a form that is based on a table called CVA Defects Table. Three of the fields in the table and form are Oil line defects, Gas line defects, and Sub assembly defects. These fields use lookups into another table called "defects table". If I input from the CVA Defects Table everything works fine all the time. However when I input data
from the form I have problems.
The Oil & Gas line lookups work very well all the time in the form. The Sub assembly lookup doesn't. I get this error message:
The record source'~sq_cCVA Line DC~sq_cSub Assembly Defect' specified on this form or report does not exist.
So I've checked the record source property line and this is what is in that line: Select [CVA Defects Table].[Sub Assembly Defects] From [CVA Defects Table];
This appears to be correct. I'm not sure why the error message says "CVA Line DC, that is the name of the form not the table.
I can make it work if I redo the record source. When I redo the record source I type in exactly what I wrote above. I even highlighted the line, cut it, and pasted it right back in. That made it work. I save it close the form, open it back up and get the same error message.
I also deleted the combo box from the form, dragged a new one down from the field list and it worked perfectly, until I re-opened it, then I got the same error message again.
The defects table that holds the three defects data has three columns, Oil defects, Gas defects, and Sub assembly defects. I use the record source, column count, and bound column property boxes to control which column the lookup uses.
Any ideas what is wrong? Thanks for your help, Don............ ......
Here's another thing that is puzzling. I've deleted the combo box on my
form for the sub assembly defects. I then go into "view" field list and
pull down the same, sub assembly defects. If the message is telling me
this doesn't exist "> The record source'~sq_cCVA Line DC~sq_cSub
Assembly Defect' specified on this form or report does not exist.
then why would it be in my field list?
It works until I close the form but when I re-open the form I get the
message.
Don............ .
Don Sealer wrote: I have a form that is based on a table called CVA Defects Table. Three of the fields in the table and form are Oil line defects, Gas line defects, and Sub assembly defects. These fields use lookups into another table called "defects table". If I input from the CVA Defects Table everything works fine all the time. However when I input data from the form I have problems. The Oil & Gas line lookups work very well all the time in the form. The Sub assembly lookup doesn't. I get this error message:
The record source'~sq_cCVA Line DC~sq_cSub Assembly Defect' specified on this form or report does not exist.
So I've checked the record source property line and this is what is in that line: Select [CVA Defects Table].[Sub Assembly Defects] From [CVA Defects Table];
This appears to be correct. I'm not sure why the error message says "CVA Line DC, that is the name of the form not the table.
I can make it work if I redo the record source. When I redo the record source I type in exactly what I wrote above. I even highlighted the line, cut it, and pasted it right back in. That made it work. I save it close the form, open it back up and get the same error message.
I also deleted the combo box from the form, dragged a new one down from the field list and it worked perfectly, until I re-opened it, then I got the same error message again.
The defects table that holds the three defects data has three columns, Oil defects, Gas defects, and Sub assembly defects. I use the record source, column count, and bound column property boxes to control which column the lookup uses.
Any ideas what is wrong? Thanks for your help, Don............ ...... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: CGuy |
last post by:
URGENT HELP REQUIRED FROM GURUS
Hi,
I have a custom object that implements ICollection and IListSource. This
object has also an enumerator defined for it which implements IEnumerator
and IList. Now, I'm trying to bind object to a combo box. The bidning
happens correctly, but I'm unable to set the DisplayMember property of the
combo box (the count of items in the combo box gives me the correct value,
but no items are displayed in the...
|
by: mark |
last post by:
I've been working on an Access 2000 database for a couple of weeks now. I
took a course in access about a year ago, a crash course, and I learned a
ton, but I didn't touch Access for the year since then so I forgot
everything I learned : ( So this little project I envisioned has turned out
to be much harder than I thought. But I think I'm close with it, so I want
to see it through.
What I wanted to create is a database that will track my...
|
by: J. Yuan |
last post by:
Hi,
I am working on a checkout/inventory system. How can I make a button
that when pressed, would update the previous fields transaction number
to a table (for example, -3 printers, so that printer total is now 20
instead of 23) while also logging the transaction in another table
(for example, logging the date and -3 printers).
I have another question, while a value is selected by a combo box, how
can I retrieve it? I mean, I want...
|
by: Steve Patrick |
last post by:
Hi All
You guys are my last hope, despite spending money on books and hours reading
them I still can not achieve the results I need.
I have designed a database in Access 2000 based on 1 table, all has gone
very well with one exception. The table is based on applications made by
potential customers looking to buy franchise rights to particular locations
and as part of the process they are asked to list their preferred locations
1 to 4....
|
by: Steph |
last post by:
Hi.
I'm very new to MS Access and have been presented with an Access database
of contacts by my employer.
I am trying to redesign the main form of the database so that a button
entitled 'search' may be clicked on by the user and the user can then
search all records by postcode. I want to do this to prevent duplicate
data entry.
| |
by: Edwinah63 |
last post by:
Hi everyone,
Please let there be someone out there who can help.
I have two BOUND combo boxes on a continuous form, the second being
dependent on the first. I have no problem getting the second combo to
change depending on what values the user selects in the first box, it's
just that every time the user changes the first combobox, the second
combobox FOR EVERY RECORD goes blank.
|
by: CCLeasing |
last post by:
Hello, I have searched google but can not find a straight forward
answer to my problem. Hopefuly someone will be kind enough to offer
their expertise. Please forgive if this seems a bit convoluted but this
is probabally a reflection of my not clear understanding of the
mechanics behind what i'm trying to achieve. Please bear with it I
really could do with your help.
I have a simple windows form. There are two controls on the form that I...
|
by: CCLeasing |
last post by:
Hello, I have searched google but can not find a straight forward
answer to my problem. Hopefuly someone will be kind enough to offer
their expertise. Please forgive if this seems a bit convoluted but this
is probabally a reflection of my not clear understanding of the
mechanics behind what i'm trying to achieve. Please bear with it I
really could do with your help.
I have a simple windows form. There are two controls on the form that I...
|
by: Strasser |
last post by:
In a nested subform in datasheet view, an interviewer of homeless
people picks a descriptive CATEGORY from 20 descriptive categories.
The 20 categories are displayed via a combo box.
(Categories are things like "addiction", "criminal", "dangerous?"
etc. Total number of categories = 20).
For EACH of the 20 categories there are 5 statuses, from
"bad" (1=worst) to "good" (5=best).
(Therefore, there are really 100 choices: 20 categories...
|
by: jafarsibtain |
last post by:
hi..
I am creating a form where there are two combo Boxes (drop Down)
> Program_Combo_box
> Course_Code_Combo
in the Program Combo Box there are five items in the list >
1. BIT
2.BCA
3. MCA
|
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: 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: 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: 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,...
|
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: 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: 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.
| |