Search results

Thanks. It does indeed. How disappointing. i.e. ARRRGGGHHH!!! lol Thanks again.

They use the merged information in the word document and have to build in the values to the worksheets. The values in the INPUTSfixed are used to merge into that doc. The INPUTSdynamic is there just so I have a way of building a random set of values each time I assign this. I'm still working on...

Nick: THANKS for your help. I am attaching a generic version of the actual file I am working on right now (still need to do some cleanup on the values input... but it works. The only difference between this workbook and the one the student gets is, of course, the answers and required...

Is there a function that allows me to report into a cell the active cell row number without using VBA? I want the row number of the active cell to be reported when the active cell is within a specific range, but not otherwise. For example, if the active cell is in the range D10-D40, I want the...

OK. Editing this entry since it went so quickly. I see that your code fills in the appropriate line with its answer, and then sets it as a value so that it does not empty when the LOAD entry is changed. So, all I would have to do is cycle through the 105 LOAD values to get all my answers...

Hello. I need some help with a project I am developing for an accounting course I teach. In this project, the students are given 13 spreadsheets in a workbook, each of the first 9 of which having a number of cells in which they must make entries (about 50 in all). All students have common...

I'm actually using 2010. Thanks for any help!

Hello all. I'd like to create a "game" of sorts for my grandkids in which a picture is displayed in one control, and a multiple-choice question selection is available for them to guess the definition, related word, description, etc... Later, they'll have to type in the 'answer' without...

Well, it's for an accounting class, so the answers will be integers (no alpha strings and no decimals). So, it's just a matter of comparison to the built-in value in a table. "Does this equal that?" Not a problem there. I'm not familiar with Rnd. I appreciate the input on it and will study...

I'm attempting to build a Q and A testing database for my students. What I would like to do is have a random question fill into a form control, and the student then must fill in the answer in another control. The question and correct answer would be in a table, and the student's answer would be...

I'm going to be teaching an accounting principles course at a local university this fall. One of the projects I am required to assign has the students entering debits and credits for various transactions. This submission is done on paper. I'd like to create a database that allows the students to...

Thanks, Bob. I think I might be a little behind here yet. I've set all the B,C,D,E controls visible = false. Here's what I'm trying to simplify: A01 Afterupdate If Me.A01.Value = True Then Me.B01.Visible = True Me.D01.Visible = True End If If...

I need some help figuring this one out... I have 50 text controls on a form... 5 types of controls, 10 iterations (for different purposes but analogous). Let's call each set of five controls A,B,C,D,E. They are iterated with a 2-digit suffix, such that there is A01, A02.... A10, with matching...

Great ideas guys. Thanks. This should get me started.

Thought I should add a caveat here, based on my observation. Though this code works perfectly, it DOES NOT put an "On Click" event on your button control. It somehow links the existing (pre-move) code to the click. So, when you look for the event code on the button's properties, the line is...

Found a Missinglinq post on another forum http://www.dbforums.com/microsoft-access/1664455-move-command-button-onto-tab-without-losing-onclick-event.html that contained this code, attributed to ADezii at Bytes.com. Private Sub Form_Load() Dim ctl As Control For Each ctl In Me.Controls If...

I've placed a bunch o'buttons on a series of tabs in a form, but a few should be in the main form's header area. When I move, copy and paste, cut and paste... anything... I lose my event code related to the button. Any help in how to avoid this or a workaround would be greatly appreciated.

Thanks guys. At least now I know.

I like using the wizards for adding certain simple objects, like buttons to open forms, etc. However, if I drop a button onto a form and close the wizard accidentally, I lose the ability of using it for that control. Is there a way of bringing it back up or do I simply have to do what I've...

Thanks guys... seeing that table has helped immensely!!