Recent content by roley

I made a report with a subreort and I want to export it to a word doc for my printer. Because I have a subreport it won't let me. Am I doing anything wrong? Is there a way to get around this? I have no Code knowledge. I get by with Macros I'm sorry to say.

Can I alteranate the color of the background? I would like to make everyo ther record have a gray background. I don't know code. Can anyone help me?

My wizards don't work. I've triedd to repair Office from the disc, from detect and repair, and I've tried to reinstall Office five or six times. I will for example go to reports, label wizard, find the table for my labels, click next and then nothing. The box that I was entering the selection is...

MY WIZARDS don't work My wizards don't work. I've triedd to repair Office from the disc, from detect and repair, and I've tried to reinstall Office five or six times. I will for example go to reports, label wizard, find the table for my labels, click next and then nothing. The box that I was...

I'm a book taught user with no VB Code experience. I have a database that has over 1000 pieces of equipment in it. Each piece of equpment has an equipment type. Each piece of eqipment type has an equipment size. In my form I would like to have a command button that would open a form listing the...

Also there are some addresses in there as well. I think I can get those out by using key words "road" & "street"

There is no pattern. Some city have a comma some don't some state or NY some are N.Y. some are New York some zips are 12345 and some are 12345-1234> It really is a mess. I got two fields like this to do. Apparently over the years people added this to line 4 or Line 5 with no rhyme or reason in...

I got imported to me a field that has city, state and zip all in one field. I don't know code and am a self starter. How do i dissect and break this up to it's rightfull 3 fields. MOST of the cities have a comma after it. There are about 4600 records to do. Please help!

Warning not a PRO. I have a query that i use to keep track of rental equipment. When the piece comes in off rent we record the date it left and when it came back, as well as it's "hour" meter. It's like a speedometer to tell us how long it has been running. At the end of each month i run a...

Really, Access make it hard to send word docs. I thought in my inexperience I was missing something. The report is about 18 pages worth. I'm unfamiliar with mail merging except for insert fields. Can you do a whole doc with merge?

What I'm trying to do is take my report and email as msword. The only way I have found is to publish it with MSword then email it. When I do that I loose certain graphics such as lines drawn to seperate the rows. Any suggestions. Doing a Snapshot is no good for my audience and I don't have PDF...

DCX, I appreciate your stick-to-itness. I seen this type of wording in my searches: SELECT TableA.ID, TableB.ID, TableA.Firstname, TableA.Lastname FROM TableB RIGHT JOIN TableA ON TableB.ID = TableA.ID WHERE (((TableA.Firstname)<>[TableB].[Firstname])) OR (((TableB.ID) Is Null)) OR...

no if you just run it, it shows all the records that are equal and not the ones that are not. I would like to see if the address is different which is right. If the phone is different. If there is a new entry to Table A is he already in Table B as a Temp and then should I change his name in...

I'm sorry DCX maybe I'm not making myself clear. The thread made no sense with what i'm tryng to do. I know how to do an update query and/or append query. What I'm having trouble doing is finding which what has changed in table A in relation to table B. In other words Table A has 20000...

I would like to synch the two tables but the only way i get the info from table A is thru CSV. It is an old DOS system that is very user unfriendly.