Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Programming

52K

Solutions

40K

Contributors

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Share tech news, updates, or what's on your mind.

Sign up to Post

I have a spreadsheet that gets opened automatically every day to pull data from other sources. I have a list of dates for every work day for the year in column A. In column B in the first row I have a formula to start. None of the other rows in column B have this formula yet. What I need to do is when the file is opened every morning automatically I need the formula to be copied down to the row that has the current date in column A and then paste the values in the row where the copy originated from. For example if A1 is 1/17/18 and the formula is in B1 I need to take that formula and copy it to B2 since A2 is 1/18/18. And then paste the value that is already in B1 so the formula is no more in B1 and is now in B2. How can this be done in VBA?
0
Become an Android App Developer
LVL 11
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Hello All,

This is an extension of a question here - https://www.experts-exchange.com/questions/29071843/Display-Query-Results-in-Message-Box.html

I'm trying to "cache" the results of the input box and re-use it on reload of the script.

My thought is this:

Is it possible to send the result of objRecordSet("ID") to a spreadsheet, then put that result from the spreadsheet as the default data in the input box?

So, the below code works fine. It populates the fields as it should but I want to send the objRecordSet("ID") to the
spreadsheet and retrieve it from the spreadsheet at reload of the script to be input box default value - see bold font I added that's not part of the original script.

So, in effect each ID the user enters in the input box will be the default value when they re-run the script.

If there's another way to do what I'm asking, I'm all ears! I hope this makes sense, thanks!


strKey = InputBox("Enter Person ID","Search", MyDefaultValue)
If strKey = "" then
Field1 = ""
Field2 = ""
on error resume next
Else
strConnection = "Provider=SQLOLEDB;Server=;Database=;User ID=;Password="
strSQL = "SELECT * FROM Table1 where ID LIKE '%" & strKey & "%' or User_Name LIKE '%" & strKey & "%'"
Set objConnection = CreateObject("ADODB.Connection")
objConnection.Open strConnection
Set objRecordSet = CreateObject("ADODB.Recordset")
objRecordSet.Open strSQL, objConnection, adLockReadOnly
do while objRecordSet.EOF = false
Field1 = …
0
Hello Experts,

I have run a hql called samplehive.hql, see attached. However, the script fails with the following error:

FAILED: ParseException line 1:2 cannot recognize input near 'D' 'R' 'O'
18/01/17 20:46:46 [main]: ERROR ql.Driver: FAILED: ParseException line 1:2 cannot recognize input near 'D' 'R' 'O'
org.apache.hadoop.hive.ql.parse.ParseException: line 1:2 cannot recognize input near 'D' 'R' 'O'

I'm very new to Hadoop Hive, can someone take a look at the script and let me know where I'm going wrong

Thanks
samplehive.txt
0
Why are these columns in Amibroker not filling with data when IB data is enabled?

https://www.screencast.com/t/cKtchTvX1Y5
0
Hi there!

I have an issue preparing an installation of Python/IDLE in one of my client's team computers. Basically, I prepared a couple of scrappers using Python and Selenium. The packages being used on my scripts are selenium, openpyxl, and python-docx.
However, I can't even get to installing the packages on that machine, because one I execute the Python installer from the website (3.6.x), the insteller won't. I tried using admin rights, disabling antivirus, I checked the correct processor architecture, and I still can't get to run the installer on that particular machine. In other team members I was able to installe in their machines. I have run out of ideas to trouble shoot this. Could you please point me to things that I can try out to run the installer Python/IDLE installer?

Thank you so much!
Any help is greatly appreciate it.
0
Hi there!

I have an issue preparing an installation of Python/IDLE in one of my client's team computers. Basically, I prepared a couple of scrappers using Python and Selenium. The packages being used on my scripts are selenium, openpyxl, and python-docx.
However, I can't even get to installing the packages on that machine, because one I execute the Python installer from the website (3.6.x), the insteller won't. I tried using admin rights, disabling antivirus, I checked the correct processor architecture, so I give up trying to install the officitial distirbution in that machine. In other machines I don't have this problem.

So I was wondering if you could recommend other Python distributions for windows that can enable me to run my scripts using the mentioned package? I saw some alternatives such as PyCharm, but I am not sure if that will help.

Can someone confident recommend some for this case?

Thank you so much!
Any help is greatly appreciate it.
0
Can I assign co line 6 to a phone number as  part of system programming I want this a a 'panic' button to call a specific outside number
0
I created a main form with a datasheet subform that includes 4 fields: ID, Product, MinimumStock, StockOnHand. Subform record sources are from a query.

I now want to add a checkbox field onto the form, so the user can select products that are under minimum qty and then by clicking a button on main form to generate a Production Order of records ticked.

Also, it is possible to show updated stock level in the main ProductTable? How this can be realised?

I just started learning Access for couple months, and only know very little about Macro and VBA. If any programming is needed, please kindly post the code as well.

Thank you for your help in advance.
0
Hi, so I've got an Ionic 3 app which has a native camera plugin and onesignal plugin as well for notifications.

The native camera plugin works fine in Ionic View or DevApp, and onesignal works when build it to an APK and run it natively on my Android phone.

