Search results

The thing is, 'answering in kind' is what everyone thinks they are doing. "He started it" is a child's reason for perpetuating a conflict. But considering Frothingslosh is the only person on your friends list and you haven't seen fit to use the forum's ignore feature, I suspect your...

If I may be so bold as to attempt to smooth this over... Libre, first let me say I agree it's a fascinating question and I'd like to add my ideas on the topic. I struggled with this during the "I'm a teenager and learning how to make decisions for myself, while my parents and teachers declare...

I enjoyed the show, and since you're a fan I do recommend it. The cast certainly did an excellent job and there's enough of the music to pluck those nostalgia strings. It's definitely not a musical review type show, though, if that's what you're looking for. There's a lot more talking than...

:o I miss those folks. And Selena. Apparently really, really, really bored. I joined these forums 14 years ago (omfg) and Colin is still singing the exact same tune. Don't they have video games in the UK? As an aside, I spent a few days in London this spring. It was my second visit and for...

Thanks for responding, but as I described in my post this works by adding a simple checkbox on the parent form; I just can't figure out a better way to do it. Seems sloppy to force the user to do clicks that don't really do anything. I guess the answer is there isn't one?

I feel like there's any easy answer here but I can't find it via searching nor trial and error. Quick version: I want to force an autonumber field on a parent form to start a new record when clicking on a subform, so that value can be passed to new records in the subform. Is there a simple way...

Ken, I will never forgive you for mixing up Indiana and Illinois. Though it's fun to see you're still up to your old tricks ;)

Is this a trick question? *narrow eyes* Thanks, Brian! Very kind of you to say, and nice to see a friendly name from the Long Ago Time ;) Life has been good, no complaints any worse than anyone else's. Major life events include buying a house, a trip to Rome and Paris to celebrate my 10-year...

I did. :) After I got over my astonishment this thread/argument is still running...

If it's an Access issue that'll be beyond my knowledge, but the first thing that popped into my head is that perhaps your printer drivers don't understand what Access is telling it. Have you tried printing to different printers? Have you tried printing directly to a PDF?

Well, without seeing your data and table structure it's hard to pinpoint the problem, but that message ought to mean that Department ID and Course ID have different data types defined. CourseID in Courses is the primary key, which should mean it has a data type of Autonumber. Therefore...

Try adding CourseID to your query. Since CourseNo and CourseName are dependant on that field rather than on DeptID, I don't think any of the fields in your query are currently pulling any records from Courses. Other possibilities that spring to mind: Does DepartmentID in both tables have the...

Have you tried an input mask? If you go to the properties for InputBox, under the Data tab is a property called InputMask that controls what kinds of characters users are allowed to type in a box. Set it to Password and it will display asterisks as you type but still retain the value.

Try selecting DepartmentID from Courses instead of CourseTaken. I'm not certain it will work but that's the first thing I'd try.

That did the trick! Interestingly, the record selector button does not appear 'pressed' by this code, but the record is still selected and editable. Thank you kindly!

One of the controls I'm hiding is the button that executes the code, so it has the focus at the time I'd try to hide it, which I cannot do. The only real purpose of setting the focus is to allow "cmdNewFeeNextStep.Visible = False" to work. Also, if I remove all the code after the IF statements...

Good to know :) Like most terrible programmers, I start with what I know and then hack and slash code salad together until it works. These suggestions will help me be tidier. So now I'm sad that even Bob Larson doesn't have a suggested fix for this weirdness, but happy that I'm not just an...

I have a very minor but annoying bug. My code grabs some information from the current record and passes it to a new record, then hides and shows some buttons and instruction labels. The strange thing is that when it is done I can't edit any fields until I click on the record selector button...

The above post is good advice. Most financial planning professionals will help you get started with a personalized plan for very little cost. If you're determined to make an independent decision but don't want to actively manage your investments, I suggest looking into retirement target funds...

This was going to be a plea for help but is now a retelling of my experience in case someone else runs into a similar problem. After being upgraded to Office 2010 I received the dreaded MSCAL.OCX error message but quickly found the solution of removing the missing reference from the VBA list...