Search results

You exactly helped my problem. And I didn't just need the record count but relied on it being correct from the start. Now I know better... thanks to all of you! Victor PS : This forum is really one of the best I've seen in terms of getting help etc.

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...

Thanks, as it looks now, that solved my problem!

Thank you very much! Victor PS : Still playing Doom I/II ? :)

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...

Exactly what I needed, thanks a lot!

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 (...

Exactly, I want to start out at a particular key...

No, I don't need "Project ID" in the list. Before, I tried to omit "NEW_ID.[Project ID]" from the SQL statement of the combobox and it would have no entries at all. I guess, because "Project ID" is the primary key...? So I will try your suggestion, nateobot, thanks for that! Victor PS : And...

Hello reclusivemonkey, I guess the value of the primary key is best...? Thanks for the reply!

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 ShaneMan, first off, thanks for your reply. But that is exactly my problem : "Project ID" is the key but I still want to eliminate duplicate entries of "Work ID". So what you are saying is that there is no solution? Not even a workaround?

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...