Search results

  1. C

    Create a query to show rows with timestamps in between two times

    Hi Experts, has anyone done to Create a query to show rows with timestamps in between two timestamps? my variables are cutoff time and the current time where cutoff time is saved on a table (tblcontroltable.cutoff) a pseudo code of what i want to achieve is select date, product, timestamps...
  2. C

    Adding values to present column

    Hello All, I would like to ask why my code doesn't add my values? First off, I use the output of a query (qryTally) to set as my values to a table (tblOrderCountDaily) which sets all the count of a product ordered during a cmdbutton was clicked. If cutoff wasnt clicked for that day, it would...
  3. C

    UPDATE SET Sql not working

    Hello All, I was planning to use the said commands above via vba. (UPDATE SET of SQL) DoCmd.SetWarnings False 'adds the strSQL = "UPDATE tblCurrentOrder" & TblNum & _ " SET Table = '" & TblNum & "', OrderNumber = '" & OrdNum & "';" DoCmd.RunSQL strSQL...
  4. C

    Show report's print preview as display in subform

    Hello, I would like to show a report's print preview in a sub form. Is there any possible way? I don't want the user to see the datasheet view of the table so I decided to put on a report. Any idea would be appreciated :)
  5. C

    Hello Everyone :)

    Hello Everyone! :) Looking forward to learn and help the community
Back
Top Bottom