Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Iendyar

    Exporting fields into Word document but some fields won't show up

    Okay :) Reading the 3nf paper now Iendyar
  2. Iendyar

    Exporting fields into Word document but some fields won't show up

    Yes, I can see the values in the table. I am going to restructure the tables as you have recommended. I have tried recreating the mail merge process, but not using a query. It will not show me the properties of the field in Word. Iendyar
  3. Iendyar

    Exporting fields into Word document but some fields won't show up

    Oh, and those are fields in the table. Iendyar
  4. Iendyar

    Exporting fields into Word document but some fields won't show up

    Okay. Thank you so much for your help and your valuable time. Iendyar
  5. Iendyar

    Exporting fields into Word document but some fields won't show up

    Okay, sorry the server was down. The structure is as follows: ID which is autonum ContractNum number which is a number assigned by the company. Date but you told me I don't need that Bank Text FirstName Text LastName Text StreetAdd Text City Text State Text Zip Number HomePhone Number...
  6. Iendyar

    Exporting fields into Word document but some fields won't show up

    These fields are also currency. I don't see anyway to set the field type to calculated. Iendyar
  7. Iendyar

    Exporting fields into Word document but some fields won't show up

    Nope, that calculation is in the properties (control source)in the form. Yes, those are the same field. Iendyar
  8. Iendyar

    Exporting fields into Word document but some fields won't show up

    The calculations are in the control source on the Text box in the form. Is that the wrong way to do it? Iendyar
  9. Iendyar

    Exporting fields into Word document but some fields won't show up

    I just created a query with the data that I want to use. Here is the SQL: SELECT [ContractNum], [Date], [ReferalName], [Bank], [FirstName], [LastName], [StreetAdd], [City], [State], [Zip], [HomePhone], [Fax], [Other Phone], [LotNum], [BlockNum], [SecNum], [SubDivision], [HomePrice], [LotPrice]...
  10. Iendyar

    Exporting fields into Word document but some fields won't show up

    No, the document isn't called out from access yet. I was designing the template first, then I was going to try to call the template and fill in the fields using the current record. I just looked and there is not a query for the mail merge listed in my queries. Thanks, Iendyar
  11. Iendyar

    Exporting fields into Word document but some fields won't show up

    Not really sure how to use SQL. There is VB on these machines, but really haven't used too much of that either. I am an Access newbie :)
  12. Iendyar

    Exporting fields into Word document but some fields won't show up

    Here are the calculations for those fields in the control source block TotalPrice=[HomePrice]+[LotPrice]+[SitePrep]+[Contractextras]+[Contractextras1]+[Contractextras2]+[Contractextras3] CashReq=[TotalPrice]-[ProposedMtg] FivePer=[TotalPrice]*0.05...
  13. Iendyar

    Exporting fields into Word document but some fields won't show up

    I used the mail merge in word to populate the fields, I didn't write any code to do it. HTH, Iendyar
  14. Iendyar

    Trying to put command button to open an excel file on an access form

    Thank you all so much. Your help has been invaluable! Iendyar
  15. Iendyar

    Exporting fields into Word document but some fields won't show up

    I have created an access database that computes all the values for a contract to purchase a new home. There are 3 fields which add or subtract currency amounts to compute total price, 5% of total price for downpayment and one that computes the difference between purchase amount and mortgage...
  16. Iendyar

    Trying to put command button to open an excel file on an access form

    Thank you all for your help.
  17. Iendyar

    Trying to put command button to open an excel file on an access form

    Hi all. I have been trying to figure out how to put a command button that will open an excel file on a form in access. I have had no luck. Any help would be greatly appreciated. Thanks in advance

Part and Inventory Search

Back
Top