MS 2010 Forms - Creating Recordset

I am very new to MS Access 2010 Forms. I was working on 2003 before.
I am using the below code to read the table but it's not working. Can somone plz send me the code should I use in 2010?

Dim Dbs As Database
Dim rs As Recordset
Dim X As Double
SubRefrsh

Set Dbs = CurrentDb
Set rs = Dbs.OpenRecordset("[2b - 2010 Campaign Details]")

AA = "00100000002ta6TAAQ"
Do While Not rs.EOF
If AA = rs!AccountId Then
MsgBox ("Got it!")

End If
rs.MoveNext
Loop

Sponsored Links:

Related Topics

Creating an updatable query recordset using Access 2010
I am trying to create a recordset in Access 2010 using a query. The query uses global variable that captures the users log-name to filter for the records that they entered. The queryexecutes, but the records are not updatable.

The code uses ADO. My goal is to split this database to create a multi-user environment. The source table has a primary key and there are no calculated fields.

Can someone please explain how I can make this recordset updatable.


Form Recordset Property (Want ADODB.Recordset for MDB Forms)
In Access 2002/2003, is it possible to get the forms in a MDB front end to use ADO Recordset's for their Recordset property instead of (I guess?) DAO Recordsets? I want to do this for compatiblity with an access data project which uses ADODB.Recordset for it's Form Recordset property by default.


form controls & recordset
I am creating an access app where I have 2 forms.

Default Form with combobox cb_default

Main Form with combobox cb_Main and a listbox lst_main

I have bound the Default form to a recordset and retrived a column of the table into cb_Default.I want to populate the cb_Main from the same recordset according to the value selected in cb_Default and populate lst_main from the same recordset accoording to value selected in cb_main.

Do I have to bind the recordset to each control because the query is not same for all

I am little confused


Recordset get records from Recordset
trying to open a recordset from a select statement off of another recordset. access can't find the input table or query.

Is it not possible to open a recordset off the results of a prior opened recordset


Access 2010 Formatting Forms
After creating a form, you might want to modify its appearance. Formatting your forms can help make your database look consistent and professional. Some formatting changes can even make your forms easier to use. With Access 2010's formatting tools, you can customize your forms to look exactly the way you want.
In this lesson, you will learn how to add command buttons, modify form layouts, add logos and other images, in addition to changing form colors and fonts.


EOF to gray out nextButton
What is wrong about this:?

Private Sub Form_Current()
Forms!A.btnNext.Enabled = (Not Forms!A.Recordset.EOF) End Sub

There is a Form "A" and a button "btnNext" on it. onCurrent I'd like to gray or not to gray it out depending on whether the last record has been reached or not.

What is wrong about the code above? It doesn't work.
Forms!A.Recordset.EOF seems to return only FALSE (even at end of RecordSet


filter a recordset
I am trying to filter a recordset but it doesn't seem to be working.

The forms recordset has 3 rows. One of the fields is a status flag. I want to only show the rows in my recordset where the StatusFlag is empty ("").

I use the filter but when I do a row count I still get 3 rows

Set rs = srcForm.Recordset
rs.Filter = "StatusFlag = """""
MsgBox rs.RecordCount


Me.Recordset.Move
I would like to move to record number x in a recordset using

me.recordset.move x, 1

However, I keep getting a "not a valid bookmark" error.

What am I missing? Does the form's recordset object take different methods to an ADO recordset?

Of course, I can achieve the same effect using:

me.recordset.movefirst
me.recordset.move x

but that doesn't help me to understand why I can't get .move to work with two parameters


Displaying a recordset in a datasheet view
I have a procedure which generates a recordset in code. Currently I copy the recordset to a temporary table and use docmd.opentable to display the table. Is there a better way of doing itrather than creating the temporary table? Can I just display a recordset in a datasheet view?


Save Form In PDF Format
Unlike previous versions, Access 2010 offers a direct way to publish reports and forms in widely used document publishing format – PDF. Once you’ve done creating your forms in Access 2010, you can export the form into PDF and XPS format


DAO.Recordset Vs ADODB.Recordset Vs Recordset
So I know that there are two types of libraries for retrieving recordsets, either DAO or ADO.
I read somewhere that if you are using DAO, you should use DAO.recordset instead of just "recordset" to make sure it run properly.
E.g.
Dim rs As DAO.Recordset
instead of
Dim rs As Recordset

but if the default is DAO anyways (I think), would it really cause any problems. (I'm using Access 2003)

So now, which is better DAO or ADO if I'm only using a recordset to update a single field of a record from a table that may contain hundreds of records.

Which is better in general? What exceptions are there? What do other people use


creating a ADODB Recordset and adding records...
Im trying to dynamically create a ADODB recordset and then add records and then set it as the record source for a form.

What I dont understand is the open statement for the recordset. As I have nothing to open.? until I have added records to it.so what am I missing


Introduction to Record Sets
Topics: The Type of Recordset Objects, Creating a Recordset Object, Characteristics of a Record Set, Opening a Record Set, Record Navigation in a Record Set, The Fields of a Recordset.


Access 2010 Creating Forms
Creating forms for your database can make entering data much more convenient. When you create a form, you can design it in a way that works with your database and makes sense to you.
In this lesson, you will learn how to create and modify forms. You'll also learn how to use form options like design controls and form properties to make sure your form works exactly the way you want it to.


Qualify data before writing to recordset
Need a way to mandate that the date be filled in. I am new to unbound forms writing to a recordset. But the is what I have come up with so far.


Download in MS Word file format (.doc)
This tutorial has been designed to give an introduction to some of the basic features of MS Access. The tutorial will cover the following topics:
Creating a database; Creating tables; Changing the Field Properties in the tables; Adding Lookup Tables; Creating relationships; Adding Passwords to the database; Creating simple forms using the Form Wizard; Adding graphics and creating customized forms; Creating forms using multiple tables; Creating reports using the report wizard; Formatting reports; Creating Switchboards.


order recordset
I use this query to filter an ordering a recordset. After I use the getrow statement. During the loop in the records the ordering is lost!
Why?
In effect to speed up the looping in the recordset, to store the recordset in a variant array and lopp in, or not?


SQL Recordset Versus Filtering
Currently, I have a form that uses SQL to generate a recordset on the "On Open" event. The form's "On Activate" is then used to filter the recordset based on a command button pressed in the calling form.

Instead of doing this two step process, I am contemplating revising the code to move recordset creation from the "On Open" event to the "On Activate" event. This would eliminate the filtering step, but then I would be creating a new recordset each time the form is called. Of course, I would be adding the "Where" clause to the SQL statement.


Creating Forms in Microsoft Access 2010
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry situation. If you’re working with users you don’t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we’ll walk through the process of creating an Access form.


Can't add new record to subform bound to ADO recordset
I have Access 2010 (front end) and SQL Server 2008 Express Edition (back end). I'm using ADO recordsets to populate a form and subform that I need to use for updates in the data.

The thing is that I need to be able to add new records to the subforms, but these subforms only have records created before, and I don't get the blank (new line) record.

Is there a way to get this line or is it impossible to get with ADO recordset linked forms?

Here is what I'm doing with the Open Event of the form: