Range Fields

[Muhammad Haris]

Hello ,

Can we create a table field like ranging from 1-500 will be known as the cheque book numbers of acc id = 1 .

In short words I mean like can i create range fields and update them when the cheque numbers of a particular account has been finished.

Any ideas,codes and sql synataxes or any logical explaination for this thing is requsted and appriciated.

Regards,
Muhammad Haris

[RobDog888]

You might want to give a little more info so we can help. What type of Grid control is this or is this Excel? If so what version? Doing this in Excel only or automating it from VB6?

[Muhammad Haris]

It isint a datagrid or an excel file , I have a field in the database known as cheque serials and i want to do make that field a range field, a range field as in like for an accno which is 1 (accno=1) the cheque serials issued were 1-500.

I wanted this application to work like if we withdraw a cheque ranging from 1-500 the account balance is deducted from the accno = 1 else it checks if 501-1000 is accno =2 then it deducts from the accbalance of accno =2

I hope you know how the bank withdraw,account balance and cheque book serials works in the bank.

Any big description/solutions/codes/methods regarding this would be appriciated.

Regards,
Muhammad Haris

[RobDog888]

So it sounds like you are using a Database then. Which one? You can create an auto incrementing field but the syntax/type differ depending on the db your using.

[Muhammad Haris]

I'm using MS Access 2003 , I understand the auto incrementing logic but How can i assign like 1-500 for one user but other user have 501-100 and then the third user is automatically got 1001-1500 and the 4th user got 1501-2000 but for example when 1-500 of the first user is finished it is assigned with 2001-2500.

Any logics/solutions/comments?

[RobDog888]

Its a design issue here then. You can not skip IDs but you can just use a numeric field and create the ID numbering yourself. Are you doing this all in Access with an Access form?

[Muhammad Haris]

No , I'm not making forms in ms access but I Have connected database with visual basic.Can you please make me a example of database and a example form in visual basic?

Please

[RobDog888]

Sure, checkout our ADO database turorial located here - http://www.vbforums.com/showthread.php?t=337051

[LeonX]

just keep the last serial issued, so when there is someone issued the check it will retrieve the last serial plus 499.

[LeonX]

use this field:
- unique id
- user id
- start serial
- last serial
- a flag: when the user had used the last serial set this flag