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!

  • Congratulations Mike Lewis 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. Centurin

    Create a Query that Returns one Record

    Also, this part of the code, 'these are the listing of the export specifications. Public Const exExampleSpec1 As String = "exSpec1" Public Const exExampleSpec2 As String = "exSpec2" is giving me an error stating constants, fixed-length strings, arrays, user-defined types, and declare...
  2. Centurin

    Create a Query that Returns one Record

    I have a couple questions about setting this up. In the fact is says I need: 1) a working text export specification, 2) a sample text file containing data using those specific fields, and of course, 3) a Word mailmerge document. I found a guide to creating a text export spec, but I'm not sure...
  3. Centurin

    Create a Query that Returns one Record

    That clears it up. Thanks
  4. Centurin

    Calculated field in a Form

    I'll give that a try, thanks.
  5. Centurin

    Create a Query that Returns one Record

    In that faq, it stated usage as Private Sub cmdPrintInvoice_Click() RunMailmerge "SELECT * FROM qryInvoicesFormatted " & _ "WHERE CustID = " & txtCustID.Value & _ " AND SaleDate = #" & _ Format(txtSaleDate.Value, "mm/dd/yyyy") & _ "#", "exInvoice"...
  6. Centurin

    Calculated field in a Form

    I have a number of price fields in a form. I want to create a command button that will add them up and put them in a total field. I realize that I can do this with a query, but I need to be able to change the total field if I wish. My main problem is that I haven't done code in Access in quite...
  7. Centurin

    Create a Query that Returns one Record

    Hi guys, I'm trying to make a Mail Merge document in Word using a form on my database. I've looked at faq181-271 and faq181-28. What I want to do is simply have a command button that uses data from the current record in my form to create a word document using mail merge. The Faq recommends to...

Part and Inventory Search

Back
Top