Hi.
Access 97 form has a recordsource property, which is basically a string, like "SELECT * FROM Hotels".
But I have a ADO recordset that I would like to bind to a form. How can I do that?
Thanks in advance.
Hi, here is the code:
Public Function convertToRS(ByVal ds As DataSet) As Recordset
Dim rs As DAO.Recordset
Dim i, j As Integer
Dim dt As New TableDef
For i = 0 To ds.Tables(0).Columns.Count - 1
dt.CreateField(ds.Tables(0).Columns(i).ColumnName)...
Hi,
We use Access 97. However, there are very useful modules written in VB.NET. So, my question is if it is possible to use VB.NET dll files in Access 97?
Otherwise, that functionality will have to be re-written in VBA.
Hi,
We use Access 97. However, there are very useful modules written in VB.NET. So, my question is if it is possible to use VB.NET dll files in Access 97?
Otherwise, that functionality will have to be re-written in VBA.
Hi,
is there a way or a control to use NumericUpDown control for Double type? like a dollar value. So increase/decrease is going to be not by whole dollars, but by cents.
Thanks,
Vladimir.
is is like:
btnPin.image.fromfile("pinhor.jpg")
and then, what property do I use to figure out what image is being used on the button currently?
Thanks
How to create Auto Hiding control like Toolbox in VB Studio?
I have a lot of controls on the form, but those that I would place on the toolbox are rarely used, so I would like them not to appear on the form, but be there at the time when needed. I don't even know what to start with.Please make...
Hi,
How do I select controls on the panel or on the tabcontrol in Design view if they are outside of panel view, but I know that they are there? Like, if I do CTRL A, it would select all controls on the form. What about all controls on the panel? Thanks.
Hi,
I have a subform where there are few records. After I press the button on the parent form, I need the cursor to go through all the records on the subform. Line on the button's click event: DoCmd.GoToRecord acDataForm, "Sub_Hdetails1_Quote", acNext generates an error: "Sub_Hdetails1_Quote...
Hi,
How do I set the focus for the combobox?
When I use:
combobox1.Focus = True
It gives me an error:
Expression is a value and therefore cannot be the target of an assignment.
Thanks
Hi, I have this problem of passing bunch of names of textboxes and values in them in a collection, array, or arraylist or whatever to a method . Values better be integers.
Is it possible to create a 2-dimensional ArrayList that has the first column as a string type, and 2-nd column as an...
Hi,
I have this code:
Public HISetID As Integer
public RTID as Integer
Private Sub frmHotelInventoryManager_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cmbHotelInventorySet.ValueMember = "HotInvSetID"
cmbHotelInventorySet.DisplayMember =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.