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

    removing carriage return from records

    Hi I have an Access '97 table that has addresses of contacts. Some of the fields have been populated from the Form that is bound to this Table, with second and sometimes third lines of text. I need to export these addresses to a totally different application (probably via Excel) but this new...
  2. greenfibres

    removing carriage return from records

    Hi I have an Access '97 table that has addresses of contacts. Some of the fields have been populated from the Form that is bound to this Table, with second and sometimes third lines of text. I need to export these addresses to a totally different application (probably via Excel) but this new...
  3. greenfibres

    recording a last modified date/time for a form

    Hello all I have a table of contacts which I access through a form. I would like to keep a record of the last time any of the contacts fields (name, address, tel. no., email, etc.) were changed. (I only need 1 field to be changed for the last modified flag to be relevant) Any ideas? Thanks Jim
  4. greenfibres

    removing 'Mr' from cell containing 'Mr Robert'

    Hello I have an Access table with separate fields for Title Firstname and Surname. Unfortunately many of the Firstname cells include a Title, so the Title is empty and the Firstname reads Mr Robert and the Surname reads Burns. How can I remove the Mr from the Firstname and place it in the...
  5. greenfibres

    #Error in a field that then becomes inaccessible

    Hi everyone I am using an Access97 database. Somehow a memo field has the text "#Error" within it and is not editable - it always gives the message: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time The...
  6. greenfibres

    data FILTER rows AND columns

    Hi everyone The data FILTER function is so useful, I want to be able to filter BOTH rows AND columns...... is this possible? i.e i can set the data filter along the columns and then find specific rows that contain results i'm looking for.... but then i also want to data filter along the rows...
  7. greenfibres

    data sort rows AND columns

    Hi everyone The data sort function is so useful, I want to be able to sort BOTH rows AND columns...... is this possible? I have faith that someone has discovered the answer :-) All the best Jim
  8. greenfibres

    "exclude" query

    Hi all - hope you can help I have 2 tables table 1 = customers on this table is a 'firstcontact' field table 2 = orders on this table is a 'orderdate' field I am trying to find all customers who had first contact between 01/01/1997 and 31/12/1998 inclusive and who ONLY ordered since...

Part and Inventory Search

Back
Top