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 Mike Lewis 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: *

  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