However, when I use an emulator to run it, even on IOS, it comes up with cordova_not_available. And even the cameras don't work. i run the command

ionic cordova run android or ionic cordova run ios

Emulator shows up but the issue is that cordova doesn't seem to be compiled in. Thus causing cordova plugins to fail.

What can possible be the issue? I've removed all the plugins and android/ios platform, re-installed an still the same.

It's kind of difficult to develop the OneSignal notification when I can't run it with the emulator.

Anyone who has come across this, please advice.
0
Im trying to do a transfers but they are all pending but Eth never leaves my wallet.
They are all under SIGNER and local transactions.

Im not sure did they even leave my computer?
If I go to TxQueue Viewer I see this
Parity.JPG
Can anyone tell me whats is wrong?
0
Receive 1:1 tech help
LVL 11
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

We are converting some BBX/Pro5 Business Basic data files for a customer.
I can read all of the fields in the file except for the DATE fields, which are stored in some kind of packed format.

Here's an example of the file layout:
-------------------------------------------------------------------------------------------------------------------
REF NAME               DESCRIPTION                            MASK/FORMAT   POSITION
PAYMENT DATE      CURRENT PAYMENT DATE      MMDDYY B   1(45,3)
   ENCRYPT WITH:         DECRYPT WITH:

DUE DATE               CURRENT DUE DATE                MMDDYY B   1(48,3)
   ENCRYPT WITH:         DECRYPT WITH:

DISCOUNT DATE    INVOICE DISCOUNT DATE      MMDDYY B   1(45,3)
   ENCRYPT WITH:         DECRYPT WITH:
-------------------------------------------------------------------------------------------------------------------

Opening the file and reading into a string variable results in garbage.
Since the field is only 3 bytes, there must be some way to define a field other than as a string.

Does anyone still remember this and would be willing to point me in the right direction?

Thanks!

John -Z-
0
hi,

what is difference between control shift L and call hierarchy(control+alt+H)  in eclipse debugging the code.
what are best debugging techniques or tips

please advise
0
We have 4 RDS servers, and 1 RDS Gateway Server which is also the Broker. The 4 Session Host servers is divided into 2  Sessions Collections. When a user RDP into the Gateway he is getting redirected to the Wrong Session Collection.

I have search the internet and can't find a proper explanation on how to broker decide to which Session Collection to send the client. I thought it was based on the group you add when creating the Session collection.

Please any help on this will be much appreciated. The outcome is to have say User Group A to always go to Session Collection A and then User Group B to go to Session Collection B.
0
I have to open csv file after creating from Powerbuilder.
Upon creating csv file , I have to open csv file as excel file automatically.

So I think it is better to use command prompt.
How could I open csv file as excel by using command prompt?
0
I've created a custom API for internal use and have query strings used to find specific assets - http://localhost:3000/api/asset?ipaddress=10.1.1.100 ... returns 1 device

What I would like to do is return results for all devices with the ip address that contains the substring in the query string - http://localhost:3000/api/asset?ipaddress=10.1.1 ... returns all devices within this subnet. Right now, this returns 0 devices.

Here's the structure of my router(s) -

router.get('/', verifyToken, function (req, res) {
    const query = {};

    if(req.query.clientcode)
        query.clientcode = req.query.clientcode;
    if(req.query.assetkey)
        query.assetkey = req.query.assetkey;
    if(req.query.name)
        query.name = req.query.name;
    if(req.query.siteid)
        query.siteid = req.query.siteid;
    if(req.query.ipaddress)
        query.ipaddress = req.query.ipaddress;

    asset.find(query,function(err, results) {
        return res.json(results);
      });
});

Open in new window

0
i would like to develop a page which can interact with AD so that user's can update their contact details on the fly and it's in sync with AD so that signatures are up to date. I also want to flash the page every 30/60 days to every user so that they are forced to check and update their contact

i have attached a layout , which i would like to create a page so that i can ask every user every now and then to update their contact details.
0
I would like to write a custom check writing software for this dot-matrix printer.
Preferably in python. Any recommendations on how to go about this? What is the best language etc...
I think I would prefer a Linux environment but I am open to c# .net windows as well.
0
I have worksheets named WS1 and WS2. I need to compare Column C of WS1 with Column D of WS2. If both columns contain same values then I need to highlight both the cells of "Column C of WS1" and "Column D of WS2".
Example:
Column C of WS1    
500,000.00
260,000.00
65,000.00
30,000.00
46,104.00
530,000.00
350,000.00
55,000.00
7,000.00
2,520.16
30,000.00
210,000.00
650,000.00
10,000.00

Column D of WS2
2520.16
500,000.00
260,000.00
65,000.00
30,000.00
46,104.00
530,000.00
350,000.00
55,000.00
7,000.00
30,000.00
1,827,099.63
210,000.00
650,000.00
10,000.00
If values of Column C = Value of Column D then the cell containing same values in both columns is highlighted. My data is not uniform. They may have repetitive values. I am doing it manually right now and it is time-consuming as I have a lot of data to work on. Can you please suggest me.
 I am looking for exact matches for currency amounts and also I want the amounts which has been already matched to be left out. The value in each cell should be matched with only one value of another cell. Leave out the next repeated value to match with next.
