access | Forum profile

Quote: Originally Posted by topher23 Obviously, my predecessor convinced our management that this was an acceptable risk, as this method was implemented on at least 16 different databases before I took over, and is still in place for many of them. It's hard to tell from this which you have the more respect for :D

I see your point, OB. I need to rethink this with a solution that will work. I don't know what I was thinking earlier.

The period character is simply used as a separator between the table name and the field name. In SQL, the [ ] characters are not required unless you need to delimit a table or field name with spaces in it. So imagine I have a table named myTable and it had field1, field2, field3. I can select all three fields by writing Expand | Select | Wrap | Line Numbers SELECT Field1, Field2, Field3 FROM myTable...

Ok, like Linq said, we still don't know what you are doing. But I can tell you what to do to get the results you are looking for, what you need to do: 1. Assume you have a text box named txtYear 2. Create another text box and go to its properties and put " =DaysInYear([txtYear]) " in the control source field. (no double quotes!) 3. Keep this code with the tweak I put in: Expand | Select | Wrap | Line Numbers...

Well, I'm exhausted. I've tried to see if there was a way to send a mouse click through sendkeys, and I found some stuff on it, but nothing beat this problem. Topher23, I did see the button get full focus, but then get pulled back as you described. It leads me to believe that the web browser control might have some other event after the documentComplete that is pulling the focus back. I've tried to figure out what that event...

I like that idea dpminusa. I will try that. I don't know how to set a macro to a keyboard combination but I'd like to try to figure it out on my own before I ask a question on it. Thanks!

I've taken the liberty to modify the Code and output the Results (Matches) to the 1st Column of Sheet3. Just make sure that you have 3 Worksheets named: Sheet1, Sheet2, and Sheet3 in order for the Revised Code to work properly. Expand | Select | Wrap | Line Numbers Dim rng_1 As Range Dim rng_2 As Range Dim rngRef_1 As Range...

First off, there is no need to have the same code for each checkbox appear in the OnClick event and the AfterUpdate event. One or the other will do! Secondly, because you're apparently (from your description) doing this on a Continuous or Datasheet View Form, you need to use, for each appropriate control Me.PRAWhat3.Enabled = False Me.PRAWhat3.Locked = True or Me.PRAWhat3.Enabled = True Me.PRAWhat3.Locked = False in order for the...

Great explanation, nsbecker--helps me not only to understand why I was getting the error, also helps me visualize what the procedures themselves mean/are doing, so I can select the ones I need in the future. Thanks, all!

Yeah you can remove the scrollbars, record navs, all that. I did this quite a while ago, but I remember it was a pain to set up the subreports initially. The whole reasoning behind using the subform/subreport, I believe, was that the code I used to call the stored image out of the tables was all self-contained within that object, and I wouldnt have to recreate any of it on another report or form. Although, I do believe I had to call instances...