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!

Recent content by Qino

  1. Qino

    Update Memo field and not allow edit of old info

    Excellent! Thank you Knicks, I knew I was in the right neighborhood with the code but I just couldn't get it to do what I wanted. Now I have this version which works fine: [COLOR=blue] Me.Correspondence.Locked = False Me.Correspondence = Now() & "--" & CurrentUser() & "--" & [ADD] & vbCrLf &...
  2. Qino

    Update Memo field and not allow edit of old info

    Well, even if I create a seperate table, it needs to be accessed and added to by all users, but edits and deletes limited to myself and a few others. The request was to have it in a memo field because that is something all the users are familiar with. Is there some way to link this to a word...
  3. Qino

    Update Memo field and not allow edit of old info

    I have the following code in a subform which adds the date, user and a dividing line in a memo field: Private Sub Command2_Click() Me!Correspondence = Now() & "--" & CurrentUser() & vbCrLf &...
  4. Qino

    Subform to filter tables

    When I got this it had most of the 175 fields (7x25) bunched into two tables, I simply broke up the info into the more logical grouping (by category) rather than year. When I search a given ID I need to be able to pull up (even if one at a time) all 25 years worth of the 7 categories of...
  5. Qino

    Subform to filter tables

    I have seven tables I need to query at once and display the results requested. Each of the seven tables lists the unique ID and 25yrs of data (ie. certification or state of project) I need a subform within the main form (which lists basics like address and contact info) to query the seven...
  6. Qino

    Unable to count by multiple fields in Report

    About 3 hours after I posted I ran a second query on the same data which totaled exactly as I needed and did the calculated field. I just added it to the report as a sub-report. It seems so obvious now.
  7. Qino

    Unable to count by multiple fields in Report

    I've had great difficulty getting my report to provide a breakdown of totals by three fields, and calculate the final field. I can get a total count no problem, but several dead-ends and now I need a push in the right direction: I have this: Type Quality Size 20 A...
See more

Part and Inventory Search

Back
Top