Hi guys,

         I want to set u a field to generate auto bill number..
 like..## IND/25/07 ### ..I dont know how to start with..

 please give me an solution ..



Learn as you can..
------------------------
pap...

It sounds like you are building a string from elements on the form. If this is the case, on the form's Before Insert event, add the code to build the string and put it into the Bill Number text box (should not be editable.)

Did that help? If not, where are you getting these elements:

IND
25
07?

Sounds like a day and year, and some other element.



mmcdonal

mc,

 like an billing software ,generate bill number automatically ..i want to generate gatepass number automatically ..

 did you got the idea..

 please revert me .!


Learn as you can..
------------------------
pap...

I know exactly what you want to do. The issue is, where are you getting the elements?

I see that of "IND/25/07", 25 and 07 probably come from the current date. Where does the IND come from? Without knowing that, here is some code:

On the Before Insert event of the form:
(Assuming field [IND] and field [BillNumber])
(Assuming field [BillNumber] is locked and disabled)

Dim sBillNo As String
Dim sIND As String

If IsNull(Me.IND) Or Me.IND = "" Then
   MsgBox "Please enter that field value."
   Exit Sub
Else
   sIND = Me.IND
End If

sBillNo = sIND & "/" & DatePart("d", Date) & "/" & DatePart("m", Date)

If IsNull(Me.BillNumber) Or Me.BillNumber = "" Then
   Me.BillNumber = sBillNo
Else
   MsgBox "There is already a Bill Number for this record."
End If

This will automatically create the Bill Number. However, there may be some issues with when the user sees it.

Did that help any? Do a search of Microsoft for "regular expressions".


mmcdonal

ind is an example value its not in the database..

ok i ill explain in detail ..

the text box name txt_passno
the Gatepass no. is like ARIS/01/05/07

 in this ARIS is an constant text come for every gate pass number and 01 is the gate pass number and 05 is the month and 07 is the year ok . Each time when iam adding the record for gate pass the ARIS will be remains same the gatepass number should increases and the month and year should change according to the system month and year...

did u got the idea what i really need ..

thanks a lot for ur attention .

anukagni

Learn as you can..
------------------------
pap...