Search results

  1. R

    exporting to .rtf from a report with a sub report

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

    Alternating Color

    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?
  3. R

    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 entering the selection is...
  4. R

    Wizards Not Working

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

    select a record and send info to a field

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

    dissecting a field

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

    dissecting a field

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

    dissecting a field

    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!
  9. R

    show only the newest date

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

    MSword Publish

    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?
  11. R

    MSword Publish

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

    find not equal fields

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

    find not equal fields

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

    find not equal fields

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

    find not equal fields

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

    find not equal fields

    I need to see what is on table A but not on Table B. Meaning table A has expanded and there are new records. I would like to find what those new records are and then add them to Table B. Some of the records on Table A may have changed as well and I'd like to see what they changed to before I...
  17. R

    find not equal fields

    If I have a table that I built off a master datasource (Not in ACCESS) and need to update my table with any new data from the master source how do I do it. I'm kinda of newbie that is self taught with no visual basic skills. I tried the search but could not find or understand what was being...
  18. R

    udate Query

    Some months I will have 200 recods that will need to updated. I really don't want to go thru the process of picking out the oldest one. I haven't tried a total query unless it's in with a duplicate query. I will try it. But you said append? I don't want to add to the inventory but replace the...
  19. R

    udate Query

    I am trying to write a update query for our rental equipment business. In my rental Table I have a primary field[rental number] then [stock number], [date in], [date out] [date2], and [hours]. Every month i want to update my Inventory tables fields[new hours] and [date of new hours] with [hours]...
  20. R

    Open Form Actiom

    Good Morning, I created a command button and trying to write an on click command. I created a macro to open a form. I want to open this form and to filter all records where the fields are =. In the where condition i used expression builder and put [CUST NAME]=[Rental Form]![customer]. I tried...
Back
Top Bottom