Recent content by yahazim

  1. Y

    Import whole lotta MS Word 2000 docs into Database

    OK. Thank you in advance for product suggestions, methods, ideas, etc. Real concrete working info of course would be the best. ---- I'm on a solution development team. We've captured many development documents based on single form templates, so they all look the same. I am wanting to...
  2. Y

    Help with Access -> Word Mail Merge

    Hello! I am doing my best to develop a database that automates the generation of a series of Test Cases using the Mail Merge feature of Microsoft Word to import information from an Access Database. I can get all the fields to fill out correctly from EXCEPT for the fields that are Many to One...
  3. Y

    Listbox Word Wrap

    I've searched all over for just a simple answer. Is it possible to have a Listbox wordwrap when there are multiple large entries in that listbox? THANKS.
  4. Y

    Filter Weekend and Evening Hours

    Travis -- that's it. Thanks for showing me the logic. I can figure it out from here. Jim
  5. Y

    Filter Weekend and Evening Hours

    Also -- what if the status spans multiple days? through a weekend? how would the calculation look logically then?
  6. Y

    Filter Weekend and Evening Hours

    This makes sense, I'm not quite sure how to do this in code. Do you have an example? Jim
  7. Y

    Filter Weekend and Evening Hours

    Allright. I have an Access frontend that is tracking Queues and Statuses of a specific process. When a Queue or Status changes, a timestamp is taken at the end of the old status, and the beginning of the new. I want to be able to track the number of hours something stays in that Status...
  8. Y

    Parameter to Listbox populated with Sproc

    Hello! I just created an Access .mdb to an .adp because my deployment method just changed today. I am recreating the RowSource of a Listbox to a Stored Procedure with one input parameter, called @VendorID, based on a field in the main form. The real world example is that I have a form that...
  9. Y

    Categories & Subcategories

    OK. I looked throughout the board, and I tried the Microsoft Knowledgebase, and learned how to do the VB to update the combo boxes. NOW. My last question. What does the datamodel look like? 1) One table with three tables joined (M:1) OR 2) A series of cascading tables ??? Thanks in...
  10. Y

    Categories & Subcategories

    Yes, this does help. If anyone has more to share please do. Jim Yahazim EDS, Inc.
  11. Y

    Categories & Subcategories

    I am creating a database to hold test cases for software my company is developing, and I need to categorize each test case. Each category has a possible subcategory, and then another subcategory based on the previous one, creating a table stucture that looks like this: TESTCASE (M:1) CATEGORY...
  12. Y

    Run a Query at a specific time

    Would I then save the results of the Query to a table? Or would it be better to create a Report and save the results of the Report to a file? Thanks! Jim
  13. Y

    Run a Query at a specific time

    I have an Access database connected to a SQL Server backend. All tables are linked. I have a query that I want to run at downtime every evening at 2am, PST. I want to save the results of this query so that I can run a Report the next morning on the results of that query. How do I do this...
  14. Y

    Autofill? Help!

    What would the setup of relationships look like between these tables?
  15. Y

    Autofill? Help!

    OK. I have a Form that allows a Systems Administrator to fill out the results of testing software. We are testing the software on 6 different clients, using 135 different tests, each test which can be a pass, fail, or N/A. It's important for me to find a way to AUTOFILL a subform in the Test...
Top Bottom