Search Result

gnawoncents · Feb 4 '11, 07:04 PM

Greetings,

I have a datasheet, created through VBA, and I am trying to automate setting the column widths to Best Fit. Currently I loop through the controls using the code below

Code:

    'Set width of columns to best fit data
    Dim ctl As Control
    For Each ctl In Forms![Form1].Controls
        If (ctl.ControlType = acTextBox) Then
            ctl.SetFocus
            Call TBBestFit

...

JMANTN · Apr 21 '10, 10:05 PM

Hello,

I'm trying to incorporate some code that was used in an old database (access 2003 but everything works in 2007) by someone who no longer works with me that utilizes sendkeys to send employee (agent) exceptions into their schedule which is in a different application. The old database works fine as is however I'm making a database for training and trying to use the code with mine and just started learning VBA and could use some...

dfemery · Mar 26 '10, 02:07 PM

I am writing a program that uses a third-party library of routines and methods to receive and display video from an S-Video source through a USB video capture device. That part works perfectly. There is a method that can be used to pop up a video driver screen so that the user can then use his mouse or keyboard, in the usual manner, to change video settings.

The problem, however, is that I cannot get SendKeys to change the settings...

Search Result

How do I set the Focus to a Popup Dialog?

changing code to get data from a yes/no field instead of form & SendMessage help

Problem sending keystrokes using SendKeys