Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: setting form's recordset property in microsoft.public.access.formscoding
Started 3 weeks, 3 days ago by DoDev
I am having problems with setting form's recordset property. My subform's form_load event sub includes the following code: Private WithEvents rstA As ADODB.Recordset Dim SQLStmt As String Set rstA = New ADODB.Recordset SQLStmt = "SELECT * FROM tblA" rstA.Open SQLStmt, CurrentProject.Connection, _...
Site: Discussions in microsoft.public.access.formscoding  Discussions in microsoft.public.access.formscoding - site profile
Forum: microsoft.public.access.formscoding  microsoft.public.access.formscoding - forum profile
Total authors: 2 authors
Total thread posts: 2 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

Beetle replied 3 weeks, 3 days ago
A form has a RecordSource property, not a RecordSet property. The RecordSource property is a string, so you just use your SQL statement directly, rather than creating a record set and trying to use that, which would result in a Type Mismatch error. Dim SQLstmt As String SQLstmt = "Select * From TableA" Me.RecordSource =...
Size: 1,816 bytes
Customize:  Customize "<b>Reply 1</b>: setting form's recordset property in microsoft.public.access.formscoding :: microsoft.public.access.formscoding :: Discussions in microsoft.public.access.formscoding"

 

Top contributing authors

Name
Posts
Beetle
1
user's latest post:
setting form's recordset...
Published (2009-11-07 08:15:00)
&nbsp; A form has a RecordSource property, not a RecordSet property. The RecordSource property is a string, so you just use your SQL statement directly, rather than creating a record set and trying to use that, which would result in a Type Mismatch error. Dim SQLstmt As String SQLstmt = &quot;Select * From TableA&quot; Me.RecordSource = SQLstmt -- _________ Sean Bailey &quot;DoDev&quot; wrote: &gt; I am having problems...
DoDev
1
user's latest post:
setting form's recordset...
Published (2009-11-06 20:15:00)
&nbsp; I am having problems with setting form's recordset property. My subform's form_load event sub includes the following code: Private WithEvents rstA As ADODB.Recordset Dim SQLStmt As String Set rstA = New ADODB.Recordset SQLStmt = &quot;SELECT * FROM tblA&quot; rstA.Open SQLStmt, CurrentProject.Connection, _ adOpenDynamic, adLockOptimistic Set Me.Recordset = rstA The last causes the following VB error: &quot;the...

Related threads on "Discussions in microsoft.public.access.formscoding":

How do i use list box recordset property in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile How do i use list box recordset property in microsoft.public.access.formscoding
How do i use list box recordset property in microsoft.public.access.formscoding
Must use dbSeeChanges option with Recordset in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Must use dbSeeChanges option with Recordset in microsoft.public.access.formscoding
Must use dbSeeChanges option with Recordset in microsoft.public.access.formscoding
Accessing data from a subform in the parent form's...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Accessing data from a subform in the parent form's recordset in microsoft.public.access.formscoding
Accessing data from a subform in the parent form's recordset in microsoft.public.access.formscoding
How to write an append query on a recordset in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile How to write an append query on a recordset in microsoft.public.access.formscoding
How to write an append query on a recordset in microsoft.public.access.formscoding
Combobox with recordset in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Combobox with recordset in microsoft.public.access.formscoding
Combobox with recordset in microsoft.public.access.formscoding
Dynamic cmd button creation based on recordset in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Dynamic cmd button creation based on recordset in microsoft.public.access.formscoding
Dynamic cmd button creation based on recordset in microsoft.public.access.formscoding
Opening and populating a premade Report with a DAO...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Opening and populating a premade Report with a DAO recordset. in microsoft.public.access.formscoding
Opening and populating a premade Report with a DAO recordset. in microsoft.public.access.formscoding
Filter or reload recordset? in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Filter or reload recordset? in microsoft.public.access.formscoding
Filter or reload recordset? in microsoft.public.access.formscoding
Copy from one field to other in recordset in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Copy from one field to other in recordset in microsoft.public.access.formscoding
Copy from one field to other in recordset in microsoft.public.access.formscoding
Filter form recordset in microsoft.public.access.formscoding  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Filter form recordset in microsoft.public.access.formscoding
Filter form recordset in microsoft.public.access.formscoding

Related threads on other sites:

Use lbox recordset property w/ ado memory recordset? in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Use lbox recordset property w/ ado memory recordset? in microsoft.public.access.modulesdaovba
Use lbox recordset property w/ ado memory recordset? in microsoft.public.access.modulesdaovba
How use listbox recordset property with ado memory...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile How use listbox recordset property with ado memory recordset ? in microsoft.public.access
How use listbox recordset property with ado memory recordset ? in microsoft.public.access
Do I need to close a recordset clone like a table...  Discussions in microsoft.public.access.security - site profile microsoft.public.access.security - forum profile Do I need to close a recordset clone like a table recordset? in microsoft.public.access.security
Do I need to close a recordset clone like a table recordset? in microsoft.public.access.security
Assigning the Recordset property of a Grouped Report in...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Assigning the Recordset property of a Grouped Report in microsoft.public.access.reports
Assigning the Recordset property of a Grouped Report in microsoft.public.access.reports
How use listbox recordset property with ado memory...  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile General Discussion - forum profile How use listbox recordset property with ado memory recordset ?
How use listbox recordset property with ado memory recordset ?
Excel PivotCache Recordset property is it Read/Write? in...  Discussions in microsoft.public.excel.programming - site profile microsoft.public.excel.programming - forum profile Excel PivotCache Recordset property is it Read/Write? in microsoft.public.excel.programming
Excel PivotCache Recordset property is it Read/Write? in microsoft.public.excel.programming
Recordset popolato con dati di altro recordset in...  Discussions in microsoft.public.it.office.access - site profile microsoft.public.it.office.access - forum profile Recordset popolato con dati di altro recordset in microsoft.public.it.office.access
Recordset popolato con dati di altro recordset in microsoft.public.it.office.access
Recordset en Microsoft DAO in...  Discussions in microsoft.public.nl.office.access - site profile microsoft.public.nl.office.access - forum profile Recordset en Microsoft DAO in microsoft.public.nl.office.access
Recordset en Microsoft DAO in microsoft.public.nl.office.access
Recordset dentro de otro recordset in microsoft.public.es.vb  Discussions in microsoft.public.es.vb - site profile microsoft.public.es.vb - forum profile Recordset dentro de otro recordset in microsoft.public.es.vb
Recordset dentro de otro recordset in microsoft.public.es.vb
The object you entered is not a valid recordset property  Expert Communities - bytes - site profile access - forum profile The object you entered is not a valid recordset property
The object you entered is not a valid recordset property
Thread profile page for "setting form's recordset property in microsoft.public.access.formscoding" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "setting form's recordset property in microsoft.public.access.formscoding", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity