Is it possible to update (as in change the text in a box) without having it affect all of the same fields with the same ID? I want to be able to change 2 fields in a subform (in the event that they are entered wrong), however the fact that they are linked with the PK is preventing an isolated change to a single entry, instead it changes all because they have the same PK.
Thanks,
Mark
9 1189 zmbd 5,501
Expert Mod 4TB
mcupito:
You will need to provide some information about the table relationships, how the form is designed, for example:
tblone
[tblone_pk] primary key, autonumber
[tblone_field1] text(25)indexed-required
[tblone_(....)] more fields
tbltwo
[tbltwo_pk] primary key, autonumber
[tbltwo_fk_tblone] numeric-long, 1:M with tblone
[tbltwo_(....)] more fields
We prefer to not have the database attached at this point:
Please understand, many of us cannot or will not d/l un-requested attachments. This has absolutely nothing to do with who you are... In my case, such d/l are prohibited by my ITSec staff. For many others, it is part of "safe computing/best practices" not to d/l such files. A practical example as to why can be found here http://bytes.com/topic/access/answer...l-ms-products. this unfourtunate Member opened a file from a trusted source and is now haveing all sorts of issues!
I feel as though due to the way these tables are connected, trying to change the LOB_Abbr and the CompanyAbbr in the subform changes their values in their respective tables, which is a big issue. What I need to happen is I want to be able to edit the Company_Abbr or LOB_Abbr on that subform ONLY, not in the tables.
However, looking at the table setup, the way the subform table (ServiceTemp) is connected to the other tables is through Keys. So I can see why editing an entry is changing all of the others, I am just not sure how to isolate it.
I really hope this is enough info, I am at my wits end here folks.
Thanks
Isn't this the same question as your other one?
Rabbit, while it is similar, this one is much more focused and condensed. The other thread was getting sloppy and misguided. Now that I have narrowed down the issue I felt as though it would increase efficiency in assisting the viewers.
zmbd 5,501
Expert Mod 4TB
McUpito;
It really sounds as if eithre the database or the form was not setup correctly to begin with - I really suggest looking carefully at the form and how the record set to the form is established, then make sure the controls have the correct bound state to the recordset and then the correct rowsource as this is the most common mistake made... the ROWSOURCE is NOT always the same as the RECORDSOURCE for the form.
You need to understand the basics better before we can really provide any help.
The following site is not my favorite site due to the age now; however, the Basics are still solid. I've also sent you a PM about the following site as the Author is a bit biased against VBA, which in 95 was not as kind to us as it is now. MS Access 95 Tutorial
I agree, zmbd, something is amiss. Thank you for your resources and guidance. I've begun taking a look at your references.
I am stuck on this issue, as it is the final issue holding this db back from production.
I suppose I will continue to experiment and see if something works.
zmbd 5,501
Expert Mod 4TB
cool... we do want to help... we just need to get you the proper tools first :)
Hang-in-there!!!! We'll help you get this thing sorted out, may just take walking on hot coals (ouch, :-O )
I am going to try to have an update button for each record, have that open a new form that displays the data row from the form, use 2 combo boxes to inhibit mindless entries for Company and LOB, have an 'Update' button - Append query that inserts the new data into the ServiceTbl and a 'Cancel' button that will take the user back to the previous form.
I don't imagine I will need a 'Delete' button, since each row is identified by an autonumber PK, which I was use as a control for the Edit Button, and the new data will be appended to that row ID.
Is this logical?
Solution: I created an Edit (Command) Button, which then opened the form. I used the ServiceID for each row of data to limit changes and also changed the origin of the information to the ServiceTbl, and used queries to filter data.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: harish |
last post by:
I am using java applications to connect to my MS SQL Server database.
I am using ODBC for database connectivity.
If i am running my java applications in a remote PC and try to connect
to database...
|
by: Akif |
last post by:
Hi. I'm a SQL Server novice, so apologies if any of this sounds simple.
I am running Windows XP SP2, and have just installed SQLServer 2000. I
need another application to connect to SQLServer,...
|
by: Jenbo |
last post by:
I know this has come up frequently but I can't seem to put my finger on
the precise problem as it applies to me. I have a workgroup with a 2003
box with Sql server on it. Also, on this, I have an...
|
by: Patrick Finnegan |
last post by:
DB2 8.2.0 on Windows 2000 Server.
I had a problem connecting to a remote instance despite the "SVCENAME"
parameter and service file entries being set correctly. I eventually
noticed that the...
|
by: David Costello |
last post by:
Hi all,
I keep getting a bizarre login error, when trying to connect to a SQL Server 2005 database on a local domain to my machine using C#. The Exception returns:
SQLException: Login failed for...
|
by: Scav |
last post by:
Helpful folks,
I am having a problem getting Oracle's Transparent Gateway for DRDA
product to interface with DB2 UDB for LUW 8.1.14.
The Gateway product is running on Linux and using DRDA...
|
by: Dave44 |
last post by:
Hello,
Ok, so i have Win XP pro on one machine and RHEL 4 on another. A router connects the two machines and to the internet as well.
Linux has a static IP 192.168.1.100 and it can...
|
by: reachravi |
last post by:
Hi,
In our ASP application, we are using a visual basic Dll file to perform database operations. We have a function in our Dll file for executing stored procedures.
This function...
|
by: johndavid |
last post by:
I work for as a Computer Systems Manager for a large government agency with a baffling problem.
Some of what I will say below makes zero sense, which is why I am baffled.
I have a site that...
|
by: paldebayan |
last post by:
We are getting following errors in the log.
ÝJun 11, 2010 03:14:35¨ ERROR RRTUtil.exception(): The program has
encountered exception ...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
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...
|
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,...
| |