Can anyone help me for my programming difficulty regarding recordset looping. I want an expected result as shown in my attachment "Sample Expected Result.txt"
I have 2 recordsets using two tables named "Table1 and Table2". I am also using do while loop as shown in my attachment. The result of my code was shown in an immediate window.
Can anyone provide me as an exact code to show an expected result.
It would appear that you are trying to retrieve the [ID] and [Req'd By] Field Values from Table2, is this correct? What does Table1 have to do with this scenario?
Sorry, one of the attachment is missing. I send it again the codes and the result in the immediate window.
But i want the expected result based on my previous attachment.
Here is the Codes:
Expand|Select|Wrap|Line Numbers
1. Option Compare Database
2. Private Sub Command0_Click()
3. Dim db As Database
4. Dim rstab1, rstab2 As DAO.Recordset
5. Set db = CurrentDb
6. Set rstab1 = db.OpenRecordset("Table1", dbOpenDynaset)
7. Set rstab2 = db.OpenRecordset("Table2", dbOpenDynaset)
I need to display data like this:
CompanyName1
Company | Date| Transactions Count -- headers
CompanyName1 | Date| 1 -- data
CompanyName2 | Date| 5 -- data...
I want to open a recordset object on an .asp page. When I open the
recordset I would like to use a stored procedure that expects a parameter to
be passed for the stored procedure. I will then use...
I currently use Do while loop, but I'd rather use a For Loop though I
have never gotten the hang of them.
Would some one please be so kind as to show me how to loop through a
recordset.
Hi
I have a database that I use to keep track of the sales promotions that we
send to companies.
I normally send a mailing based on a subset of the companies in the database
(found using the...
Is it possible to use a recursive function to loop through a recordset faster?
I have a table that I need to edit its contents after doing some calculation. The table has one field has an RawData...
Expand full for viewing...
I have a parent/child table. The basic setup is as follows:
The parent table is called load sheet. It has fields such as Tripno,
carrier, loaddate, etc.
The child...
Hello. I was hoping that someone may be able to assist with an issue
that I am experiencing. I have created an Access DB which imports an
Excel File with a particular layout and field naming. ...
Hi everyone,
I'm a newbie to the forum.
I have an issue and was hoping to get some assistance/ideas:
Im trying to read a XML file into two record sets.
I can acheive looping through the...
Hi all,
All I am trying to do is open a table, edit it, and then close it.
But I am having the strangest error. Here is my code
Dim i as integer
Dim rs as adodb.recordset
Set rs = new...
Using Access 2003
I am looping through table values and creating a separate report for each name. The report is then emailed with a TO: and CC: address. That works fine. What I would like to do is...
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you