Update Or CancelUpdate without AddNew or Edit error

Hi there, I keep getting this error after I update a record, then try moving to another record. When I debug, the error comes up where I am setting my modifier date field on the form to a certain value in the forms BeforeUpdate event. Is there ...

Message posted on the April 23rd, 2009 - 5:34 PM ET

Hi there, I keep getting this error after I update a record, then try moving to another record. When I debug, it comes up with me setting my modifier date field on the form to a value in the forms BeforeUpdate event. Is there somewhere else I can ...

Message posted on the April 23rd, 2009 - 10:59 AM ET

Ignore & continue for ADO 'field is too small' errors

Hi all. I'd post this on the VB6 ADO or VB6 database groups, but it seems dead over there. I've also done quite a bit of Googling about this, but strangely only found one post way back in 2004, with no replies and he was using C++. Anyway, while ...

Message posted on the January 16th, 2012 - 2:24 PM ET

Error 2147352567

I have a combo box on it that searches for the record on my form. My problem is that when I enter a new record using my command button to add a new record, then try to search for another record on my form using my combo box, I get the following ...

Message posted on the May 28th, 2010 - 8:26 AM ET

do loop through a table

I want to go through records in a table "TESTLIST" and assign 1,2,3... to Field1 based on whether there Field2 is not Null. if Field 2 is Null Field1 should start at 0. Field1 Field2 1 Mr. and Mrs. John Smith 2 1 Park Avenue 3 New York, ...

Message posted on the August 6th, 2009 - 1:41 PM ET

Invalid Reference Error

I have two Access 2000, properly split, applications deployed at a client. Both are quite complex (58,000 and 26,000 lines of code) and connect to three (the same) backends. Anywhere from 2 to 15 users each, read/write. Occassionally, I get error ...

Message posted on the July 30th, 2009 - 10:12 AM ET

Which Event to give field a value

Hey there, I need to my 2 fields, ModifierID and ModifierDate to be updated when a record gets inserted into the table, however they are dynamic, no user entry for these obviously. They both call for their own separate routines. I tried putting them ...

Message posted on the April 22nd, 2009 - 6:24 PM ET

Canceling an OnClick Event

Hi all, Is it possible for a BeforeUpdate event of one control to cancel the OnClick event of another? Details: I have an unbound form that allows for editing and creating sites. txtSiteNo has a BeforeUpdate event that checks if the site already ...

Message posted on the May 25th, 2010 - 5:34 PM ET

Exporting data with vba from Excel to an Access 2007 db with password

I will use Excel 2007 and Access 2007 and want to log events in an *.accdb file. I also want to password protect the database. However, when trying to add a new record to the db with password, I get an error? If I remove the password from my db and ...

Message posted on the February 12th, 2012 - 4:01 PM ET

Capture ID of newly inserted row

I have an access database that I am scaling up to an Oracle database via ODBC connection. I've run into a problem capturing the ID column of a newly created record. I need this ID to populate the FK of dependent related rows in another table that I ...

Message posted on the October 26th, 2010 - 3:01 AM ET

Run-time error 80004005

Run-time error -2147467259 (80004005) Could not update; currently locked by user 'abcde' on machine 'ComputerName' What is the actual cause of this error? Here's the situation: I have an app (VB6 of course) in which I'm maintaining an Access ...

Message posted on the January 27th, 2010 - 9:43 AM ET

Unpredicatable BeforeUpdate event

Hi, I am totally new to programming. I have tried to design a form with some code in the beforeupdate. The behaviour of the form has baffled me so much i can’t understand where it’s going wrong. It’s totally unpredictable. So, ...

Message posted on the December 12th, 2009 - 12:41 PM ET

Recordset processing problem

I have a very complex loop that does recordset processing. I'm getting an error on an .ADDNEW statement saying 'operation not allowed when object is closed'. Well... I am not closing the object except after I have exited the loop. What could cause ...

Message posted on the May 13th, 2009 - 4:00 PM ET

Audit Trail function won't record new records

When I add a new record to a form, then save it before selecting another record or using find to find another record, I get an error at these lines, one after the other when I rem the first one out etc. rs!PriorInfo = Screen.ActiveControl.OldValue ...

Message posted on the July 2nd, 2010 - 4:03 PM ET

without addnew