Search results

Either create a hyperlink field in your table for the document path or place a label or text box on your form and set the hyperlink address.

You can use the recover design master function to make a replica the design master in the event of dm corruption/loss. If you want to test your changes copy the DM to a development computer. Use the Recover DM function so it becomes a DM and can be updated. In the event that your live DM is...

Use fe/be and replicate the b/e. Issue a new f/e when there have been changes.

Check the tab value, e.g. Dim PageNo as integer PageNo = me!myTab.value you may want to use it with the Tab Change event

I have found on occasion using 2k that a form can take an age to load. Through trial and error I discovered that if the form had a date field with the default value set to Date() it could take an age. Remove the default value and the response was instant. I can’t explain why because other forms...

A possible is, If you have moved or copied the DM to another folder it changes the status to replica. Try the Recover design Master option from the Tools menubar.

You have a front end database in which your forms, reports, queries etc. reside and a back end database holding your tables. Each PC including your laptops will have a copy of the front end. Your networked PCs, excluding the laptops, will link across your network to the tables on your back end...

In Access 2002 it's relatively easy. I've never succeeded in earlier versions. If you have 2002 look in help for the Printers Collection Keith

I think that you may have misunderstood the purpose of replication. It is the data that needs to be replicated so that it may be used on such as a laptop disconnected from its network, and when subsequently connect back to the network, synchronised with your network replica and design master to...

I should have finished the post ... to make the replica back to the DM

You can use the Recover Design Master option via Tools and Replication menu bar.

If you are referring to the control from within the Form try me("btnPost").visible = false

Hi Cassandra Each computer that syncs with another must have write permissions. If you can sync two, e.g. your network (I assume design master) and the laptop, but not your network an another, then it suggests to me that the permissions on the another computer will not allow it to be updated...

Try ebay.co.uk

Hi Cassandra My suspicion would be a network permissions problem. Check that you have write permissions to the appropriate folder on the server and vice versa.

Your thingking is correct. You can create a replica from another replica as long as it is a full, i.e. not a partial, replica. So create your replica and then make one of them the design master. If you need further help let me know. Hope this helps.

Public Function Find_This_File(ByVal strFileName As String) As Boolean On Error GoTo findErr Dim t_date t_date = FileDateTime(strFileName) Find_This_File = True findErrExit: Exit Function findErr: Find_This_File = False Resume findErrExit End Function...

In a similar situation I use error trapping, e.g. attempt to link all tables to the first BE. If it gives an error then link to the second BE. This approach has served me well with upto 4 BEs. Hope it helps.

To initiate the add-in package and deployment wizard for an mde, start access, alt+F11 to open the vb editor, alt+F11 to hide vb editor, open your mde whilst holding down the shift key, alt+F11 to open editor. Select wizard from add-ins.

Try www.mvps.org/access/bugs/bugs0010.htm or do a Google search on 'Can't open any more tables' which should point you to the Microsoft KB. Hope this helps.