Recent content by ducker

if you're updating a table with values from a form, wouldn't you want to run an update SQL statement to update that record in the table with the values in your form?? I'm not sure if you can do this with a macro.

does this happen when printing out to a different printer? or from a different PC? Sounds like a printer driver issue.

I'm still seeing this and I can't figure out why?? any other ideas?

yea something like that :)

couldn't you check to see if the field was empty and skip the horizontal line?

?? not .rtf or .txt, but .xls Note... it's just this one report on this one PC that I've been able to find this error on thus far. other XP machines it works ok. on the machine it's failing on I can sucessfuly export other reports... odd huh.

Running AC97 on WinXP. When I attempt to export the report to Excel 97, I get this error. I do not get this error when I attempt to export the same report on a PC running Win98. Nor do I get the error when I export in RTF, or Text. I'm searching the internet looking for a possible reason...

AWESOME! thanks a ton!

I'm running the following line: dbs.Execute ("DROP TABLE [tbl_No Certs]") the problem is that sometimes the table doesn't exist... Instead of trapping the error code, is there a way I can check to see if the table exists? If it doesn't I'll simply skip this step of my code and move on. Thanks!

if each of those months have the exact same type of data/information stored in them. I'd combine them in to one table and then have a crossreference table between your personel table and your "meetings" table.

actually: dim NPVarray() as double Woooo.... it worked :) Thanks all.

Ok. Tweeked the code with all the suggestions. And well, now I can't get it to compile :) COMPILE ERROR: Type mismatch:array or user-defined type expected. The error on the array part of the NPV function. If I manually set the variable NPVarray in the first DIM statement as an array of length...

either way will get it to loop. the problem is the NPV function itself is failing.

Actually, I don't believe it is. since the first value in the array for the NPV function is a negative number, followed by 45 payments. I actually want to run it to the 45th itteration. Yea, that was my mistake. I keep forgetting. I'll give this a try. I know what you mean. I get really...

Attempting to use NPV function in Access 97. I keep getting this error. Dispite the fact that I believe I'm using the function properly, as well as setting up the array correctly. pretty straight forward as far as I can tell. I keep getting a Subscript out of range on the NPV function...