Lebans Holdings 1999 Ltd.

 Home ] Up ] Feedback ] Contents ] Search ] What's New ] Files & Tips ] 

RowNumber
Home
Up
HScroller
RowNumber
CustomScrollBar
MemViewer
EnumFonts
FontColorDialog
OLEtoDisk
CommandBars
WindowToBitmap
ListTablesInMDB
PrintFailures
Utilities
CallBackBrowser
Image FAQ
SaveRelationshipView
AddSQLComments

RETIRED! September 2009

I have officially retired from all things Access. Please do not send Email requesting support as I will not respond.

 

Keep all of your questions to the Newsgroups where everyone will benefit!

 

 

Rownumber.zip is a database containing functions for the automatic row numbering of Forms, SubForms and Queries.

Updated Oct. 13 by Allen Browne. Includes error handling and cleaned code.

 

Here's an update to the Serialize function by Peter Schroeder:

Good to hear. FWIW, here's the version I came up with today, based off of your code and Ken's(Getz) suggestion, with a few changes:

Function Serialize(qryname As String, keyname As String, keyvalue) As Long

Dim rs As Recordset

On Error GoTo Err_Serialize

Set rs = CurrentDb.OpenRecordset(qryname, dbOpenDynaset, dbReadOnly)

rs.FindFirst Application.BuildCriteria(keyname, rs.Fields(keyname).Type, keyvalue)

Serialize = Nz(rs.AbsolutePosition, -1) + 1

Err_Serialize:

rs.Close

Set rs = Nothing

End Function

Peter Schroeder

 
 

May 23, 2004 Product Update
 
 
Rich Text ActiveX control. Version 1.8

Click Here!

 

Mar 15, 2005 Product Update
 
MouseHook  Replaces the MouseWheel DLL subclassing solution. Turns On/Off the MouseWheel with one line of code. No DLL registration required. Now supports Logitech mice!

Click Here! 

 

 

 
Back ] Home ] Up ] Next ] 
Stephen Lebans Copyright 2009

Last Modified : 09/11/09 12:03 AM