HELP FORM WILL NOT LET ME ADD ANOTHER RECORD

N

Need Help

Hi,

Please help. I am in the process of adding new records to form it is
actually a data entry screen and will not let me add another one. The last
record is at 99. Please, Please, help


Thanks in advance
 
B

Bill Mosca

Does the "New record" row at the bottom show?
What error message are you getting?
 
N

Need Help

No it says 1 to 99 and the new record button will not light so I can go to
the next record. The next records button will not light up and there is not
error message
 
B

Bill Mosca

It sounds like the form's query is not updatable. Can you post the SQL for
the query?
 
N

Need Help

HERE YOU GO
SELECT TBL_VEHICLE_INCIDENT_REPORT.[Claim No],
TBL_VEHICLE_INCIDENT_REPORT.Date, TBL_VEHICLE_INCIDENT_REPORT.[Dr First
Name], TBL_VEHICLE_INCIDENT_REPORT.[Dr MI], TBL_VEHICLE_INCIDENT_REPORT.[Dr
Last Name], TBL_VEHICLE_INCIDENT_REPORT.[CO#],
TBL_VEHICLE_INCIDENT_REPORT.[Facility No],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Bus Unit],
TBL_VEHICLE_INCIDENT_REPORT.[CODD Region],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Address],
TBL_VEHICLE_INCIDENT_REPORT.[Facility City],
TBL_VEHICLE_INCIDENT_REPORT.[Facility State],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Zip],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Phone],
TBL_VEHICLE_INCIDENT_REPORT.[Supervisor Name],
TBL_VEHICLE_INCIDENT_REPORT.[Supervisory Phone],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Location],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Date],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Time],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Description],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Detail],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Cause Code],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Dr Injured],
TBL_VEHICLE_INCIDENT_REPORT.[Use of Co Vehicle],
TBL_VEHICLE_INCIDENT_REPORT.[Citation(s) Issued],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Unit No],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Year],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Make],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Model],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle VIN],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle License State],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle License No],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle GVW],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Trailer Involved],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Damaged],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Drivable],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Location],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Damage Description],
TBL_VEHICLE_INCIDENT_REPORT.Injuries, TBL_VEHICLE_INCIDENT_REPORT.[Property
Damage], TBL_VEHICLE_INCIDENT_REPORT.[Single Vehicle],
TBL_VEHICLE_INCIDENT_REPORT.Injured, TBL_VEHICLE_INCIDENT_REPORT.[How Many -
Injured], TBL_VEHICLE_INCIDENT_REPORT.Hospital,
TBL_VEHICLE_INCIDENT_REPORT.[How Many Fatalities],
TBL_VEHICLE_INCIDENT_REPORT.[How Many - Hospital],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Vehicle Towed],
TBL_VEHICLE_INCIDENT_REPORT.[Other Vehicle Towed],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Dr Cited],
TBL_VEHICLE_INCIDENT_REPORT.[Other Dr Cited],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Weight],
TBL_VEHICLE_INCIDENT_REPORT.[Trans Haz Mat], TBL_VEHICLE_INCIDENT_REPORT.[DOT
Recordable], TBL_VEHICLE_INCIDENT_REPORT.[Accident Register],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Category],
TBL_VEHICLE_INCIDENT_REPORT.[Regional Group],
TBL_VEHICLE_INCIDENT_REPORT.[Last Name]
FROM TBL_VEHICLE_INCIDENT_REPORT;
 
B

Bill Mosca

Since th equery is on just one table, it should be updatable. That tells me
that the settings for the form must be such that Allow Additions is set to
NO. Is this the case? If it is, change it to Yes.


--
Bill Mosca


