• Microsoft Access AutoNumber

    Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to be of 8...

    Ansh12320 pointsBadges:
  • Switch between two options in Microsoft Access 2000 text field

    I am an access programmer, not much used to with the VB codes. I am using the wizards instead. I have a new project where in I want the secondary level users to check the data fed by the primary users. The findings of the primary user will be available in the new screen for the secondary level user...

    SRCA5 pointsBadges:
  • SQL Server 2005 query to get the average

    Hi, I'm using MSSql 2005 on Windows 2003 Server. I need some assistance to write a query to get the average of two columns and write the value to a third coulmn. All the transactions is in one table. Basically it is column 1 + column 2 devide by two = column 3 Thank you, George

    GPNel200675 pointsBadges:
  • How can I compare fields on two databases

    I want to list all fields on a database and use a forall loop to check list of fields on two forms in two seperate databases...can this be done

    Star0810 pointsBadges:
  • Finding the number of rows of all tables of a user/schema in Oracle

    how can i know all the table names along with the no. of rows they contain for a user/scema in oracle 9i through sql? plz answer ......

    Chrishram15 pointsBadges:
  • Resizing Microsoft Access 2003 properties form

    I recently installed MS Access 2003 SP3 on a new machine under Windows XP SP3. I find that I cannot resize the properties window when doing form design. The problem also applies to popup forms that I create. If I take the .mdb file to another machine, it works just fien. I have tried uninstalling...

    JNewmarch5 pointsBadges:
  • Website and database connection

    can anybody tell me how to connect the MS sql database with the jsp pages....I got the ip address and username with the password...I know how to connect it in a local system...but I dont know how to connect it with the database in the web server....Please help me to solve this matter

    Advancedjava25 pointsBadges:
  • SQL query and Oracle database design help needed

    Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could put this as an item of the...

    Rohit331225 pointsBadges:
  • How can I select unique records from Access based on two criteria

    I need to do the following: SQL = "select amount, count(amount) from table1 group by amount having count(*) =1" This returns all unique records, but I need to add another criteria to that statement ie: I need to select all unique records only if a second value is met as well! This is what I had in...

    Grantp40 pointsBadges:
  • Update one database from another database with ASP.NET

    I want to update my database from another database when it change.Thank for your answers

    Ingineer5 pointsBadges:
  • Sending more then 1 Access Report to Outlook

    Hi, I have 2 Access Reports which I need to send to Outlook as attachments. I usually use SendObject, but that only allows for 1 attachment. I am using Access 2007 Thanksyou Julie

    JulieSandra15 pointsBadges:
  • PL/SQL

    Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and strange it...

    Inprise610 pointsBadges:
  • Update database when combo box value is changed

    Hello, I am wondering how to update all the text fields, other combo boxes, and memo's when values are change in a combo box in MS Access 2003. For example, I have a form that when values are change of a combo box that has dates for every quarter. I want the values that I have set for the other...

    ProgrammingGal30 pointsBadges:
  • Temporary recordset in MS Access VBA

    Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don't need to make...

    Darryn765 pointsBadges:
  • Problems with VAL function

    I have a table with an NVarChar field that contains left aligned numeric values. I've tried using the VAL function to return the integer values, but I'm getting back Short Date results. What can I do to get integer results? Thanks, Arlin

    Arlin70 pointsBadges:
  • Combo search box – “Invalid Outside Proceedure”

    ..and before you ask, no I don't use anything linked into Access 2007 to program my database. So, I've been creating a form coming from the same table with the same information to be used as a separate edit form. And now suddenly my "search box" gets this error in my normal form. HELP!

    Abaumeister25 pointsBadges:
  • Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?

    hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver... i believe every thing should be fine. I have check the access permission for that user. that is not the issue. when...

    Sagar20005 pointsBadges:
  • Need a 3rd party AS/400 utility for converting to .CSV files

    Hello there, I’m hoping somebody can point me in the right direction. I need a 3rd party software which will be able to integrate with the AS400 to download 4 files & then convert them into .CSV files. This software will then need to save the exported data files to a server on our network. The...

    Smeakin5 pointsBadges:
  • A Socket Connection was Attempted to an Unreachable Host

    Hi, i am getting this Ureachable Exception when connecting From Pocket PC Application To Desktop Application through Scoket. But The same is Working with Wondows Form Application.Not Working with PockePC Application. I can't Understand this. Please tell me How to solve This Problem

    5149365 pointsBadges:
  • ESX luns allocated on Symmetrix will not format.

    Recently we allocated Symmetrix space for an ESX cluster. Some of the LUNs format fine but one or two come up with an error message that says "unable to read partition information from this disk." All of the luns were exactly the same capacity. The ESX is currently attached to a Symmetrix array as...

    Emcsanman20 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