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 IamaSherpa 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: *

  • Users: jwm
  • Order by date
  1. jwm

    Totals in subreports

    Thanks much...I had completely forgotten about that technique! My wife will be very happy...as will I, as I can now take some time to drink sme Georgian wine! :) Ciao...
  2. jwm

    Totals in subreports

    I'm stuck in Tbilisi, Rep. of Georgia without any of my Access documentation...help...on any number of levels! :) I have a report with two subreports and I need to sum the totals of the three on the report footer. I can't seem to hit on the right expression to sum "Total Report A" &...
  3. jwm

    Access 2002 & XML

    I currently use A2K but have a requirement to import some XML documents into an Access database for display on a webpage. As I have almost no experience with XML, is Access 2002 as comfortable with well-formed XML importation as MS would lead one to believe? TIA...
  4. jwm

    auto fill

    Following is the code I place on the After Update property of my zipcode field. You'll have to adjust the field names IAW your scheme. Private Sub strPostalCode_AfterUpdate() Me!strCity = DLookup("City", "tblZipCode", "Zip = " & "'" & Me!strPostalCode &...
  5. jwm

    Pass info to next form

    Joe: That was a nifty trick, "too obvious," and totally suited to my needs. Thanks very much! John
  6. jwm

    Pass info to next form

    Joe: Thanks! Now that seems to work, but was too simple...there must be a downside! LOL John
  7. jwm

    Pass info to next form

    Thanks, Scoty. However, I'm still missing the forest for the trees. I tried your method and it simply opened the form with nothing entered in the "memberID" field. The form opens with focus to the "memberID" field, but nothing entered in the field. I can manually enter a...
  8. jwm

    Record numbering problems

    The following will work, but I don't know if it's what you're seeking. Create your document in MS Word using the engineering notation choice, e.g. 1, 1.1, 1.1.1, etc., in "Bullets & Numbering." This will serve as your master document, as any paragraph additions/subtractions will...
  9. jwm

    Pass info to next form

    I have a form on which the user can lookup a specific member using a combo box. Due to many members having the same name, I want the user to ensure they have the correct member before proceeding. Once they've confirmed the member, I want them to choose among three forms, via a command button...
  10. jwm

    Using a dual monitor display with access

    I can't speak to Access 97, but I employ Access 2K on a dual monitor dispaly with no problems whatsoever. I can move the Access workspace between monitors and have the various toolboxes open on the 2d monitor withour cluttering the workspace.

Part and Inventory Search

Back
Top