User Profile
Collapse
-
Current Recordset does not support updating error while submitting form.
New to the forum, so thanks for having me.
I'm submitting a form, and attempting to save it to a local copy of an ACCESS 2007 database. When I am submitting the form, I get the following error:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/JustBorn/form_submit.asp , line 414
Line 414 is: rs.Open... -
I am having 2 people access the data in the database. they will be doing this project over a couple of weeks. I have added a field called CALL DATE to the database. when they go into a record on the form and modify something on there, I want the form to auto-populate todays date, so I have a record of when this person was contacted last. I have added the code...
...Code:Private Sub Form_Dirty(Cancel As Integer) Me.Call_Date = Date
Leave a comment:
-
Microsoft Access auto-updating exisiting records in a form not working.
I have an access database with about 3000 records, and we need to go thru this and update certain information in the records. I have created a form that has the following code...
This code, I thought, would update the CALL DATE field to the most current date once a modification has been made. It works for New records, but not working...Code:Private Sub Form_Dirty(Cancel As Integer) Me.Call_Date = Date End Sub
-
At launch, I am getting the error at line 33 EXPECTED HEXADECIMAL DIGIT
when running, and I hit submit, I get an error at line 83 OBJECT EXPECTEDLeave a comment:
-
Yes. this will only be used in a closed environment at this time. the office is Microsoft central.Leave a comment:
-
HTML Database access using Javascript
Trying to create an HTML page called Project.html that will ask the user for basic information (name, e-mail address, and comments), and when the SUBMIT buttom is hit, add the users to an Access 2007 Database. Ideally, the information would only be able to be added once, but I need the adding sequence to work first. Any and all comments or questions would be appreciated.
Anthony
Beginning Programmer
...Code:<!DOCTYPE
No activity results to display
Show More
Leave a comment: