Search results for query: *

Wow Aivars that is some nice code. My problem is fixed - thanks all.

I am developing an Access application that utilizes the "Format" function here and there in VBA code. The code works perfectly on my machine. When I load the database on my co-workers machine, it fails on every instance of the Format function - error: Can't find project or library...

You can use the query method or still use the recordset method - your choice. To get an accurate record count from the recordset, use the .MoveLast method first. Then the recordcount property will be accurate.

I don't know of a way to do this directly from the table. Maybe someone else has already figured this out and can help. Exporting directly from tables is a lot less flexible than working in queries. I tried messing around a lot with the table field formats with no success before I moved to...

Are you exporting from a query window? Here is a sample statement I use a lot: Current Rate: Format([cur_rate],"0.000") This exports the field with three decimal places. Use "0.00" for two decimal places. I hope this helps.

PS - when you are calling the field from a variable, don't use any dots or bangs. Let me know if you'd like to see a code sample of how this works.

I had a few messy problems with this in the past. Try passing "FldName" as a field, not a string: ...FldName as Field I hope this helps.