Recent content by dbagley

Thanks rac2. I was trying to insert 3 rows with a union. Sort of like this: INSERT decoder_ring (code, description) select ('y', 'Yes') union select ('x','No') union select ('z','Yes'); This is when it complains about the missing table. In Oracle, I could just add 'From Dual' to each select...

Hey, In Oracle, you can select literals from a table called 'DUAL'. Is there such a table in Access? I'm trying to just insert all literals into a table and need a dummy table name to select from. Thanks, Bagman

Hey, I'm working with Acess97 and get the error "No current record" when creating a new form using the wizard. I remember getting this error in the past, but don't recall the fix. I'm in a terminal server environment where theres 97 & 2000 software. But, for certain reasons, I must use...

Hey Ken, I keep seeing the 'check for missing references', but I'm not sure how. From the module menu, I click Tools, then References. I have 4 boxes checked: Visual Basic For Applications MS Access 8.0 Object Library OLE Automation MS ActiveX Data Objects 2.1 Library The rest are...

Hello, I keep getting an 'Undefined Function <name>' error in my Access 97 database. It seems to be random, but all of the functions are built-in functions (Round, Nz, etc.). I've search the forum & Microsoft, but can't seem to get a clear answer. Is there a bug? Is it my version? Should I just...