VBA help says:
"The RecordSource property setting can be a table name, a query name, or an SQL statement. For example, you can use the following settings."
That exactly is in the example since the Name property is set to the SQL string "Select * from tblTest1 where longfield=4".
So the RecordSource is properly set to the query.
But if I have manually created Recordset it doesn't have...
juing
Last Activity: Jul 14 '09, 09:18 PM
Joined: Apr 21 '09
Location:
-
Thanks, I've already found this. In that example, the source of the Recordset is a QUERY and thus it is possible to assign it to the Report.
I've already tried to manually open an ADODB.Recordset , create some fields there, add some records but haven't found any way hot to assign it to the Report's RecordSource property :(...Leave a comment:
-
List Boxes are generated dynamically according to data chosen in the form which contains them....Leave a comment:
-
Temporary table in read-only database
Hi,
I need to generate a Report. Unfortunately the report can not be constructed from calculated data. My data is populated only in the ValueList type ListBoxes.
So I decided to create a temporary tables, move the data into these tables and use them to build the Report.
The problem is that I need to be able to generate the Report also when the MDB file is set as read-only.
Is there a way to have... -
Hi, just a comment ...
Connect method is not useful in case of UDP sockets.
MSDN says this:
"If you are using a connectionless protocol such as UDP, you do not have to call Connect before sending and receiving data. You can use SendTo and ReceiveFrom to synchronously communicate with a remote host. If you do call Connect, any datagrams that arrive from an address other than the specified default will be discarded. If...Leave a comment:
-
How does the Control.Invoke method work?
Hi All,
does anybody know how the Invoke method in the Control class exactly works?
Every help mentions that it ensures calling the delegate on thread of the control's owner but I am not able to find how this is performed.
The only idea I have is that it uses a special Windows message which is send to the GUI thread which tells the thread to call the method.
Thanks a lot.
juing -
I want to create instance of the ListBox class for temporary purposes.
What are dependent Objects ?
I temporarily solved this by adding ListBox component to one of my forms and made it invisible. And I use its object as a temporary listbox for storing data....Leave a comment:
-
Create ListBox programatically
Hi Guys,
is it possible to create an instance of ListBox programatically ?
Actually I have two issues here:
1.)
When I type this line in Access 2003:
Access' run-time compiler changes the "ListBox" name to "listbox" (lowercase):Code:Dim tmpList As ListBox Set tmpList = New ListBox
2.)...Code:Dim tmpList As listbox Set tmpList = New listbox
-
I believe using "Requery()" method on ListBox with RowSourceType = "Value list" doesn't have any effect.
Anyway, I finally got it working ...
The problem is that it is not possible to use "Selected() " method on single selection ListBox.
Although this line
changes the ListIndex to -1 but the Value property remains set to the last selected...Code:List98.Selected(List98.ListIndex) = False
Leave a comment:
-
ListBox ListIndex behavior
Hi All,
I am very new in the VBA coding and I've noticed this (to me strange) behavior:
Assume this code for "Value Items" type of single select two column ListBox:
1)
If List98.ListInde x > -1 Then
List98.Selected (List98.ListInd ex) = False
End If
2)
List98.RowSourc e = ""
3)
Set rst = CurrentDb.OpenR ecordset( "any...
No activity results to display
Leave a comment: