Register and Join the most happening forum of Sikh community & intellectuals from around the world.
Hello groups !
In a vbs script, I connect to an Access 2000 database and open a
recordset for in readonly mode :
Set oConn =...
I'm trying to run through a recordset (rs) and create a new one
(OfferingsDuplicate) off of that one. It errors out on the .AddNew with
Below is my code. I have a form that has a field named [Criteria] and a
button that when clicked creates a new recordset and sets the form to use...
I've just spent 3 hours working on getting a simple recordset loop to go
through all the records that the SQL returned.
Heres my code,...
The following code is only showing me one message box with one idInvoice.
Yet the SQL behind it returns 4 distinct rows, each with a...
I have a couple of questions:
When I attempt to use the following code, I get the error "Too Few
Parameters. Expected 6".
dim db AS...
How do you find the end of a recordset, so it can be used in a loop. I tried
the EOF command but it wont enter the loop when i use it. Here is an...
I am using MS Access 2002 SP3 and Oracle 9i.
On an Access form, I have created a list box. It is no problem to
populate it with the results of a...
I am a new at this and not sure how to displaying matching recordset. I
Dim loDB As Database
Dim loRSPlayer As...
What would be the quickest way to write an ADO recordset to an Access table?
I am doing this in Excel VBA.
Would I have to (double) loop through...
Is it possible to see what a recordset holds by using a watch ?
I have this code line -
Dim rs As DAO.Recordset
I want to copy data from a control on a form (primary table) to a control on
subform (secondary table)- one to many relationship. The purpose is...
I'm new to programming Access, and I'm having a big problem creating a
recordset. This is a very basic (and not very secure) login form, and I...
This is my current situation, which I use to produce a report that is
grouped by months and weeks of the month...(week 1, week 2, week
I am trying to open a persistent Recordset object and set the CacheSize
property using VBA. I do this in the Form_Open event, but every time I...
I have a new user request which I can't seem to find an easy way to
accommodate. Currently users have a button they click and a report...