sbaud2003's latest activity
-
Ssbaud2003 replied to the thread Finding missing No.Thanks to all for your advise
-
SJust write a quick VBA function to iterate the numbers and report the gaps. You shouldn't expect an intact sequence with an autonumber...
-
SPiling on a bit, I know. If gaps in a sequence of AutoNumbers is a problem, you've been doing it wrong. I love the analogy to teeth...
-
SA simple way to do it would be: Create a table with all the Id possibles (for example in Excel and attach that table) Create a query...
-
SAutonumber can easily be "missed", when a users enters a New record and start typing and eventually bail out and discontinue adding the...
-
SHere is some info about autonumbers from UtterAccess. What they are NOT: 1. Row (record) sequence numbers. 2. An "order of entry into...
-
Ssbaud2003 replied to the thread Finding missing No.yes
-
SI want to find all the missing IDs in a table starting from 1 to the end of the Table. How can i do that and display the missing IDs IDs...
-
Ssbaud2003 replied to the thread Change font colour in VB.THANK YOU SIR
-
SIn your vba code, the properties to set are [control].ForeColor - for the text in a text box, combo box, list box, or label - the...
-
Ssbaud2003 replied to the thread Change of a Text Box Color:-.Actully I want to mark absent with RED and Present with Blue. (TEXT) so pls help me how to do
-
SI guess you could also specify whether you want to change the background color or the text itself. Because, the first suggestion can do...
-
SHi Sir's Is there any method where a Text Box color can be changed. I.e if Present then BLUE and if Absent then RED
-
Ssbaud2003 replied to the thread Solved FINDING A RECORD FROM UNBOUND TEXT BOX.Yes sir, and its working fine thanks alot, There was a syntex error.
-
Ssbaud2003 reacted to arnelgp's post in the thread Solved FINDING A RECORD FROM UNBOUND TEXT BOX with
Like.
if AC_NO is Long Integer: If Not IsNull(Me![FINDAC]) Then Set rs = Me.RecordsetClone rs.FindFirst "[AC_NO] = " & Me![FINDAC] If Not...