Recent content by Radioactiveduck

I am using Access and Excel 2003, as a matter of fact. And that solution worked. I wrote a function that broke the field down into text strings of 900 characters or less and concatenated them into a variable. Then setting the excel cell equal to the string variable did the trick. For anyone...

The excel file is being created from scratch within VBA, so I don't see how any of the excel columns could be limited by data validation. Could you be more specific?

Alright, so I have a form with a group of combo boxes. Each one of these combo boxes allows the user to select a field from the table "Customers" that they want exported to excel. When they hit the "Export to Excel" button, the export code executes. This normally works fine, with the...

Ah, I see now. That is, in regard to the control index. I've changed the form to use a set number of combo boxes, but I'm sure it'll come in handy in the future anyway. Thanks.

I have, and I may use it if the combo boxes prove to be too difficult to work with, but there are two virtues of the combo boxes that I'd prefer to keep: 1: The user can view all of the columns they've already selected without having to scroll through the list to see what they've highlighted...

Ah, I wasn't aware that deleting controls wouldn't avoid a control limit. I may have to find another way to write this then. But essentially, the goal of this code is to allow the user to conveniently export any variable combination of fields from their "Customers" table to either Microsoft...

Alright, so I have two forms in my access database, WIP and Exports. The WIP form has a button cmd_ExcelExport and a textbox txt_ColNum, which is validated to be a number greater than zero. When the user pushes the cmd_ExcelExport button, I intend for Access to open the Exports form and a...

Sweet, thanks! That fixed it.

I have a form with the following fields and data types: Date: text in "mmm dd, yyyy" format JAF: checkbox EFS: checkbox txt_ChAttn: textbox, generic format Note: textbox, generic format Basically, I've written code that does an AfterUpdate whenever JAF or EFS are checked or unchecked. It...