Recent content by Howie Jones

Just ran up an old copy of Access 97 and you're right, I couldn't find an option to 'compact on exit' either. As Access doesn't seem to support macro or VB compacting from within a database it looks like the only way you can do this is from the menus. For those interested I'll be putting a...

See the comment from Rich above, I think compact on exit is available in '97.

Interesting question. I've not had to think about this yet as the server I was planning to use, so all users accessed the one database, is completey unstable. They're currently using individual databases on their own machines and I collate the data once a week into a master database: there are...

Thanks for that reminder. I'd actually used this option on one database but not the other. I'm sure a nice lie-down in a darkened room will restore my sanity.

To keep users out of the menu system I'm trying to compact my database automatically on exit. This can be coded from within Access with 'DoCmd.RunCommand acCmdCompactDatabase'. But when the code runs I get an error message saying that this can't be done from within code and that I should use...

Thanks to all. I thought about doing it in code from within Access but decided to do it from Word as I thought there would be less hassle. I also think it may be because the query that the merge is based on asks for a parameter. However, I don't have any trouble running this mail-merge in...

When I use mail merge in Word XP/2002 it cannot see all of the tables and queries in my .mdb. None of the queries are hidden. When I update the database to Access XP/2002 I have the same problem. Has anyone got any ideas, or is this another 'undocumented design feature'? Regards Howie Jones

Yes, I think that might be a shorter method than the first one. HowieJ

Me again I have a situation where I run a query, carry out some editing on one of the fileds in the query and then run a report based on the query. No problems. I now need to add a critrion to one of the fields in the query to drill-down further. Again this is not a problem, but the report is...

Excellent, worked first time. Howie

Hi again I want to replicate the 'Filter by selection' menu functionality in VBA to filter to the current record only. DoCmd.ApplyFilter appears to only accept text as the = part of the argument. If I Dim and set a variable CurRec to = SCOFull (a serial number that is unique to a given...

Hi I've now tried DoCmd.RunCommand acCmdSpelling, and just as I thought, it wants to check the whole of the database not just the relevant field. There doesn't seem to be any way of getting hold of it and restriciting it to the current field. Any ideas? Howie

Rich No I haven't, I'll give it a try, but isn't that just a new way of using DoCmd.DoMenuItem ... ? HowieJ

I'm not great on VBA, but I'm pretty sure that your problem is the space: a bit like weblinks and Field names etc. Regards HowieJ

Has anyone got any suggestions as to how I can spell check a specific field using the on_exit event? I want this to be done automatically without user intervention. I know that I can use DoCmd.DoMenuItem ... , but this has no control and spell checks the whole of the record. Any advice or...