Search results for query: *

Synch more frequently. Use Replman.exe (Replication Manager provided with MOD) http://msdn.microsoft.com/library/default.asp?url=/archive/en-us/dnaraccgen/html/msdn_replicat.asp

Correcting the sequence of commands... DoCmd.RunSQL "SELECT * INTO tblTest FROM [Control Plan];" DoCmd.RunSQL "ALTER TABLE tblTest " & _ "ADD CONSTRAINT makePK PRIMARY KEY ProjectNo);" OR dbs.Execute "SELECT * INTO tblTest FROM [Control...

Using Access 2000, the following worked for me dbs.Execute "ALTER TABLE tblTest " & _ "ADD CONSTRAINT makePK PRIMARY KEY (ProjectNo)" DoCmd.RunSQL "ALTER TABLE tblTest " & _ "ADD CONSTRAINT makePK PRIMARY KEY...

TRANSFORM Max(tblTest.Result) AS MaxOfResult SELECT tblTest.Date FROM tblTest GROUP BY tblTest.Date PIVOT tblTest.Chemical; I used max here but use whichever aggregate Fn you need (perhaps Sum() or Last(), etc). If there is only one, Max works nicely.

Allow users to synch with the design master when they feel like it? Are you sure you want that? What if you are working on the design master doing testing of new functionality and such. Meanwhile, a user decides to activate the design master synch? Keep the design master out of the synch...

'Important: Differentiate between a form, a subform, and a subform control 'The first two are forms; the third is a control which is placed on a form and 'points to another form. 'frmSub is NOT necessarily the name of the source subform. Rather it is the name of 'the control I placed on my form...