shamas21
06-13-2008, 11:03 AM
Hi All
Im new to Access, but can someone drive me into the right direction on how to let multiple users access the simple database i have created. The database is nothing special, but needs to be accessed by people in Edinburgh and London.
Is there a way to do this?
Many thanks
boblarson
06-13-2008, 11:49 AM
Perhaps this will provide some good info:
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html
shamas21
06-13-2008, 12:08 PM
Perhaps this will provide some good info:
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html
Thanks Bob.
I need you expertise for something else, I have a list box with in a form that Allows users to Add and Delete data from it.
I have no trouble Adding to it but i cant seem to get around the deleting part. I have the following code, it executes fine except when a user select multiple rows from the Listbox, then an error occurs
Private Sub btnRemove_Click()
With Listbox1
For i = 0 To .ItemsSelected.Count - 1
.RemoveItem (.ItemsSelected(i))
Next
End With
End Sub
This instructs VBA to remove items depending on how many items were selected. However, there occurs in the .RemoveItem (.ItemsSelected(i)) part as VBA doesnt recognise any rows highlighted after the first removal beacuse after the first row is removed then Access de-selects the rest of the previously highlighted rows, so VBA thinks there was only one row selected.
Is there a way aroudn this ? Any help is greatly appreciated.