1
  • How do I get a macro to move between workbooks?

    I have a template (workbook #1) that I would like to copy data out of and paste into the workbook that I run the macro from (workbooks 2, 3, 4, 5...). The problem is that when I record the macro from workbook, excel codes the name of that workbook, making the macro unusable in workbooks 3, 4, 5.......

    Bondsmith5 pointsBadges:
  • Case sensitive variables in SQL Server 2008

    Our company is using SQL Server 2008 with several databases. We just want one database to be case sensitive to names of variable but we don't want the others this way. We want to change the settings so we can run the following script without errors:DECLARE @A int DECLARE @a intHow can you change...

    ITKE54,985 pointsBadges:
  • Accessing another database using a variable

    I have a select like this: SELECT a.part_id, a.descript, b.location from PART_MASTER a, anotherdatabase.INVENTORY b where a.part_id = b.part_id Is it possible to use a @variable to identify the other database, rather than hard coding it? (I've tried @db2.INVENTORY b) but SQL SERVER 2000 doesn't...

    CO Bill120 pointsBadges:
  • Passing a Memory Variable from a Form to a Reprt in Access 2007

    In Microsoft Access, I am using a Form to set up parameters and run reports from a single database. One of the parameters is a report title. Within the Form, I have set up VBA code for running the reports. I am using a memory variable (strReportName) to store the title for each report, rather than...

    Greek19585 pointsBadges:
  • How to call a procedure in VB 6 depending on variable

    i have some procedure in vb 6.0 like sub a_on msgbox"A" end sub Sub b_on msgbox"B" End sub dim str as string 'str may be a_on or b_on str="a_on" i m planning to call procedure a_on or b_on based on the variable str how to call the procedure a_on or b_on depending on variable

    Jmbritto5 pointsBadges:
  • Concatenate many *CHAR variables.

    Is it possible to Concatenate many *CHAR variable in one same type variable. I've created a CL who will read records from one file and concatenate them in one varaible which i will use after in my CL. But after exiting the loop i got a varaible with the last record value so the concatenation...

    junioras400250 pointsBadges:
  • How to combine variables

    In my data set, I have four variables that have the same codes in them. The four variables relate to the same question that was given four different times to the same people. How do I get all of their responses under one variable so that I can work with it

    Onw3320 pointsBadges:
  • not a valid Query Management variable.

    Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement...

    Pmh5 pointsBadges:
  • Truncating parameters!

    I haev a 6 position alpha variable that has a value of '12345 ' (a trailing blank). When I submit a job that does a CALL to a pgm with that variable as a parm, the submitted job has the value of that parm as '12345' with no trailing blank. Both pgms declare the variable as 6 *CHAR. I know there are...

    JeffWilson20 pointsBadges:
  • Add variable to document. object

    I am trying to fill an input field from previou input field value if user click the check box next to it. The problem I am having was document.form_two will not take other variable. For example, document.form_two.ckb_iCount.value will not take iCount value. It suppose to be......

    Saung5 pointsBadges:
  • QMQRY not a valid Query Management variable.

    Hi there, I am trying to pass parameters to QMQRY but get the following error. CALL PGM(JCCSTREP2) PARM(C165) 'C165' is not a valid Query Management variable. Error found on STRQMQRY command. CPF0001 received by JCCSTREP2 at 2800. (C D I R) the CL pgm that call the query is as follows: PGM...

    NormFeile25 pointsBadges:
  • VC++: int keyword gives different results in Oracle 9i and 10g

    In my code i am using a structure with integer variable and this variable is used to accept values from generic VC++ 6.0 functions, the value which got filled to the variable is from a table field whose datatype is NUMBER(10), in oracle 10g it runs fine but in oracle 9i it always returns 0, any...

    SANS35 pointsBadges:
  • SQL Server 2000 connection to multiple databases using variables

    I have a fairly simple select statement that joins three tables from two SQL Server 2000 databases. It works fine, but now I need to run the stored procedure against different servers, so my hardcoded reference to the second database (currently coded as "secondDB.tableName.columnName") needs to be...

    CO Bill120 pointsBadges:
  • Adding a number to a variable title

    I am writing a program at work to help me design some irrigation equiptment. I have a section where I select which number span I am working on and then set it's dia. with a drop combobox and then it's length with a drop combobox. the values of these comboboxes are to go into labels so the user can...

    Angelus196515 pointsBadges:
  • %SST

    Hi, Im traying to get out put of this below mention simple logic code.But im geting out of different.(im trying with my laptop trhough my company server. DCL &FIELD1 *CHAR 10 VALUE('TCS AS/400') DCL &FIELD2 *CHAR 10 CHGVAR(%SST(&FIELD2 1 10))(%SST(&FIELD1 10 1) Can you tell me the value of field2...

    0 pointsBadges:
  • where does in memory the contant variable in C get store?

    Like global,static and local variables get store in data area and stack area respectively,where does the variable qualified as const get placed.Thanks in advance.

    Nagesh5345 pointsBadges:
  • Trying to achieve form data (variables) to be sent from one system (PHP) to another (ASP) via a GET Request

    On the PHP system, there is an existing form to collect user data; name, email, phone, etc. My ASP guy has created an asp page to receive the variables http://aspsite.com/regiser.asp The problem is that the PHP guy doesn't know what to do. Below are the variables: id (required) (MD5 Hash) email...

    Player-one5 pointsBadges:
  • Is there a way to Call a Lotus Notes agent from Access code and pass Variables?

    I'm on a Windows XP Pro System using M.S. Access 2003 and Lotus Notes 6.5. I provide adhoc and ancillary reports to our user community. We now have to send a hotspot to the users to inform them where their Excel files can be found. I created an agent that will send an email to a specific user, and...

    VinceP45 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following