Search results

In the form's form properties, set Cycle to Current Record.

Oh, heck - why not just use the sink? JUST KIDDING, FELLAS Is that better, Vassago? ;)

Yeah, what he said. :D

Deborah, Are you using this form to enter data, or just to view it? If you only need to view data in datasheet view, the simplest way to do a multi-column sort is with a query rather than a form.

No problem. I think you're right - this second article's approach looks like it will be easier for me to implement. Thanks again! :)

Well Jack, Despite the fact that the first sentence I saw in the article you sent was "Advanced: Requires expert coding, interoperability, and multiuser skills.", I will indeed try what you suggest. Thanks a bunch, it looks like just what I'm looking for. :)

I'm designing a form for entering a person's residential history, with each record recording one residence for an individual. What I'd like to do is this: The user enters in the year a person moved from a particular location ([YrEnded]), then clicks a command button to go to a new record to...

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]