Search results

  1. E

    SetFocus Statement

    The GotFocus event is triggered the second it receives the focus, as it is supposed to
  2. E

    Hiding things when starting Access2000

    Answers: 1. Go to Tools of the Access menu item, select Startup and uncheck the Display Database Window option. Also, make sure the AllowBypassKey property is set to False so a user cannot use the Shift key to circumvent hiding the database window 2. On the OnClick event of the Command Button...
  3. E

    How to total checks in checkboxes?

    Awww, Rich. Inquiring minds want to know. C'mon, share the love...
  4. E

    How to total checks in checkboxes?

    As a DBA, it's just force of habit. Consider it part of the new homeland security initiative ;)
  5. E

    How to total checks in checkboxes?

    Unzip this file. The solution can be found in this sample database I created under the Union Query (qryTestResults).
  6. E

    Noob Question..

    Access' Control Wizard (just make sure it's toggled on before you embed a control on your form) provides a speedy way to add controls to a form on the fly which contain built-in logic to perform many customary tasks like adding, deleting, and saving records, etc. Try this first.
  7. E

    Length and substitute

    Hi texasalynn, Here's a sample of the solution in an Access 97 database. Enjoy.
  8. E

    Help needed ASAP - Searching Dates

    Create an aggregate (Totals) query that includes a Count of the Title field. Add two new fields with the following expressions respectively: RecordMonth: Month([Recording Date]) and RecordYear: Year([Recording Date]). Do not show these fields in the final query (make sure the 'Show' checkbox...
  9. E

    Date Query Problem

    I mean Rich.
  10. E

    Date Query Problem

    I stand corrected. Thanks Max
  11. E

    Problems setting List Properties

    Try: ctlControl.RowSource = "qryHeadDetails" ctlControl.ColumnCount = 5 ctlControl.ColumnHeads = True ctlControl.ColumnWidths = "0 in;.5 in;.5 in;.35 in;.75 in" ctlControl.ListWidth = "2.5 in" ctlControl.LimitToList = True Make sure that "qryHeadDetails" has 5 columns. If you want the...
  12. E

    Problem with sql statement in ADODB recordset

    The code looks fine and it worked for me. I'm assuming you've enclosed this within a Sub or Function, right?
  13. E

    Date Query Problem

    Create an aggregate query where it groups the records by the date field. Save it as Query1. Then use Query1 as a subquery in a new query (Query2) and group it on the date field using the aggregate function, LAST :cool:
  14. E

    Using =Date()

    Instead of =Date(), try Date() in the criteria (and be sure the data type is set to Date/Time:cool:
  15. E

    Length and substitute

    Thanks Colin. I wasn't as diligent as I should have been when testing the code. I hope it worked out for texasalynn.
  16. E

    Length and substitute

    Open up a new Module and cut, paste and save this snippet of code: Public Function CharCount(strChr As String, strSearch As String) As Integer Dim iCounter As Long For iCounter = 1 To Len(strSearch) If Mid(strSearch, iCounter, Len(strChr)) = strChr Then CharCount = CharCount...
  17. E

    Special date question.

    No problem Hans, And thank you Dave for spreading the knowledge.
  18. E

    Special date question.

    Didn't try that. Pretty good. However, the correct syntax seems to be DateAdd("yyyy",-1,[Enter date]) instead of DateAdd("y",-1,[Enter date]). Also, it doesn't seem to work with leap years where the user may want to check the compare the last day of the month of the current year with the...
  19. E

    Special date question.

    Give me a day to think of a workaround for leap years.
  20. E

    Special date question.

    Try placing this formula in the date criteria of the field you are trying to retrieve the previous year's date: CDate(Month([Date:]) & "/" & Day([Date:]) & "/" & Year([Date:])-1) HTH, Edward
Back
Top Bottom