Search results for query: *

brilliant. Tat works wonderfully, Thanks, e

Hi, Thank you for the quick response. I can't seem to access that property. But I've put it at the beginning of the surboutine, but still not reordering.

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...

Leslie, That is brilliant! Thanks so much for the quick rep! Regards, Eric

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 Lightning, Can always count on lightning providing lightning fast results! It worked perfectly! Thank you for your time and help. It is greatly appreciated! e

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...

Hi, Have you found any sample references. if so, would someone mind sharing with me? thanx, e

Hi Judge, Thank you for your informative post. Indeed I have run across that entry. I'm excited about what it can do, but have yet to see results. I try running the code and I get an error: "database": user definied type not found. What would you suggest. Thank you for your response. e