Search results

I am getting the following error message on a database that I converted from 2000 to 2007. Under the advanced options I have deselected the check box on the "Open databases by using record-level locking" and changed all the intervals to "0". Under the DDE operations I have selected the "Ignore...

I am way over my head on this one. I am using a database to track cable reels. Reel numbers are assigned upon receipt into inventory. The reel can be issued out or transfered to a different faciltity and then brought back into inventory. On the receiving form I would like to check to make...

I get an error message that I am missing an operator. Can somene please help me on this. I have tried using the SQL keyword LTRIM instead and keep getting the same error message. I have highlighted the problem area. Below is the code: 'Delcare variables to change the start date back 180...

I am using an 2 text boxes as input for a date range. All dates in our database is a string: yyyymmdd (example - 20090101). I am using the following RunSQL: DoCmd.RunSQL "SELECT ... "INTO mtblIssueSummary " & _ "FROM ... "WHERE KWODS_ODS_TIDPBOOK.TRANS_DATE Between (txtStartDate) and...