Search results

I guess I'm not "one" then. Unfortunately, I do need to export a report to Excel, per the requirements of the business I'm working with. It looks like it will be an ugly endeavor. My question remains... is there a way of doing this?

Hey a1computer, Are you saying you want to resize all the fields depending on the size of description, or figure out a way to keep the description from taking up rows? If it's the row issue, make the description field wider.

Hey dudes & dudesses, Do you know of any way to keep the Access report formatting when you analyze it with Excel? I have columns that are grouped together, and I'm curious as to whether you can keep them grouped and have a label and line over the proper columns in the exported Excel sheet. Any...

Yeah, I tried the font size thing. It's not me that wants this... they want to be able to limit how much information to display about each item in a big list of items. So if they decide to see all the data, that's all the columns. Well looks like I'll stick to the alternative. Thanks for helping!

Hey all, I am trying to make a form update a table over an ODBC driver on the fly. Once text in a text box changes, I need to stamp the time, date, security level, and username into some form fields, and they need to be saved under a specific record in the table. The problem is... this table...

Ah, thanks for the response. Do you know of any other way of solving my problem inside of Access (like using page breaks or new pages as report controls), or is there no way of getting around this limited width? I just discovered the acPageBreak and acPage CreateReportControl properties, but I'm...

Hello all, I'm trying to allow users to choose specific columns from a certain list of total possible columns. Once they click a button, it is supposed to dynamically generate a report based on the columns that they specified. Basically I'm using a buttload of VBA code in the background to...