I have a database that tracks the marketing source of new cases (law firm) and flags potential new cases that need to be followed up on until they are accepted, declined, the client stopped responding, or they are referred out to another firm. I have a lot of “feeder” tables that populate drop down boxes, but have four main tables. I have a Form (frmMaster) that collects the initial data on the marketing source (tblIntakeMaster), the client info (tblClient), the accident info (tblAccident), and if there is any follow up needed (tblFollowUp).
There is also a table (tblReferIn) that tracks info on cases referred in from another lawyer and a table (tblReferOut) that tracks case info on cases referred out to other firms. I have not been able to implement these because my main form (frmMaster) is not working. So this will be the next phase. However, I keep getting the following error message on the frmMaster when trying to enter new records:
“You cannot add or change a record because a related record is required in table ‘tblClient’.
My main Form (frmMaster) is made up of 3 Pages: Intake Info, Client Info & Accident Info, with Accident Info having another subform for follow ups.
The Record source for frmMaster is tblIntakeMaster (PK=IntakeMasterID) and is Page1 = Intake Info.
The 2nd Page is Client Info, Record source is sfrmClient, which is tied to tblClient (PK=ClientID, FK=IntakeMasterID) I added AccidentID as another FK because I kept getting the above error, but it still didn’t work. The Link Master & Child Fields on sfrmClient is IntakeMasterID.
The 3rd Page is Accident Info, Record source is sfrmAccident, which is tied to tblAccident (PK=AccidentID, FK=ClientID & IntakeMasterID). The Link Master is IntakeMasterID and the Link Child is ClientID.
At the bottom of Page 3 is another subform named sfrmFollowUp, which is tied to tblFollowUp (PK=FollowUpID, FK=AccidentID). The Link Master & Child Fields on sfrmFollowUp is AccidentID.
I have added fields to my tables, changed the Link records, and nothing seems to work. I even created a sample database and it worked! Could it be that I have to rebuild this database once again in order to make it work because I didn’t have the structure setup the first time? I am attaching my database if anyone wants to take a look at. The problem is in frmMaster when you try to add a record and has something to do with tblClient and tblAccident. I really appreciate any help!
Thanks,
Mike
It probably has something to do with the way you set up your relationships. But I can't be sure without test data. And I can't open the database you attached. So either you can make a copy of your database in 2003 or 2007 format or hopefully someone with whatever version you're using comes along and takes a look.
20 1914
I can't open that database. It must be in a newer version. Either save it in 2003 format or describe the relevant structures here.
see attached PDF copy of table structure
I would also need to see the form setup. Not everything, just the few properties related to the subforms and how they're being linked.
Ok, let me know if this helps. - sfrmClient (Page 2)
-
Source Object = sfrmClient
-
Link Master Field = IntakeMasterID
-
Link Child Field = IntakeMasterID
-
Filter on Empty Master = Yes (same for all subforms)
-
Enabled = Yes (same for all subforms)
-
Locked = Yes (same for all subforms)
-
-
sfrmAccident (Page 3)
-
Source Object = sfrmAccident
-
Link Master Field = IntakeMasterID
-
Link Child Field = ClientID
-
-
sfrmFollowUp (within Page 3)
-
Source Object = sfrmFollowUp
-
Link Master Field = AccidentID
-
Link Child Field = AccidentID
Thanks
It probably has something to do with the way you set up your relationships. But I can't be sure without test data. And I can't open the database you attached. So either you can make a copy of your database in 2003 or 2007 format or hopefully someone with whatever version you're using comes along and takes a look.
Here is the database in 2003.
I can "open" Seth's version of the DB, but get errors for missing DLL's, so I am unable to open frmMaster to try to induce the errors..... However, it is most likely, as Rabbit surmises, a problem with the relationships, which I have been studying in your DB, trying to see if I can identify anything "visually"....
I am sorry but I only have Access 2010. I was not able to save in a lower version. I believe the problem is with relationships. I am going to export all tables to a new database and see what happens. After that, I will start deleting fields and/or tables. I believe that some of the problem might be with the AttorneyID with is in the IntakeMaster table and Accident table. I guess it's going to be another long day.
Thanks for your help. Still trying to figure this out.
zmbd 5,501
Expert Mod 4TB
V2010 to save in earlier format:
{Ribbon}
{file}
-leftpane (mid-bottom)- {save&publish}
-rightpane- "save database as"
select the [2002 - 2003 (*.mdb)]
click on the [saveas] button under the pane
follow prompts
Caution: This will strip anything from the database that is not available in the olderversions... I've found that alot of forms will suffer this fate.
zmbd 5,501
Expert Mod 4TB
mburch2000
I've played with your main form and can not get your error...
Check that your office has the lastest patches.
Give me the baby-step-by-step as to how the error was generated.
What I have noted is that you can enter data into any of the tabs in any order; however, you can't get back to that data... for example, if you enter information in tab accident info and then move away from that record without information in the other two, then there is no way from your form to enter the missing customer information same thing with customer information... you have to start with the first tab and then move on to the second etc..
@zmbd, you are right about saving in lower version. I was stupid on this point. As far as the error goes, I entered data on page1 (Intake Info), page2 (Client Info), and then page3 (Accident Info). When I got to the last field on sfrmAccident, either Refer Out Attorney or Intake Status, and hit tab to go to the Follow Up section at bottom, the error occurred.
And yes, you are right about the missing information if you skip a tab. I don't know how to tie them together yet, any suggestions?
zmbd 5,501
Expert Mod 4TB
Nope.
Can't re-create the error even following the steps given.
As for getting back to orphaned records, i.e. tblaccident from the tab "accident info," the interface is quite complex and will take awhile to work thru.
Are you using the tab key to move through your forms and then clicking on the next tab after you've tabbed out of your last field? You do realize that the client form will move on to a new record if you tab on the last field right? And when you do finally reach that last field and tab out and it tries to save, there won't be an existing record for it to link to.
Yes I am using the tab key to move through the forms. And yes I do realize that if you are on the last field and tab, it goes to the next record. These are some of the problems I need to fix after I get everything working.
So then that's probably what's causing the error you got. Because I don't get the error you're getting.
Rabbit is so smart! I never would'a thought to tie those events together to cause the error..... Good thing to keep in mind, though, as I continue to improve my designs!
Ok then, makes sense. So how do I control the tab key so that when it gets to last record on page, it automatically goes to next page, instead of next record? And when I get to last page, how do I get the tab key to go to first page of next record automatically? This sure would help my design unless you have another suggestion.
There are a few options that you have. You could not tab out of the last control and just click on the next tab or you could put a save button on the form what would be the next tab stop. This would save the record without going on to the next record.
Seth, I'm working on it now. Good suggestion! Thanks
Unbelieveable, it works now! I modified several tables, the relationships between tables, and added/deleted fields in tables. I linked my main tables together and pulled queries to populate the feeder tables and removed any relationships to the main tables. The relationships is what created the problems. I really appreciate everyone's help. I'm sure I'll probably have other questions, but you guys are a great support group! Thanks a bunch.
Mike
Sign in to post your reply or Sign up for a free account.
Similar topics
by: invincible |
last post by:
hi
I have a cpp application , which is getting compiled
but while linking I am getting error message " first defined here".
error line is pointing to class constructor
...
|
by: afreema |
last post by:
We have a WebSphere application that quit working this week. It was
trying to hit DB2 UDB Version 8 on Linux. The Driver is DB2 V7. This
is the message in the WebSphere logs. Does anyone know...
|
by: Steve |
last post by:
I have several pairs of synchronized subforms in an application. I have a Delete
button for each pair that uses the following code or similar to delete a record
in the second subform:
...
|
by: Rolan |
last post by:
I seem to be unable to have a custom error message to appear for Error
10011 (database was unable to append all the data to the table). Each
time, the MS Access default error message box appears....
|
by: Leon Shaw |
last post by:
Someone please help me understand the following error message:
Server Error in '/solo' Application.
----------------------------------------------------------------------------
----
...
|
by: Robert |
last post by:
Every time I navigate to any .aspx file on my computer, I get the error below. According to MSDN this indicates that my CLR is corrupt, but I've re-installed the .NET framework with no help. Also...
|
by: Rod |
last post by:
I have been working with ASP.NET 1.1 for quite a while now. For some
reason, opening some ASP.NET applications we wrote is producing the
following error message:
"The Web server reported...
|
by: Bruce Schechter |
last post by:
I just started to develop an ASP.NET application in vs.net 2003 . But each
time I try to execute the application (which is basically empty so far), I
get a dialog box titled "Microsoft Development...
|
by: ayman723 |
last post by:
hi;
I have this code in my book and when I copied it into my compiler into two files, one is header and the other is .cpp. it gives me an error, I'm sure I copied it right but can't figure out the...
|
by: robertmeyer1 |
last post by:
Hey. I have a mainform, based off a tblClient. Then 2 sbf’s based off queries. I’m trying to insert the sbf’s into the mainform to allow for data entry (using the Tab Control). I am linking the...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |