Search results for query: *

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

Thanks very much - very helpful.

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

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

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

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

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'...

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?

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

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

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.

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

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

Works like a charm, thanks.

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

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

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.

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

Nevermind, I figured it out.

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