Search results for query: *

I have made a rather comprehensive VBA routine that documents the content of Access databases, especially tables and queries. I find the number of records in a table by: For Each aTabDef In CurrentDb.TableDefs aRecordCount = aTabDef.RecordCount Next aTabDef However, I have recognized that...

I have some VBA that loops through a list of tables, empties them, and then fills them again by running append queries. For each table I get messages like "You are about to delete 123 row(s) from the specified table" and "You are about to append 456 row(s)". These messages I can suppress by...

The taskbar shows the text from the title bars of all windows. If several documents are open in Word, the taskbar shows: Document1.doc - Microsoft Word Document2.doc - Microsoft Word etc. With an auto-hidden taskbar positioned to the left it is easy to choose the correct document...

The following registry extension will add the item "Dir /S" to the folder context menu. By selecting this item the command file (DOS batch file) "C:\BAT\_DirS.cmd" is executed. [HKEY_CLASSES_ROOT\Directory\shell\CMD1] @="Dir /S" [HKEY_CLASSES_ROOT\Directory\shell\CMD1\Command]...

I have a VBA function that is called from many cells in several worksheets in my workbook. The function performs some error trapping (data checking) and gives a message if an error is found. However, I need to retrieve information on from where the erroneous call of the function is placed...

When I save a web page to my harddisk I always use the "Web Archive, single file (*.mht)" option. But the default is "Web Page, complete (*.htm,*.html)" that produces an HTM-file and a subfolder with several files referenced by the HTM-file. How do I change the default file type to Web Archive...

I am developing Excel and Access applications that are meant to be used by several (many?) other persons. In the development I am using Office-2000 and Office-XP, but end-users will use Office-97, Office-2000 and Office-XP. I am opening an Excel object from Access and vice versa an Access...

I am developing Excel and Access applications that are meant to be used by several (many?) other persons. In the development I am using Office-2000 and Office-XP, but end-users will use Office-97, Office-2000 and Office-XP. I am opening an Excel object from Access and vice versa an Access...

I would like to declare a variable representing a userform. If I simply declare it as OBJECT, things function. But if I declare it as USERFORM, I get an error when showing the userform. Run-time error '438': "Object doesn't support this property or method". Do I really have to declare it as a...

I have a database table in MS Access with many records. I use some VBA in Excel to delete some of these records. But when I try to delete many records I get the error : File sharing lock count exceeded. Increase MaxLocksPerFile registry entry. My VBA looks like this : ' Select...

In Excel I am writing some VBA code with calls to ADO. When I need help on some ADO statement I place the cursor on the word in question, eg. Execute, and press F1. Then I get a choice between "Office" and "ADODB". But if I select ADODB nothing happens. It is as if the system does not at all...