I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the reco
I re开发者_StackOverflow社区cently switched to Outlook 2007 and noticed that my VBA-macros won\'t work. I use the following code to open a new appointment-item (and fill it automatically). It worked p
I\'m using Application run to call several macros in order like this. Sub Run_A开发者_开发知识库ll_Macros()
This question comes from a comment under Range.Formula= in VBA throws a strange error. I wrote that program by trial-and-error so I naturally tried + to concatenate strings.
I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by the
I was trying to chart some RTD data and accidentally ended up with hundreds of charts on the same worksheet. Now I\'m trying to undo my error and remove all of the charts but I\'m not having much luck
Sorry in advance for the rookie-ness you are about to hear..... I have VB application that uses an Access DB, call the database: db_1.
From one of VBA tutorials I learned that variables contining numbers should be firstly declared as integers:
The problem: I use VBA to populate MS Excel 2000 cells with text. The column has a fixed width (should not be changed due to layout) and the wordwrap property is set to true so the text wraps over mul
Why does my Do Until loop try to run raw.Delete even though raw.EOF is true? If I have an empty table, this crashes. Why?