Search results for query: *

Bob, thank you very much!! Dan.

Hi all, is it possible to select records two months back in a query. Can one select records with date range of >=3/1/04 and <=3/1/31 using a function? The function needs to calculate the monthend. Thanks, Dan.

Thanks Glenn. It's clear now. Also thanks to Dimandja for asking. Dan.

please expain what DB-OK and NOT DB-OK actually mean. Thanks, Dan.

Thanks Glenn. I've always wondered about that but couldn't find the explanation. Dan.

Thanks Dimandja. This was bugging me! Dan.

I've seen L-O-I in other people's code, but do not know what it means: CALL "DBGET" USING DB-MHS-BASE DS-CASE-MANAGEMENT-SET DB-MODE-6 DB-STATUS L-O-I DI-MHCASEMG-BUFFER DB-MODE-6...

Thanks Brian and Dan! Dan.

Is there a function I can use in a TRANSACT-SQL statement to make this date conversion? Thanks, Dan.

Thanks cmmrfrds. This code will be quite helpful. Dan.

Is it possible to use ADO in to set a field as a key? Thanks, Dan.

Thanks JeremyNYC for getting me on track. Dan.

Hi Eric, thanks for the link. I pulled this from the link: &quot;Please note that this technique affects the Close button on the application window of Microsoft Access, not the Close button on the Database window.&quot; I'm not sure if the problems with table locking comes from the close...

I've been told that when one closes Access with the &quot;x&quot; on the title bar, locking problems occur with multiple users, but if Access is closed using Quit for File menu/Exit, this problem doesn't occur. Has anyone heard of this? If so, can the titlebar &quot;x&quot; be inactivated...

Good idea Bob. Dan.

OK, thanks guys. Appreciate the responses. Dan.

Hi all, in HP COBOL II, we use CALL INTRINSIC &quot;QUIT&quot; to abort a Cobol program in such a way as to cause the JCL to abort as well. Is there a standard Cobol statement that will do the same? Thanks, Dan.

Hi jimbOne, sorry 'bout the confusing question. I tried to requery the recordset using the where clause in SQL and thus crashed and burned. I realized all I had to do was loop through the existing recordset and compare the input key value with rs!myKey. Everything works fine now. My...

Hi All, I have a form where I can push buttons to move forward or backward in the recordset. Searching for a key field works OK as well. After the search, however, the movenext and moveprevious methods &quot;remember&quot; the position in the recordset before the Search. Is there a way to...

Thanks Glenn and Dimandja. I gave both of you stars for your expert postings. Glenn, I did as you stated and it was accepted as standard Cobol. Dimandja, thanks for clarifying that. I would never have guessed! Dan.