Search results

  1. O

    Mail Merge Help

    I'll do my best to explain what I am wanting to do here with a mail merge (Word 2007). I have data in an excel file which looks like: Group A Group B Name Y/N 12345 1234A John Smith N 12345 1234B John Smith Y 98765...
  2. O

    Shortcut vs Dedicated Front End to DB

    I'm getting ready to push out a new DB for approximately 20 people to use - it is used to document names/addresses & then generate new files with updated addresses. A prior version of this had usage that generated approximately 40,000 records per year. At any given time there would be about 10...
  3. O

    DB for tracking Testing

    Two questions: Can a step be applicable to more than one case? Theoretically it could, but that is not my intention. For each test case I am thinking it should have a unique list of steps. I'll try to explain what I mean with the following example (hopefully I am being clear). Project =...
  4. O

    DB for tracking Testing

    First let me say I browsed but did not find anything matching this but if I missed it please feel free to point me in the right direction. Also, thanks in advance for any input. OK - so currently when keeping track of my test cases I have a spreadsheet and just go down the list on them making...
  5. O

    Require field only if specific combo selection made

    Got it working - thanks for the help!
  6. O

    Require field only if specific combo selection made

    pbaldy - I'm not to experienced with VB and am not sure what the first line should say. I have the message appearing and moving the cursor to the appropriate field if the correct value is selected in the combo box. However, I do not know how to make it recognize that the field has...
  7. O

    Require field only if specific combo selection made

    Thanks in advance for any assistance with this - and I browsed through the forms sections but did not see an answer to this. My form has a combo box (Reason) and several text fields on it. What I would like to happen is if Reason 1 is selected, then Text_Field1 becomes required. If any...
  8. O

    Find Duplicate Values

    Thanks Trevor! Used the Match function & that will bet me to where I need to go. Thanks alot!
  9. O

    Find Duplicate Values

    Hello, I have an Excel file which has 4 different worksheets on it. The first worksheet (profiles) has a listing of User Names and Group #'s. The other 3 tabs have a listing of all the available group #'s split by their their different categories (small, large, individual). The task I...
  10. O

    email attachment - lotus notes

    I have a feeling this must be covered somewhere, but I didn't find anything - if it's out there I'm sorry for asking, and feel free to point me in the correct direction. Right now I have a macro that will open lotus notes & attach my report into it and all I have to do is hit the send button...
  11. O

    Simple Sales DB

    Thanks for the response - I've looked at the link you supplied and set up some tables based on it. I believe I have this set up correctly but am not having any luck creating an entry form where you can select 1 Customer and add multiple products to 1 Order Number. Does this setup look correct?
  12. O

    Simple Sales DB

    I know this is very easy, but I have not looked at access for about 7 years and am finding it very difficult. All I am trying to create is a super simple sales database. I intended to have 3 tables: customer, product, orders and basically have a simple form where I would: A. Select the...
Back
Top Bottom