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 derfloh 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: PJ44
  • Order by date
  1. PJ44

    Updating Multiple Records at once

    Hey man, thanks for the star. And if you want to keep the paynow box checked for the records that have been paid, just remove the PayNow = 0 from the UPDATE string. I'm not real sure why I originally included that unless it was to ensure that all records were viewable in the query. Removing...
  2. PJ44

    Updating Multiple Records at once

    In the test db I did, the requery resorted them, but did not remove them from the table. Instead of changing PAYNOW = -1, my brain (faulty thought it may be) would set it back to 0 and create an on Load event on the form that says "If Not IsNull(DatePaid) Then PayNow.Enabled=False". Or better...
  3. PJ44

    Dialog box for report criteria: date range

    I think this is probably exactly what you are looking for. Good info for parameter queries and dynamic reports. http://www.fontstuff.com/access/acctut19.htm
  4. PJ44

    Updating Multiple Records at once

    Hey Aves - If I were to do this, I'd use a SQL statement in VBA that would run when an "Update Now" button is clicked. I did a quick test and here is what it looks like. Private Sub cmdGo_Click() Dim strSQL As String strSQL = "UPDATE Repairs SET DatePaid = '" & Me.NewDate.Value & "'...
  5. PJ44

    Help

    do you have another field in the query that stores the number of procedures performed? if so, just divide number dead by # of procedures, then set the format to Percent. PJ
  6. PJ44

    Help

    Try this. I just got done calculating percentages on a report of mine. =(DCount("[Procedure]","tblMyTable","[Survived]=1"))/(DCount("[Procedure]","tblMyTable","[ProcedureID]=243")) Breakdown: DCount - counts the number of records in a specific domain (ie table or query) "[Procedure]" - Field...
  7. PJ44

    how modify field so that only part of text string appears

    Likewise, you can use the RIGHT function to select characters on the right side of your string. This obviously dosen't apply to your situation, but still good to know. Left(field name or string,#) Right(field name or string,#) # equals the number of characters you want to see. So if you want...

Part and Inventory Search

Back
Top