Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: fiona108
  • Content: Threads
  • Order by date
  1. fiona108

    How to Prevent Excel Running a Form on Auto Open

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

    Adding Outlook Attachment olByValue olByReference Problem

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

    Save and Apply Filter Problem with Comboboxes keyed on ID field

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

    Updating lookup tables which are linked in the relationship window

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

Part and Inventory Search

Back
Top