Add records to a recordset

[jmar93]

Change made no difference.

[dsatino]

Could have. You can't add a number to a Null. Before the change, you weren't moving any data to rsDest.Fields(" TotalSF") so it would be null. Now, there should be data in the TotalSF field of your schedule table, but if there is an empty value in one of the records, you'll get the same error.

There are lots of ways to deal with that via code, but you're probably better off setting the default value in the table to 0 so you don't have to worry about it.

[jmar93]

There was a null value in the source table, once I removed it everything works great. Thank you so much for all of your help, it was huge.

thanks again,
Jeff

[jmar93]

Hi,

One last question, what is the easiest way to replace the 10000 in the following line:

Do Until x > 10000

with a number that you enter at run-time?

thanks,
Jeff

[jmar93]

Forget it, figured it out.

thanks,
Jeff

[NeoPa]

Jeff,

Please note all the times people have had to tidy up after you adding the code tags that are required when posting code. Please ensure this never happens again, or we will issue an official site warning which could lead to a suspension of your account on further transgressions.

-Administrator.