Recent content by ilikemyfto

Fix Ok now - used Seltop to find the row then add selheight for selection in new query.

I have a form in datasheet mode with several rows highlighted, is there a way of creating a new query showing the selected rows on the form datasheet?

:confused: I have a report form with about 8 sub reports embedded, all with Can-Grow set to yes. Everytime it prints my testdata on of the subreports stats to print at the bottom of the page, only there is not quite enough room and although the subreport heading prints ok the 1st record gets...

Does anyone know a way to recover from "Ms Access.exe has generated errors. I know why I get the error, it's when I create a local table on the first load of a replica and I can't think of another way to program it without running into other difficulites later down the track. So if there was a...

Update to previous statement:- It's now intermittant, sometimes it fails others it's ok.

Fix (I Hope!) When all else fails – “Read the manual” From the Access 97 Developer’s Handbook by Paul Litwin, Ken Getz & Mike Gilbert Found a section on replication referencing setting the local / replicable property for objects. Sorry but the text rather left me cold but wondered if by...

I get this error the first time the replica is used. If I load up the replica a second and subsequent time it's fine and the tables are created as local. I am sure it worked ok when I first added the code but that was several iterations ago. I have even tried unreplicating the Design Master to...

Try using Help About. It should give the the version and Service Pack Details.

This is driving me bonkers. I have a replicated database and when I create a replica from the Design Master I get a message saying Msaccess.exe has generated errors... when I open the replica, but only on the first load. I have traced it to a point where I create a local table with the...

I think I have managed to resolve my own problem. My home PC is at Access SR-1 and the Work PC is at SR-2. It looks like I will need to unreplicate the replica while at SR-1 and then remake when I upgrade to SR-2. :D

On loading a 97 replicated database (Replicated by DAO) I get the following message on my works PC:- "This member of the replica set has exceeded the maximum number of days allowed between synchronizations and can't be synchronized with any other member of the replica set." I know that DAO...