Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jeffman38
-
Finding the row number for the last line of data
Dim Intmax as Integer 'Find Last Numerical Row in a Table and Return to Variable 'Object_Id = Column Name 'Object = Table Name intMax = DMax("Object_ID", "Object") Hope This helps Dave- jeffman38
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA CODE FOR ACCESS
Updating Table with Query? ****ERROR: DATA TYPE ERROR IN CRITERIA EXPRESSION**** Can anyone tell me what is wrong with the code below ? OBJECT = TABLE Object_Description = Field I want to add from text box Object_Id = Primary Key determined by a variable CODE...- jeffman38
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Empty, Nothing, Null, IsEmpty, IsNull, IsMissing, Optional
I wondered this myself and found reference at: http://www.subzero-solutions.com/DevCorner/DC008.htm TEXT BELOW >>> HOPE IT HELPS. DON'T CONFUSE NULL, NOTHING, "", EMPTY, AND ZERO. There are many ways in VB to say that something is "nil," a term I'm going to use temporarily...- jeffman38
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
