Search results for query: *

Hi, I have a subform that displays the contents of a query in datasheet view. Now I know that I can order the column by right clicking, but I'm trying to implement an option box that will order all the information by whatever predefined ordering I desire. I had a working model of it code...

Hi, Does anyone know how to create a macro to repair/compact a DB. My goal is to have the macro automated so that it will repair/compact my DB then make a copy of it and save it in a separate directory. Any suggestions/pointers would be greatly appreciated as I'm quite new to this...

Hi, I'm trying to create a macro in MS word that will take my selected text and make every character lowercase. Better yet would be a method to make the first letter of the sentence UPPERCASE and the rest lower. Thanks in advance, e

Hi, I'm trying to make the code a bit better. Do While (exit condition that works) ProgNo = rst![ProgramNo] 'from another table, this changes on each iteration thru the loop 'inefficient!!!!! there should be a method to requery without opening and closing each time rst2.Open "SELECT...

Hi, I'm trying to use access to generate a word document. Specifically I'm looking for any sample code on how to generate write text that will be of the form bold, italics, heading styles (or any combination of above) As well, if anyone know how to generate a Table of Contents using VBA that...

Hi, I'm woondering if anyone knows how to put headers and footers in word documents generated from access. To make thigns a bit more trickier, i'm wondering if anyone knows how to get it so that the first page does not contain the header/footer. I can access some sort of function...

Hi, I'm looking for a guidance/examples on how to format a word document using VBA. ie. 1. how to add a header/footer 2. how to add a carriage return between fields 3. how to add an image currently, I have it set up to write all the data to a string and then output the string using the...