Search results

I apologize for the delayed response to your question. Just in case anyone else is looking for this ActiveX control it's located at http://www.lebans.com/xjustifytext.htm Hope this solves your issue.

Good morning everyone, I need help with creating a query with two tables. Table A contains multiple records with the same ID number and SERVICE DATES (Some service date may not contain a date [BLANK]). Table B contains multiple records with the same ID and STATUS DATES and a STATUS FLAG that...

You did it again David! I was able to download the ActiveX control, install it and then edit my report using the ActiveX control called Access Justification Control ver2. I simply used the Insert menu and select ActiveX controls. The ListBox that pops up contained a listing "Access...

I understand it's a limitation or flaw in Access format within reporting. Wonder if the latest version has this problem? I will try the ActiveX control and let you know if it worked. Thank you again.

This works with one issue, if the last line is a 2 to 4 words the distribute format extends the words to the end of the line. instead of leaving it as is. Example: Dear brothers and sisters, when troubles come your way, consider it an opportunity for great joy. will look like this: Dear...

Hi, I'm creating a form letter in Access 2002 and the letter is completed but I want to change the formatting from align left to justify but can't find a way to do this. The detail section contains 2 label boxes and 1 text box. Can this be done?

The code worked, never had a doubt. Thank you.

Yep that was the answer. I entered your code into the query and it worked perfectly. I have one more issue and instead of taking an hour to figure it out I know you will have the answer quickly. I have a gender field F=Female and M=Male I want to query that field to determine if the title...

No rules for the date. I just need the date I enter to display in the letter. I'm creating a button to print the letter. Before the letter is printing it will prompt for various group numbers and at the end it will prompt for a date. I will use this date in the body of the letter, for all...

Hi everyone, I'm using MS Access 2002 and I need some help with the following, I'm trying to create a prompt for a date and then enter that date into the body of the letter. Also can the date format be short and converted into a long format on the letter. Example: Prompt - Enter Date Date...

thanks for the quick response I will try it over the weekend and let you know how it went.

Hi all, I have a field that is populated the a single letter code. I want to write a query that will assign a number to the code. CODES = ASSIGNED NUMBER H = 2 W = 2 If the code is not H or W = 3 If there is no code or blank = 1 Thanks

Your correct 9/31/2012 is not right, I mistyped the date it should have been 9/30/2012. I corrected it.

Sorry for not responding sooner guys I was really busy. I was able to figure out what I was going to ask. It was taking a true termination date Ex. 9/5/2012 and then displaying the last day of the month 9/30/2012 from the true date. I used the following code: Termination Date...

Thank you. The Union worked great! Can I bother you with another request or should I create a new post?

Here is a sample of the database. Hopefully this will answer your question about it being an improperly structured database and why aren't they all in the same database.

Hi all, I need to take the ID#, first, and last name of one table and the ID#, first, and last name of another table and create a query that will display/merge all the ID#'s, first, and last names of both tables. I can provide a sample database if needed. Thank you, Rinova

This works perfect! Awesome! Thank you! Thank you! Thank you!

Your right the dependent was active and the spouse was terminated. Thanks for correction.

the database was not created by me, I usually ask the staff what the codes mean and then document it. Thank you all for helping me out.