Recent content by Craig_Withers

I've written a database for a handful of users in my office, split it and compiled the mde, which they are using fine with no problems *touches wood* so far. This is the first time I've compiled a database into an mde, and I've just noticed that if you hold down Shift when opening the mde, it...

Thanks for the help, but I can't seem to get it to work... The text box on the subform which holds the info I want is called 'SumOfContribAmount', the text box on the main form I want to pass this info to is called txtPreTotal. In the Current event of the subform, I've put the following...

I've got a rather complicated problem with Access 97 here, at least it seems cpmplicated to me! The main form on my database, called frmMain has a subform on it (running from a query) which lists payments or contributions made, I've got that working fine so that the payments shown on the...

I wouldn't mind seeing this myself actually, it sounds pretty interesting.

I hadn't actually re-enabled the system messages, thanks for pointing that out. The performance isn't a problem at all, it's only shifting70-odd records out of a couple hundred, so it doesn't clunk at all. Like I said, I'm just being picky.

Well, I thought there might be some way of doing it through SQL or VBA, some really obvious way that I was missing altogether. I'm just being picky, I know...

I've just written an Append query to copy data from a live table into an archive table, and a Delete query to remove the data from the live table. I've also written a macro that runs when the database switchboard opens, that disables the system messages, then runs the append query, then runs the...