Search results

Hello, I have another problem and I hope someone knows the reason... In some module, I write : Dim R As Recordset Set R = CurrentDb.OpenRecordset("SELECT * FROM MY_TABLE") This "MY_TABLE" has several records and the resulting recordset should have all in it, right? But as a result, only the...

Hello, there is a member called "CurrentRecord" of forms that gives you, obviously, the currently selected record. But can you access the current record of sub-forms, too, somehow? Thanks! Victor

Hello, my problem is, I have a form with a sub-form that displays results of a certain query. Now, on the main form I have buttons that manipulate this query. What I want is, after the SQL of this query has been changed, the sub-form to show updated query results based on the changed SQL. When...

Hello, there is a functionality I need to implement in my database and I don't have a clue how to do it. The problem : In one form I select search parameters and from there, I can start a search. Now the problem, I need another form to open up and display the search/query results in a table (...

Hello, I have another question about ACCESS forms. With VBA, I want to change the record showing when I open a form. I see there is a member "CurrentRecord" so I tried in the class module Me.CurrentRecord = 2 I compiles but gives runtime error that is write-protected and cannot be changed. In...

Hello everybody, I am new to this forum. Currently, I am designing a database for the company I work at. It is the first time I use ACCESS and it is ACCESS 97 (!). Now my first ( of probably many following ) questions : I have a table with a key data field. Now I want to set up a combobox...