Search Result

nambr9 · Apr 24 '12, 08:10 PM

Hello.

I am trying to change a RecordSource (query) of a subform based on user selection in another form.

In the code below I am setting the same query as defined on the subform (Property RecordSource), but it returns no records at all.

Code:

Private Sub ID_Click()
    Dim fetchedId As Integer
    Dim sql As String
    With Me.Form.Recordset
        Me.Parent.Form!IdHolder = .Fields("Id")

...

wisni1rr · Nov 30 '11, 06:54 PM

Hi there,

I have a VBA code that I use to compute the median:

Code:

Option Compare Database
Option Explicit



Function DMedian(tName As String, fldName As String) As Single
  Dim MedianDB As DAO.Database
  Dim ssMedian As DAO.Recordset
  Dim RCount As Integer, i As Integer, x As Double, y As Double, _
      OffSet As Integer
  Set MedianDB = CurrentDb()

...

thelonelyghost · Jun 29 '10, 03:58 PM

Just searched google and this website but I couldn't come up with an answer to this.

Basic Information
Software: Microsoft Access 2000
OS: Windows XP Professional SP3
Problem: Error 3008 (locked table, [tblReturnLog]) when trying to modify recordsource of subform.

Code:

Private Sub btnSearch_Click()

'Changes recordsource of subform. subform name: frmSubform
' subform source form:

...

matt753 · May 19 '10, 06:03 PM

I am trying to move the location of two combo boxes to a different form, but it is not working very well. the two combo boxes are cmbEmployeeID and cmdPerformance. I am trying to move them to a subform that pops up from another form.

I copied everything exactly, the row source is exactly the same, and I added the reference in the forms Record Source. (seen below)

cmbPerformance RowSource

Code:

SELECT STAT_Performance_LT.PerformanceID,

...

lburgher · Mar 13 '10, 06:56 PM

I noticed a thread (now closed) asking how to use an array as a source for an Access report, for which no useful answer was given, and the guy gave up and put the data into a table. I also didn't find any useful hits on Google, so I decided to figure it out for myself. I applogize to the closed thread questioner for being nearly 5 years late in offering a solution.

1) Leave the RecordSource property blank
2) Create your controls...

Nov 13 '05, 04:14 AM

I have a subform that I dont want to have a recordsource initially as it is
locking the table that is created dynamically. I want to connect to the
table after the data has been written by another routine.

I had hoped I could do mytable.records ource = myquery...

Search Result

Changing RecordSource in code problem

Error with Median Code

Subform RecordSource Error 3008

Problem with duplicating two combo boxes from another form

Using an array instead of a table in an Access Report

how to change subform recordsource in vba