New Entries Added Almost Daily!
Click here to get on our Mailing List

ReplicationID

Using the ReplicationID Function

In this tutorial you will learn how to use the ReplicationID.

Create | Table Design

Add an ID Field, choose 'AutoNumber' then change the Field Size to "Replication ID".

Add some sample data.

If you try to MsgBox the ID it'll show "???"

	Private Sub Command1_Click()
		MsgBox ID
	End Sub
	

Therefore you need to use a Function to get this ID.

There are two available when working with GUIDs: StringFromGUID and GUIDFromString.

Add this to a Button event:

	Private Sub Command1_Click()
		MsgBox StringFromGUID(ID)
	End Sub
	

Want to learn more? Request this via the contact form.

Access Beginner 3

You can find more about this by searching the website.

By: Alex Hedley

Click here to sign up for more FREE tips