Java CSV reader (+charts)
Hello there, I’m trying to create a Java web application which will do the following: -upload .CSV files -store them in a database -will display charts depending on the content of the .CSV file Any ideas? It HAS to be in JAVA! Thanks in advance, Peter

Answer Question   |  May 15, 2013  12:03 AM
.CSV files, Eclipse, Java, MySQL

barcode entered, still dlookup not populating “item” and “price” in the form
I have two tables, one is “inventory” and the other is “sale”. I created form using the fields from “sale”. in the “inventory” table, I saved barcodes of all items. Here, I want the form to populate the “item” name and “price” of the barcode I enter in the barcode textbox of the form. Currenty, [...]

Answer Question   |  February 27, 2012  9:40 AM
Microsoft Access, Microsoft Access forms

Schedule SQL job to run and export to CSV file
Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

Answer Question   |  May 8, 2013  11:45 PM
CSV, SQL Jobs, SSMS 2008

access 2003 mdb file size increases automatically
please if you can tell me why size of an access 2003 file automatically increase whereas no data is entered or very less data. it increases upto more than 1 GB. once the same data is imported into another file it is of the size of about 20-30 mb. strange? i have used anti viruses [...]

Answer Question   |  February 27, 2012  9:01 AM
MDB, Microsoft Access 2003

max query expression
have a very basic table: dwg, dwg rev, rev date – what query expression do I write to show only highest rev?

Answer Question   |  February 27, 2012  2:51 PM
Microsoft Access 2003, Microsoft Access queries

vb.net development environment
I am coming out of retirement and have a couple of projects I was going to do in VB6. After doing a little research it became clear that I needed to migrate my development environment from VB6/sp6 to VB.Net. My question is very basic,, what do I need to start VB.Net development? I do not [...]

Answer Question   |  February 28, 2012  2:53 PM
MySQL, Visual Basic 6, Visual Studio 2010

Writing to multiple fields with one text box
I am trying to find a way to get a single text box to write to multiple fields within a table. The reason I want to do this is for graphing purposes (with an outside source) and to not over crowd/complicate a form for the operators who will be using it. If this is not [...]

Answer Question   |  February 28, 2012  2:20 PM
Access Database, Access query, Access Tables, MS Access 2007

how to perform a distinct count on a record over 2 sub reports
hi all, i have a report returning list where it is grouped by city. it contains fields: ID (each record has unique id), serial(each client will have a serial to idenfy a person) group1 (A<B<C<D) and group2(A<B<C<D) and group date each client can have multiple entries based on how many times they have visited a centre [...]

Answer Question   |  February 28, 2012  12:50 PM
Crystal Report XI, Distinct Records

Multiple Selection in Combo Box in MS ACCESS
Hi EveryOne, I am trying to change the Combo Box for multiple section as YES in MS ACCESS.In my Form there are 64 Combo Boxes .I would like to apply same requirement for all Combo Boxes. Combo Box data Resource is getting by a query from a table which have one Id(Primary Key Column) and Name [...]

Answer Question   |  February 28, 2012  6:23 AM
Microsoft Access, Microsoft Access ComboBox, MS Access 2007

MYSQL DATABASE!!!
Hello everyone! please help me about transfering MYSQL DATABASE from one computer to another….. I am a student and got to show a project on JDBC. I am using Windows 7 os and Mysql server 5.1.. Thank you.

Answer Question   |  February 28, 2012  10:09 AM
Mysql 5.1, MySQL Database, Windows 7 OS

Trigger over table that uses transaction inserts
I have a table that is being updated via JDBC. The program that is writing records (sql insert) is using transactions. This table has an after insert trigger on it. When the trigger is disabled the table is updates correctly. When the trigger is on we get the first record and the tigger locks the [...]

Answer Question   |  February 28, 2012  5:23 PM
iSeries, JDBC, SQL INSERT, Triggers

oracle
how to find the difference between structure of the table?

Answer Question   |  February 28, 2012  2:37 AM
Oracle Schema, Oracle Table, Toad Data Modeler

personal storage disabled?
I get this message,”Pst (Personal storage) usage is disabled on this computer” when I try to import my personal files from Office 2003. Previously an Exchange program had been installed – I’m trying to disable it.

Answer Question   |  February 28, 2012  11:56 PM
.pst, Exchange server software, Import

Replace data in a text file using Access 2007
I need to replace data in a fixed length text file where the line number and position is always the same. Can anyone offer advice on this? Thanks in advance!

Answer Question   |  February 28, 2012  7:22 PM
Access 2007 functions, text files

Access 2007 DB Project
Hello, I am setting up a database for a small airline. I have an ‘Aircraft_Table’ with the fields:

Answer Question   |  February 28, 2012  10:41 PM
Access 2007, Database, SQL

Exporting a (.csv) file from SQL 2005
Hi, I’m trying to export date to a (.csv) file from SQL 2005 and I keep getting a carriage return and line feed after each record. I have been told that this may be because it is getting exported in Unicode rather than ASCII. I do not have reporting services on my box. I have [...]

Answer Question   |  February 28, 2012  5:57 PM
CSV, SQL

DB2 database on Iseries
Ho can I get the size of a DB2 data base on a iSeries platform

Answer Question   |  March 17, 2012  10:44 AM
Database, iSeries

Tie Access Query results to Form Entry
I am attempting to run a calculation based on the numerical values entered into the form. The end result would be to include the numerical value entered into the form as an item in a query equation calculation. Any help you can provide is greatly appreciated.

Answer Question   |  February 28, 2012  5:39 PM
Access 2007 forms

Cloud Certification
Hi, I have done a bit of searching on the net and it appears that  SOA Cloud certifications (c90.01A, C90.02….) are the valid and accepted. These exams seems to be vendor neutrals. Can anyone assist me to understand whether SOA certifications are the best,accepted and industry recognized Cloud Certifications that one needs to attempt or is there any other certifications? [...]

Answer Question   |  February 28, 2012  4:15 PM
IT careers, IT training and certifications

getting ORA-01422: exact fetch returns more than requested number of rows. while setting up UK bank branch
Hi All iam getting ORA-01422: exact fetch returns more than requested number of rows. while setting up UK bank branch. Please,let me know if someone faced the similar issue. Thanks Priya

Answer Question   |  February 28, 2012  11:33 PM
Database, Oracle, Oracle installation