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!

Recent content by Spicealdous

  1. Spicealdous

    Deleting Data

    Please help! Sorry if it is blindingly obvious! I have 2 tables, lets call them A and B. In table A there is a list of Names plus other fields of info. In table B there are another list of names and fields of info. I want a delete query to delete all names in table A that match the names in...
  2. Spicealdous

    Excel formula problem

    I apologise if this a very simple request! Let me set the scene: I have a range of 20 cells each containing various figures, these figures are entered into cells A1:A20. I want to do a countif formula that will count all the cells where the value is between 10 and 20 including 10 and 20. So...
  3. Spicealdous

    Can anyone help re adding a graphic to a form

    I would be extremely grateful if anyone can help!! I have created a database that is to be used in numerous areas by various teams. Therefore it needs to look professional i.e the company logo needs to be added to the forms. I have a jpeg image that i want to use on the forms that is about...
  4. Spicealdous

    Protection Problems!

    Thank You!
  5. Spicealdous

    Protection Problems!

    Can anybody help me! I have created a button on a form that carries out a function when selected. I want to know how to make this button prompt for a password before carrying out the function. Thanks!!
  6. Spicealdous

    Showing "no data" on a report

    Can anybody help me??? I would like a report to show the message "Nill Returns" when I run a report, instead of showing a blank page or a page full of "Errors" Any ideas as this is really bugging me!
  7. Spicealdous

    Access Form Backgrounds

    I have been asked to develop a set of databases to look more professional. To do this I need to change the background of the forms to business related or professional. Can anyone advise me where to look for these pictures?
  8. Spicealdous

    Unsolvable error message!

    I have created a database that is very straight forward and only has 1 table and about 5000 records. However when I try to export the results of a query into an excel spreadsheet via a macro the following message appears: "There isn't enough free memory to update the display. Close...
  9. Spicealdous

    Display a specified date range on a report

    I have set up a basic query in which I have a date field. In the criteria for this field I have stated "between [Enter start date] and [Enter end date]" in order to allow me to view any date range. Could anybody help me as I wish to display this range on a report.

Part and Inventory Search

Back
Top