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

Edit existing record - dhRichClient3

I am trying to edit an existing sqlite record using dhRichClient3. I must be missing something as I am having no success. I am using the following code; With Me.fgAccounts SQLstring = "SELECT * From [AccountsList] WHERE ...

Message posted on the October 8th, 2009 - 10:04 PM 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

Using ADODB in MS Excel.

I have 2 excel files namely Interface.xls & Tracker.xls. I have used following code to update data from Interface to Tracker. Public Sub interface2datadump() Sheet1.Select Dim cn As ADODB.Connection, RS As ADODB.Recordset, RS1 As ...

Message posted on the June 27th, 2009 - 1:20 PM ET

Add New Record

Could anyone help please? I use an unbound Combo Box as a method of finding records in a table and tha is currently working fine. I am wanting to enter an item into the "Find Combo Box" and the search for it with the result that ; if the ...

Message posted on the February 3rd, 2009 - 6:08 AM ET

Combo box assigned to a field not working

I have a combo box that I set up with the wizard. It is based on a table and uses the 3rd option of searching for an existing record. The wizard allows me to set up the lookup with 2 fields, Fname and Lname in my Customers table. When the selection ...

Message posted on the September 13th, 2009 - 8:34 PM ET

without addnew edit