Search results

Has anyone found that the name assigned to printers under XP is different than under Windows 98? For example: Using Access 97, I created an invoice report and defined a specific printer called "Invoices". This printer is a shared network printer and is identified by Windows 98 as "Invoices"...

Has anyone found that the name assigned to printers under XP is different than under Windows 98? For example: Using Access 97, I created an invoice report and defined a specific printer called "Invoices". This printer is a shared network printer and is identified by Windows 98 as "Invoices"...

New Discovery: A "trick" to get rowsource SQL to ignore table defined captions. Select [myfield] & "" AS [my field] from... This works because Access does not consider myfield & "" to actually be coming from a table, but rather views it as the result of a concatenation. So it allows you to...

No chance. I have even tried some different names like "jfgjg" just to be sure.

Type line one, press ctrl+enter, type line two.

I have seen behavior where the "AS" clause name will take precidence and sometimes the table caption does. The SQL should always override the table's caption, but sometimes doesn't. I have not figured out how Access determines this. If anyone knows, please reply. John_Hazen@hotmail.com

I did some experiments and have found some very strange "behavior". If I build a query on an Employee table using EmpNo:EmployeeID as the Field, I get "Employee ID" as the name in the output (I presume, taken from the field's caption property in the Employee table) My rename to "EmpNo" is...