Examples of Temporary Recordset Code?

[Sean25]

Could anyone point me to VALID examples of Recordset declaration/creation? Anything I've googled on is very limited, and not very explanitory. What I'm looking to do is pull data from a table using temporary Recordsets, so it can be manipualted between forms etc. easier, as opposed to binding a form to a table/query.

Any help is greatly appreciated. Thanks in advance.

S.

 

[dcx693]

Check out jfgambit's famous searchdb in the FAQ section: Search Text and Common Dialog Sample

 

[Pat Hartman]

temporary Recordsets is redundant in the sense of "consensus of opinion". Recordsets are by definition temporary.

easier, as opposed to binding a form to a table/query.

- where did you ever get this idea? You have no idea the work Access is doing for you behind the scenes when you use a bound form or report until you try to reproduce the functionality yourself with VBA. The whole point of developing with Access is its support of bound forms and reports. If you're going to write all your own code, you would do better to use VB.

 

[Sean25]

temporary Recordsets is redundant in the sense of "consensus of opinion". Recordsets are by definition temporary.

If you wish to be semantic, by all means. But I think you could easily discern that I was intending to differentiate between a Recordset declared and created within a sub function, as opposed to the greater underlying Form Recordset.

Although, I perhaps could have worded the inquiry differently.

- where did you ever get this idea? You have no idea the work Access is doing for you behind the scenes when you use a bound form or report until you try to reproduce the functionality yourself with VBA. The whole point of developing with Access is its support of bound forms and reports. If you're going to write all your own code, you would do better to use VB.

Because in my experience, (limited as it may be) I have found binding the Form to be restrictive for the manner in which I want to manipulate the data. I am not maintaining a database of all the information contained on the Form that is being used, it is simply there as a way to passthrough information. There is no need to create a gigantic table to store all this data. Binding the few fields I would need to the items database does not allow me to do what I want (in the manner with which I did it previously), I am sure there are other (some would say better?) ways of doing what I require, however, I was simply looking for examples of familiar code, as a refresher.

S.