How to ADD integer (vba)

**RuralGuy** · 03-07-2010, 05:18 PM

Paul,
Read my post #9.

**pbaldy** · 03-07-2010, 10:46 PM

I'm with you Allan. A textbox on a report is read-only, to the best of my knowledge. I mean, the textbox can "remember" a value, presuming that value comes from a table, but you couldn't increment it on the report.

**Computer202** · 03-08-2010, 10:24 AM

Originally Posted by pbaldy

I'm with you Allan. A textbox on a report is read-only, to the best of my knowledge. I mean, the textbox can "remember" a value, presuming that value comes from a table, but you couldn't increment it on the report.

So its not possibly? Right well thanks for the help, the work around appears to be to simply print a copy of each

**RuralGuy** · 03-08-2010, 10:35 AM

Why do you want this incrementing number on your report? Is it to make each report unique? Maybe we could come up with a suggestion or two if you would share with us the WHY.

**Computer202** · 03-09-2010, 10:26 AM

Basically its a Games database...

The idea is that a certain number of games are added to a table, They are then added up in this report, I wanted it to number this report 1... Then I can save it as PDF...

Then the records in the table are deleted and another report is created... This number needs to be different so if it added 1 every time it opened that would have worked

So yeah a unique number...

We could also just manually save each one as different name incrementing, But the idea of this database is to save time :P

Thanks

**RuralGuy** · 03-09-2010, 10:35 AM

I would use a separate table and a UDF to both return the number and increment it for the next time.

**Computer202** · 03-10-2010, 12:39 PM

Originally Posted by RuralGuy

I would use a separate table and a UDF to both return the number and increment it for the next time.

UDF? I am not that well trained in access :P

**RuralGuy** · 03-10-2010, 01:47 PM

UDF = User Defined Function; usually in a standard module rather than a class module for a form.

**Computer202** · 03-13-2010, 08:46 AM

Originally Posted by RuralGuy

UDF = User Defined Function; usually in a standard module rather than a class module for a form.

Thanks I will look into that on a side note but its fine for now thanks to the saving as PDF... Thanks for the help...

**RuralGuy** · 03-13-2010, 08:50 AM

You are certainly welcome. Glad we could help.

How to ADD integer (vba)

Thread Tools

Similar Threads

Make Long Integer Field Size show 2.5 Billion

Text field max number as integer in sql query of MS Access

Need to round the decimal portion on a field not the integer

Posting Permissions