Replace null value (1 Viewer)

shawnntjr

Registered User.
Local time
Today, 00:51
Joined
Oct 28, 2014
Messages
42
Hi all,

Is there a code that will replace the empty fields by shifting the bottom fields up for access? I am planning to write a code that will delete unnecessary items in my database, however, that will cause the database to have "holes" in it.
 

smig

Registered User.
Local time
Today, 09:51
Joined
Nov 25, 2009
Messages
2,209
What do you mean by "holes" exactly ?
Make sure you dont confuse fields with records.
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 07:51
Joined
Sep 12, 2006
Messages
15,614
if you are referring to gaps in an autonumber sequence .... then there are loads of tips about what an autonumber is and isn't - the main thing being that it will not guarantee an intact sequence.
 

smig

Registered User.
Local time
Today, 09:51
Joined
Nov 25, 2009
Messages
2,209
with AutoNumber if add a record and delete it, even if it was the last record the AutoNumber won't get this number again.
 

Users who are viewing this thread

Top Bottom