• conversion problem

    how do you convert DCF files into CSV files for export to Excel Spreadsheet

    ironpony45 pointsBadges:
  • Declare flat file in CL programming

    How would I declare a flat file in CL programming?

    mahalakshmi4375 pointsBadges:
  • Rename a MySQL database

    Is there a way to rename a MySQL database? I know that I can just dump the database / reimport it but I can't do that with mine. It's a huge database. Also, it needs to work with InnoDB. Thanks!

    ITKE413,545 pointsBadges:
  • Secure database passwords in PHP

    I have a PHP application that makes a database connection but it also has a login / password. I'm using a minimum permission login for the app so the PHP just needs to know that login / password. What would be the best way to secure that password? I don't want to write in PHP code.

    ITKE413,545 pointsBadges:
  • List tables in SQLite database

    In a SQLite database, is there a way to list tables? Specifically when I attach the database file with the ATTACH command on the SQLite command line tool. Thanks so much!

    ITKE413,545 pointsBadges:
  • Which database to use with NAS?

    My company has recently shifted to NAS and we are looking for a database option to implement.

    arp122515 pointsBadges:
  • Need to split the values in few cells in all the cells in CSV

    Need to split Database-A and 40005 and need to place Database-A in Column A4 and need to replace 1414 with 40005 in Column B4.   Column A  ColumnB URL Port Application-a.com 1414 Application-b.com 1414 website-x.com 25025 website-y.com 20208 Database-A,40005 1414 Database-B,40000 1414

    ManojD0595 pointsBadges:
  • Display date in Oracle Toad

    How to display all the months between two dates. My fromdate format is 'mon-yyyy' and todate format is 'dd-mon-yyyy'. Please suggest.

    Deb4u50 pointsBadges:
  • Access – Word Mail Merge email address duplication

    I have an email field in my Word document when the data comes over from Access it lists the email address but then repeats it again surrounded by # signs ex. blahblah@yahoo.com#mailto:blahblah@yahoo.com# Any tips on a switch I could use to remove the # signs and duplicate address? Thank you!

    jengrn265 pointsBadges:
  • Crystal Reports 2008 – CSV Export

    We've installed CR 2008 onto our server and now having issues with CSV Exports. Previously when using Crystal reporter 9 the CSV exports would have all items in quotations. e.g. "ABC","$100,000.00","2015-06-30" Now, when running the reports from our recently installed Crystal Reporter 2008, the...

    cbinsydney5 pointsBadges:
  • How to transition an old local CRM system to a more modern networked CRM Solution

    Hi. We have an old CRM system that is currently local to only a single location and we are looking to transition it to a more modern system with network capability and would appreciate any advice about the best way to go about it. Basically, we currently have a fairly simple Microsoft Access (2007)...

    ericw19755 pointsBadges:
  • Apply 2 mathmetical operators on Access fields

    Hi all, could you help me to create new field on Access table calculating the sum of two other fields and divide it by 2? I am struggling with its syntax. Thanks a lot.

    Knowledgeislight5 pointsBadges:
  • Copy query to new table in Access 2010

    I want to copy data used in 2015 query to a create a 2016 table. So the same data used in the 2016 table is the same as the results of the 2015 query.

    quando5 pointsBadges:
  • Add buttons to an input form in database

    How do I add buttons to an input form in database?

    Anotida5 pointsBadges:
  • PCI compliance issues on MySQL database

    We use Stripe to process credit card information / store client's payments in our MySQL database. We only store the ID of transaction and the client ID. And Stripe controls the PCI compliance issues. We also isolate payments to a single box that hosts the database and payment site. Now, here's our...

    ITKE413,545 pointsBadges:
  • Access 2010: Putting a summary field data into form

    I have a simple form and subform. Form tracks donors, and subform tracks their pledges (promises to give) and payments. I'd like to put the summary information - how much they've pledged and how much they've paid, on the main form. So far, sum command hasn't worked, nor has a query.

    AllanKahan15 pointsBadges:
  • DB2/400 SQL Sub Query Performance?

    Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from INVEHD where EVENT in...

    Apothen0 pointsBadges:
  • How do I open a .DBF file to a tab in my worksheet?

    I need a macro that will open a .DBF file to a tab in my worksheet. Is this possible? If so, can you show me the code needed and if not would you have any alternative suggestions? Thank you

    myleszikiom5 pointsBadges:
  • Convert PST to CSV

    Can I convert a PST to CSV? If yes, how?

    awa2kee5 pointsBadges:
  • Date dd-mm-yyyy reversed to mm-dd-yyyy

    Hi guys, Could you tell me why when I insert date into a database table, it's reversed from (dd-mm-yyyy) to (mm-dd-yyyy)? I have well defined my date format on form design already, but when it's inserted into the table it automatically reversed. How can I solve it?

    srithea345 pointsBadges:

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.

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

Following