i posted this in (General) since my issue is for report. i will find a way to delete the post in (General). Anyways
hi. i am working first time with query and reports. i have created a database. i have reports and query. i have a button in my form by the name of (View reports) if a user clicks on that button it opens another form with 3 options
1) Problems all report
2) problems resolved
3) Problems not resolved
I have created a VB procedure which is something like this not an exact code since i am at my home rite now but i have used Docmd.Openreport in actformat excel something like this. it worked. when a user clicks on problem resolved button it automatically takes him to the excel worksheet. but my problem rite now is really critical the last stage. whenever the report is open in excel the whole formatting is bad like for instance i have a field by the name of (description) which have a data type of memo. it will show a part of description because of the column width and everything. same thing with my other fields also. i was wondering if there is any code which someone can provide me so then if a user clicks on the myh report button it should open in excel which i have already achieved but should be perfectly formatted. anyone plz help.
Thanks alot
hi. i am working first time with query and reports. i have created a database. i have reports and query. i have a button in my form by the name of (View reports) if a user clicks on that button it opens another form with 3 options
1) Problems all report
2) problems resolved
3) Problems not resolved
I have created a VB procedure which is something like this not an exact code since i am at my home rite now but i have used Docmd.Openreport in actformat excel something like this. it worked. when a user clicks on problem resolved button it automatically takes him to the excel worksheet. but my problem rite now is really critical the last stage. whenever the report is open in excel the whole formatting is bad like for instance i have a field by the name of (description) which have a data type of memo. it will show a part of description because of the column width and everything. same thing with my other fields also. i was wondering if there is any code which someone can provide me so then if a user clicks on the myh report button it should open in excel which i have already achieved but should be perfectly formatted. anyone plz help.
Thanks alot
