Search results

  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...
  16. Y

    Adding records to a lookup table through a combo box

    I'm creating a database to help automate generation and tracking of ticket numbers for a help desk database. I have three tables: * Ticket table (ticket_ID = PK) * Applications table (App_ID = PK) * Vendor table (Vendor_ID = PK) My primary keys are Autonumbers, and, the Vendor...
  17. Y

    Form Data Entry

    I have these two tables, among others: * tblEmployee * tblEmployeeType ---- I'm modeling a business process in Access, and I want at various stages of the process to input Employees who are responsible for certain tasks in the process. Here is the question: Is there a way, using Queries or...
  18. Y

    Print current report

    I KNOW we've already discussed this, however I'm still lost. I want to print a report directly from a form. I'm using the SAME query for both the form and report. What VB sub clause do I put in my OpenReport to make Access JUST PRINT the current report? I'm also planning on porting this to...
  19. Y

    Help an idiot . . . Autonumbers (again)

    ALL RIGHT. This worked for me, and of course very simple once figured out. Try Refreshing the form OnActivate. -------------- Private Sub Form_Activate() Me.Refresh End Sub -------------- Jim
  20. Y

    Go To a Record on a Form

    OK. I have a form that will reference a table with many many records. I need a control that allows the user to "Go To" a record number the user specifies. How do I do this? THANKS in advance!
Top Bottom