How to ADD integer (vba)

**Computer202** · 03-06-2010, 10:45 AM

Is there a bit of code I can add to a report LoadEvent which simple adds 1 to my text box "Text33".

Every time the report is opened I want that number in the text box to increase by 1

Creating a unique number every time

Starting value: 1

Dan

**pbaldy** · 03-06-2010, 01:18 PM

You realize the textbox would have to be bound to a table to save the value? I assume you mean a textbox on a form:

Forms!FormName.Text33 = Forms!FormName.Text33 + 1

**Computer202** · 03-07-2010, 06:39 AM

Cheers for the reply, Had a late night/morning :P

I didn't know they needed to be bound so I am trying to bound it...

The problem being this number is not related to anything! I simply want it to count up :P How do I set that up and make sure it is bound?

**RuralGuy** · 03-07-2010, 08:46 AM

Why not create a System Table for just such values?

**Computer202** · 03-07-2010, 10:28 AM

well I have tried a normal table with one field (No primary key)
and i have tried a normal table with 2 fields (one being a primary key)

I am confused as to what you mean? Could you please expand (I am a novice)

Thanks

**RuralGuy** · 03-07-2010, 11:00 AM

The first table should work just fine. It will only have one record. Set it as the RecordSource of your form.

**Computer202** · 03-07-2010, 11:09 AM

I have just tried setting the table as the source for the report but none of the other data works after lol... I have set up a query which combines the two but for some reason this does not show any data in the box :P

**Computer202** · 03-07-2010, 11:12 AM

Just a reminder I am in a report, not a form, This report was based on the table, now its based on the query :P

**RuralGuy** · 03-07-2010, 11:27 AM

You want a TextBox on a *Report* to remember what number it contains when you run the report again? I doubt you will get there, sorry.

**Computer202** · 03-07-2010, 11:29 AM

Kinda of yes. I don't mind making a table for it I just don't know how? I have tried linking it but no luck and the load up code doesn't seem to work for reports

**RuralGuy** · 03-07-2010, 11:32 AM

Maybe Paul (pbaldy) will have some ideas for you.

**Computer202** · 03-07-2010, 11:36 AM

right thanks, I will drop him a line

**RuralGuy** · 03-07-2010, 11:39 AM

Paul is subscribed to this thread so he sees what we have been talking about. Nothing else is needed to let him know.

**Computer202** · 03-07-2010, 11:41 AM

damn too late :| I am soooo impatient!

**pbaldy** · 03-07-2010, 03:16 PM

I assume since the thread is marked solved that you sorted it out?

How to ADD integer (vba)

Thread Tools

How to ADD integer (vba)

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