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 SkipVought 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. FACETS

    FILTER WHEN NO DATA IN SUB REPORT

    I have report with a subreport. How can I filter the pages that have no data in the subreport.
  2. FACETS

    TABLE WONT COMPACT / RECORD DELETED

    I have narrowed the problem down to 1 field in 1 table (a memo field). Now that I know this what can be done? I dont see anything wrong here........
  3. FACETS

    TABLE WONT COMPACT / RECORD DELETED

    Unfortunately not in this case but thanks anyway Jim
  4. FACETS

    TABLE WONT COMPACT / RECORD DELETED

    I have a single table that opens and seems fine but locks up during "compact and repair". When I try and import it into an other database it says "Record Deleted" and doesn't finish.
  5. FACETS

    COMPACT & REPAIR PROBLEM

    Decompiling only works for forms and reports, not on the tables...
  6. FACETS

    get started a (complicated) database

    There's a great book called "Database Design for Mere Mortals" on rational database design. This might be a good place to start. I can't figure why you would need so many tables to describe a single item. Use the "combo box wizard" to create a lookup For discount make a...
  7. FACETS

    Autonum Starting Point

    Create a temporary table with just one field, a Number field; set its FieldSize property to Long Integer and give it the same name as the AutoNumber field in the table whose value you want to change. In Datasheet view, enter a value in the Number field of the temporary table that is 1 less...
  8. FACETS

    Workgroup Information File

    yep this is how it works. the WIF is for any database for that PC profile. Limitations are put on an individual by the "ADMIN" of that database seting the restrictions in "USER AND GROUP PERMISSIONS"
  9. FACETS

    Date/Time stamp in Table design accepts 3 digit year

    I haven't looked into that but you might want to set the input mask so that a 3 digit date can't be entered at all
  10. FACETS

    Emulating Autonumber

    Create a temporary table with just one field, a Number field; set its FieldSize property to Long Integer and give it the same name as the AutoNumber field in the table whose value you want to change. In Datasheet view, enter a value in the Number field of the temporary table that is 1 less than...
  11. FACETS

    Database Creation

    you'll really have to supply a bit more info than that to get an answer!
  12. FACETS

    COMPACT & REPAIR PROBLEM

    I have a database(backend) that hasn't been compacted and repaired in over a year. When I try and do it now it seems like it gets half way (status bars) and freezes. I've let it run for close to a 24 hr period so I don't think that its a time issue. Other than that the DB works just fine. Is...

Part and Inventory Search

Back
Top