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

    Problem using Totals function in a query

    Existing Table: Cross Cross Date # of Sale Sale Closed Spreads (1) (2) Adams 1/1/03 3 RREM DDA Adams 1/5/03 2 DDA Adams 1/6/03 2 Jones 1/1/03 1 RREM Jones 1/2/03 1 RREM DDA Jones 1/6/03 1...
  2. Cowboysooner

    Can a drop down menu limit options in next cell?

    I have a drop down menu with the following items: Drop down menu #1: Residential Real Estate Treasury Management Investments I would like Drop down menu #2 options to be limited. For example, drop #1 choice is Treasury Management, then drop #2 options are limited to Treasury...
  3. Cowboysooner

    Can Access 97 identify users & limit access

    Is it possible, when opening access 97 for the program to ask the user his name (or other identifier) and then auto populate fields with the user's info (for example division, location, name, address) [maybe using autoexec] while allowing the user to only look at data he has input? I don't need...
  4. Cowboysooner

    In Access 97can I combine three date fields into one field?

    My query calculates due dates and must use three fields due to the large size of the formulas. Consolidating the formulas to one or two fields results in a "too complex" error message. I would like to combine the results of the three fields into a single field. The formula output for...
  5. Cowboysooner

    How to calculate dates using info from columns

    The formula in the Date Next Due column causes syntax errors and does not work in Access 97. It works just fine in Excel 97. Please help. Required Last Date Document Frequency Received Audit Annually 12/31/01 Compilation...
  6. Cowboysooner

    IF statement problem in Excel 97

    Are the logical tests in excel 97 limited to numeric fields only? The following IF statements produce a FALSE result but field A4 does equal Audit and A5 does equal Compiled. 1 A B C D 2 Date Last Date Next 3 Document Frequency Received Due 4...
  7. Cowboysooner

    Can Access find and combine duplicate fields when one of the fileds co

    I have two tables. One with Company Name, Number of Employees and Address, the other with Company Name, Sales Size, Address and Phone Number. The tables are from different sources. Can I combine the records of these files based on a 70%-90% match of characters in the company name field? The...
  8. Cowboysooner

    Please Help, Read Only Problem in Access 2002

    This is very annoying. I have created numerous queries of an extremely large database but Access 2002 will not allow these queries to be exported to Excel or any other program. It says the database or object is read only; however, I am able to delete the queries which makes no sense if it is...
  9. Cowboysooner

    Deleting character types within a field

    I have a field containing alpha and numeric characters (street number and street name of a physical address). I have copied the field and now want to delete all alpha charaters in field one and all numeric in filed two so street number and street name are in separate fields (columns).
  10. Cowboysooner

    Read Only Problem in Access 2002

    I am no longer able to export queries to Excell. Each time I try I get a message saying the query is read only. The help link associated with the message is no help at all. I am using my home computer and I am the only user. I was halfway finished with a project when my queries magically became...
  11. Cowboysooner

    Transfer *.dat file to Microsoft Access 97

    How do I import or convert a 500 megabyte file with extension *.dat to Microsoft Access 97. Access says the file is an unrecognized database format. Excel, wordpad and notepad are able to read the file but it is much too large to fully open within these programs.

Part and Inventory Search

Back
Top