Search results

Try the following.... Public Declare Function GetUserName _ Lib "advapi32.dll" Alias "GetUserNameA" _ (ByVal lpBuffer As String, nSize As Long) As Long Public Sub GetUserID() On Error GoTo Err_GetUserID Dim lpBuffer As String * 200 Dim iEndOfID As Integer Dim vlen&...

If you are sending data from Excel to Excel, you have the ability to access the Excel application model. If you turn off the Screen Updating and Auto Calculation of Excel, your processing should occur faster. I'm not entirely sure how you are using ADO if you are passing data from Excel to...

Sending data from Excel to Excel, or from Excel to Access? If sending data to another spreadsheet, try changing the Excel application calculation method from xlCalculationAutomatic to xlCalculationManual while processing. When you are finished, turn the calculation back to...

Marcus: You could add a large text box, and apply conditional formatting to it. The control source is whatever field has the value of 10. Use Format - "Send to Back" to make the large control the background of the form.

How many names are in the list box? Are they last name first? Hopefully they are already sorted? As you are probably aware, simply typing the first letter and only the first letter will advance to the next item in the list that starts with that letter. After the initial letter you are on...

James: I am glad you got your solution. I'm not sure that I've consciously used Quikview. I use Textpad when I'm glancing at text files through an Explorer window. Follow up question... how do you determine (through code) if a file is in a busy state? I originally read the concern about...

I'm not sure about the skills qualifier, nor am I entirely clear about the Quick View utility, but here goes anyway... :eek: I checked the Object Browser in MS Access 2000, and don't see an QuickView object. There's QuickInfo, QuickPrint, and QuickWatch. Those three objects appear to be...