Search results for query: *

I'm thinking maybe to not bother with this now. Decided that instead of scrolling the form (and the contained image), I could just 'scroll' a control down the form, continually setting focus to it. Used a command button (1mm x 1mm to keep it out the way) called cmdForAutoScroll, and looped...

Or simply open your startup form frm4 from an AutoExec macro/procedure (and all the other forms for that matter) then each will go through its entire load process and you can still run some code for focus purposes thereafter. Though using the 'phantom form' suggested by MajP above seems like a...

If something like Forms("Form1").SetFocus doesn't do it, then usually you can just send another open command for the form you'd like focused. If the form is already openend then you will set focus to it by goinG DoCmd.OpenForm "Form1", acNormal etc maybe there's a better wAY ...

Oh I see what you mean. Yeah, if you then went to attemp to paste int the same workshhet, you'd overwrite the clipboard contents as soon as you selected your destination cells. So you could only get away with pasting to another worksheet or another application. Minor limitation .. But maybe...

I'm sure that's not supposed to be a trick question Skip, but I don't know what you're asking. The general idea here was to exploit the Events functionality of the workshhet, so as to automate the running of the code upon each selection change in selection. First you have to know what Events...

Another way you might do this is with text manipulation functions. Supose yor cell value as above is In cell A1, then put the following in cell B1: =RIGHT(A1,6) This will give the right hand side six characters from cell A1, which in this case would be 560.25 this will work for you if the...

If you wanted the cell contents to be copied to the clipboard as soon as you select them (as opposed to having to hit a button etc to execute the Selection.copy command shown above), you might consider putting that single-line code in the selection-change event of the worksheet. That way, every...

Oh, ok -- this vba forum a bit too general when it can be nailed down to an access forms Q. Nice if there was a way to 'reclassify' the thread but can't a find a way. Guess I'll have to copy and paste ... And maybe dig up some example code. After all, think I managed to get SendMessage to give...

Hi, I wonder if some careful examiner of the bounds in which we must work has figured out SendMessage! I would like to be able to make use of the SendMessage API call to get an MSAccess form to scroll continuously. I've been able to achieve a similar outcome using VB, but VB has a built-in...

Your scanner did two sided copying, but not two sided scanning ... bit of a design oversight ... ! I have a Canon multi-function, which has an automatic document feeder, but no ability to physically flip pages. Yet it can still achieve duplex scanning via the bundled software. You manually...