• SQL – SQL Data is not clearing

    Generated my sql data and proceed to load data into a subfile. It works great except for one thing every time i leave the program and return back into the program, my subfile is load with my last search criteria and i don't know how to clear the buffers or tempfiles or whatever sql does with its...

    Pablov45 pointsBadges:
  • LEFT JOIN depending on more conditions

    I'm not sure what says the ansi norm about this SELECT * FROM a LEFT JOIN b ON b.mast_id = a.id AND b.flag = 1. Is it possible (by the ansi norm) to use in "ON" condition more then one boolean expression? Like in this case condition compounded by two expressions? Of course, meaning by this that...

    Flopy5 pointsBadges:
  • Dynamically adding rows to Gridview

    Hi friends , Can any one help on following requirement Dynamically Adding a new Row to Gridview Control in ASP.NET

    Bala1155 pointsBadges:
  • Several multi-criteria dependant drop down lists

    I am designing a database for product which will have seven different combo boxes. with each selection in each combo box needing to limit what is available in the others. Can some body please help?

    BenBritton5 pointsBadges:
  • Transfer values to database

    how to get data from windown form and store it in sql database

    Gane10 pointsBadges:
  • MS access Program / module

    Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY...

    Imtiyaz725310 pointsBadges:
  • How to show selected item from DataGridView shows in ComboBox

    how to show selected item from datagridview shows in combobox

    Kpj5 pointsBadges:
  • Form having the link for multiple databases

    INSTEAD OF OPENING THE FILE OF EACH DATABASE WHICH I WANT TO LOOK,I WANT A FORM PAGE FROM WHICH I CAN ACESS ALL MY DATABASE INSTEAD OF OPENING EACH DATABASE SEPARATELY. CAN YOU GIVE ME SOME TIPS ON THIS? ONE MORE THING I DONOT WANT HYPERLINK

    RAKA5 pointsBadges:
  • Trigger statement

    sample trigger : create trigger trig_sample on table for insert,update as update table go now, the statement inside the trigger is to update the same table . will the trigger keeps on firing and thus cause and internal error??

    C114020 pointsBadges:
  • Adding prefix to records

    Hi, I have a simple database for some products that has some SKU numbers... ie SKU 1001-01076-0000 1001-01120 1001-01120-2100 1001-01120-2400 1001-01121 1001-01121-2100 What I want to do is add the prefix "GF-" in front of those SKUs. This is a database that will continually get sent to me, so...

    Whoshanh5 pointsBadges:
  • Compile Error

    I am trying to prevent duplicate job orders from being entered for the same employer. The employer is in the main form and the job order is in the subform. I have this code attached to the "beforeupdate" event of the control on the subform but I get a compile error: wrong number or arguments or...

    Bec10 pointsBadges:
  • Switch/Case statment in access

    how i can use Switch/Case Satatment in Mic. Access 2003, am working on database as follow: Field Name: Directions in this field i need to write codes like: TAm Field Name: Translation here i need to read TAm as T=Take, Am= Morning. the problem i have more than 200 codes, which they have to be...

    Darkblue4615 pointsBadges:
  • Setting isolation levels with hibernate and DB2/AS400

    I am using hibernate with DB2/AS400. When I set any isoltion level other than '0' in the hibernate.cfg.xml and try to insert/update data in the table on DB2/AS400, The Exception '' could not update :" occurs. Update is succesful for isolation level 0. Please guide how this can be solved. Following...

    Saurabhjain5 pointsBadges:
  • Problem deleting an object(form) in Access 2000

    When I try to delete a form that is visible in the object list a message 'could not find the object' is being returned. I have tried compact/repair and decompile on the database to no avail. Any ideas....

    Eamonngarvey5 pointsBadges:
  • Access database management

    Hi guys I am managing a database and need to know if there is away of moving 'completed' records into another database but keep them linked. Senario is: We have records of pieces of work coming into the office and which take about amonth to complete the cycle. My query is instead of having this...

    Timanderson5 pointsBadges:
  • Can we extract the data from a input file and then map that data to an existing pdf document

    Hi, Can anyone tell me whether it is possible to extract the data from an input file or the database and then map that data to an existing pdf document in delphi.If not possible in delphi ,please tell me which language best suits for this.Kindly provide pointers.Thanks in advance.

    Rajalakshmi08240 pointsBadges:
  • Excel 2003.novice user wants to set up database for research

    Using Excel 2003. I want to set up a database that can be added to by using a form format with drop down boxes, tick boxes and boxes to enter data. Don't know what it's called. can I do something like this to then use it to make queries for certain data?

    Hocosteo5 pointsBadges:
  • MS Access Forms

    I created a database in MS Access with 2 simple tables and 2 or 3 related queries. I also created a form which I use for data entry. I based the form on a query that uses two tables (related by one field) and an additional column for an age calculation. I was happily entering data via my form and...

    Gaildean5 pointsBadges:
  • Highlight Keywords in Access 2003 Forms

    I have a searchable form in Access 2003. Users can type in a keyword or phrase to filter records. Is there a way of highlighting the keyword or phrase used in the set of filtered records?

    Morgandtx5 pointsBadges:
  • sql

    is it possible in vb.net to read two database(access) with one sql? like select * from databaseA!tableA union select * from databaseB!tableB what connection type to use ty in advance

    Maytel5 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