Search results

Hi, can anyone tell me why the following doesn't work? Private Sub cmdOpenFile_Click() On Error GoTo Err_cmdOpenFile_Click Dim stAppName Dim docType As Integer Dim ext As String docType = DLookup("documentType", "tblDocuments", "documentID = '" & Me.documentID.Value &...

Hiya, Working in Access 2000 to an MS-SQL 2000 server, and having created the ADE file and put it on the fileserver, it opens as read only, so it is impossible to add or modify data (somewhat defeating the object of a database, you might say) I have tried copying the ADE down to local machines...

Hi, This was asked once three years ago, and no-one replied...... Having got my database somewhere near where I want it, I decided to test the client / server setup. So, I went to create an ADE file. But the dialog threw back an error that simply said "Access was unable to create a .ade...

I am having major trouble with a simple date, and it's driving me insane. I am working on a database to store user, asset, software and license info for an IT company. There is a requirement for a table to record every transaction, an audit trail in effect. I am working in an Access 2000 adp...