o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Looping records -

im using ms access as backend database;

this are my records;

Debit ---> Credit ---> Balance
============================
0.00 ---> 100.00 ---> 0.00
50.00 ---> 0.00 ---> 0.00
0.00 ---> 25.00 ---> 0.00
75.00 ---> 0.00 ---> 0.00

now using Do while | Loop statement it goes like this;
Debit Credit Balance
===========================
0.00 100.00 100.00
50.00 0.00 50.00
0.00 25.00 75.00
75.00 0.00 0.00


Balance = Credit - Debit

is there an easiest way to do this w/o looping the records? because if it is thousand of records? it takes me time before it display the results

kindly help me pls?

 

Delete all records in a recordset without looping -
One of you guru's out there probably have a simple answer for this... I spent about 20 minutes searching on the boards and couldn't find anything. But I seem to recall something about this from a post I read before.... Is there a way to delete all the records in an existing Record


looping through records -
What would be the syntax for looping through the records in an access database. ex. For Each RECORD In Table "do this stuff" Loop Any Help? Thanks, JO


Looping records -
im using ms access as backend database; this are my records; Debit ---> Credit ---> Balance ============================ 0.00 ---> 100.00 ---> 0.00 50.00 ---> 0.00 ---> 0.00 0.00 ---> 25.00 ---> 0.00 75.00 ---> 0.00 ---> 0.00 now using Do wh


Data Dynamics ActiveX Reports v 2.0 -
I have created a rpx report. I want to display 2 records per page. I have designed the detail section in such a way that it displays only two records and more than that will be displayed in the next page. The problem i encountered is when i have one record or multiple records in


Looping, i think -
Looping i a new to programming, can anyone help me I am trying to loop through a file of records any help? ---------------------------------------- i'll fill in some details I am doing a school project about a hospital loaning system On a form i save uername, Cl


having problem looping vb code thru acess table -
Ineed to loop vbcodes thru records in my acces table but am finding it difficult.Have calculated the value (its a simple result program) for the first record and it work fine So i need to loop this very code thru the remaining records but it's not working. i know its a loop and


Faster way of .BOF and .EOF -
In my app I'm looping through records, and am allowing the user to move through the records themselves. So obviously I have to check if we've reached .BOF or .EOF I've found though that as the database enlarges, it takes quite a while for the app to actually figure out where .BOF


help ! Access problems need to search a lot of records -
Hi Guys Here's the deal Table 1 has 67,500 records in it, its an access DB. I have indexed the main field but not made it primary as it may have duplicate entries. I have made it duplicate entries okay. Table 2 is a linked table , it is linked to a text file and is updated eve


VB record looping -
I have an Access table consisting of 2 fields. I have a code that adds a text from a textbox and selected item from a listbox to that table. To avoid duplicated records in that table how can I loop through the table records and compare the existing records to a new one? I figured there


looping through a msflexgrid while inserting records to a table -
I wanted to insert several records into a table while looping throuth the records in a msflexgrid with the code below: 1. Dim q As Integer 2. With Me.MSFlexPOS 3. For q = 1 To (.Rows - 1) 4. 5. Cn.Execute "INSERT INTO POS_TBL(INVNO,INVDATE,BARCODE,DESCRIPTION,CATEGORY ,UN


[2005] Question about looping through controls -
When looping through controls inside of a container, what is the logic behind the order of each control being looped? Basically I have about 5 checkboxes in a container and I am looping through them all to find which is checked, but it seems it is looping from the bottom to the top,


for-next looping.. -
hello there, I learned to print 10 images on the screen using FOR LOOPING. (for x=0;x<10;x++); document.write('some.jpg') this prints ten images side by side.. But What Iwant to do is clear all those 10 images one by one usin FOR looping...I think I need a setTime and ho


