Summary: I have an extract of a csv file that looks like this: 5619,Marcus Lindsay Asher,2005/06,3500,525 5806,John Clifford,1999/00,3000,450 5806,John Cliffor...
Summary: I have some records in a table that looks like this: 5619,Marcus Lindsay Asher,2005/06,3500,525 5806,John Clifford,1999/00,3000,450 5806,John Clifford...
Summary: I'm getting duplicate rows when I joined three tables in SQL 2000. Table 1: employee fields: last name,first name,ssn,rec_num Table 2: hepatits date1,...
Summary: There is no easy way of doing it unless all the field names in the Excell file have matching field names in the Access file. If this is the case you ...
Summary: Try this: Open "c:\results.txt" For Input as #1 While Not EOF(1) Input #1, Student_id, Student_name, DOB If txtstudentid.Text = Student_id Then found ...
Summary: With a CSV file it is assumed the records are of random length. That precludes using random access. I would convert it to random access by finding...
Summary: I'm getting the message running VBA within MSAccess, "the changes you requested to the table were not successful because they would create duplicate v...
Summary: I have an Access 2k database with a VB6 front end, I have retrieved the data I require to each of the forms using ADO data control with Data Grid disp...
Summary: Exactly where is this reference number? If it is part of the record with the duplicate value then just use the dlookup command to get the value. ...
Summary: Hi folks. I have a table that consists of 428 invoice records which have a total value of £477631.78. Now, I have been asked to try and identify a l...
Summary: Hi, I was woundering if it's possible to combine the Frequency and countif formula together? i have an excel spreadsheet, which contains 3 worksheets....
Summary: I was working on a script for someone and needed a way to remove duplicate lines from a text file. I searched the forums for a solution and came acros...
Summary: Hi, I want to combine two or more files into one file The first row is the header I want to strip the header in each file and then create a combine fi...
Summary: Using VB6 I have a list of records saved in a .dat file, which are displayed in a list box on a form called ‘frm_Existing_Student’. Using a separa...
Summary: I am trying to get my program to check if a duplicate ISBN is being entered but cant seem to get it too work, might be the strcmp - can anyone talk m...
Summary: I need the syntax to combine strings. This doesn't work: // char first[10]="hello "; char last[20]="world"; char name[50]=first+last; // TIA If at ...
Summary: Hey, I have a problem. I'm creating a 2D "picture" by placing characters within a grid. I do not know the official name for it, but here's an example ...
Summary: HI all I am trying to find all records which have a value in a certain field with 1 or more lower case letters in the field. The value in the field i...
Summary: I have a large database, am creating labels and do not want to send the same info tow or three times to the same house. Each name and address is a se...
Summary: This is a page from sir dystic's site. Using this as a guide i managed to compile an exe displaying a messagebox, which was only 1024 bytes in size! -...
Summary: HI, I have a requirement where in i am connecting to sql from unix function and spoolling output of my query into a file. Can somebody pls guide me is...
Summary: How you actually do it depends on how the text boxes are created. Are they 16 individual boxs, Tex1, Test2, Text3, etc. Foure arrays of four text box...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
