• Microsoft Access 2013 button placement on form

    In Access 2013 (Win 7) with controls aligned vertically, is there an easy way to have equal spacing between them?

    LeonFromWA5 pointsBadges:
  • Change user/file path in Access database

    My boss left and I took over her access database. When I try to pull the information from tables she created I get error that says"C:user****is not a valid path make sure path name correct or connected to server. How can I change the database to be "mine" so I can access the tables information?

    tkarp5115 pointsBadges:
  • Set up DB2 Web Query dashboard

    I would like to be able to set up a dashboard on a particular managers desktop, and demonstrate the features of DB2 Web Query. Does anyone know of a good web site that I could go to, that would show me how to do this? Alternatively, are there any books on the market that someone would recommend?

    Piano520 pointsBadges:
  • Inserting 50000 rows using FORALL statement

    How can we insert 50000 rows by using FORALL,please give me entire code?

    Ramesh5530 pointsBadges:
  • export VB6 report in pdf format.

    I'm making a project in VB 6 using MS Access as a database. I'm making a report in crystal report and want to export that report in PDF format.

    Ambastha5 pointsBadges:
  • How can I find duplicate records in a MySQL database

    I'm trying to pull out duplicate records in a MySQL database. I've already figured out how to do it this way: SELECT address, count(id) as cnt FROM list GROUP BY address HAVING cnt > 1 This is what it results in: 100 MAIN ST 2 But I need to do a pull that shows each row that has a duplicate,...

    ITKE351,965 pointsBadges:
  • Deleting multiple rows in MySQL

    We have a table with the following fields: id (Unique) url (Unique) title company site_id We now need to remove rows that have the same title, company and site_id. We've figured out one way to do it: SELECT title, site_id, location, id, count( * ) FROM jobs GROUP BY site_id, company, title,...

    ITKE351,965 pointsBadges:
  • How to put Access Control List in Cisco WS-C2960-24TT-L

    What are the commands to put Access control List in cisco WS - C2960-24TTL

    Whyshree5 pointsBadges:
  • Experience applying SP4 to SQL 2005?

    Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I...

    CarlMarius15 pointsBadges:
  • Can I select 10 rows randomly in MySQL?

    What's the best way to write a query that can select 10 rows randomly from a total of 800,000.

    ITKE351,965 pointsBadges:
  • Can I replicate the ROW_NUMBER() in MySQL?

    Does anyone know of a way, in MySQL, to replicate a SQL Server function "ROW_NUMBER()?"  Here's my example: SELECT col1, col2, ROW_NUMBER() OVER (PARTITION BY col1, col2 ORDER BY col3 DESC) AS intRow FROM Table1 With this, I would be able to add a condition to limit "intRow" to 1 to get a single...

    ITKE351,965 pointsBadges:
  • How to create a MySQL pivot table

    I currently have a MySQL table that looks like this: company_name action pagecount ------------------------------- Company A PRINT 3 Company A PRINT 2 Company A PRINT 3 Company B EMAIL Company B PRINT 2 Company B PRINT 2 Company B PRINT 1 Company A PRINT 3 But now I need to run a SQL query to get...

    ITKE351,965 pointsBadges:
  • How to check if a table exists in MySQL without throwing an exception

    Does anyone know if there's a way to check if a table exists in MySQL (possibly through PHP) without throwing an exception? It's not beneficial for me to parse the results of "SHOW TABLES LIKE." There must be some sort of query I can use.

    ITKE351,965 pointsBadges:
  • Multiple numbers for the same part in Microsoft Access

    I have 3 relating part numbers for the same part with the same description. How do I enter them into an Access DB for tracking?

    vaustin5 pointsBadges:
  • Getting error when selecting triggers to display in System I Navigator

    I keep getting an error when selecting triggers to display in navigator: sql0205 Eventdelete not in table systriggers in qsys2.

    Pgmr4660 pointsBadges:
  • Creating forms with PHP and MySQL

    Using PHP and MySQL, I am trying to create a table form which can input multiple data within the form. When the space row provided is not enough, I want to add in another function which can help add rows in the same table. How can I do this?

    MarkG7135 pointsBadges:
  • Download from the AS/400 tab delimited file

    I need to be able to download in an automated fashion, a DB2 table as a tab delimited text file on a PC. I have successfully done this manually using the Actions munu in client access but need to be able to do it automatically in either a CL of a PC scheduled job so that it will run unattended. Any...

    Butcheanes5 pointsBadges:
  • How do I save pictures in database VB.NET

    I'm using SQL Express to develop application which have I pictures so I can try how a save picture inside database and loading VB picture box. Can anyone tell me please? How do I do this?

    12345678900110 pointsBadges:
  • Is it possible to randomly select rows in a SQL Server database?

    I've been using SQL Server 2005 and in my database, I have a table labeled "customerNames" which has two different columns (ID and name). It has around 1,000 results. I've been trying to create a function that allows me the capability to select five different customers randomly every time. Would...

    ITKE351,965 pointsBadges:
  • Pulling a list of triggers in a SQL Server database

    I'm trying to get a list of triggers in a SQL Server database with the table name and the table's schema. Here's what I have so far: SELECT trigger_name = name, trigger_owner = USER_NAME(uid),table_schema = , table_name = OBJECT_NAME(parent_obj), isupdate = OBJECTPROPERTY( id,...

    ITKE351,965 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.

Following