Search results

Sunday, September 5, 2021 is a special day for VBA (and VB in general). Something is happening on this day that hasn't happened since April 5, 1991, over 30 years ago. First to figure it out (hint in thread title) gets a big hooraw!

This is a problem I've been wrangling with for over two weeks. I have very high resolution images that I need to import into a Microsoft Access Report. The dataset (query) source for the report contains the following information: Field Datatype Description ImageID Text Unique ID...

A common occurrence in working with Access interface forms is to be able to move a Listbox item up or down a list, sometimes to the top or bottom of the list. The programming for such a relatively benign function is involved. The Listbox must use a Row Source Type of Value/List with delimiters...

This is a simple but handy function that allows you to obtain the positions of characters within a text block. Say you have a line of text, or block of text, as follows: An apple a day keeps the doctor away. Now you would like to find the all the character positions of the letter “a” within...

In many cases, I’ve had the need to extract text from text blocks, such as HTML source pages, in a quick but highly comprehensive manner. The text is identified by providing the string for the text immediately to the left of the desired text, as well as providing the string for the text...

Perhaps the most fundamental reason for using a database is to process names. Specifically, a process that can automatically parse a name into its constituent name parts and provide a method in which names can be populated into their proper places is a great time-saver. For instance, if you...

There have been a couple of examples in this thread that has provided a return of a date from an occurrence of a particular day of the week, such as "3rd Wednesday in Month" function earlier. The idea was to simplify the function to a tight algorithm so it could be used for any Day of Week, as...

When you create an Access Report with a subreport control, you can use VBA to format the Detail section to create alternating colored rows. Unfortunately, subforms do not share the same versatility as subreports. However, you can create rows of alternating colors by adding a field to the query...

Very General Question What version of Access do you use? And if you use Access 97, why do you choose to use that over that of Access 2000 or higher? I am curious to find out the reasons. As for me, I use Access 2003 all around.

Just a small hint. When a query is created in VBA code, the smallest errors or ommissions can cause much time to be lost in troubleshooting, particularly with syntax. My suggestion is to create a string variable to hold the SQL string so it can be tested independently of the actual process...

This is not a specific problem, but a question I have in general about VBA code. I have seen a lot of examples from beginners to experts that use error code numbers to process a procedure, not just to trap an error. In my opinion, I consider it a very poor approach to code design. I wanted to...

My turn to ask for help. I have a Web Browser Active X control on my form. I have two command buttons, cmdForward and cmdBack, which navigate to the previous or the next page, using the GoBack or GoFoward method of the browser property. How do I identify when I am at the beginning or the end...