Recent content by sullyscsu

The only reason why I suggested a temporary table is because I saw he had a SELECT INTO statement that I assume put the data in the Excel spreadsheet, so if that was the way he wanted to go he can accomplish it that way. Otherwise, yes, a query is probably the best way to go.

Probably an easier way of doing it is to put your data in a temporary table then use the TransferSpreadsheet method using the acExport argument then finally clearing your temporary table.

I would either a) put the popup form in Data Entry mode or b) create a Temp table and bind the popup form to that then put the form in Data Entry mode. If you go the Temp table route, make sure there is a way to append the record to your main table and delete the temporary record . Either way...

I solved this problem.. I ended up using a bunch of if's and else if's in VBA in the report's format event

huh???????????

would you mind giving me a snippett of what that function might look like? Thanks.

I am designing this report for work to determine whether or not the $ change for a particular project requires review by a higher authority or not. It is setup as follows: Project# | Proposed Change | Currently in Budget | Var. | Requires Review? all but the last column are pulled from the...