I work for a major investment bank and we use DBArtisan on Sybase ASE to an extent.   It does the job very well but is one of the buggiest apps...

I definately agree with 2 monitors rather than one. 

I use 2x19's at work and I've got a single 32in at home.  I prefer the 2x19's anyday.

oooh my bad .   You're right   I obviously didn't read it closely enough

Ok - my bad - just noticed that my example using RoundUp function also rounds up anything

so in the function change it like the...

Hi,

Good suggestion however it'll round up anything using that method.. ie:

? ABS(INT(2.443 * -1))

 3

Hi,

Above solutions are ok but this one uses a windows API to properly sleep rather than steal system resources floating around doing 10,000 times around a loop

Just spotted a typo:

To call it from within a query just do FieldName: fRound([fieldyouwanttoroundup])  or from within VBA the usual way.

should've been:

To call it from within a query just do...

This functionality is built into Excel but not Access (which is where I assume you wish to use this).  However, using the magic of references we can still use everything...

I would say that mean's suited and booted imho.

ah good work mate.

Glad you solved it

I do agree with Mike C - there will always be more jobs available onshore compared to offshore.  We have recently taken a view that offshoring isn't working for our...

Hi macrocharlie,

Try the below

DoCmd.OutputTo acOutputStoredProcedure, strProcName, acFormatXLS, FilePath, False

Cheers

Carl.

found some information you probably didn't want to hear:

http://support.microsoft.com/default.aspx?scid=kb;en-us;313895

Trust M$ 

ahh - I'm not so sure about adp's. Thanks to my joys of tying Access to Sybase I'm forced to use mdb's with tons of VBA to make all my...

also as far as I'm aware - this cannot be set via code, you have to do it this way first and save your export spec