0
When developing an application / web application, what type of documentation is required /beneficial if a developer leaves a company to allow the new developer to understand the setup /configuration
0
Industry Leaders: We Want Your Opinion!
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Hello Experts - I am running Server 2008 R2 with Office 2007 and IE8.  I need to upgrade to IE11 as some of the third party sites we work with are no longer compatible with IE8-IE10.

I have an Access application that currently works extremely well retrieving files from IE8, however, when I try to use this with IE11 the Open/Save/Save As bar at the bottom is a problem.

If I am retrieving a file that has a direct url to the file that includes a .xls file extension, then the file will open without the download bar.  If I am in a site and the application navigates to a url that does not have a .xls file extension included, or one that is for a file type other than pdf or xls, or one that is within a site that requires a login first to download the file, then the download bar appears.

Direct URL w/File Extension Example - http://www.plazahomemortgage.com/Documents/Rates/Plaza_JAX_Rates.xls
URL w/o File Extension Example - http://h2o.caliberdirect.com/Utilities/PublicOpenDocument.aspx?c=ICAgICAgNzcyNUBAMTNAQDU2QEAxMAAA

I have tried several different solutions for editing the registry, but I am either doing it wrong, or it isn't working.

I can run this same Access application on a Windows 10/Office 2016/IE11 setup and the download bar does not appear.

Switching to Chrome/Selenium is not an option; I don't have time to learn Selenium right now, and the Security Team won't approve Selenium for install.

Thanks in advance for your help!
1
Hi,

Can someone please give me a link to a book on KCML Kerridge C Macro Language (KCML) and any info on how to develop in it please.

Started working for a company that uses it - thanks!
0
I'm contemplating the design of classes, playing with a simple hypothetical design, and wondering if there's some general principle of good design this violates, and if there's a better way.

Say I have a class of Messages. Each message is a string. The Messages class holds a list of all the message strings.

I want to send these messages to their destination. Say, write them to a file. So I have a MessageSender class which does the job.

Class Diagram

using System;
using System.Collections.Generic;
using System.IO;

namespace TestMessages
{
    class Program
    {
        static void Main(string[] args)
        {
            var messages = new Messages();
            var messageSender = new MessageSender();
            messageSender.SendMessages();
        }
    }

    public class Messages
    {
        public static List<string> myMessages;
        public Messages()
        {
            myMessages = new List<String>(new string[] { "one", "two", "three" });
        }
    }

    class MessageSender
    {
        public void SendMessages()
        {
            using (StreamWriter writer = new StreamWriter("myFile.txt"))
            {
                foreach (string s in Messages.myMessages)
                {
                    writer.WriteLine(s);
                }
            }
        }
    }

}

Open in new window

This all works. But I see problems.

First there's the obvious static List in the Messages class, which makes it global and easily accessible, and abusable.

And the Messages class is just data with no behavior.

Second, I see MessageSender reaching in to class Messages and extracting the data. This is the one I'm not sure if it violates encapsulation, or some other good design principle.

I can make the MyMessages list not static:

Class Diagram

Open in new window

0
field will be in the form are as follows
GIN--STATIONARY NO
GX NO. CG/001/N - AUTOMATIC CHANGEABLE AFTER EACH
DATE - CHANGEABLE
DOO- DATE I WILL DECIDE
SUR NAME- FROM TABLE
INITIAL-FROM TABLE
RANK-STATIONARY FOR EACH PERSON
P. NO.-UNIQUE NO
THERE WILL BE SOME CASUALTY e.g. LEAVE, MOVEMENT, PROMOTION,AMENDMENT
i donot have the idea how to make this form from the so that i can receive the date from table. ple help me.
0
I am trying to add custom layout to my preferences. Here is the relevant code.

1. SettingsActivity

        public class SettingsActivity extends AppCompatActivity {
        private SettingsFragment mSettingsFragment;

        @Override
        public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_fragment);

        FragmentManager fm = getFragmentManager();
        mSettingsFragment = (SettingsFragment) fm.findFragmentByTag(SettingsFragment.TAG);
        if (mSettingsFragment == null) {
            mSettingsFragment = SettingsFragment.newInstance(R.xml.settings_main);
        }

        try {

            fm.beginTransaction()
                .replace(R.id.content_frame, mSettingsFragment, SettingsFragment.TAG)
                .commit();
        } catch (Exception ex) {

        }

        }

        @Override
        public void onBackPressed() {
        if (getFragmentManager().getBackStackEntryCount() > 0) {
            getFragmentManager().popBackStack();
        } else {
            super.onBackPressed();
        }
        }
        }


activity_fragment :

    <?xml version="1.0" encoding="utf-8"?>
    <LinearLayout android:id="@+id/root"
    xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical">


    <FrameLayout
  …
0
There are a few custom object types in our database.  This is a new area for me.
Is there anything a DBA should be aware of when these are trickled throughout the database?

Thanks for feedback! Theresa
0

Programming

52K

Solutions

40K

Contributors

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.