Search results for query: *

Sounds like you want to use a Bound or Unbound OLE object. (And there are probably other options available out there, but this ships with Access 97, which is where most of my experience comes from.) Depending on the properties settings, you can cut & paste or drag & drop to/from the form...

I don't know off-hand if Access (any version) provides a way to get at the scroll bar of a text-box at all. But you might be able to find something in the Windows APIs for your version(s) of Windows. The API's can be declared and used just like other functions in VB. You can find out more...

...which I hope you have, even if your desktop PC was purchased with Windows pre-installed.) Then try looking in your database again. Good Luck. * * * [I've done a middling bit of work in Access 97 with bound OLE fields, with both linked and embedded objects, over the past few years. And I...

...it! (My e-mail client did tell me that auto-notices had come in, saying that another post had been added to the thread, but I've been busy with *my* work for a while :-) , so I only got to check just now. Heh heh, you got it, m'boy!) Now, just so that a future reader understands how you...

...And Label26 is by a control (CheckBox, RadioButton, whatever), which sets the option group's value when it is selected/checked. That control *always* returns the same value -- you *could* change the control's option group value, but I don't see you doing that in code, so it always returns...

...a bother; I can ignore you at any time <evil grin> ! Is your form open at the time the report runs? The Forms collection is the collection of all *OPEN* forms. Sometimes that's a pain, and just occasionally it is handy. If it is open, do you have the name of your form and control typed...

...module) or a stand-alone &quot;normal&quot; module. (Check help to see what that does.) They may or may not be. I suggest, by the way, that they *should* be so set. Any declarations that should be global should go right after that Option Explicit statement and any other Option statements...

...out a word or two. &quot;'Constants are assumed to be declared globally&quot; would have been better phrasing, and less confusing than what I *did* type <sheepish grin> . General tip: Did the VB editor show you which line(s) caused the error? That should give you a clue about the source...

Access97 does not have a Replace function. But I just read in another post in this forum that Access2000 does. People should be careful to specify which version of Access they are referring to. Have a good one. -- C Vigil =) (Before becoming a member, I also signed on several posts as...

And just to add to the options, check out Access' user-defined collections. You can add, literally, any object to them. So if you wanted, you could add all of the relevant controls to a collection named Part, and reference each control with syntax liekke Part(0), Part(1), Part(2), and so on...

...it returns an empty string, &quot;&quot;. What do you want your app to do when the user presses Cancel on the common dialog? Right now, it does *not* change the value displayed in Me![FilePath], but it *does* clear the picture. That seems inconsistent to me. I don't know if you are...

That's clear :-) . And the solution is simple. The Open File dialog (the common dialog) remembers the last chosen path for you. As long as you do *not* specify an initial directory, the common dialog &quot;stays where it was left&quot;, and displays the last directory chosen when it is opened...

Thaks for the definition, MichaelRed! I went back and read the relevant portions of the post, and understand now :-) . &quot;Read you around,&quot; -- C Vigil =) (Before becoming a member, I also signed on several posts as &quot;JustPassingThru&quot; and &quot;QuickieBoy&quot; -- as in...

Sure you can, fredk. You just did :-) . -- C Vigil =) (Before becoming a member, I also signed on several posts as &quot;JustPassingThru&quot; and &quot;QuickieBoy&quot; -- as in &quot;Giving Quick Answers&quot;)

...but I'm not too surprised that the space used is fairly consistent. I am (somewhat) surprised (perhaps dismayed is a better word) that it takes so *much* room. I *did* find this web site a couple of days ago, as a result of reading another post here: http://www.unsoftwareag.com/ Look...

...(This is easily adapted to a macro, though.) You open the report (in Preview View). Then you set the Filter property of the report. Then you *turn on* the Filter property by setting the FilterOn property to True. An example Sub: Public Sub RunReport1() 'Shows the report in preview...

...that Split was added to Access 2000's VBA -- a good move in my opinion. I recall that before I wrote MyStrArray (before this thread, for sure), I *looked* for a built-in function that would do the work for me, but didn't find it. Something had told me it was worth the look, but that was...

...human sorts, we'll suggest what strategic improvements we think we notice. (While I'm addressing this, readers will please note that MichaelRed *did* offer help, as well as wonderment :-) .) Perhaps all sabavno needs is a field containing the count, appended to the record information, but...

...record from the waystation table. You could use the Fields collection, and loop through that, copying values. Then change the primary key values *before* using the .Update command. That way, you don't have to explicitly list/name any fields, except the primary key fields. (And if you...

...useful for such purposes. I have used it in the following function, which you will probably have to paste back into the module editor to read: '************************ Public Function MyStrArray(ByVal strList As String, ByVal strSep As String) As Variant '- This function accepts a single...