Search results for query: *

I saw some goofs after I submitted the sample code. Use this instead: ' SET VARIABLES '--------------- Dim i as Integer ' Loop Number Value Dim CoName as String ' Company Name as Text Dim CoRexMax as Long ' Maximum Number of Company Records CoRexMax = DCount("*","CNAMES") i = 0...

I've done this a hundred times. It'll work as long as the CID is sequential from 1 (or some other starting point) to whatever without any missing numbers. If that's the case, then what you need to do is set up your Company Name and ID values as VARIABLES so the actual value can change as you...

Wow! I never thought of creating a new table via code. I'll have to look into that, though I'm not sure I have the time to do that for this project I'm working on right now. I've never done that before and I'd have to research on how to format all the fields. But even if I don't don't do it...

Thanks. I'm already ahead of you; I've changed the Make-Table Query to an Append Query, and in the object table I've inserted an AutoNumber field. For various reasons, I was hoping to avoid this because now the autonumber will grow and grow and grow to the point where even though there may be...

The advice provided in the following thread (http://www.tek-tips.com/viewthread.cfm?qid=1070674&page=2) is tantilizing, but imcomplete for someone like me who's never done it before. How do I add an AutoNumber field to a table made from a MakeTable Query? The resulting table is called...