Search results

I am using Access 2010. I have many tables that are downloaded from SAP into Access. Within each table structure are the following standard Access attributes: Field Name Data Type Description When I create a query I add the Field Name from the table nothing earth shattering here. But, in...

I'm not sure I follow. Let's say I wrote a query using SQL instead of the query design feature. Is there code I can include that would say: give me all records for Field A in Table A but instead of the Field A name appearing as the column name in the output it would be the description of field A...

Is it possible to view both the table field name and a description in a query? This would be the description contained in the table for each field it contains. I would prefer to see description instead of field name in the output on some queries I run. How would I do this if it is possible? I...

Thanks! I will do that. I used this forum because I am using Access to try and connect to SAP and download tables for analysis. I'll try the ocx search. Thanks Mark

Is there some VB code or commands I can add to see error statements or authorization issues? For example I can't connect because I may be missing some authorizations for object S_RFC in SAP. I am looking for something similar to SU53 to check missing authorizations, if any. Is this possible to...