Search results

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...

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

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...

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...

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...