• Access query formula to decrease order quantity

    Need an access query formula to decrease order quantity. Here what I am doing. I have a part number as a field and date due, quantity order and instock qty, four fields, in the 5th field I need a formula to show a decrease from the stock qty and the order qty, if I have six orders of the same part...

    luddy2385 pointsBadges:
  • Update statement with inner JOIN query isn’t working in Oracle

    We have a query that works fine with MySQL. For the past few days, we've been trying to get it to work in Oracle but keep getting the following error: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" Here's the query we're using: UPDATE table1...

    ITKE351,965 pointsBadges:
  • Copy a SQL Binary Large Object (BLOB) from one database to another

    Is there  a way to find out the name of a Blob stored in a database. I am trying the code below and apparently the name is not correct. SQL> Declare   2   tpsr Blob;   3   spsr blob;   4  Begin   5   Select '8502' into tpsr from ca90joetmp.spec_form_psr where spec_form_id = '90710';...

    Bobf15 pointsBadges:
  • Exclusive access to Access 2003 database

    I have a database located on a server. I have it set to where user clicks the icon and it will open to a main menu. I have one user that when they click the icon and the database opens, they get the message "You do not have exlucive access to this database at this time." It pops up 4 to 6 times...

    Ryker5 pointsBadges:
  • Autonumbering gone wrong Microsoft Access

    I am using an append query to add data to a table. The query works except I have an autonumbering field and am not including it in my query because I want to continue the autonumbering in the table I am adding data to. The only problem is, is that the autonumbering is beginning from a much higher...

    Kball5 pointsBadges:
  • DB Web interface

    What would be the easiest language to use/learn if I want to create a web interface for my Access DB?

    Jaco65 pointsBadges:
  • DB2 data over web browser

    Our solutions resides in System i and its all are internal developed systems. Our applications are Logistics business driven and now we have the need to publish these informations over web for view by customers. HOW do i do that.. and what should i consider..

    bsathia20 pointsBadges:
  • FoxPro error

    Trying to open a program and get this: FoxPro caused a general protection failure in module FOXSQZ.FLL@0001:6875 HELP

    Perless5 pointsBadges:
  • Table Names

    What are these table names: 0 0 1 23 136 Rentpath 1 1 158 14.0 And: select c.customer_id, o.organization_key, o.extn_dc from yfs_customer c, yfs_organization o where c.customer_id = o.organization_key and o.extn_dc = '005'

    Shellken6940 pointsBadges:
  • How to calculate my database size

    Dear all, I like to calculate my database size. Can you tell me the views and formula to calculate my DB size please?

    VADCHACHO5 pointsBadges:
  • Bulk Collect loop and Cursor Loop

    Why there is such a huge performace difference between Collection loop and a cursor Loop? Why collection populated using Bulk collect is way faster? Detailed explaination will be helpful. Thanks

    Nikhildhar35 pointsBadges:
  • Converting a Report in Access to PDF

    Hi, Does anyone know the VB code used to convert a report in access to ADOBE PDF format and E-Mail it automatically? I can do so manually but it would far easier if I could just click on one button while in the form. Thank you

    Dyllon0 pointsBadges:
  • Convert from MS Access to SQL 2005

    SELECT Format(DTrans.DATE,'dd/mmm/yyyy') AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, 'By ' & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, '' , DTrans.AMOUNT, dtrans.craCCODE AS accode,...

    Radhikanutalapati5 pointsBadges:
  • Can’t use database within Workgroup with Windows XP clients

    I am in charge of 10 computers and a server, I have them all on a workgroup and i can only use the database application installed on the server on the older computers. I try to use the same program on win xp but it says that the program is outside of the local intranet or on a untrusted source so...

    Techsupport0985 pointsBadges:
  • How to link to different tables based on an index in the first table in Microsoft Access 2010?

    I am setting up a database of photos and fine art prints made from those photos. I have a table that lists each photo and its related data. Each photo can then have a number of prints made from it (each one can be different size, material etc.) They should each be numbered individually and...

    agelidis5 pointsBadges:
  • Backing up a Joomla website without plugin

    How can we backup a Joomla website without a plugin? We need the db and the files associated with it for disaster recovery.

    Troubleshooter24755 pointsBadges:
  • How to use databases made in Access or Excel in SQL

    How can I use databases made in Access or Excel in SQL? I'm trying to import readymade databases in SQL.

    Dragan1525 pointsBadges:
  • How can I select random rows in PostgreSQL?

    I'm looking to get a random selection of rows from PostgreSQL. I've already tried this: select * from table where random() < 0.01; But one of my friends told me to use this: select * from table order by random() limit 1000; My table has over 200 million rows so I need it to be fast. Which way...

    ITKE351,965 pointsBadges:
  • Saving calculated data in Access 2000

    How do I save a calculated value on a form into a field in my table?

    chicbora5 pointsBadges:
  • 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:

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