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...

Beiber39, yes I'd say (chiming in) that Access isn't "talking nicely" with Fax & Image Viewer -- and then I'd check it out to see if I'm right or wrong ;> . So here's the next step to take. Read Microsoft Knowledgebase article - 307859 - "How to change file associations in Windows XP" at...

[knight] [hippy] [rockband] GREAT! YIPPEE! [karate] [king] [jester2] [elf] It was pleasant to come in after your three successive posts, to see you'd worked right through 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...

[Your second post today came in while I was typing this, so I'm still putting this one in. I just wanted to note that it started a little bit ago, immediatley after my first post today. -- Editor] This is in a post separate from the first one I put up today, because the point I'm going to make...

You're not 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...

First quick response: &quot;declared globally (outside any individual Sub or Function)&quot; This means, &quot;in a module, but before any line that starts a Sub or Function (like 'Private Sub XXX()' or Public Function TrueOrFalseFunction() as Boolean')&quot;. Your Access options...

&quot;'Constants assumed be declared globally&quot; Baaah! Bad English on my part, and I have no excuse, I'm afraid -- I'm just guilty of somehow leaving out a word or two. &quot;'Constants are assumed to be declared globally&quot; would have been better phrasing, and less confusing than what...

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...

Okay, let's just start ticking through points without more preamble... strSaveCaption = cmdGetFileForOLEobject.Caption seems to have no purpose in your code. The variable is declared as local to the Sub, non-static, and isn't used again in the context of the Sub, anyway. It's wasted code and...

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;)

I don't really know much about the file size issue. I do know that you can compact the database size, which does not actually fix the problem. The fact that -- using linked objects (rather than embedded) -- the file size jumps roughly the same amount for all objects ... this doesn't surprise...

fredk, you asked, &quot;[...] Can I proceed using sql to run the report? If so, how do I assign the sql to the reports recordsource?&quot; You can programmatically alter the data displayed by a report. [thumbsup2] You have a few options; I'll call them 1, 2, and 3. For options 1 and 2...

Excellent, Shyam! A built-in function that does the same will save you the overhead of building your own (or using the one I wrote)! Now that you mention it, the Split function seems familiar, so I've seen it before. I'm thinking that I've seen it in full-blown VB (I haven't done much coding...

Sooo, MichaelRed, tell us how you really feel [noevil] . [bigsmile] What does &quot;V&V&quot; mean, please? You're right about, &quot;But if you follow CVigil's general approach, just bind the Form to the temp (waystation?) table -- at least for the fields which are part of your 'main'...

Hrrmmm... If you bound the form to a table independent of, but identical to, your actual destination table -- it would be a waystation for entered records, if you will -- then you could allow data entry as normal on the form. In fact, with what I'm about to propose, the form should be for data...

I believe RJFost missed the point of shyamsundar's request. Shyam, you want to allow a user to enter multiple search criteria, for instance &quot;sugar&quot; and &quot;milk&quot;. The syntax you would have them use for such a search is &quot;sugar, milk&quot;, although you would be willing to...