Search results

Programically Controlling the ADO Data Controls Hi, I am programming with the ADO data control, datagrid, datalist, and datacombo. I cannot find much documentation from Microsoft and other. I would like to set up these controls programically at run-time; example, set the column widths for the...

Explanation Needed - How Code that Recursively Search Works I have a function that uses the FSO to recursively search folders looking for files. The code is included at the bottom of the posts (mind the typos!) I can use this function and modify it to suit my needs, but I do not have a full...

Standard Naming Convention for Font Files I have been designing a font viewer/manager. I have noticed that many of my differently named font files contain the same font. Is there some kind of standard naming convention to name font files or is it "anything goes"? If there are several different...

Enumerate Windows to Detect Second Application Instance Hi, How does one use the EnumWindows API? I am not having any luck with this API; I would like to find the window handles of other instances of an application and act upon the findings; in Applleman's Dev Guide to Win32 API, it is...

Way to Turn Off Computer Programically After Shutdown? Hi, I have learned to shutdown Windows 2000 programically using the API ExitWindowsEx Lib, but the computer will not turn off; I get an "Ok to turn off computer" message box; How can I programically turn off the computer so the computer...

How Does Make Sure Only One Instance of an Application Runs? Hi, I have an application and would like to prevent users from opening more than one instance of it; How does one do this? I don't need any code, just the general idea of how to do it; Thank you! --llyal

Hoes to Make an Application an Associated Program? I have a made a simple image viewer; i would like this program to display graphics when i open graphic files instead of having to start the application then open the image; example, when i click on a JPG file, the Microsoft Imaging program...

How do I Size Internet Explorer Window Programically? Hi, I am making a tool that opens several URLs in different Internet Explorer Instances; Internet Explore does not automatically resize to full-screen so I need to do this programically; How does one do this in Visual Basic? I have Java...

Hi, Does anybody know what ADO/SQL Server 7's Query Size Limit is (if any)? Example, I would like to send very long SQL statements (>8K bytes total length); I also would like to send very long lists of stored procedure parameters (>8K bytes total length); Can ADO/SQL Server 7 handle this...

How to Change MS Outlook Rules Programically I would like to manipulate the rules programically. I have a diagram of the Outlook object model but I don't see the Outlook rules anywhere. Do they exist? Can I manipulate them programically? Thank you! --llyal

How To Set Access Options Programically How does one programically set the options of MS Access, when the database is open. Example, I want to make sure that compacting upon closed option is on. I want to set this option in case it was un-set somehow (by a user, etc). How would I do this...

Why can't zero-length strings be inserted using INSERT INTO SQL? When I try to insert fields of a new record, and if one of them is a zero-length, the insert fails. I can insert nulls but not zero-length- very odd! Following is my SQL: strSQL = "INSERT INTO tblNTLogIgnoredEntries (Server...

Cannot successfully change the ColumnCount or ColumnWidths of a Combo Box after it is used in a form Interesting thing i want to do to a combo box- I want to change the combo box parameters so that I can see the bound column- but only when I press a Command Button. All other times, I don't want...

How does one handle rollovers when doing subtraction with time? I find that when adding time, VBA handles rollovers at the 24-hour mark gracefully; but when i subtract hours, VBA gives me weird results; Here is some code: ' subtract 12 hours, if resuting time is larger than current time then...

Tough Problem With Two Subforms I have a form with a combo box and a subform; the combo box updates the recordsource of the subform with the AfterUpdate() event; no problems; I am trying to convert this into a form with two subforms, one subform replacing the functionality of the combo box- by...

Cannot Set Form Property AllowDesignChanges - Get Errors 'AllowDesignChanges 'is a new property to Access 2000; On MS website, it says that i can assign a value to the 'AllowDesignChanges' property of a form through VB...

Controlling toolbars On Off by VB Code In Access97, i created a URL Manager that opens many URls in separate IE instances; Access97 will display a Web toolbar when it does this; i would like to turn this toolbar off- i think it is annoying; is there a way in VB/ VBA that controls the on/off of...

Understanding of Bookmark and RecordClone Here is the code snippet in question: Me.RecordsetClone.FindFirst "TestID = " & numTestID Me.Bookmark = Me.RecordsetClone.Bookmark I use it all the time and know the end-result- a specific record is located fast; however, i do not understand...

Short-cut Key for View Code? Is there a short-cut key to View Code; i can bring up the debug window via short-cut, but it is not documented if there is a short-cut to view code; since i work with Access all the time, this short-cut would be a big time-saver; i hope someone has figured it out...

Problem Making Subreport Display Something When Recordset is Empty The problem i have is how to display "none" when the recordset is empty for this subreport; All my present attempts result in errors or nothing being displayed; I have tried the On No Data event and others; What is the how-to...