Search results

Well, I did a bit of research and testing on left and right functions and I'm now pretty confused... To start with I used (for example) Right(Space(10) & myBatchList("Status"), 10) That gave me the value of Status, exactally 10 characters, long but aligned to the right. Next, I reversed...

The text file is Courier New 10 point... same when the e-mail goes out. I think the problem is a lack of spaces on the short data (and too many on the long) so I don't think proportional spacing is really an issue. I'm thinking maybe I can build a function that either trims or pads the length...

Hey Dave! Actually, I'm using the value as a token replacement in the body of an e-mail message. It gets inserted into a saved text file and then that is used as the body of the e-mail. Everything works great except that the formatting can get a little ugly if the length of data is long or...

Nope... didn't work... Didn't actually do anything in terms of lining up the columns...

Oh, right... Forgot about that trick! But what if the value of MyOldFieldName is short? This would deal with long data but the same (if opposite) problem exists for short values....

At the risk of revealing my ignorance, how would I "force them to a certain length"? I think I would prefer that over letting the string get too long....

Okay, I am using a simple loop and pulling together a list of data into a string value while trying to make it look like a table of information. Everything works pretty well except that I'm having trouble getting my columns to line up. I have used vbTab to seperate the columns and that works...

Well, I'm already calling a text file for the body of my e-mail. I need to insert the data from the query into a specified point of that other text file. I believe I can do that using a token to mark where it goes and then a Replace command in the code to send the mail. I guess I need to look...

What error are you getting?

Okay - I'm not entirely sure how to ask this question so please bear with me... I need to place the contents of a DAO Recordset into a string value that can then be inserted into a text file that is the body of an e-mail message. The DAO Recordset is a query that will have from 1 to any number...

Ok... I finally got it to work... I had the ID field in the wrong place. It needed to be between the group and department fields. Works great now! Thanks!!

I did include the group name in the totals query... I've tried a couple of different ways to sort the result but it keeps comming out the same... I may have to just live with the sort order...

Well, they went to the bottom... All the Group totals... They don't stay with their groups when I do it that way...

Ok, so doing the union trick was pretty simple... The only problem I have at this point is that to get the totals, I leave the department null in the portion that does the totals. In the union, the sort order places that now null value at the top of the results rather than below for the given...

Mostly, I need groups and totals. Using the pure query results then doing the formatting in Excel causes an error the next time I export the data (it doesn't like it when I insert lines in the results). The purpose of the data is to show compliance totals at different levels of the...

Ok, so I need to get a results set from my Access application to an Excel Workbook. Normally, I would use a DoCmd.TransferSpreadsheet on a query result but in this case, I need certain formatting that I can only get via a report in Access. The code below is what I put together so far but it...

Paul - So you think I can run through the query results and use the replace function for all the records? I assume that would mean a loop but wouldn't the loop just replace the text each time? Or can I append the results with a loop? I'm not too sure how that might work though... The...

I need to come up with a way to place the results of a query into the body of an e-mail message that will be sent with Outlook. I already have a function that sends e-mail based on individual records in a table but I would like a seperate process that sends the entire contents of a query as...

I'd say you need to add a column to your table to store a true/false value once the late fee is assessed. The deafult value would be false; add a condition to your IF to check the value and then set it to True once you apply the fee. Just my $100 worth... :D

Paul - Ok, great! That works for looping through the list. Now I just have to figure out how to get it to do what I need! Thanks again!