Search results
-
M
Auto populate increment value in textbox.
It's basic stuff. I just need autofill on a textbox that says "Appointment Number". The number of records are affected by the StudentID. Which means if you type in say 00000001 you will be able to see say 3 records on the Appointment table that is linked to the same ID. Record 1 should show "1"... -
M
Auto populate increment value in textbox.
Hi again I manage to get the auto number working with a query built. Thanks for the guidance ! But here is the second part of my nutty idea. The subform that the auto-filled text box resides in is linked to a main form which basically splits the data appearing in the subform according to the... -
M
Auto populate increment value in textbox.
Hello vbaInet Firstly thanks for posting the links ! I am learning from the links... Secondly I apologise if I come across as a kid who needs his hands held all the time but I am trying my best to understand this. I have incorporated the code on the first link which looks like it would work... -
M
Auto populate increment value in textbox.
Hi guys Just a quick questions guys, I want to populate a textbox (txtA) in a subform with an increment of numbers starting from "1". 2 concerns; I don't want txtA to be filled in the unless other textboxes are filled in (can I make the code sorta like a dependant to these textboxes ?)... -
M
Run-time error 2501
Hi guys I have implemented this code into a button on my form to invoke the action of print preview of a report based on an ID query. It works fine when the user inputs an ID into the field. But when the user clicks on the cancel button or the X button, a runtime error happens. The error is... -
M
Hi there Thank you so much for your help ! It is much appreciated.
Hi there Thank you so much for your help ! It is much appreciated.- mCool
- Profile post
-
M
Validation Rule in Form
I found the answer. The reason it did not show what I wanted was because I did not populate the subform's table with different data. I have a r/ship btw the main form and the subform's table so it was all sorted automatically ! Thank you all so much for you time and advices !!! -
M
Validation Rule in Form
Hi guys I am new to Access 2003 and I was trying to populate data onto a subform with a condition. The condition is that the data that is populated is limited to the same ID number as the ID number on the main form. Can I do that via each textbox's validation rule or is there a simpler way ?