Search results for query: *

Thanks, that's exactly what I needed. I thought the locked property is for locking the control's positioin on the form, like in VB.NET.

Hi. Let's say, I disabled a textbox, how can I keep the style, so it's not greyed out? Thanks.

Thanks a lot. That helped.

Hi, I can't find Split function or duplicate its functionality in VBA for Access97. Please, Help. Thanks

How about using temporary tables? If yes, then, how would I implement that? Thanks.

But how??? Please help

No, I still get the feeling that it is possible;)

Thanks, but they are referring to Access 2000, and there the form has a Recordset property. But in Access 97 the form does not have a recordset property:((

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.

Thanks ca8msm, That last link has helped me. I have added an ADODB library to Access 97 as a reference, so I could use ADO recordsets in addition to DAO. So, I used that code to pass ADO recordsets across from .NET to Access 97.

Thanks for your reply, ca8msm. But there's gotta be an easier way to do this. I just need a simple function that takes a single table in the dataset and converts it into a recordset with the same column names. i'm looking for something like this: Public Function convertToRS(ByVal ds As...

It could be that I'm doing it completely wrong. Could anybody tell me what's the better way to convert. Thank you 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)...

Dataset contains just one table with bunch of rows.

Hi, What would be the best way to convert .NET Dataset into a DAO.recordset?? Thanks in advance.

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.

Thanks a lot to all of you. that's exactly what i needed. Vladimir

Hi. Is there a function in VB.NET to convert a string, let's say "123105", to a date "12/31/05"? Thanks.

YES, that's exactly what I needed. Thanks.