You're the best. I went through each field after the one wasn't it.. Found three that were mismatched...
Actually, I ended up just making them all be <field> = Null , no matter if they were text or date or what have you... it seems to work, added a dozen dummy parts with no faults...
GOLD STAR FOR YOU!!
AlexNunley
Last Activity: Jan 25 '08, 10:30 PM
Joined: May 11 '07
Location:
-
Thanks for the reply!
Looked at what you suggested, the field is not numeric, rather its a memo......
......
Looked further into this, found a few fields that are cross typed... I will fix them, and see if this works...
Is there anything to be done with Memo fields special? or is "" okay?...Leave a comment:
-
Problems with Updating table
I've adopted a moderately sized (65k records) active use database (Access 2000, Windows XP). One of the most commonly used forms is whats called the RMA generation field, used to add claim information to a table on an item-by-item basis. the form is pretty straight forward, but is in need of updating.
In talking with some of the users its been decided to add a few fields to the form. Digging through the guts, I find commands, the cmdAddParts... -
Access & Excel Interoperability woes
I am trying to dump data from an access query into excel so I can pretify it. I found sample code from an old access 97 book (The version of access in use)and tinkered it into working.
Well sort of. The error I get is usually a "Object Required" error, and it highlights the bolded section below. I have been through this thing backwards and forth and cannot figure it out. I am new to this whole thing, so be easy on me....
No activity results to display
Leave a comment: