Hi, I am working on my project and your HELP guys is really appreciated. I have a STUDENT NUMBER textbox, and what I want is when the form is open, IT WILL AUTOMATICALLY ASSIGN student number so that the registrar will not bother anymore to encode the student number...Is this possible?...Thanks
If you want the app to start with a new student by default then yes, but I'd have a "NEW STUDENT" button and put the code there. If NEW STUDENT displays a new form then you can put it in that form load event handler.
I would suggest you to use ADODB data control. Its more faster and prefect. anyway if you want to go with dao then here it is:
make a new data control for counting your records. put this query in your data controls "recordsource" property box
@Jim: SELECT COUNT() is counting the total records in the table while SELECT Max(StudentNo) is getting the maximum value in the field "StudentNo" What If he use ST01-ST02-ST03 like this. then your query doesn't work.that's why i suggested to use count().
@NewCoder: I don't know about your other controls. If you want any suggestion from us. Just post the part of your code with a screenshot if there is any error coming up. We'll try to figure it out ! But firstly you have to try it urself. Surf google, you will find lots of examples and codes there.
Are you using a running number (Such as Sequence Number) on the table to saving records? If so how do you do it?If you are using the Autonumber, it will give problems when you happened to Delete records on the said table.
Yes, its a running number starts at 2014-001
What I want to happen is that everytime I open the form that contains the student number field, it will automatically start at the next availble number...I didnt use the AUTONUMBER IN ACCESS..TNX
In that case you can't use my suggestion because StudentNo is not actually a number. Using the format ####-## you'd have to store it as a string rather than a number. Are there any special rules to be used in generating the number? For example, are the first four digits supposed to be the year that the student was registered or is it just a coincidence that it happens to be 2014 in your example? If it is the year, what do you do when you have more than 999 students register in a given year?
Hi I'm having a problem implementing a mini shopping cart drop down in the header to show the user all the products they have in their shopping cart. It seems the only solution for this is Ajax, and I've looked all over and can't find anything that I could possibly ...
Help! I want to create a java program that finds the highest even integer among the values entered by the user. Stop asking values when a value less than 1 have been entered. If no even integer is entered, display "No Even Integer"