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!

Register Log in
  • Congratulations dencom 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. realtallgal

    search key was not found in any record - importing excel table into access

    I am trying to import a xls sheet into a new table in current ACCESS database. I am using the wizard am getting the error " the search key ws not found in any record". File was not imported. I went through my file and included a key identifier...do not know why it won't import. please advise
  2. realtallgal

    EXCEL Formulat question

    I have a column of numbers, from 1-5, and the rest are blank. I want to make all of the blanks N/A, the formula I have been struggling with is not working (have a feeling I am over thinking this).. I want to leave the 1-3 as they are but change the blanks to NA =IF(OR(Q3="1",Q3 ="2",Q3...
  3. realtallgal

    Forms and fields that are blank

    I built a form for 154 records, but I don't want the form to displace a field if the results are blank. FOr example,years 2000-2010, I have one customer that has data for all, but another that only has data for 2000-2005, I don't want that record to show 2006-2010 field names when the data would...
  4. realtallgal

    Exporting Access Form to PDF

    I am in Acces, right clicking to export to PDF, but it won't allow me to export, it wants to print only. Is there a setting in Access that needs to be set so it will allow me to convert to PDF but not print? When I hit export, PDF.. I get the err This document was preivuosly formatted for the...
  5. realtallgal

    Table size

    How do I see what the size of each of my tables in a Access 2007 database?
  6. realtallgal

    Access Database - Read Only

    For some reason my database on the LAN keeps reverting to read only.. I will be in it one minute, close it, then go back into it and it says that it is READ ONLY.. is there a feature that i have on that I don't realize that is causing this? Please advise.
  7. realtallgal

    Date Stamp

    Within a form, I have a field for updates, once the user puts their update in ( or right before) I want Access to auto generate a date stamp. How do I do this?
  8. realtallgal

    Can't Save Main Switchboard

    I am trying to make changes to my switchboard, but when I try to close it asks me if I want to save, I say yes, but then it doen't close, nor does it close.
  9. realtallgal

    Required fields

    How do I write a validation that says "If the status = "completed", then the completed date must be populated"? Thanks diana
  10. realtallgal

    Auto Number help

    I using autonumber, but it is starting at 6299978, rather than 1. It is the first record in my database. Why is it doing this?

Part and Inventory Search

Back
Top