Search results

Have been searching a while on this and other forums for a solution to this problem: I have a report that shows 79 rows of ranked data, only it all appears in the GroupFooter section. (Got rid of the Detail Section, for various reasons). I've been exploring forums to try and find a way and/or...

Thanks Pat, good advice. How would you place the code into each control's lost focus event? I'm not familiar with the lost focus event.

ssteinke, Thanks a TON!! That last link did the trick. I had to modify the code considerably, but it worked like a charm after that, with the ADDED BONUS of me expanding my knowledge of VB and Access. Again, Many Thanks for pointing me in the right direction! :D Here's how I modified it for...

SST, Thanks for pointing me to the message that has me on the right path. I copied and pasted the code, inserted it in the right place, changed the names of the fields to mine, saved and tried it out. However, the message box popped up, for the field that DID have text in it, not the field that...

Thanks, It certainly might, HOWEVER, I just don't know VB, so I'm not sure. I'm still learning. It "looks" like it should work..... I paste the code, and fill in the proper textbox names and see what happens. Where would I paste this code? I mean I can't just choose one of the required fields...

In searching for an answer to my just posted thread titled: "Urgent Required Field Advice Needed ", I was reading this thread. In reading the solution here, I *think* it contains the solution to my problem. Would the authors of this thread and replies take a look at my question and guide me in...

I'm looking for advice on the best method to accomplish the following from the esteemed members of this Forum (You all have provided excellent advice in the past to this Access Dummy, with my thanks), (I've also searched the forums without result): I would like to make several fields "required"...

Creating a query in Design View, how does one create a query in the "Condition" field that tells the Access to return the record set where the contents of one column is greater than the other? Table Name=SURVEY_RAW_DATA Column Name=TOTAL_EXP Column Name=TOTAL_NX There are obviously many more...

Yes I do. thanks!

Thanks Len, I'll give it a shot.

Yes, I think a PDF might work......how would I do that?

I've already tried the export to rich text, unfortunatley, it loses all the formatting from the Access report, in is very labor intensive for making the report look good again. Some of these reports are 22 pages long, and each page in MS Word has to be re-formatted. Thanks anyway for the...

Thanks Thanks Len, I'll give that a try and see how the quality looks. I'm also thinking of acquiring and using "Snag-It" to grab screen shots.

Thanks Andrew The last suggestion did the trick, the one with changes the picture property to (none). I hope MS realises that one option in the Auto Format dialog should be "None" Many thanks & Cheers, Ken

Am I missing something here, or is it impossible to remove the auto formatting on a form, like the "blueprint", "sumi painting" etc.?? I can't seem to just change the background to a solid color. How does one do this? Thanks in advance. P.S. I may just be thick, it's probably something...

I have a database that contains about 20 reports that I have designed. Here is the problem. How to export these report's pages onto PowerPoint slides? Any ideas? I've used the built in Tools/Office Links/Publish it with Word, and Publish it with Excel to no avail. What I'm looking for is to...

Have a table containing a column called "BOC" (Budget Object Code) that contains approximately 85 different 4 digit codes, with one selected for each row. (See sample below). Table has 30,000 rows of data. What I need to do is run a query that will give me a subtotal dollar amount for each...

Beautiful! Worked like a charm! Thanks SJ! Wonderful! Worked like a charm! Thank you so much SJ!

Does anyone know a way that I can create a simple listing of all the tables in a database? I don't need details of each table, just a listing of all the tables names in a database, preferably in a format that I can export to an Excel spreadsheet so I can save and print/manipulate/email them...