Adding numbers in sequence

[howlettb]

Hi ... I'm rather new at this, so please bear with me. I work for a non profit agency, and we offer a Representative Payee service (paying bills for those who can't handle their own money). I've created a database that keeps track of everyone's finances, and gives us all the reports we need. The only thing I have not been able to do is to actually print the checks. I have a report that pulls up the data (in check format ... including making $1.00 say one dollar and 00/100). But I'm stuck trying to give the checks a check number. I can't figure out how to pick a number to start with, and then add numbers sequentially. If you answer this, please be very specific. I've read through 100's of posts, and can't seem to figure out where I'm supposed to put what. Thank you in advance for your help!

[June7]

Generating custom unique identifier is a common topic. Latest I responded in:

https://www.accessforums.net/access/...lue-40205.html

https://www.accessforums.net/forms/a...oop-40386.html

[ssanfu]

What you are looking for is "Custom Autonumbers" or "Sequential numbers".
If you google either or both, you will find lots of examples.

If you answer this, please be very specific. I

Without knowing how your dB is structured, how your reports/check printer is designed or having your dB, it is very hard to be specific.
Mostly it is adding a table to keep track of the next check number and a little bit of code.

Here are a few links:

http://www.utteraccess.com/wiki/inde...tial_Numbering

http://www.techonthenet.com/access/m...ential_nbr.php

http://www.rogersaccesslibrary.com/forum/topic142.html

http://www.baldyweb.com/CustomAutonumber.htm

[howlettb]

I'm sorry ... but I'm still confused, and I actually think I might be missing a step. I have a menu page that has a field called "FirstCheckNumber" and a button that takes you to a CheckR Report. The CheckR Report comes from a query asking for any bills that have not been paid during a specified period of time. Before clicking the button to get this report, you must first enter the "FirstCheckNumber". My hope is that when the report opens, the "FirstCheckNumber" will start the sequencing of the check numbers. (I have a [check#] field in the report that I"m hoping it will populate. I guess my first question is should I be using a form instead of a report? Is it possible to do this in a report? Where do I put the coding? This is the last step I need to make this happen and I'm so close I can taste it ... just not there yet. Anything you can do to help would be greatly appreciated.

Hi ... I'm rather new at this, so please bear with me. I work for a non profit agency, and we offer a Representative Payee service (paying bills for those who can't handle their own money). I've created a database that keeps track of everyone's finances, and gives us all the reports we need. The only thing I have not been able to do is to actually print the checks. I have a report that pulls up the data (in check format ... including making $1.00 say one dollar and 00/100). But I'm stuck trying to give the checks a check number. I can't figure out how to pick a number to start with, and then add numbers sequentially. If you answer this, please be very specific. I've read through 100's of posts, and can't seem to figure out where I'm supposed to put what. Thank you in advance for your help!

[ssanfu]

There are many ways to number the checks.

You could have a button on the menu page that would have code to number the checks to be printed.
Then after the check numbers are entered, the print routine runs to print the checks.

You might be able to create a UDF to number the checks in the OnPage event (see Help) of the report.

It depends on how/when you want to number the checks.

[howlettb]

I'm still confused. I can get the next sequential number to pop into my form, but it then stays that next number for all of the records. It doesn't continue to increase. What am I doing wrong??

There are many ways to number the checks.

You could have a button on the menu page that would have code to number the checks to be printed.
Then after the check numbers are entered, the print routine runs to print the checks.

You might be able to create a UDF to number the checks in the OnPage event (see Help) of the report.

It depends on how/when you want to number the checks.

[June7]

Pops into your form into an unbound textbox? Then all records will display the same value.

When/how are these 'check' records generated?

The check numbers must be saved into a table somewhere.

Without familiarity with your data structure, can't be specific. If you want to provide db for analysis, follow instructions at bottom of my post.