Need Help said:
HERE YOU GO
SELECT TBL_VEHICLE_INCIDENT_REPORT.[Claim No],
TBL_VEHICLE_INCIDENT_REPORT.Date, TBL_VEHICLE_INCIDENT_REPORT.[Dr First
Name], TBL_VEHICLE_INCIDENT_REPORT.[Dr MI], TBL_VEHICLE_INCIDENT_REPORT.[Dr
Last Name], TBL_VEHICLE_INCIDENT_REPORT.[CO#],
TBL_VEHICLE_INCIDENT_REPORT.[Facility No],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Bus Unit],
TBL_VEHICLE_INCIDENT_REPORT.[CODD Region],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Address],
TBL_VEHICLE_INCIDENT_REPORT.[Facility City],
TBL_VEHICLE_INCIDENT_REPORT.[Facility State],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Zip],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Phone],
TBL_VEHICLE_INCIDENT_REPORT.[Supervisor Name],
TBL_VEHICLE_INCIDENT_REPORT.[Supervisory Phone],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Location],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Date],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Time],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Description],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Detail],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Cause Code],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Dr Injured],
TBL_VEHICLE_INCIDENT_REPORT.[Use of Co Vehicle],
TBL_VEHICLE_INCIDENT_REPORT.[Citation(s) Issued],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Unit No],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Year],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Make],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Model],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle VIN],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle License State],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle License No],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle GVW],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Trailer Involved],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Damaged],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Drivable],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Location],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Damage Description],
TBL_VEHICLE_INCIDENT_REPORT.Injuries, TBL_VEHICLE_INCIDENT_REPORT.[Property
Damage], TBL_VEHICLE_INCIDENT_REPORT.[Single Vehicle],
TBL_VEHICLE_INCIDENT_REPORT.Injured, TBL_VEHICLE_INCIDENT_REPORT.[How Many -
Injured], TBL_VEHICLE_INCIDENT_REPORT.Hospital,
TBL_VEHICLE_INCIDENT_REPORT.[How Many Fatalities],
TBL_VEHICLE_INCIDENT_REPORT.[How Many - Hospital],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Vehicle Towed],
TBL_VEHICLE_INCIDENT_REPORT.[Other Vehicle Towed],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Dr Cited],
TBL_VEHICLE_INCIDENT_REPORT.[Other Dr Cited],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Weight],
TBL_VEHICLE_INCIDENT_REPORT.[Trans Haz Mat], TBL_VEHICLE_INCIDENT_REPORT.[DOT
Recordable], TBL_VEHICLE_INCIDENT_REPORT.[Accident Register],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Category],
TBL_VEHICLE_INCIDENT_REPORT.[Regional Group],
TBL_VEHICLE_INCIDENT_REPORT.[Last Name]
FROM TBL_VEHICLE_INCIDENT_REPORT;



Bill Mosca said:
It sounds like the form's query is not updatable. Can you post the SQL for
the query?
Click to expand...
Click to expand...
 
N

Need Help

Thanks that helps

Bill Mosca said:
Since th equery is on just one table, it should be updatable. That tells me
that the settings for the form must be such that Allow Additions is set to
NO. Is this the case? If it is, change it to Yes.


--
Bill Mosca


Need Help said:
HERE YOU GO
SELECT TBL_VEHICLE_INCIDENT_REPORT.[Claim No],
TBL_VEHICLE_INCIDENT_REPORT.Date, TBL_VEHICLE_INCIDENT_REPORT.[Dr First
Name], TBL_VEHICLE_INCIDENT_REPORT.[Dr MI], TBL_VEHICLE_INCIDENT_REPORT.[Dr
Last Name], TBL_VEHICLE_INCIDENT_REPORT.[CO#],
TBL_VEHICLE_INCIDENT_REPORT.[Facility No],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Bus Unit],
TBL_VEHICLE_INCIDENT_REPORT.[CODD Region],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Address],
TBL_VEHICLE_INCIDENT_REPORT.[Facility City],
TBL_VEHICLE_INCIDENT_REPORT.[Facility State],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Zip],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Phone],
TBL_VEHICLE_INCIDENT_REPORT.[Supervisor Name],
TBL_VEHICLE_INCIDENT_REPORT.[Supervisory Phone],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Location],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Date],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Time],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Description],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Detail],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Cause Code],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Dr Injured],
TBL_VEHICLE_INCIDENT_REPORT.[Use of Co Vehicle],
TBL_VEHICLE_INCIDENT_REPORT.[Citation(s) Issued],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Unit No],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Year],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Make],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Model],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle VIN],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle License State],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle License No],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle GVW],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Trailer Involved],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Damaged],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Drivable],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Location],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Damage Description],
TBL_VEHICLE_INCIDENT_REPORT.Injuries, TBL_VEHICLE_INCIDENT_REPORT.[Property
Damage], TBL_VEHICLE_INCIDENT_REPORT.[Single Vehicle],
TBL_VEHICLE_INCIDENT_REPORT.Injured, TBL_VEHICLE_INCIDENT_REPORT.[How Many -
Injured], TBL_VEHICLE_INCIDENT_REPORT.Hospital,
TBL_VEHICLE_INCIDENT_REPORT.[How Many Fatalities],
TBL_VEHICLE_INCIDENT_REPORT.[How Many - Hospital],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Vehicle Towed],
TBL_VEHICLE_INCIDENT_REPORT.[Other Vehicle Towed],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Dr Cited],
TBL_VEHICLE_INCIDENT_REPORT.[Other Dr Cited],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Weight],
TBL_VEHICLE_INCIDENT_REPORT.[Trans Haz Mat], TBL_VEHICLE_INCIDENT_REPORT.[DOT
Recordable], TBL_VEHICLE_INCIDENT_REPORT.[Accident Register],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Category],
TBL_VEHICLE_INCIDENT_REPORT.[Regional Group],
TBL_VEHICLE_INCIDENT_REPORT.[Last Name]
FROM TBL_VEHICLE_INCIDENT_REPORT;



Bill Mosca said:
It sounds like the form's query is not updatable. Can you post the SQL for
the query?
--
Bill Mosca


:

