Search results

I am trying to teach the concept of randomness in a college statistics class. I was thinking of writing a macro that would loop a recalculation, and have a =RANDBETWEEN(1,100) formula in a certain cell. Then... and here's the part I cannot figure out... I want to COUNT the number of times each...

Not importing or linking. I am looking to set up a new way of maintaining these price sheets that will be easier and more accessible. Thanks for the help. I will check out "Between...and."

Hello. I have been given a set of pricing tables in Excel that, based on the type of work done, show a dollar amount for time ranges. In other words, if WorkType = A, the appropriate pricing table is referenced and the amount of time in minutes is found within ranges ("0 - .3333", ".3333 -...

Thanks for the idea, ode. With 40 or so fields on the form, I think I'll have to find another option... or just forget it altogether. One final try... any further ideas? Thanks for any help!!

ghudson: Thank you. That turns the filter off, but doesn't actually clear the grid of the previous entries. I am hoping to make it so that each subsequent use of the Filter By Form function doesn't require a manual "Clear Grid" from the right-click menu before starting a new filter entry. Tom

Is there an easy VBA equivalent of the Filter By Form "Clear Grid" command? I want to have users apply a filter by form, but then be able to hit a form button that will deactivate the filter AND remove the parameters they entered in the Filter By Form function... in other words, "clear the...

Aaaaaarrrrrrrrrrrggggggggghhhhhhhhh!!!!!!!! I found information at http://support.microsoft.com/kb/q208548/ But am having trouble with the syntax of the following: Private Sub Command96_Click() If Me.Filter = "" Then MsgBox "Apply a filter to the form first." Else...

Michael: Thanks, but not exactly what I'm looking for. That example has prebuilt queries that the report then is based on. I want to be able to use the filtering tools and then select the report button, which would run the report based on the current filter. Thanks for the reply! Tom

Hello all. I would like to place a "Print Report" button on my primary form that allows a Filter By Selection (OR Filter By Form) first, then when selecting the button will view or print my already-created primary report but only for the records that were selected by the filter. I looked and...

I was afraid that might be the answer. Thanks, Pat.

Hello, all. I need to use a datasheet view for a subform, but I can't seem to find how to keep users from editing the column widths within the view. Help? THANKS! Tom

Pat: THANKS! I was going to try to implement the first solution, but quickly gave up. I see where you're headed, and feel comfortable I can successfully make it happen. In the meantime, I found I can do this fairly easily in Excel, but I don't want to have to export/import data to get this...

Each day, I receive a set of data (of varying size) which is, essentially, a simple set of timings in seconds with other appropriate identfying data (source, date, person, etc). One set of the calculations I do is mean, min and max. However, it has been requested that a reasonable interval be...

A woman goes to a doctor because of chest pains. He gives a full physical examination and tells her "You have acute angina." "Thank you." she replies, "But what about my chest pains?"

Perhaps you could have a checkbox called "Expired" and have an Open Form action that turns the value to True if the corresponding date field is >date()-365 and False if not. Then you could query the values for the "False" (unchecked) records and put a sum function in a text box, or just put...

You shouldn't need to store calculated values. If you are going to print a report, you can put in the same equations you put in the form text boxes. Do you have specific purpose for having the calculated values in the table itself?

Wayne did a GREAT job on that. I think I would make only one modification, though. I would create an On Open event for the form that sets all the fields to Visible = False. That way, you won't see any of the fields until you complete the combo.

Now, if only I could convert and compact my body....

Why don't you just go to Tables, select New, then Import Tables? It allows you to browse to your datasource and import easily. I do that all the time and never have trouble. Just make sure that your Excel sheet tabs are one word with no odd characters and NO SPACES. Same goes for the column...

I tried this out and found you can also use this technique to make subforms visible/invisible. Very cool.