Search results for query: *

Is there a way in a MVS Cobol program to tell which CICS Region I am running in. I have to do different things depending on if running in test or production.

I recently did a upgrade on SPYWARE DOCTOR and after it finished installing and the inital scan was done, I could no longer get connected to the internet. I have attempted both a IPCONFIG /Renew and a repair on the devices. both come back with unable to refresh the ip address. I have check...

I am looking for a way to add a record number count to a selection query like below: select field1, field2, field3 from table where field1 = 'data' output is: field1 field2 field3 ------ ------ ------ data data data ... ...

I have a scheduled task that runs fine as long as the screensaver is not active, once I turn that on then the task will startup but not run to completion (waits until either times out, or user logs on). How can I have these task run while the screensaver is active. The user has full admin...

Is there any way to have the steps in a macro wait untill the previous step has finished processing. I have a macro that 1. opens a table for the user to input the date range for this run. 2. The I want to execute som VBA code that takes these datea and appends a temp table all the dates in...

I have been able to create and Regular Expression that finds all the lines that begin with the following phrases (HDR,SHP,BIL,INS,CNT). ^((HDR)|(SHP)|(BIL)|(INS)|(CNT)) What I need to be able to find is all lines that DO NOT match these. I have tried multiple things and it either still finds...

Is there a way to refresh the link to an Oracle Tale from withing VBA Code when a password is required? I have code that will walk though and refresh other links to MDB databases, but have not been able to get to work with the Oracle Tables. This is the code that I am using to refresh the...

Is there a way to refresh the link to an Oracle Tale from withing VBA Code when a password is required? I have code that will walk though and refresh other links to MDB databases, but have not been able to get to work with the Oracle Tables. Thanks

Is it possilble to call a VBA routine that is in the BE from a form in the FE or does the code need to reside in both (creating a maintenance nightmare). Little background: I have some routines that are run at night that import data and do some data edits before the users come in. Since that...

I am trying to run a specific query that is pre-defined as a stand-alone query inside of my VBA Code using the "RUNSQL" command as below: DoCmd.RunSQL "#GetFirstCustomerCall", 0 the query contains: UPDATE tblCDNCustData SET tblCDNCustData.tblFCareRepName = funReturnUser() WHERE...

I am trying to pass a parameter to a query based off a field on my form. I am trying to get what is in red to come from the form, but it keep giving the popup asking for the parameter: Thanks in advance SELECT DISTINCT TOP 5 [qryHistoryUniqueRecords (No Dup Phone #)].hstCallDate...

Is there anyway to create indexes on the fields in a Linked Text File. I have a file that contains approx 3 million records that i would like to link to rather then import on a daily basis. The import takes forever where the link is very quick. Only drawback is that I not been able to find a way...

I have set up my out of office with a rule that any e-mails sent directly to me or by cc to be forwarded to my home E-Mail address while I am working from home. This is not working, is there something else that I need to setup to allow this. I can send a new E-mail to my home address with no...

What are the procedures to split the database into FE/BE that the link to the tables references the network path rather then the drive letter: Link currently has ~ Z:\hereitis_be.mdb want to have ~ either DBHere$\hereitis_be.mdb or \\SeverName\DBHere$\hereitis_be.mdb different User may not...

I have one form that everytime I open it it appears to lock up the application. If i have the database opened bypassing this opening form and go into look at the design of it, it also seems to disapear. I found it be accident by move the scroll bars all the way down and to the right. Once...

I have one form that everytime I open it it appears to lock up the application. If i have the database opened bypassing this opening form and go into look at the design of it, it also seems to disapear. I found it be accident by move the scroll bars all the way down and to the right...

I have a text file that I am trying to import that has the date in the following format "05/14/03 04:54:00 PM". I have the advance import specs setup as MDY, with the / as date sep, unchecked 4 digit years and checked leading zeroes in the date. Every time I import I get a type conversion...

Is there a way to create a x-ref that displays where procedures and functions are used along wether or not variables are used. I have rather large application with both code in the forms along with module code. I am trying to clean it out of all dead code and varibles that are no longer in use...

Is there anyway to tell which index are being used in a query? I want to be able to verify that these are using the best index available or if the query needs to be adjusted to pick a better Index to enhance the performance. Thanks in advance.

Is there a way to create a x-ref that displays where procedures and functions are used along wether or not variables are used. I have rather large application with both code in the forms along with module code. I am trying to clean it out of all dead code and varibles that are no longer in use...