• Access 2003 question

    My form has an address field tied to a table. Previously I could input an address in that field and it would copy into the table. I could then perform a lookup in that form by the address and it would pull that record up. Now when I put the address in the address field, it is not copying into the...

    tempnorm5 pointsBadges:
  • How can I become a DBA?

    I'm in a 2nd year CS engineering student and want to be a DBA. How shall I proceed?

    HritikaMehta5 pointsBadges:
  • Hardware sizing for the infrastructure

    Hi, I would like to do the Hardware sizing for below applications on Linux based OS both in Physical and Virtual environment, can someone provide details on how many servers, type of servers, storage, network and other if related to sizing required to setup centralized for 2000 to 50000 concurrent...

    12480355 pointsBadges:
  • 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!

    ITKE371,755 pointsBadges:
  • Check if a column exists in SQL Server database

    In a SQL Server database, is there a way to check if a column exists in a table? This is what I came up with but it keeps returning false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') Thanks!

    ITKE371,755 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.

    ITKE371,755 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!

    ITKE371,755 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...

    ITKE371,755 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:

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.