Recent content by jwol

Thanks Keith, worked like a charm! I've wondered what a Pass Through Query was, now I know. You saved me a lot of screwing around, thanks again. John

Hi all, I've searched this with no success. I have a ODBC (Firebird) table linked using a DSN connection which has >300 fields. In Access, the linked table only show 256 fields (max for Access). Otherwise the link works fine. I have no control over the source Firebird table. What I'd like...

Thanks Pat, Your solution is elegant in it's simplicity - the best ones always are! I was thinking about how to work a CalType table into the mix, and you showed the way. Again, many thanks, John

Hi everyone, I have a table design question. I have a Master table tblData: DataKey (PK) CalibrationKey (foreign key) Various data fields . . I want the CalibrationKey to be able to refer to >1 possible calibratioin tables, since there are several possible calibration protocols. Each...

Thanks Neil, I'd personally prefer to just leave the FE in A97, but when it's opened in A2000 it doesn't allow some stuff to run (ie enabling/disabling controls via code). I guess that qualifies as "modifying the design". Again, thanks, John

Hello all, We are slowly making the conversion from A97 to A2000 and I've been reseaching how best to handle the transition. Currently we have a front-end/back-end setup, both A97, both on the network. The FE is an .mdb. From the archives it seems the accepted strategy is to leave the BE in...

Hello all, I'm trying to print a form w. subform, but on the DoCmd.Printout all the subform controls display their default values. The screen values remain as they should. This occurs for the simplest case possible, a subform w. only a text box on a form w. only a Print button (give it a...