Search results

I'll contribute a few, but I must say I'm a little distressed by the anti-woman turn the Watercooler has taken just lately. :( "Well, would you rather watch football or spend time with me?" "You like (big boobs/blonde hair/long legs), don't you?" "How come we never talk any more?" Now...

When you launch Access, if you click on "Help" there's an option "Detect and Repair...". This utility repairs all office files. Does anyone know if this might help solve Nashat's problem??

For what it's worth, I very much agree with the last post - it's always a good idea to give a person just enough flexibility/power to do what they need, and no more. saves on errors. Speaking of which, the reason I'm posting is to ask what kind of errors the data entry people are making. The...

Yes, when the subform is opened on its own in form view, the labels show up. That's one of the things that's really puzzling me.

Thanks for your post, but size doesn't appear to be the issue. The labels are all surrounded by other controls, and everything shows up except for these particular labels.

Sorry for a stupid question, but why are you pressing the space bar? Is your combo box set to limit response to the listed items? I'm guessing not. I'm thinking that when you add a space or enter any value that is not in your item list, the combo box is trying to store a null value in your...

Have you tried the "MoveSize" command?

I'm having a weird glitch in a subform. I have a large subform embedded in a full-size form (22" x 22"). I put 6 questions on each form (2 across, 3 down), so that each question has its own screen. In this form, the main form has 2 questions side by side at the top, the subform has 4 questions...

I'm having some trouble getting getting macros to run within a subform. As an example, my interview asks whether a person is on any medications. If they are, the form goes to a continuous subform based on a table that stores the information 1 record/medication. I'd like to have the ability to...

No problem - it's nice to know I can be useful!

Put the calculation in the Control Source property of an unbound text box on the report, e.g.: =[total licenses owned]-[total used]

To print the report, use the OpenReport command in Print view (I do this in macros so I don't know the exact syntax in VB). This should print the whole report, not just a screen capture. I haven't used password protection before, so I can't be much help there.

In the criteria row for the date field, type this: Between [Enter beginning date] and [Enter ending date]

I was just trying to do the same thing myself. What I did is include [ID] in the query as Group By, and [DATE] as Max - and presto, I got the most recent date for each ID.

Put all three fields on your form. You can easily trigger the computation in one of 2 ways. 1) put a command button on the form labeled something like "compute total", set the on click event to set the value of your total field to rate*footage. 2) omit the command button and link the calculation...

This is probably a silly question, but did you make sure "allow additions" in the form properties is set to "yes"?

Key the expression to the price fields "on change" or "after update" event property.

Do you want to run the update query periodically, like at the end of each day, or do you want total on hand to immediately update every time someone checks out or checks in a product? If you want immediate updates, you may not need a query at all - I'd be tempted to perform the calculations...

What I usually do is create a form to do this. Put the combo box on the form as an unbound field, and include this field as the selection criteria in the query that generates the report. So the user will open the form frmReport, select a value in the combo box NAME, then click on a command...

It could be something simple - use [] only to enclose variable names, not as parentheses. Actually you don't even need parentheses, under update to: type [qty on hand]-[qty checked out]+[qty returned] Let me know if it works.