Search results

- I have a form with five subforms, each with it's own table (recordsource). - Each subform is linked to the same Primary Key on the Parent. - The fields in the five subforms each have the default data value set to 0. My problem is that I would like each subform to save those zeros in...

I'm working with Access 2003, split database. I'm trying to apply a custom ReplicationConflictFunction as described in the VB Help file (and I've poured through many web pages looking for answers). I believe that I've done everything as specified. However, when I synchronize a replica via the...

I'm simply trying to select an item in a bound listbox. When I do this, the form locks up. I added a setfocus to an unbound button and that generated Reserved Error 2950. Stumped again. Dim lg As Long, lgIndex As Long, lgLastUser As Long With Me lgLastUser = Val(!LastUser.Caption)...

I have learned how to redirect FE table links from a Master to a Replicated DB (and back again as needed). Now I'm trying to find a way to detect whether the user is logged on to the server remotely via VPN (vs attached to the network locally) and then reLink accordingly. If the user is remote...

I'm simply trying to open a new instance of Access with the following code: Dim objAccess as object Dim stTarget as string stTarget = "<DB PATH>" Set objAccess = CreateObject("Access.Application") With objAccess .OpenCurrentDatabase stTarget .Visible = True...

I'm working with Access 2003. I've created a database which will help to maintain test equipment. I have a subform with recordset = 'Equipment' table. This table includes a binary field titled 'Export'. The purpose of that field is to allow users to select one or more records for 'export' to a...

Please bear with me, but this is a strange one: I've created a database which will help to maintain test equipment. I have a subform with recordset = 'Equipment' table. This table includes a binary field titled 'Export'. The purpose of that field is to allow users to select one or more...