Recent content by dhebert

I was able to finally determine it was the ODBC DNS that needed to be changed. If anyone runs into this situation please don't hesitate to contact me and I can explain how I corrected the problem. Dave

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...

Yes, I see that worked also. Thanks to both of your for your help with this. It's great to be able to go to resources that can solve simple problems for us beginners. Thanks again, Dave

That's the answer!!!!! I have been struggling with that for hours. Thanks for your quick response. Your help is appreciated!!!!! Dave

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...

Thanks Paul. I was hoping there was an easier way. Yes I'm running queries against our Enterprise database and I can't believe it was developed with the date range as a string. I am constantly using Format or Mid, Right, & Left functions to convert dates. It is a pain. Thanks again for your...

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...