Search results

;) Watch what you write ;)

Wow, Bob, you're so quick at help. I have a huge screen and I'm quick in changing windows, so I think staying online would be my choice, unless there's a book that "has-them-all" short, and to the point. Any preferred sites for good reference besides functionx?

Thanks Bob for the site, I'm starting to check it out. Would you think that "having a couple of good books" would be a good decision, or today I can get them all online?

What's the best way to learn VBA Access for free? I have no patience to sit by courses and listening to all things I know but the dummies in the class don't. I'm looking for a website (hmm.. and free..) that is well organized and mainly it should be both "to-the-point" AND well-explained. On...

Re: Problem changing from acViewReport to acViewPreview Anybody did the same thing and did not have this problem?

Problem changing from acViewReport to acViewPreview Hi there, I open my report with a filter with following code: DoCmd.OpenReport "MyReport", acViewReport, , MyFilter On the report I have a button to open the same report in Print Preview view, with following code: DoCmd.OpenReport...

You're right Smig, I'll change them.

here you are again Bob, Thank you thiiiiiiiiis much. :)

I have 2 Fields: 1. [Message] 2. [Result] I want to see in [Result] the result of the text in [Message]. Text in [Message] is "Application.Printer.DeviceName" (w/o Quotes). Double Click VBA for [Message] is: Private Sub Message_DblClick(Cancel As Integer) Result = [Message] End Sub I expect...

eRed, I have a little stupid comment on your conclusion: you could use: ... & "And [Control] .... Instead of: ... & " And " & "[Control] ....

Thanks guys!

Good morning "gseach" Your post helped me here in 2011. Many thanks.

Than you Bob

Hey, I got it! For Each Control In Me!SubForm.Controls Control.BackStyle = 0 Next

User enters multiple records in a continuous subform bound to temporary "New Products" table. When finished, he clicks "Continue" Button. Now I want him to REVIEW the new products he is about to apply to permanent "Products" table. Then he could click "Confirm" and code will append "New...

When user confirms his newly created records in a SubForm, I want all the Controls in the Subform to get "Transparent Background" and their 'Font' to be 'Bold'. Will I have to write code for every single Control, or there is a way to apply a property to ALL Controls in SubForm?

OK, next step. For "Add SINGLE Product" I used TabControl-Pages in a SingleForm. No subform was needed. NOW: I also want an "Add MULTIPLE Products" form, for user to be able to enter MANY records at once, also in wizard-like style. What's the best approach to THAT? What do I need to...

I made my path thru your advice, thanx again vbaInet. Just instead of playing around with "visible=true/false", I set the TabCtl:Type to None (=hide tabs), and to get to page 2, I used SetFocus to a control in page 2.

Thank you AMB and RG for the Q&A #1, it helped for me now. Sometimes your doings have a far effect after years... ;)

Thank you vbaInet, I Looked into Tab control. Now, in step 1, I want customer to see only Page1, and after clicking "Continue" button, he proceeds to step 2 where he see's only Page2. So far I understand how to let him navigate between pages, but I want him to see ONLY the applicable page. How...