AccessDiscussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
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:
Sounds like a day and year, and some other element.
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 .
Learn as you can..