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!

  • Congratulations strongm 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. JulieS

    View entity relationship diagram from .sql file

    Hi, I was sent a .sql file containing a database structure. My task is to create a diagram (ERD) from the sql code. Is there an easy way to do this, instead of starting from scratch? I downloaded a series of programs, but have not had any luck yet. The closest was with the DDT program, I don't...
  2. JulieS

    Weighted Random Number formula?

    Thanks very much - very helpful.
  3. JulieS

    Weighted Random Number formula?

    Thank you so much, this is a brilliant solution and exactly what I need. One other thing that's really stumped me is how to ensure 100% of employees are tested over the given time period? I'm not even sure if that's possible, as new employees could be hired right up to the last test period...
  4. JulieS

    Weighted Random Number formula?

    I've uploaded a spreadsheet that gives an example of how I was initially thinking about applying the weights. http://www.mediafire.com/file/6l1dyb9vy1vvbuo/Weighted%20Random%20Program-1.xlsx
  5. JulieS

    Weighted Random Number formula?

    Thank you for your replies: Response 1. Sorry for not being clear. You're right, you can't test every employee. The weights and the timeframe are variables (they can change by user). So one user might want to test their X number of employees in Y timeframe at Z weights. There definitely will...
  6. JulieS

    Weighted Random Number formula?

    Hi, I have a list of 100 employees. I want to randomly select 5% of the employees per month for a test (there's a test once per month for one year). To start, each employee has an equal chance of getting selected. Once an employee is selected, his chance of being randomly selected again...
  7. JulieS

    Work with ActiveCell from one worksheet in another

    I have two excel spreadsheets - one with the macro, and the others that I want the macro to run on. I have successfully opened the other spreadsheet, activated it, and can read values from the cells, but when I reference ActiveCell, I get the following error: Run-time error '1004'...
  8. JulieS

    Tab control with subforms

    Thanks Pampers, I tried that, but when I go to tab C (the subform that needs to link to subform B which is linked to form A), it only lists the parent fields as those of A, not B which I need. Should I give real examples, or is this ABC stuff ok?
  9. JulieS

    Tab control with subforms

    I have a form with a tab control. The main form is on tab A, and the second tab's form (tab B) is related to A. The problem is that tab C and D are related to tab B. However, I am unable link them on the parent/child fields because it only gives me tab A data to pick from. I tried creating...
  10. JulieS

    Module Not Found

    It pops up every so often as I'm deleting (I'm deleting line by line) and it won't let me save.
  11. JulieS

    Module Not Found

    I have a procedure in my code that refers to a button I deleted - when I try to delete the code it won't let me, won't save it. For now, I'm just importing everything into a new database and designing the form again. It seems to be working so far, thanks for the suggestions.
  12. JulieS

    Module Not Found

    Copacting and repair isn't working. When I try to open the code, it says 'You cancelled the previous operation'. Does that mean anything?
  13. JulieS

    Module Not Found

    Something very strange has happened to my database. It was working fine, but all of a sudden when I click on a button on the main menu that takes me to another form, it says 'Module Not Found'. Its saying this for all buttons, and I"m not even able to open a form directly. I didn't do anything...
  14. JulieS

    pass parameter from combo box with multiple columns

    Yep I know. It still says 'undefined function ... in expression'.
  15. JulieS

    pass parameter from combo box with multiple columns

    I have a combo box that lists titles and dates of events. There could be duplicate titles but not dates, that's why I've listed them both in one combo box. I would like to pass both the title and date to my query, however the syntax in the query's criteria field...
  16. JulieS

    FindRecord is Replacing my Second Column

    Fixed. I had changed the Title text box to a combo box. When I built it from a new combo box, it worked. Whaddya know.
  17. JulieS

    FindRecord is Replacing my Second Column

    I have a combo box that lists the ID in Column(0) and the Title in Column(1). When I use the docmd.FindRecord, it is replacing my Title with the previous ID (before the update). This is very curious because I've used the same code in other databases and its worked fine. The code is as follows...
  18. JulieS

    Building a report from 2 queries

    Nevermind, I figured it out.
  19. JulieS

    Building a report from 2 queries

    Not sure if this is possible, but I have 2 queries that are seemingly unrelated to each other that I need to put into one report. Situation: Table A is related to Table B and Table C. So, one query calculates the number of times variable x in Table A appears in TableB, another query...

Part and Inventory Search

Back
Top