Search results

  1. J

    Load Form with Max Date

    TranDte type is Date&Time in the table. I want the form to load only one day worth of sales. There is a record for each product type per day. So the form might have 9 or 10 records displayed (one for each product that day) and the user can move through days to view the sales.
  2. J

    Load Form with Max Date

    Alright I've added an ORDER BY to my Query and selected the TOP 1 in my form. Oddly, my top date in the query is 7/19/2013, but the form is starting on 7/1/2013. Progress. Thanks for pointing me in the right direction. Private Sub Form_Load() DoCmd.OpenForm "FrmSalesInp", acNormal, ""...
  3. J

    Load Form with Max Date

    I'm using this form to go forward/backward through dates and allow for searches. So the form needs to be multi-purpose. I have all of the functionality working except for the On-Load (where I want to start with the most recent date). If I base the form off of this specific query I would...
  4. J

    Load Form with Max Date

    Hey, I'm trying to open a specific set of records when the form is first opened (namely the most recent date that was added). I'm trying something along these lines and am simply unable to get it to work: Private Sub Form_Load() Dim strQry As String strQry = DMax("TranDte"...
Back
Top Bottom