Adding records to a recordset -
Ok, I've got the following problem: I've got a ADODB recordset filled with records Im looping to all the records looking if a specific field is filled, itf it is I want to add it to another ADODB recordset (but I only want to add the current record from the previous recordset not


[2.0]Looping up to 3 times to add records -
I have a situation that I am not sure of the best way to handle. I have 3 rows of 3 text boxes, each row represents a separate row of data to entered into a table (there are more fields but I can deal withh them). Now for each row that gets entered here, I need to go get a numbe


Looping process with datareader -
Dear The Expert, I don't understand .. why my looping process below (with level break condition) does not working ..I meant the "mTotalFreq" always has incorrect value.. it seems like the looping process has skipped one or some records, am I missing something? DataReader


slow response using ado in vb6 on access 97 db -
Hi guys The subject pretty much says it all. I'm opening a connection to an access 97 db (yes, I know - nothing I can do about it) running a simple select query against a single table which contains over 100,000 records, then looping through and adding the records to a combo box.


Single insert statement for multiple records -
I thought this was possible, but not sure now. I have a stored procedure in SQL 2000 or 2005. I use this to insert many records from a VB.NET application. Rather than looping through each record I want to insert, is there a way to constructed some sort of delimited list and then do


Looping MP3 in VB is not seemless -
I have tried using both the Windows Media Player control as well as the mciSendString method for playing an MP3 within my Visual Basic 2003 app. The problem is that when the MP3 is looping there is always a small bit of silence between when the sound ends and begins again. I have ver


looping through records... -
OK, I have a very simple database, which consists of one table. I have Name, Address, Phone Number. I have the data control in there...with 3 text boxes..when I go through the data control..there's no problem having the info show up... But what I'd like it to do is for the data c


using 2 dataReaders -
I am quite new to vb.net so you will have to bear with me. I have these 2 tables in the same database in an SQL Server. I want to loop through one table and for each record check to see if i can find a record that matches the current one's phone number in the other table. My


How to Get Recordcount -
Dear Team, I am using Adodb control.I want to get the record count of a query without looping through the records


[2005] PrintDocument when Looping through Records -
I am finally transitioning our programs from VB6 to VB.Net 2005. Yesterday and today I learned how to print using the PrintDocument control. I now am stumped by how to loop through records and print. I am trying to print an invoice, which has line items. I am not sure where I query my


Looping thru records -SQL SRV 2000 -
Hi All Can you please tell me how to loop thru a table and the insert records to it. I know how the insert works but how do you loop thru a table?


Have Table Will Query [Figured Out] -
I have a table that contains records that were imported from a file. I've got another table that holds validation errors from the import. The way it is set up, is that one record in the import table can have 0 or more records in the validation errors table. Now I need to qury out t


Paging -
Hello everybody, I have an ASP page where I send my select statement in a query string variable and execute the query and display all the records by looping through recordset. I want to do paging just like google search etc. I want to show twenty records on one page and another tw


Efficiency Comparison of two methods using ADO recordset -
Situation: There is two tables (sql server db) which have the same fields. One of the field is 'unique'. However, both table may not have the same number of records for that particular unqiue record (field). For a particular unique records in table1, table 2 should have exactly the sam


Best way to output list of records from database -
Howdy. I'm using an access database to record some stuff. There's about 10000 records in the database. Each record has about 30 fields. I'm using my own numbering system (because I dont trust Access). The RecNum field is a unique numeric field that says what record number this r


Aliging columns -
HI there, I'm displaying a series of records in a list box. Each record consists of 5 fields, say call the A-E. The problem I'm having is that because the character length of the strings in each field varies, I'm finding it difficult to display the records so that they're vertically


[2005] using looping -
i am having a hard time programming unreal situation than real world applications for looping... like for example, my problem right now, is i cant make a triangle or a pyramid using looping....as well as an inverted pyramid or a cone... does anyone knows how to output a pyramid or


Insert between dbs ** RESOLVED ** -
I have searched the forums and can't find an answer to this.. I have dbA and dbB. They are both SQL Server 2000 dbs. dbA is my 'active' database dbB is my 'archive' database I need to get records from a table in dbA to a table in dbB. I would like to use an 'execute' state


Easy question but I'm stuck he he !!! -
I have a table with about 5000 records. I want to change value for one field for about 2000 records at once. I know there is a simple SQL statment that can do it for me instead of looping thourgh every record. Here is an example of the SLOW code Set RS=db.openrecordsset("Select


Performance difference between ways of looping -
I was just wondering if there was any significant performance difference between ways one can loop through data, like Using a For.. Next loop vs looping by increasing an index number, or things like that. I have an application that does a long recursive algorithm and just want to know


Lagging Problems... :( -
alright so I have a Sendkeys Commandd that is looping... The problem is is that it causes the computer to lag a lot... so I added a timer and it lessened the lag a bit but then the send keys wasnt looping fast enough... is there a way to lower the lag without lessening the loop time?


Multithreaded application using Active Exe -
Hi All! In short... i have an application which was running on 4 different PCs now i have to run one application on server which performs the same work which those 4 applications were doing on different computers... the work involves looping through a recordset continously(the new


Looping Help Needed -
OK i have only 1 big problem and thats looping. I want to search a listview box to see it text is there and if its there do 1 thing and if its not do another thing. How do i do that. Plz help .


*RESOLVED* VB > Outlook ..Search for EntryID without looping. -
Hi, I was wondering if there was a way to search Outlook via VB for an item by its EntryID without looping through all of the folders. Basically I'm asking if there is a more direct (faster) way of pulling contacts. Right now I loop through the folders looking for Contacts and post


Need a hand... -
How would I access more than one table in a database at once using VB's Data Control? I know I have the option of "looping" through all tables, but this is a simple delete query, and I'd rather not waste time looping if I don't have to. Thanks!


Remove empty records -
How can I omit these spaces(empty strings) while looping through all data in specific column (when I load them , they are there in the dataset) have a look at the attachted image to have better idea of what I'm talking about , if not clear plz let me know ! Thanks


Looping and updating simulatneously problem -
I have a problem. I am using the OLEDataProvider class. By looping through a table of records via the data reader, I use a connection item called "conn". Within this loop, when I find a condition which matches my condition, I then update that particular record (I wan


Help me with a DAO piece of code -
Can you help with this? I need a piece of code using DAO recordsets and looping to transfer all the records in tblContact (marked for deletion) to tblContactArchive.