Recent content by innocent_smoothie

I'll give that a try and I'll post again. But I think it might make the compacting take longer, because when you do the delete query it doesn't shrink the file, so you end up with lots of empty space. I thought that the make-table route might stop that from happening

Thanks Bob for your late-night reply to my early morning question :) Currently the whole of this database is on the user local machine. The only contact with the server is when the SQL tables in the external database are accessed via the ODBC routines

Access 2000 I have produced a database which provides management reports for a sales operation. It involves about 8 make-table queries, then ends up with a report which is lnked to a select query. Note: the first 3 queries retrieve data via ODBC from an external data source which is a much...

wow! result! :):):):):):):):):):) Thank you so much. By the way, I notice this works with Access 2003, but in Access 2000 you get the message "Undefined function 'Replace' in expression" so I guess it was a new feature in 2003

Thanks for the reply I am familiar with update queries, but can't work out how to build a replace() functon into one. Do I need to use sql code?

In my macro, I want to open a table ("Products") search through a field ("ProductCode"), find a text character ("%") and replace it with a blank Can this be done ?