Recent content by Dark Stranger

  1. D

    Solved Query By Form Not Working

    Hey guys. Thanks for the help. I followed your recommendations and looked for examples dynamic SQL search code. I found what I needed in a blog by Allan Browne. The example uses a continuous form with unbound text boxes in the header. DS
  2. D

    Solved Query By Form Not Working

    The search form has 15 boxes: 2 text, 9 combo, 4 date (Project open - Start and end, and Project close -start and end). The most common search will be by date range, or by Project Leader name. The most likely combination search will be date range and project status (Active, Complete . . .)...
  3. D

    Solved Combo Box only enters first item on list

    Thanks guys. Your help was greatly appreciated.
  4. D

    Solved Query By Form Not Working

    Access Newbie here again with another question on my project database. I am trying to set up a Query by form so users can quickly filter the project info table. When i enter the filtering criteria in one field it works well, but when I add a criteria into a second field it stops working. The...
  5. D

    Solved Combo Box only enters first item on list

    I have no Idea what I did wrong. I renamed boxes and fields to make sure they were all unique, then I deleted and re-entered the query code. Now it is working. Thanks for the help
  6. D

    Solved Combo Box only enters first item on list

    I have a combo box with a list that changes depending on the selection in another combo Box. The list in the second box is changing correctly when I change the selection in the first box, however when i select an item in the second list it only enters the first item on the list into the...
  7. D

    Solved Project Number with Year and serial number YYNNN

    Thanks for the help. I borrowed some code from another thread that did what you guys described, and modified it to work for me, I set up two text fields in my table- tblProjectInfo. - BaseID and YearID. Then I added two corresponding hidden text boxes on the Data entry form. I also added a...
  8. D

    Solved Project Number with Year and serial number YYNNN

    I need your help. I work in a process improvement group in a small division of a large corporation. We have just been notified that the corporate group that created and maintains the project tracking database we use, that it will no longer be supporting it. I have been tasked by my boss with...
  9. D

    How do I format ID field with date prefix and have the ID restart next year?

    Pat I am attempting to do something similar. However, I would like the Project number to be generated with a Command. We will be entering project ideas into the database but don't want to assign a project number until the project becomes active. Could I use your code on the "On CLick" for an...
Top Bottom