Search results for query: *

Hi Skip Thanks for the quick reply - am I supposed to be holding Alt and F11 as I open the spreadsheet - in this case I get the properties window but it doesn't open the spreadsheet. Alt + F11 seems to have no effect once I am in and the form is being displayed. Thanks again Fiona

Hi there I've done something a bit silly. I am creating a spreadsheet for my users and open a switchboard form in the Auto Open event of the worksheet. The form has buttons to open other forms and close the spreadsheet as required. I have put in some code so the 'X' at the top right doesn't...

I have written VBA code in Access to create an email, with an attachment, and display it so the user can check, make final adjustments, then Send. However, I am having problems with the attachment. If I use olByValue, I get the following error message : ‘Unable to perform the operation...

Solved it - but thanks to anyone who was pondering on it. Instead of saving filters as queries, I wrote the filter (Me.Filter) away to a text field in a table. A description field, in the same table, holds the user entered description for the filter. These filters and descriptions are loaded...

Hi There I have a form with several text boxes and comboboxes. I want my users to be able to filter on any number of controls then save the filter, so it can be accessed and applied at a later date. I have done this by a button, labelled Save Filter which runs the following code : Private...

Thanks so much ! That sorts it.

I have written and support a database for a client which has a large number of lookup tables. These are linked in the relationships window to the master tables and Referntial Integrity is set for all relationships. The database is run on 2 separate sites, one of which can update the lookup...