Search results

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...

So no other ideas? Well, we ended up simply formating the HD and installing win2k. that seemed to of cleared up the PC's issue. If anyone has any other less dramatic solutions, I'd love to hear! thanks! -Mike

Yep. was already applied to the system before this started occuring. Atempted to patch it again, incase something was corrupted/overwritten.

I have one PC running win98,acc97 and Access is CRAWLING. I'm seeing this on ONLY this one PC, and in multiple databases. Any ideas? Possible places to look to fix this? I've tried reinstalling Office, I'd rather not have to rebuild this pc. Thanks, -Mike

After continueing my discussion with my friend it seems as though I have slightly misrepresented the situation. In the case... there is never more then 4 ingredients. In addition those 4 columns of the table are indexed and stored in to memory, thus giving him faster access to the record...

I'm not sure if this plays in to effect here, but does it matter that this example isn't to be done in access, but in mysql, accessing it through a php script? The php script will essentially be building the form (part of the html page) as it runs. So in effect the amount of modifications one...