No it says 1 to 99 and the new record button will not light so I can go to
the next record. The next records button will not light up and there is not
error message

:

Does the "New record" row at the bottom show?
What error message are you getting?
--
Bill Mosca


:

Hi,

Please help. I am in the process of adding new records to form it is
actually a data entry screen and will not let me add another one. The last
record is at 99. Please, Please, help


Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
Y

Yula

I have a query that is only one table and I can't add any records. I have
allow additions set to YES.


Below is my SQL for the Query:

SELECT Main_Table.Inserter, Main_Table.Date, Main_Table.Meter,
Main_Table.Shift, Main_Table.Category, Main_Table.Job, Main_Table.ID,
Main_Table.Count, Main_Table.Postage, Main_Table.MasterItem1,
Main_Table.PSItem1, Main_Table.Description1, Main_Table.Price1,
Main_Table.MasterItem2, Main_Table.PSItem2, Main_Table.Description2,
Main_Table.Price2, Main_Table.CostCenter, Main_Table.Contact, Main_Table.OH,
Main_Table.Post, Main_Table.Total
FROM Main_Table;

Thanks,
Yula

Bill Mosca said:
Since th equery is on just one table, it should be updatable. That tells me
that the settings for the form must be such that Allow Additions is set to
NO. Is this the case? If it is, change it to Yes.


--
Bill Mosca


Need Help said:
HERE YOU GO
SELECT TBL_VEHICLE_INCIDENT_REPORT.[Claim No],
TBL_VEHICLE_INCIDENT_REPORT.Date, TBL_VEHICLE_INCIDENT_REPORT.[Dr First
Name], TBL_VEHICLE_INCIDENT_REPORT.[Dr MI], TBL_VEHICLE_INCIDENT_REPORT.[Dr
Last Name], TBL_VEHICLE_INCIDENT_REPORT.[CO#],
TBL_VEHICLE_INCIDENT_REPORT.[Facility No],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Bus Unit],
TBL_VEHICLE_INCIDENT_REPORT.[CODD Region],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Address],
TBL_VEHICLE_INCIDENT_REPORT.[Facility City],
TBL_VEHICLE_INCIDENT_REPORT.[Facility State],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Zip],
TBL_VEHICLE_INCIDENT_REPORT.[Facility Phone],
TBL_VEHICLE_INCIDENT_REPORT.[Supervisor Name],
TBL_VEHICLE_INCIDENT_REPORT.[Supervisory Phone],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Location],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Date],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Time],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Description],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Detail],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Cause Code],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Dr Injured],
TBL_VEHICLE_INCIDENT_REPORT.[Use of Co Vehicle],
TBL_VEHICLE_INCIDENT_REPORT.[Citation(s) Issued],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Unit No],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Year],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Make],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Model],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle VIN],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle License State],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle License No],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle GVW],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Trailer Involved],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Damaged],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Drivable],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Location],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Damage Description],
TBL_VEHICLE_INCIDENT_REPORT.Injuries, TBL_VEHICLE_INCIDENT_REPORT.[Property
Damage], TBL_VEHICLE_INCIDENT_REPORT.[Single Vehicle],
TBL_VEHICLE_INCIDENT_REPORT.Injured, TBL_VEHICLE_INCIDENT_REPORT.[How Many -
Injured], TBL_VEHICLE_INCIDENT_REPORT.Hospital,
TBL_VEHICLE_INCIDENT_REPORT.[How Many Fatalities],
TBL_VEHICLE_INCIDENT_REPORT.[How Many - Hospital],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Vehicle Towed],
TBL_VEHICLE_INCIDENT_REPORT.[Other Vehicle Towed],
TBL_VEHICLE_INCIDENT_REPORT.[Culligan Dr Cited],
TBL_VEHICLE_INCIDENT_REPORT.[Other Dr Cited],
TBL_VEHICLE_INCIDENT_REPORT.[Vehicle Weight],
TBL_VEHICLE_INCIDENT_REPORT.[Trans Haz Mat], TBL_VEHICLE_INCIDENT_REPORT.[DOT
Recordable], TBL_VEHICLE_INCIDENT_REPORT.[Accident Register],
TBL_VEHICLE_INCIDENT_REPORT.[Incident Category],
TBL_VEHICLE_INCIDENT_REPORT.[Regional Group],
TBL_VEHICLE_INCIDENT_REPORT.[Last Name]
FROM TBL_VEHICLE_INCIDENT_REPORT;



Bill Mosca said:
It sounds like the form's query is not updatable. Can you post the SQL for
the query?
--
Bill Mosca


:

No it says 1 to 99 and the new record button will not light so I can go to
the next record. The next records button will not light up and there is not
error message

:

Does the "New record" row at the bottom show?
What error message are you getting?
--
Bill Mosca


:

Hi,

Please help. I am in the process of adding new records to form it is
actually a data entry screen and will not let me add another one. The last
record is at 99. Please, Please, help


Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
Top