Unable To Save A Record Because A Record Is Required

Oct 31, 2005

I have a database set thus

Clients (the main form)

ClientsID (PK)
blah blah
Information and Referral (a check box)
blah blah
blah blah

ClientIR (the form that opens up when I & R is checked)

IR ID (PK)
ClientsID (FK to the above form)
Requests (a lookup referencing to IRCategory)

The code is set up so when the I R box is checked, form will open, and unchecking it will delete the I R record of that Client.

The problem is when the IR Box is already open, the request has been selected, I cannot save it as Access says a record is required in the Clients form. There are only two buttons, one goes on to next requests (one client can have more than one requests), other saves and closes.

The Client form is already coded so it will save the Client's record before opening the IR Form, and either button will save the IR record as well.

I had referential intergrity turned on. Turning it off only gave me weird results (I was able to input records, but Access didn't autofill the ClientID in the IR records, and looking at Clients returns a blank IR record)

What am I doing wrong?


Thanks

View Replies


ADVERTISEMENT

User Unable To Save Record?

Jan 25, 2007

I have a problem where a user (with what I believe are the proper security settings) cannot save a new record in a form. I have set the securities on the form and the related table and query to allow this user to create new records (Add/Run).

This user is able to access the form and enter the data, but it will not save. I have added a "Save" button to no avail.

When I log on as the administrator, it works fine.

Any Ideas?

Thanks in advance.

View 3 Replies View Related

Forms :: Unable To Edit / Save Record - Runtime Error 2107

Apr 30, 2014

My database was working fine. Now, if I have to save or edit a record, I get a message Run time error 2107. The value you entered does not meet the validation rule defined for the field or control. I am able to enter and edit new records in the table. I did not change any validation in form. Then it goes to debug mode and highlighted this code (me.recordsource=Listsql - is highlighted)

Private Sub ListSearch_Click()
Dim dBS As Database
Dim Rst As Recordset
Dim Listsql As String
Set dBS = CurrentDb()
Listsql = "Select * from MasterData where employeeid ='" & [Forms]![MASTERFORM]![ListSearch] & "'"

[Code] ....

View 3 Replies View Related

"You Cannot Add Or Change A Record Because A Related Record Is Required In Table....

Aug 1, 2006

Hi! Please help!!!

I'm currently building a bookings database and have encountered an alert message that I cant seem to rectify -

"You cannot add or change a record because a related record is required in the table 'Booking Details'"

Basically - I have a 'Customer Database' form that is linked (via command button) to a 'Booking Details' form. Within 'Booking Details' I have 2 sub forms - 'Booking Quote' and 'Booking Payments'. Both subforms are linked to the 'Booking Details' form by the 'booking ref' field with RI.

I have no problem updating information in the 'Booking Quote' subform, but when I try to add information to 'Booking Payments' it states the above message.

Can anyone please advise as to how I can prevent this happening? I'm slowly losing my mind....!!!

Many thanks,

Stacey

View 10 Replies View Related

Tables :: Cannot Add Or Change A Record Because A Related Record Is Required In Table

Oct 22, 2012

Currently I keep getting this error: "You cannot add or change a record because a related record is required in table"..My current tables are this:

Primary Table with persons info:

Primary Key - Auto number generated
Name
Address
Email
Phone

I have 4 other tables with use check boxes.

ex:

Table 1 - Geographic locations visited

ID - Auto generated
USA
CANADA
ASIA
ECT...

Table 2 - Languages Spoken
ID - Auto generated
Spanish
Chinese
English

Table 3 - Skills
ID - Auto generated
Hunting
Dance
Singing
Weaving

Is this not a genuine one-to-one relationship table? I mean No two people would have had visited the same places and speak the same language no? I tried to create a one to one relationship with the primary key to the auto generated ID of the child tables but I'm sure that is not how you do it. Also when I try to save the check boxes in my form and I close it and come back it doesnt save and is blank again. Is it because my form gets its information from a query that takes all the information from all the tables.

how I can get this to work properly? Am i to make use of a foreign key? I've read a lot about it online and watched youtube videos but I dont see why I need it here in this case. Is there a way to set the IDs in the child tables to be the ones from the primary table? Or do I have to use a foreign key and manually input the primary ID into them?

Or would it be better to have all these child tables in the primary table and have one large table instead? I just didnt do that because one of them has like 20 checkboxes with cities and locations

View 12 Replies View Related

Cannot Add Or Change A Record Because Related Record Is Required In Table

Aug 12, 2013

I have a problem with my access form, it said "You cannot add or change a record because a related record is required in table". I have attached the access file.

View 14 Replies View Related

Can't Add Change Record Related Record Required

Jan 24, 2007

Can someone help me out by looking at my database I've been messing with it for 3 days and I can't figure it out.
I have 4 tables each are in a 1 to 1 relationship. From there I have a query that is for every field between the 4 tables. I then have a Tab Control form with 4 tabs and it uses the qryAll I have setup. when I enter on the form I can enter info on all 4 tabs but if I try to go to a different record I get the message "You can't add or change a record because a related record is required in tblScouts". I have tried so many different options. I had even posted yesterday trying to do the same thing but my tab controls had subforms on them. The_Doc_Man was helping me with that issue but I couldn't get that to go either.
Would anyone be willing to look at it for me and explain to me what I was doing wrong?

Rick

View 5 Replies View Related

Forms :: Save Form Record On Move To Next Field In Record?

Jan 15, 2014

After I enter data into one field in a record I would like the form to save the record when I move to another field in the same record. It seems that the record is only saved when I exit it entirely. Is there a way to save a record when moving between fields in that record? Can this be done without using an Event Procedure for each field?

View 8 Replies View Related

General :: Save Record On Data Entry And Generate ID For That Record

Feb 1, 2014

I am working on a database and i have notice after making a form that when i enter a record using a form if i enter incomplete data on the form access automatically save that record and generate a id for that record.

For example I have a table that contain

StudentID,StdName,FatherName,DOB,Adress,Phone

And I have created a form for that table that also containing these fields.

Here I want to do that on the form I want a "Save" button , and the purpose of this button that when I click on this button then MS Access Save the record and then generate the ID for that record and if i close my form without pressing "SAVE" button access do not save that incomplete record.

View 10 Replies View Related

Unable To Go To New Record

Jun 5, 2006

Hello everyone,

Can anyone help?

I have a data entry form via which I want to add records to a table. However, when I've entered data in the last field, the cursor remains there and the system just beeps. I added a command button on the form to go to a new record but when I click on the button i get the following message:-

You can't go to the specified record

You may be at the end of a recordset


Any suggestions??

Thanks

Will

View 10 Replies View Related

Unable To Add A New Record

Oct 18, 2015

Created three tables and one linking table, created two queries linked to a form to display the results and have now setup the code to display details. Next step to create a form to add a new record to the database.

Initially I used the form wizard, dragged the fields in and then viewed the form to see if I could add a record.However the new record button at the bottom is greyed out.I checked the Form properties and allow editions, deletions and edits are all set to yes.the source for the form is:

Code:
SELECT [tblGraves].[Plot], [tblGraves].[GraveNo], [tblGraves].[GraveID], [tblDeceased].[Forenames],
[tblDeceased].[Surname], [tblDeceased].[DayOfDeath], [tblDeceased].[MonthOfDeath],
[tblDeceased].[YearOfDeath], [tblDeceased].[DayOfBurial], [tblDeceased].[MonthOfBurial],
[tblDeceased].[YearOfBurial], [tblDeceased].[Age], [tblDeceased].[pp], [tblDeceased].[Notes],

[Code] .....

and it is a dynaset record set type.So I thought ( dangerous I know) use a query, I created the query setup the joins etc etc.I double clicked on the query and all my records were listed, I then selected the new record and the bottom but that is greyed out as well.

View 14 Replies View Related

Field Required Before Record Can Be Saved

Sep 4, 2006

What i want to do is if a user forgets to put lets say Address or Zip
Will not allow user to save record but instead will highlight the text boxs
that are required. Once data is put in will allow user to save record.


Any ideas

View 1 Replies View Related

Unable To Add Record To A Table

Mar 2, 2007

I have a database that has been working properly for months...however, suddenly I am unable to add records to a number of my tables.

Each of 10 tables are related to a main table with a 1 to 1 relationship - the relationships have not changed.

Can anyone think of any table setting which I may have inadvertantly changed that would prevent additional records from being added?

I am still able to add to the main table and I have added several new tables also with a 1 to 1 relationship with the main table that are all working fine.

Thanks!

View 3 Replies View Related

Unable To Edit Record

Apr 29, 2008

Hey Guys and Gals,

I have a form that has a drop-down box. When the form opens, all the records are shown. Once a name is selected from the drop-down, only the records associated with that name are shown (a filter is created using code). The problem is that once the selection is made, I am unable to edit the records. I try to click in the fields but am unable to.

Any ideas? Thanks

View 5 Replies View Related

General :: Unable To Add New Record To Table

Apr 28, 2015

I have been using my db for 3 years without this particular problem: I am now unable to add records to one of my tables - either through the form or in datasheet view. I have a patient table and a visit table. I put in the patient data using a form and then go to the visit form to add all of the visits for the month. I have never had a problem adding data to any of my tables but now I am unable to add data to the visit table. As much as I didn't want to I brought up last month's back up to enter the patients again. Before I did I checked to see if I could add visits - I could not. So I checked January's back up - same issue. I made no changes to the db before trying to add a visit .

View 10 Replies View Related

Forms :: Checking For Required Fields Before Saving Record

Aug 25, 2014

I have a transaction form and there is at least two fields I need to make sure have been entered before the record is saved.

I have no problem with text or numeric fields but I can't seem to be able to check the contents of a drop down field.

What is the best method to use to make sure a drop down has been selected by the user and contains a value.

I have temporarily used a default value in the drop down but that's not really what I want.

View 3 Replies View Related

Modules & VBA :: Unable To Add Hidden Information To A Record

Mar 3, 2015

I'm trying to add hidden information to a record and need to know the best way to do it.

I have a visible table that all users enter data into using a form.

I also have a hidden table that contains 2 fields "linked Table ID" and "notes"

I have a box at the top right of my form which is white (I also have a white background so it's impossible to see).

When you click the box it changes a textbox on my form visible property from false to true.

then I plan to use a separate button that the user currently uses to save a record to store ID number and hidden textbox information in the hidden table but I'm sure how to do this.

Finally I will use a hidden query which will display all the fields from both tables using the linked Table ID from the hidden table and ID field from the non hidden table.

So i have 2 questions:

1 how do I save information the user entered into a form created from one table into a different (hidden) table

2. Is this the right approach to this problem?

View 3 Replies View Related

Forms :: Creating Required Field In A Form Before Moving To Next Record

Feb 5, 2014

I have created a Form based from a Table. On one of the fields, I need to be required inside the Form before moving to the next record of that form. I can not make the required field in the table, because I have to append information day to day.

Also, the required field is a combo box option that is limit to the list.

What kind of Code I can do inside the form of the specific field to make it required before clicking onto the next record. It does not matter if the processor closes out of the form before updating, only if moving to the next record.

View 5 Replies View Related

Modules & VBA :: Formula Based On Record Number - Recordset Required?

Dec 14, 2014

In order to arrive at the required solution I have to perform a calculation, using data from each successive table record (in chronological order). The result of each calculation must then be used to arrive at the result for the next calculation.

In other words I have to update a variable based on data from each record, sorted in chronological order, and use the final result to populate a field on a form.

Is it time to break out my copy of "VBA For Dummies" and start learning how to use Recordsets?

View 8 Replies View Related

Forms :: Unable To Print Current Record In The Form

Jun 4, 2014

I tried to follow the Allen Brown print the current record in the form and its not coming up. I can print all of the records but not the current.

View 3 Replies View Related

Modules & VBA :: Unable To Create Duplicate Record On Subform

Nov 29, 2013

I am trying to create duplicate records from a main form frmManagers which has a subform frmSubMeasure. I have placed the duplicate button on the main form. It creates a duplicate of the main form data and gives me the option to add new record to the sub. I want the duplicate to be created on the sub form for me to just edit the scores.

I don't know how to pass the sub form data to be duplicated I thought the append query which I used would update the tblSubMeasure table which created the subform frmSubMeasure.
In the sub the append query do update the form with the new MeasureID from the mainform and the form is available to enter new data. I want the subform data to be duplicated as well

In the query I included all the fields from the tblSubMeasure table and this is appended to the same table tblSubMeasure and I place a tag on the MeasureID using "[Forms]![frmManagers].[Tag]"

Code:
Private Sub btnDuplicate_Click()
Dim dbs As DAO.Database, Rst As DAO.Recordset
Dim F As Form
'Return Database variable pointing to current database.
Set dbs = CurrentDb
Set Rst = Me.RecordsetClone

[Code] .....

View 1 Replies View Related

Forms :: Unable To Print A Report From A Record In Form

Oct 14, 2013

Why I cannot print a report using a single record in a form using Access 2007.

I have added the button, I am using the following code:

Private Sub cmdPrintRecord_Click()
Dim strReportName As String
Dim strCriteria As String
strReportName = "Receipt"
strCriteria = "[ID]='" & Me![ID] & "'"
DoCmd.OpenReport strReportName, acViewPreview, , strCriteria
End Sub

However when I click the button nothing happens. I have attached the database ...

I am using the Contacts Entry form, and when I am on a record that someone has paid I want to be able to print from the Receipt report that has a simple formed up letter.

View 8 Replies View Related

Record Will Not Save

Jan 27, 2005

Can't figure it out. Here is the code:


Private Sub Button_OpenQuest_Click()
On Error GoTo Err_Button_OpenQuest_Click

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Ques_Physician"

stLinkCriteria = "[sbjID]=" & "'" & Me![sbjID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Me.Visible = False

Exit_Button_OpenQuest_Click:
Exit Sub

Err_Button_OpenQuest_Click:
MsgBox Err.Description
Resume Exit_Button_OpenQuest_Click

End Sub

__________________________________________________ __

I get the message "The command or action 'SaveRecord' isn't available now"

View 7 Replies View Related

Save Record

Apr 25, 2006

Hi all,

I am wondering if there is a way to save a record in this manner.

When the user opens the form wait 1 second and then save.

But I would like it to do this only once. I have tried the “on timer” but it keeps saving the record every second.

Thanks in advance
Jon

View 10 Replies View Related

Record Tries To Save Twice

Dec 14, 2005

I have an unbound form that I load with one record. The record is selected based on a selection made in a list box on a previous form.

Then changes can be made to the data.

Then I want to click the save button which runs a stored procedure to update the table with the new data. I DON'T want Access to automatically post the record for me.

But when I hit save it tries to update twice and gives me a warning - it saves through the stored procedure and then tries to save again as the form closes. (I'm assuming. - I get a warning that says another user has changed the record and do I want to overwrite the changes.) I think it's because right now I load it with fields from a view.

Here is the code that opens the form and gives it the recordsource....

View 5 Replies View Related

Unable To Update A Field In Record In My Form After Selecting From Comboox.

Apr 25, 2005

Trying to update a field in a record in my form after selecting from a comboox.

This an orders form with a record per row for order items. I select the product from a dropdown list which is populated by a dynamic query from the afterupdate event on another combo. When I do the selection access reports the following error:
Runtime error 3331
to make changes to this field, first save the record


Debug takes me to the line :
Me!product_id = DLookup("product_id", "products_table", myvar)
from :
[code]
Private Sub comboProd_description_AfterUpdate()
Dim strFilter As Integer

comboProd_description.Value = comboProd_description.Column(1)

myvar = comboProd_description.Column(0)



Me!product_id = DLookup("product_id", "products_table", myvar)

[end code]

I'm lost as to what to do (no such thing as beginners luck!!). I'm not even sure if the error is from the combo box or from the field that it is trying to update (product_id)

Thx for looking

Kev.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved